IMPDP: The job SYS_IMPORT_FULL_01 has halted due to a fatal error
Hi,
I'm having problems importing a database whose export was successful.
The tool I'm using is expdp and impdp.
The source schema is in a tablespace different from the target schema, but in the same instance of the Oracle database.
I granted the role of EXP_FULL_DATABASE for the source user and granted the role IMP_FULL_DATABASE to the target user.
Specifically, the following happens: I can export the schema and can successfully import the first four tables to the target schema. So the impdp provides the following message:
Processing object type SCHEMA_EXPORT / TABLE / TABLE_DATA
. . imported "BDE_INEA_DES". "GPL_DECLIV_FRAGIL" 328.4 MB 668 706 lines
. . imported "BDE_INEA_DES". "GLN_CURVA_NIVEL" 336.3 MB 124 324 lines
. . imported "BDE_INEA_DES". "GPL_APP_10" 2920 lines 238.7 MB
. . imported "BDE_INEA_DES". "GLN_CURVA_NIVEL_10" 200.8 MB 15 344 lines
The job "BDE_INEA_DES". "SYS_IMPORT_SCHEMA_01" was halted due to a fatal error at 11:52:41
I've tried exporting using SYSTEM user and the user's schema source owner. I tried the same procedures with the import, but without success.
Information of my OS:
Windows Server 2008 R2 x64
Information of Oracle database:
SQL> SELECT * FROM V $ VERSION;
BANNER
-------------------------------------------------- ------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL / SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production