See Creating the Oracle Tablespaces before creating the Star tablespace for important information about the code shown in the following procedure. After logging onto SQL Plus as System\<system password>, do the following to create the Star tablespace:
CREATE SMALLFILE TABLESPACE STAR_DAT1 DATAFILE 'path\oracle\oradata\database name\star_dat1.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M SEGMENT SPACE MANAGEMENT AUTO;
Where path is the actual path to the location of the Oracle tablespaces and database name is the name of your database instance name.
CREATE SMALLFILE TABLESPACE STAR_HST1 DATAFILE 'path\oracle\oradata\database name\star_hst1.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M SEGMENT SPACE MANAGEMENT AUTO;
Where path is the actual path to the location of the Oracle tablespaces and database name is the name of your database instance name.
Related Topics |
Legal Notices
Copyright © 1999, 2014,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, January 31, 2014