Oracle of Nashville

You can import specific tables with data pump by using the TABLES parameter . impdp user/pwd directory=MY_DIR dumpfile=export.dmp logfile=import.log tables=schema1.table_name1,schema2.table_name2

Here's the only method I've found for using Data Pump to extract a package from a dump file.  You don't actually import it directly to a database.  Impdp creates a sql file with the source code for re-creating the package. impdp username/password directory=MYDIR dumpfile=export.dmp sqlfile=mysql.sql This will get all the source code for every package in your dump file.

Using datapump to import one or more schemas in an Oracle database is very easy. dpimp user/password dumpfile=file.dmp schemas=SCOTT,USER2 directory=DMP_DIR

After you've started an interactive data pump process, you can go to the data pump command line by pressing ctrl + c. Export> The data pump export will continue to run in the background. Type 'help' to view a list of commands you can run.

Oracle Data Pump is a really cool utility for exporting data from your database. It is much faster than the traditional export utility. One of the ways Data Pump is able to speed up the process is through the use of parallel threads. Data Pump can utilize multiple threads to greatly reduce export time. I use an export as a way to check for corrupt data blocks. Oracle will not notify you of a corrupt data block until that block is accessed. It could be a long while before you found out. An export will read every data block and report on any corruptions. Thus, a nightly export provides a useful means for identifying corrupt blocks. The following command will launch Data Pump and export the entire database: expdp username/password full=y logfile=fulldb.log dumpfile=fulldb.dmp To use a parfile, simply issue the following: expdp username/password parfile=myparfile.par To utilize multiple threads, use the PARALLEL parameter along with the %U wildcard in the DUMPFILE parameter. The...