.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

How To Create Additional Tablespaces for an New Database

Q

How To Create Additional Tablespaces for an New Database? - Oracle DBA FAQ - Creating New Database Instance Manually

✍: FYIcenter.com

A

This is Step 8. Creating additional tablespaces can be done by using the CREATE TABLESPACE statement as shown in the following sample script:

SQL> CREATE TABLESPACE users
  2  DATAFILE '/oraclexe/oradata/FYI/users01.dbf' SIZE 10M;

SQL> CREATE TABLESPACE indx
  2  DATAFILE '/oraclexe/oradata/FYI/indx01.dbf' SIZE 10M;

2007-04-23, 4822👍, 0💬

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML