Avatar of GNOVAK
GNOVAK
Flag for United States of America asked on

Oracle Schema dump from batch file

Is there any way to export the schema script with and without data from a batch file.
The reason I want the batch file is so that I can schedule it.
Oracle Database

Avatar of undefined
Last Comment
Geert G

8/22/2022 - Mon
slightwv (䄆 Netminder)

You should be able to do a datapump export for the schema with and without data.

The online docs have the syntax and all the options.
GNOVAK

ASKER
What's the best way to do this in a batch file if I'm using tnsnames....?
slightwv (䄆 Netminder)

expdp and impdp are command line programs.
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER CERTIFIED SOLUTION
Geert G

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.