Adding Oracle Tablespaces

This is easy!

First tell the system where you want the table space:
ALTER SYSTEM SET DB_CREATE_FILE_DEST = '/home/oracle/app/oracle/oradata/orcl';

Next, name and create the tablespace:
CREATE TABLESPACE [YourTableSpace];

Leave a Reply

Your email address will not be published.

69 + = 73