Oracle - Create Additional Tablespaces in Oracle

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;

⇒Creating New Database Instance Manually

⇒⇒Oracle Database Tutorials

2016-10-16, 174👍, 0💬

Popular Posts:

WHILE ... Loops in S...

How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...

DROP_EXISTING - Recr...

How To Recreate an Existing Index in SQL Server? If you want to change the definition of an existing...

What Are Logical/Boo...

What Are Logical/Boolean Operations in SQL Server Transact-SQL? Logical (Boolean) operations are per...

Generating CREATE VI...

How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...

Conditional Statemen...

Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...