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

database oracle datapump
user1578653 picture user1578653 · Nov 28, 2012 · Viewed 15.4k times · Source

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!

Answer

maialithar picture maialithar · Nov 28, 2012

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

Related questions

Oracle data pump impdp to remote server

We have a dump file that we want to import to an Amazon rds server. This is what I did: Create a public db link and verify it works: create public database link rdsdblink connect to dbuser identified by dbpsw …

Read More
How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More
How to select the nth row in a SQL database table?

I'm interested in learning some (ideally) database agnostic ways of selecting the nth row from a database table. It would also be interesting to see how this can be achieved using the native functionality of the following databases: SQL Server …

Read More