Collections:
Create Additional Tablespaces in Oracle
How To Create Additional Tablespaces for an New Database in Oracle?
✍: FYIcenter.com
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
2019-03-27, 1538🔥, 0💬
Popular Posts:
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...