OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » expdp error (oracle 10g + windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

expdp error [message #432105]

Sat, 21 November 2009 05:04

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

Report message to a moderator