How To Create Additional Tablespaces for an New Database

Q

How To Create Additional Tablespaces for an New Database? - Oracle DBA FAQ - Creating New Database Instance Manually

✍: 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;

2007-04-23, 5112👍, 0💬

How To Download Oracle Database 10g XE
How To Download Oracle Database 10g XE? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition If you want to download a copy of Oracle Database 10g Express Edition, visit http://www.oracle.com/technolo gy/software/products/database/ xe/.If you are using Windows systems, there are dow... 2007-04-23, 5356👍, 0💬

How To Start a Specific Oracle Instance
How To Start a Specific Oracle Instance? - Oracle DBA FAQ - Creating New Database Instance Manually A simple way to start a specific Oracle instance is to start the instance with the PFILE option as shown in the following example: >.\bin\sqlplus /nolog SQL> CONNECT / AS SYSDBA Connected. SQL> STARTU... 2007-04-23, 5312👍, 0💬

How To Start Instance with a Minimal Initialization Parameter File
How To Start Instance with a Minimal Initialization Parameter File? - Oracle DBA FAQ - Creating New Database Instance Manually The sample initialization parameter file provided by Oracle seems to be not working. But we can try to start the new instance with a minimal initialization parameter file (P... 2007-04-23, 5301👍, 0💬

How To Run CREATE DATABASE Statement
How To Run CREATE DATABASE Statement? - Oracle DBA FAQ - Creating New Database Instance Manually This is Step 7. Oracle Administrator Guide provided a sample CREATE DATABASE statement. But it is a long statement. You can modify and same it in a file, $ORACLE_HOME/configscripts/cre ate_database_fyi.sq... 2007-04-23, 5283👍, 0💬

What Are the Limitations Oracle Database 10g XE
What Are the Limitations Oracle Database 10g XE? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Oracle Database XE is free for runtime usage with the following limitations: Supports up to 4GB of user data (in addition to Oracle system data) Single instance only of Oracle Data... 2007-04-23, 5225👍, 0💬

How To Build Data Dictionary View an New Database
How To Build Data Dictionary View an New Database? - Oracle DBA FAQ - Creating New Database Instance Manually 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/cat.. . 2007-04-23, 5179👍, 0💬

How To Run CREATE DATABASE Statement Again
How To Run CREATE DATABASE Statement Again? - Oracle DBA FAQ - Creating New Database Instance Manually 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... 2007-04-23, 5144👍, 0💬

What is Oracle Database 10g Express Edition
What is Oracle Database 10g Express Edition? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Based on Oracle Web site: Oracle Database 10g Express Edition (Oracle Database XE) is an entry-level, small-footprint database based on the Oracle Database 10g Release 2 code base that... 2007-04-23, 5134👍, 0💬

How To Create Additional Tablespaces for an New Database
How To Create Additional Tablespaces for an New Database? - Oracle DBA FAQ - Creating New Database Instance Manually 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 '... 2007-04-23, 5113👍, 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.