OraFAQ Forum: Server Utilities » import of indexes using impdp

Home » RDBMS Server » Server Utilities » import of indexes using impdp (10.2.0.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

import of indexes using impdp [message #441141]

Fri, 29 January 2010 00:12

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 08 05:21:31 CST 2026