RE: Duhvelopers

Melissa
Export/import can not change the tablespace storage parameter of a lob. In 8.1.7 at least. Perhaps this is still an issue for 9i. You may need to pre-create the tables.
t

-----Original Message-----
Sent: Tuesday, 15 April 2003 11:04 am
To: Multiple recipients of list ORACLE-L

The tables that didn't create all contain LOB's. The tables without LOBs created with no problems.

CREATE TABLE ...........
TABLESPACE "SYSTEM" ENABLE STORAGE IN ROW CHUNK 4096 P"
"CTVERSION 10 NOCACHE STORAGE(INITIAL 12288 NEXT 12288 MINEXTENTS 1
MAXEXTE"
"NTS 249 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL
DEFAULT))"

IMP-00003: ORACLE error 1950 encountered 
ORA-01950: no privileges on tablespace 'SYSTEM' 
IMP-00017: following statement failed with ORACLE error 1950: 

Some bug probably.

-----Original Message-----
Sent: Monday, April 14, 2003 9:52 PM
To: 'ORACLE-L_at_fatcity.com'

List,

It's late, and I'm scratching my head on this.

Oracle 9IR2 Sun Solaris

I've got a dump file from some consultant DUHvelopers. All the tables were created in the system tablespace along with indexes etc....

In the past, I've been able to just import into another users schema and the tables are created in the default tablespace. For some reason this export file is still looking for the system tablespace when trying to create the tables.

What am I missing here?

TIA

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Trevor.Williams_at_rac.com.au

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).