Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data pump import only indexes

650105Oct 12 2011 — edited Oct 12 2011
Hello i have dumpfile having 100 million records. i was loading it to another server using data pump import utility. it load data table in half hour or less but it take 7 hr while importing indexes. finally i have to kill job and reveal only Btree Indexes has been created successfully on all table while B map fail to create Now i have dump file which have all data plus metadata. is there any way in Datapump utility to import only missing Indexes or Import all Index only no table and other things? If i use Include command would it only take index? plz suggest me any solution
This post has been answered by sb92075 on Oct 12 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 9 2011
Added on Oct 12 2011
8 comments
18,444 views