Home » RDBMS Server » Server Utilities » import of indexes using impdp (10.2.0.4)
import of indexes using impdp [message #441141] Fri, 29 January 2010 00:12 Go to next message
ankush_chawla
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.

Report message to a moderator

Re: import of indexes using impdp [message #441179 is a reply to message #441141] Fri, 29 January 2010 04:21 Go to previous message
entekeralam
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 05 08:11:08 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.