Create Additional Tablespaces in Oracle

Q

How To Create Additional Tablespaces for an New Database in Oracle?

✍: 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;

 

Build Data Dictionary View in Oracle

Running CREATE DATABASE Statement Again in Oracle

Creating New Database Instance Manually

⇑⇑ Oracle Database Tutorials

2019-03-27, 1509🔥, 0💬