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, 1938🔥, 0💬
Popular Posts:
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...