Creating the Star Tablespace

Previous TopicNext TopicContents

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:

  1. Connect to the P6 Reporting Database Star instance with a user that has "create tablespace" privileges.
  2. Create tablespace star_dat1 with uniform extent size 1M and with blocksize 32K. For example:

    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.

  3. Create tablespace star_hst1. For example:

    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

Creating the Oracle Tablespaces

Oracle Database Partitioning



Legal Notices
Copyright © 1999, 2014, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, January 31, 2014