| Tuning SQL scripts that uses partitioned tables [message #173538] |
Tue, 23 May 2006 01:25  |
d_ponnilavan
Messages: 13
Registered: May 2005
Location: india
|
Junior Member |
|
|
Hi,
I'm trying to load data from table X in database A to table Y in DB B. I'm using simple sql select/insert method. Since the table X has huge volume of data it takes hell lot of time to complete the load.
I tried to improve the performance. I've a set of ideas, can some one suggest me the fastest & the best way to do this. Here are the methods I've.
# Disable all the index/constraints in table Y & enable them after the load.
# Use PL/SQL bulk insert
# Use Transportable partitions, Table X is a partitioned table.
(Is it possible to do this like transportable tablespaces?)
Please suggest me the best way to do this from the above or some other way other than these.
Thanks in advance,
Ponnilavan
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
