imp file=mydump.dmp tables=table_x
The import process will import only the table noted in the TABLES parameter. All other objects in the dump will be skipped. But keep in mind that the import will also import any triggers, indexes, or constraints on this table unless you turn those off with the appropriate parameter.
Another example of mixing modes is to assume you have a full export of the entire database. You can import just the SCOTT schema similar to:
imp file=mydump.dmp fromuser=scott
Or assume that the dump file contains only two schemas (export was created with OWNER=schema1,schema2). You can import both schemas by specifying FULL=Y for the import.
Dig Deeper on Oracle database export, import and migration
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.