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

2019-03-27, 468👍, 0💬

Running CREATE DATABASE Statement Again in Oracle
How To Run CREATE DATABASE Statement Again in Oracle? After cleaning up the results of a previously failed CREATE DATABASE statement, you can run the CREATE DATABASE statement again as shown below: SQL> @$ORACLE_HOME\config\scripts\c reate_database_fyi.sql;CREATE DATABASE FYI * ERROR at line ... 2019-03-27, 555👍, 0💬

Clean Up When CREATE DATABASE Failed in Oracle
How To Do Clean Up If CREATE DATABASE Failed in Oracle? To better organize data files, you should create a dedicated directory for each Oracle database. This can be done by using Windows file explorer to create the \oraclexe\oradata\fyi\ directory. Try the CREATE DATABASE statement again, when you h... 2019-03-27, 552👍, 0💬

Create Additional Tablespaces in Oracle
How To Create Additional Tablespaces for an New Database in Oracle? 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 10... 2019-03-27, 469👍, 0💬

Build Data Dictionary View in Oracle
How To Build Data Dictionary View of an New Database in Oracle? This is Step 9. The Oracle Administrator Guide suggests to run two SQL scripts provided by Oracle as shown bellow: SQL> @/u01/oracle/rdbms/admin/catal og.sqlSQL> @/u01/oracle/rdbms/admin/catpr oc.sql ⇒Creating New Databas... 2019-03-27, 425👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.