Home » RDBMS Server » Backup & Recovery » expdp error (oracle 10g + windows)
expdp error [message #432105] Sat, 21 November 2009 05:04 Go to next message
gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai
Member

Hi,

I am facing following type of error while taking scheduled bacckup of expdp.

ORA-31694: master table "SYSTEM"."SYS_EXPORT_FULL_01" failed to load/unload
ORA-31644: unable to position to block number 12521673 in dump file "S:\expdp_carsnprd\expdp_carsnprd.dmp"
ORA-19502: write error on file "S:\expdp_carsnprd\expdp_carsnprd.dmp", blockno 1 (blocksize=4096)
ORA-27072: File I/O error
OSD-04008: WriteFile() failure, unable to write to file

Shall i have to drop master table SYS_EXPORT_FULL_01 from database.

Output from database is as:

SQL> select owner, tablespace_name, table_name from dba_tables where table_name='SYS_EXPORT_FULL_01';

OWNER TABLESPACE_NAME TABLE_NAME
----------- ---------------- ------------------------------
SYSTEM SYSTEM SYS_EXPORT_FULL_01

Thanks
Re: expdp error [message #432125 is a reply to message #432105] Sat, 21 November 2009 09:12 Go to previous message
BlackSwan
Messages: 25047
Registered: January 2009
Location: SoCal
Senior Member
>OSD-04008: WriteFile() failure, unable to write to file
some sort of file system problem
Is file system 100% full?
Previous Topic: Relationt of CONTROL_FILE_RECORD_KEEP_TIME with Retention policy in RMAN
Next Topic: RMAN not deleting all archived logs
Goto Forum:
  


Current Time: Fri Dec 09 09:34:59 CST 2016

Total time taken to generate the page: 0.13722 seconds