OraFAQ Forum: Server Utilities » expdp

Home » RDBMS Server » Server Utilities » expdp - file already exists

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

expdp - file already exists [message #176153]

Wed, 07 June 2006 03:51

orant1
Messages: 28
Registered: June 2005

Junior Member

HI,

I would like to execute full export (expdp) every day. How to avoid error ORA-27038 File already exists? How to append date/time to dmp file?

example:
expdp system...... FULL=Y ...... dumpfile=expdp`date`.dmp .....

Thanks

Report message to a moderator

Re: expdp - file already exists [message #176171 is a reply to message #176153]

Wed, 07 June 2006 04:29

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I guess you'll have to use your operating system possibilities to create a new filename every day and use it when submitting export job.

Report message to a moderator

Previous Topic:	Is it possible to concatenate data into one column?
Next Topic:	Ignore Last line of Text File in SQLLOADER - URGENT!!!!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 08:23:58 CST 2024