import indexes to a specified tablespace [message #290383] |
Fri, 28 December 2007 11:54 |
lawlade
Messages: 59 Registered: May 2007 Location: LAUREL, MARYLAND
|
Member |
|
|
I have created a dumpfile containing one schema with all its tables, lob storage and indexes in the users tablespace.
I will like to import the indexes into a different tablespace. Is there anyway of doing this if at all possible?
|
|
|
|
|
|
Re: import indexes to a specified tablespace [message #290404 is a reply to message #290383] |
Fri, 28 December 2007 13:39 |
lawlade
Messages: 59 Registered: May 2007 Location: LAUREL, MARYLAND
|
Member |
|
|
Thanks so much for the response. I do not see the indexes parameter as an option using the impdp utility. If it does exist, do you mean to first import tables first and then import the indexes specifying their destination tablespace?
|
|
|
|