ORA-29285 file write error with imdp and sqlfile
411278Aug 24 2006 — edited Aug 24 2006Hi,
I'm doing an import datapump (impdp) on a Oracle 10.2.0.2.0 on MS Windows 2003. Exports works fine (only that you can't overwrite your dumpfile, but got solution for that). Now I wanted to do an import with sqlfile.
I do it like this:
impdp system/manager dumpfile=pdump.dmp sqlfile=pdump.sql
it starts and I see the job in dba_datapump_jobs as executing
but on screen I don't see much movements ... after some minutes, I get this error:
ora-39125: worker unexpected fatal error in KUPW$WORKER.WRITER_UTL_FILE while calling UTL_FILE.FFLUSH [TABLE_DATA:"SYSTEM"."SYS_SQL_FILE_FULL_02"]
ORA-29285: file write error
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 6241
--------PL/SQL Call stack ------------
object line object
handle number name
69A06C40 14916 package body SYS.KUPW$WORKER
69A06C40 6300 package body SYS.KUPW$WORKER
69A06C40 15130 package body SYS.KUPW$WORKER
69A06C40 3949 package body SYS.KUPW$WORKER
69A06C40 6931 package body SYS.KUPW$WORKER
69A06C40 1262 package body SYS.KUPW$WORKER
69A4F9D8 2 anonymous block
Job "SYSTEM"."SYS_SQL_FILE_FULL_02" stopped due to fatal error at 11:12:57
the strange thing is, when I try then to create a file bdump.sql in my datapump directory, it says a file already exists. But there is absolute now file! The jobs are also still in dba_datapump_jobs defined as NOT RUNNING
Can I remove that?
Does anyone else has this problem, or am I doing something wrong?
thanks
Message was edited by:
already found what was wrong, I used an export that was created on schema-based. I did it now with a full and it succeeded.
But does this mean you can't do it with a schema-based exportfile?
duvelke