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, 318👍, 0💬

Popular Posts:

AND, OR, XOR, and NO...

What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...

ROUND() - Rounding V...

How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...

"ALTER USER" - Chang...

How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...

SQL Server Database ...

Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...

"IF ... ELSE IF ..."...

How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......