Q
Problem solve Get help with specific problems with your technologies, process and projects.

Rename a table with import utility in Oracle

I am trying to import a table in Oracle. The target database contains a table with the same name. How do I rename the table?

Using the Imp/Exp utility of Oracle, I am trying to import a table. However the target database contains a table with the same name. How do I rename the table using Import?
With the imp utility, you cannot rename a table on import. Your alternative is to rename the table in the database to a different name (temporarily), import the table from the dump file, rename the imported table, and then rename the table done in the first step back to its original name.

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close