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, 1490🔥, 0💬
Popular Posts:
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...