Re: Problem Running DDL SQL Script

From: <Shreepad.Vaidya_at_alltel.com>
Date: Thu, 22 Nov 2001 04:35:36 -0800
Message-ID: <F001.003CB84A.20011122041022@fatcity.com>

Hi Ken,
The syntax seems to be ok . It worked at my environment. So u may have to look at privileges or status of tablespaces.

Why are u creating tables as SYSTEM ? .. Just a query.

                    shreepad


                                                                                       
     
                    Ken Janusz                                                         
     
                    <ken.janusz_at_su       To:     Multiple recipients of list ORACLE-L  
     
                    fsys.com>             <ORACLE-L_at_fatcity.com>                       
     
                                         cc:                                           
     
                    21/11/01 22:35       Subject:     Problem Running DDL SQL Script   
     
                    Please respond                                                     
     
                    to ORACLE-L                                                        
     
                                                                                       
     
                                                                                       
     

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).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Shreepad.Vaidya_at_alltel.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 Thu Nov 22 2001 - 06:35:36 CST