Home » RDBMS Server » Server Utilities » Indexes and tables import to different tablespaces. (Oracle 10G R2, OS windows)
icon5.gif  Indexes and tables import to different tablespaces. [message #439708] Tue, 19 January 2010 03:28 Go to next message
JuicyFruit
Messages: 34
Registered: September 2009
Member

Hello!

Here is the question:

we have a full export dump of DB (using exp utl.) Is it possible to import that database using exp or expdp in such way, that all the tables will be in e.g. Tablespace1 and all indexes in Tablespace2? Export was done when Tables and Indexes all were in Tablespace0.
Re: Indexes and tables import to different tablespaces. [message #439709 is a reply to message #439708] Tue, 19 January 2010 03:33 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Hi

here is the answer

sriram Smile
Re: Indexes and tables import to different tablespaces. [message #439712 is a reply to message #439709] Tue, 19 January 2010 03:44 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
in addition
Quote:
dump files generated by the original export utility (exp) cannot be imported by the new data pump import utility (impdp) and vice-versa.


Quote:
Is it possible to import that database using exp or expdp in such way


exp Or Expdp or exporting tool which used to take the logical backup
Imp and impdp are the import tools.

i suggest you to read ...
Wiki.oracle

Oracle base data pump

sriram Smile
Re: Indexes and tables import to different tablespaces. [message #439847 is a reply to message #439709] Tue, 19 January 2010 12:36 Go to previous message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
If you precreate the indexes (of course you would have to precreate the tables first), then as the import runs, it will be rebuilding the index on the fly for every row, which cane make the import at least 10 times longer than if done the traditional way where the indexes are build at the end.

I would just do an
ALTER TABLE MOVE TABLESPACE
and
ALTER INDEX REBUILD
command.

Is there a legitimate reason that you need to do this? Separating indexes from tables is an ancient custom that is no longer necessary.
Previous Topic: Import Schema
Next Topic: Exp/Imp of 1 TB database
Goto Forum:
  


Current Time: Sun Dec 11 08:10:20 CST 2016

Total time taken to generate the page: 0.14217 seconds