Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

oracle 9 exp

user2487774Mar 8 2012 — edited Mar 8 2012

I am doing a database export with exp utility.

later I have to do an imp in another server with a different tablespace name. When a do the import there are errors like this:

IMP-00017: la siguiente sentencia ha fallado con el error 959 de ORACLE :
"CREATE TABLE "T_DOCUMENTO" ("DO_UID_DOCUMENTO" VARCHAR2(255) NOT NULL ENABL"
"E, "DO_DESCRIPCION" VARCHAR2(255), "DO_ARCHIVO" BLOB NOT NULL ENABLE, "DO_E"
"XTENSION" VARCHAR2(10)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STOR"
"AGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLES"
"PACE "APOSTILLADATOS" LOGGING NOCOMPRESS LOB ("DO_ARCHIVO") STORE AS (TABL"
"ESPACE "APOSTILLADATOS" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCA"
"CHE LOGGING STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POO"
"L DEFAULT))"
IMP-00003: se ha encontrado un error 959 de ORACLE
ORA-00959: el tablespace 'APOSTILLADATOS' no existe

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 5 2012

Added on Mar 8 2012

#database-security, #database-security-general, #oracle

1 comment

204 views