Answers

Question and Answer:

  Home  Oracle Database

⟩ How To Create Additional Tablespaces for an New Database?

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;

 159 views

More Questions for you: