I am importing a database dump from one Oracle 10g installation to another. The source has a layout with multiple table spaces. The target has one default tablespace for the user in which I import the dump.
Everything works fine for regular tables. Tables are moved from the source tablespace to a user default value. The problem I ran into, several tables contain CLOBs with explicit storage directives. That is, they call their storage tablespace. The imp command cannot move these CLOBs to the default user tablespace.
Is there a hidden command line option for the imp command to move the CLOB repository to the default user tablespace, or even one tablespace?
The error message ORACLE 959 is as follows:
IMP-00017: Nachfolgende Anweisung war wegen Oracle-Fehler 959 erfolglos:
"CREATE TABLE" IF_MDE_DATA_OUT "(" OID "NUMBER (10, 0) NOT NULL ENABLE," CLIEN "
"T_OID" NUMBER (10, 0) NOT NULL ENABLE, "TS_CREATE" TIMESTAMP (6) NOT NULL EN "
"ABLE," TS_UPDATE "TIMESTAMP (6) NOT NULL ENABLE," OP_CREATE "VARCHAR2 (30) N"
"OT NULL ENABLE," OP_UPDATE "VARCHAR2 (30) NOT NULL ENABLE," IDENTIFIER "VARC"
"HAR2 (50)," TRANSFERTYPE "VARCHAR2 (20) NOT NULL ENABLE," STORE "NUMBER (10, 0"
")," DATUM "DATE," STATE "NUMBER (3, 0) NOT NULL ENABLE," DATA_OLD "LONG RAW,"
"" SUPPLIER "NUMBER (10, 0)," BUYER "NUMBER (10, 0)," GOODS_OUT_IDS "VARCHAR2 ("
"4000)," CUSTOM_FIELD "VARCHAR2 (50)," DATA_ARCHIVE "BLOB," DATA "BLOB) PCTF"
"REE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE (INITIAL 65536 FREELISTS 1"
"FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE" DATA32M "LOGGING NOCOMP"
"RESS LOB (" DATA_ARCHIVE ") STORE AS (TABLESPACE" DATA32M "ENABLE STORAGE IN"
"ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE (INITIAL 65536 FREELI"
"STS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) LOB (" DATA ") STORE AS (TABLE"
"SPACE" DATA32M "ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGG"
"ING STORAGE (INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAUL"
"T))"
IMP-00003: ORACLE-Fehler 959 aufgetreten
ORA-00959: Tablespace 'DATA32M' nicht vorhanden
source
share