Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is it possible to export all schemas in a database with oracle data pump?

I am using Oracle 11g 11.2.0.1.0 and I'm trying to find a way of using data pump to export ALL schemas in a database. I know you can specify multiple schemas using the SCHEMAS argument, but I need to be able to export all schemas without having to explicitly name them, because at any given time I don't know exactly what schemas are there (it's a development database and developers can add schemas whenever they want). Is there a way to do this with data pump? Or is there some other tool which could do this?

Thanks!

like image 823
user1578653 Avatar asked Jan 14 '23 21:01

user1578653


1 Answers

You can export all schemas with full=y:

expdp system/password@db10g full=Y directory=TEST_DIR dumpfile=DB10G.dmp logfile=expdpDB10G.log
impdp system/password@db10g full=Y directory=TEST_DIR dumpfile=DB10G.dmp logfile=impdpDB10G.log

source

like image 143
maialithar Avatar answered Jan 31 '23 06:01

maialithar