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

Import/export same as rebuilding indexes of table?

Is it the same thing to export and import the table as to rebuild the indexes of the table?

I have problems with an index in one table in Oracle 9.2.0.4. My question is, is it the same thing to export and import the table as to rebuild the indexes of the table?
You do not need to export and import to rebuild the problematic index. Just use the following command:
ALTER INDEX  owner.index_name REBUILD; 

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