| ORACLE error 959 [message #71045] |
Fri, 30 August 2002 10:58  |
Misha
Messages: 25
Registered: October 2001
|
Junior Member |
|
|
during import of the table with BLOB column, I received the following error message:
IMP-00017: following statement failed with ORACLE error 959:
"CREATE TABLE "DTPROPERTIES" ("ID" NUMBER(10, 0) NOT NULL ENABLE, "OBJECTID""
" NUMBER(10, 0), "PROPERTY" VARCHAR2(64) NOT NULL ENABLE, "VALUE" VARCHAR2(2"
"55), "LVALUE" BLOB, "VERSION" NUMBER(10, 0) NOT NULL ENABLE, "UVALUE" VARCH"
"AR2(510)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(IN"
"ITIAL 65536) TABLESPACE "NVISDEV" LOB ("LVALUE") STORE AS (TABLESPACE "NVI"
"SDEV" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE STORAGE(INITI"
"AL 65536))"
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'NVISDEV' does not exist
It's obvious that the error is caused by the NVISDEV tablespace not there...
The question is, does anybody knows how to changed the default tablespace for the LOB values?
|
|
|
|
| Re: ORACLE error 959 [message #71662 is a reply to message #71045] |
Thu, 12 December 2002 09:42  |
ag
Messages: 4
Registered: November 2001
|
Junior Member |
|
|
I got same problem in importing partitioned tables. There are work around like 1) create all necessary tablespaces where the source partition/lob existed or 2) first create the tables and then import.
But I was just wondering why Oracle does not import partition/lob's in default tablepspace just like other table/indexes.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
