The parameters for export and import are fully documented in the Oracle Utilities Guide.
To export just the table, you can use the following:
exp userid=abc/password file=my_table.dmp tables=my_table
The above will sign on to the database as user "abc" and dump the specified table. To import that table, you can still use the TABLES parameter for the imp utility. But to change the schema owner, you will also need to user the FROMUSER and TOUSER parameters as follows:
imp userid=system/password file=my_table.dmp fromuser=abc touser=xyz tables=my_table
When changing schema owners, you will need to run import with a user that has the IMP_FULL_DATABASE role, like the SYSTEM user.
Dig Deeper on Oracle database backup and recovery
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.