Home » RDBMS Server » Server Utilities » export and partitions (merged)
export and partitions (merged) [message #323939] Fri, 30 May 2008 02:00 Go to next message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
Hi All,
I just wanted to ask if we export a table that has indexes created in its columns from one database(d1) and import it to another database(d2)..will the imported table contain the indexes intact??

Thanks,
Arun.
Re: Export question [message #323945 is a reply to message #323939] Fri, 30 May 2008 02:24 Go to previous messageGo to next message
Rajabaskar Thangaraj
Messages: 13
Registered: March 2008
Location: CHENNAI
Junior Member
Index object also imported.


Regards
Rajabaskar
Re: Export question [message #324026 is a reply to message #323945] Fri, 30 May 2008 05:54 Go to previous messageGo to next message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
Thanks for reply Rajbaskar..
Partition existing table using export-import [message #324034 is a reply to message #323939] Fri, 30 May 2008 06:12 Go to previous messageGo to next message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
Hi All,
I have a doubt in partitioning an existing table..If we export the table(non partitioned) ,drop the table and recreate it with partitions and import back the table data, will the indexes(that were created for non-partitioned one) be created again for the partitioned tables?
Pls give your valuable replies....well im a newbie in DBA...im sorry if you find my questions to be silly.

Thanks,
Arun.

Re: Partition existing table using export-import [message #324035 is a reply to message #324034] Fri, 30 May 2008 06:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.

Regards
Michel
Re: Partition existing table using export-import [message #324037 is a reply to message #324035] Fri, 30 May 2008 06:14 Go to previous message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
Thanks Michel.
Previous Topic: sql loader direct path is taking more time
Next Topic: sort in unix
Goto Forum:
  


Current Time: Fri Dec 09 15:19:07 CST 2016

Total time taken to generate the page: 0.37531 seconds