RE: Problem Running DDL SQL Script

From: Koivu, Lisa <lisa.koivu_at_efairfield.com>
Date: Wed, 21 Nov 2001 12:34:45 -0800
Message-ID: <F001.003CB003.20011121103018@fatcity.com>

The larger question is, why are you creating tables as system?

-----Original Message-----

From:   Ken Janusz [SMTP:ken.janusz_at_sufsys.com]
Sent:   Wednesday, November 21, 2001 12:05 PM
To:     Multiple recipients of list ORACLE-L

Subject: Problem Running DDL SQL Script

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 - 14:34:45 CST