Problem Running DDL SQL Script

From: Ken Janusz <ken.janusz_at_sufsys.com>
Date: Wed, 21 Nov 2001 09:26:07 -0800
Message-ID: <F001.003CAEB4.20011121090521@fatcity.com>

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: ken.janusz_at_sufsys.com

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: ListGuru_at_fatcity.com (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). Received on Wed Nov 21 2001 - 11:26:07 CST