Oracle Database Interview Question:

How To Create Additional Tablespaces for an New Database?

Submitted by: Administrator

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/ggl/users01.dbf' SIZE 10M;

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

Submitted by: Administrator