OraFAQ Forum: Server Utilities » import indexes to a specified tablespace

Home » RDBMS Server » Server Utilities » import indexes to a specified tablespace (10g)

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

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?

Report message to a moderator

Re: import indexes to a specified tablespace [message #290389 is a reply to message #290383]

Fri, 28 December 2007 12:14

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.

Report message to a moderator

Re: import indexes to a specified tablespace [message #290394 is a reply to message #290383]

Fri, 28 December 2007 12:38

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: import indexes to a specified tablespace [message #290397 is a reply to message #290394]

Fri, 28 December 2007 12:45

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Yes it is .Thanks for pointing.!!

Report message to a moderator

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?

Report message to a moderator

Re: import indexes to a specified tablespace [message #290406 is a reply to message #290404]

Fri, 28 December 2007 13:50

Michel Cadot
Messages: 68665
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

Report message to a moderator

Previous Topic:	sql loder problem...
Next Topic:	Control file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 06:36:38 CDT 2024