I have this script that will generate a DB with a number of create table and create index statements. When I try to run it in SQL*Plus I get this error:
ORA-00959 tablespace SOS2_TBLSPC does not exist. ORA-00942 table or view doesn't exist Here is a sample of one of the create statements: DROP TABLE ACCESS_RIGHT CASCADE CONSTRAINTS ; CREATE TABLE ACCESS_RIGHT ( ACCESS_RIGHT_ID NUMBER NOT NULL, GROUP_ID NUMBER NOT NULL, MODULE_ID NUMBER NOT NULL, CONSTRAINT PK_AR_ALL PRIMARY KEY ( ACCESS_RIGHT_ID, GROUP_ID, MODULE_ID ) USING INDEX TABLESPACE SOS2_TBLSPC PCTFREE 10 STORAGE ( INITIAL 120K NEXT 104K PCTINCREASE 0 )) TABLESPACE SOS2_TBLSPC NOLOGGING PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 30720 NEXT 8192 MINEXTENTS 1 MAXEXTENTS 505 FREELISTS 1 FREELIST GROUPS 1 ) NOCACHE; When I check the DB this tablespace exists and is online. I'm logged in as system/manager. The environment is W2000/8.1.7. Any idea what the problem is? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).