OraFAQ Forum: Server Utilities » Script to run EXPDP

Home » RDBMS Server » Server Utilities » Script to run EXPDP (10.2.0.4 Windows servers)

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

Script to run EXPDP [message #676024]

Tue, 07 May 2019 10:42

SimonD
Messages: 2
Registered: May 2019

Junior Member

Hi

First off I'm not a DBA.
But learning on the job so to speak.

I would like to run a script which exports (using expdp.exe command) our schema 'companyname'.
I need it to have 2 -3 days of retention 'companyname.dmp' in a specific folder.

Currently we have a script which does this:
EXPDP test/test dumpfile=companyname.dmp DIRECTORY=c:\test ORABACK SCHEMAS=companyname Logfile=companyname

However I want to automate this process plus provided redundancy backups.

Yes I know there is RMAN however this is just an internal test server.

Any help mush appreciated

Report message to a moderator

[Message index]

		Script to run EXPDP By: SimonD on Tue, 07 May 2019 10:42
		Re: Script to run EXPDP By: BlackSwan on Tue, 07 May 2019 10:50
		Re: Script to run EXPDP By: SimonD on Tue, 07 May 2019 10:53
		Re: Script to run EXPDP By: BlackSwan on Tue, 07 May 2019 11:05
		Re: Script to run EXPDP By: John Watson on Tue, 07 May 2019 11:03
		Re: Script to run EXPDP By: John Watson on Tue, 07 May 2019 11:05
		Re: Script to run EXPDP By: cookiemonster on Wed, 08 May 2019 03:04
		Re: Script to run EXPDP By: EdStevens on Wed, 08 May 2019 06:25

Previous Topic:	I can't export all tables
Next Topic:	External loader with Load When clause

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 13:14:33 CDT 2024