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, 4529👍, 0💬