Creating the ODS Tablespace

Previous TopicNext TopicContents

After logging onto SQL Plus as System\<system password>, do the following to create the ODS tablespace:

  1. Connect to the P6 Reporting Database ODS instance with a user that has "create tablespace" privileges.
  2. Create tablespace ODS_DAT1. For example (as all one line):

    CREATE SMALLFILE TABLESPACE ODS_DAT1 DATAFILE 'path/ods_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.

Related Topics

Creating the Oracle Tablespaces



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

Last Published Friday, January 31, 2014