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@su To: Multiple recipients of list ORACLE-L
fsys.com> <[EMAIL PROTECTED]>
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: [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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
