Home » RDBMS Server » Server Utilities » import of indexes using impdp (
import of indexes using impdp [message #441141] Fri, 29 January 2010 00:12 Go to next message
Messages: 136
Registered: November 2006
Senior Member
i have export dump of a table and its dependent objects.
Somehow I have lost all the indexes of that table . I want to take the import of only the indexes on that table from the export dump. The tablespace of that table has also been changed .
Please let me know how to do this.
Re: import of indexes using impdp [message #441179 is a reply to message #441141] Fri, 29 January 2010 04:21 Go to previous message
Messages: 19
Registered: January 2010
Junior Member
If it is conventional export dump, create a file of index-creation statements using the INDEXFILE parameter in imp.
Edit the file to change the tablspace and execute the file of index-creation statements as a SQL script to create the index.

[Updated on: Fri, 29 January 2010 05:18] by Moderator

Report message to a moderator

Previous Topic: Invalid Objects after done import
Next Topic: Import from multiple files
Goto Forum:

Current Time: Mon May 10 18:05:11 CDT 2021