After logging onto SQL Plus as System\<system password>, do the following to create the ODS tablespace:
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 |
Legal Notices
Copyright © 1999, 2014,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, January 31, 2014