Home » RDBMS Server » Server Utilities » Script to run EXPDP (10.2.0.4 Windows servers)
Script to run EXPDP [message #676024] Tue, 07 May 2019 10:42 Go to previous message
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

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


Current Time: Sat Jan 18 06:24:18 CST 2020