Oracle Database Discussions

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!

DUMP ERROR ORA-00010 - URGENT!!

785398Jul 15 2010 — edited Jul 16 2010

Hello everyone:
I have a serious problem with a dump echo the version 10G and now I'm trying to restore again on another server with 10g.
The problem is that I get an error: ORA-00010 when I use the command "IMP"
but if I use "IMPDP" begins the import and I create the table structure and schema. but I do not care about any of all rows.
Unfortunately I can not return to the dump general, as was done long ago, and the data contained in the dump, no longer exist in the current database.
It is a 16GB file.
Anyone know how I can fix this problem?? is very urgent.

thanks!

--------------WITH IMP--------------------------------------------------------------------
imp system/****@hemoprd file=AUDIT_18_05_09.DMP log=archivo.log

Import: Release 10.2.0.1.0 - Production on Jue Jul 15 22:12:15 2010
Conectado a: Oracle Database 10g Release 10.2.0.1.0 - Production

IMP-00010: archivo de exportaci¾n no vßlido, ha fallado la verificaci¾n de la cabecera
IMP-00000: La importaci¾n no ha terminado correctamente
----------------------------------------------------------------------------------------------------------------------------------------

--------------WITH IMPDP--------------------------------------------------------------------------------------------------------
Conectado a: Oracle Database 10g Release 10.2.0.1.0 - Production
La tabla maestra "SYSTEM"."SYS_IMPORT_FULL_01" se ha cargado/descargado correcta
mente
Iniciando "SYSTEM"."SYS_IMPORT_FULL_01": system/********@hemoprd DUMPFILE=AUDIT.DMP
Procesando el tipo de objeto SCHEMA_EXPORT/USER
Procesando el tipo de objeto SCHEMA_EXPORT/SYSTEM_GRANT
Procesando el tipo de objeto SCHEMA_EXPORT/ROLE_GRANT
Procesando el tipo de objeto SCHEMA_EXPORT/DEFAULT_ROLE
Procesando el tipo de objeto SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Procesando el tipo de objeto SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Procesando el tipo de objeto SCHEMA_EXPORT/TABLE/TABLE
Procesando el tipo de objeto SCHEMA_EXPORT/TABLE/TABLE_DATA
Procesando el tipo de objeto SCHEMA_EXPORT/TABLE/INDEX/INDEX
Procesando el tipo de objeto SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Procesando el tipo de objeto SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Procesando el tipo de objeto SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Procesando el tipo de objeto SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Procesando el tipo de objeto SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
El trabajo "SYSTEM"."SYS_IMPORT_FULL_01" ha terminado correctamente en 22:44:47
----------------------------------------------------------------------------------------------------------------------------------------

Edited by: user10915177 on 16-jul-2010 4:07

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 13 2010

Added on Jul 15 2010

#general-database-discussions

6 comments

2,494 views