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, 1602🔥, 0💬
Popular Posts:
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...