Home » RDBMS Server » Server Utilities » import indexes to a specified tablespace (10g)
import indexes to a specified tablespace [message #290383] Fri, 28 December 2007 11:54 Go to next message
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 #290389 is a reply to message #290383] Fri, 28 December 2007 12:14 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Just extract the indexes syntax from dump file and replace the TABLESPACE clause with new one.
Re: import indexes to a specified tablespace [message #290394 is a reply to message #290383] Fri, 28 December 2007 12:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

Just extract the indexes syntax from dump file

This is done using the INDEXFILE parameter.
Either check "imp help=yes" or the documentation for synatx.

Regards
Michel
Re: import indexes to a specified tablespace [message #290397 is a reply to message #290394] Fri, 28 December 2007 12:45 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Yes it is .Thanks for pointing.!!
Re: import indexes to a specified tablespace [message #290404 is a reply to message #290383] Fri, 28 December 2007 13:39 Go to previous messageGo to next message
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?
Re: import indexes to a specified tablespace [message #290406 is a reply to message #290404] Fri, 28 December 2007 13:50 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
we talked about imp not impdp. You should specify you use DataPump.

With DataPump you can use a REMAP_TABLESPACE or other option.
See Database Utilities
Chapter 1 Overview of Oracle Data Pump
Section Transforming Metadata During a Job

Regards
Michel
Previous Topic: sql loder problem...
Next Topic: Control file
Goto Forum:
  


Current Time: Sun Dec 04 12:35:42 CST 2016

Total time taken to generate the page: 0.10019 seconds