Skip to Main Content

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!

ORA-29285 file write error with imdp and sqlfile

411278Aug 24 2006 — edited Aug 24 2006
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 21 2006
Added on Aug 24 2006
1 comment
1,162 views