Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> How to move LOB segments to a different tablespace
Krystian
post Mar 31 2017, 08:14 AM
Post #1


Newbie
*

Group: Members
Posts: 2
Joined: 31-March 17
Member No.: 51,873



Hi,
I've got a huge table with LOB segments. I'd like to move it to the new tablespace (which is a bigfile tbs).

Any advice how to do it in the most effective way. As far as I know moving LOB segments can't be parallelised - am I right?

thanks,
Krystian
Go to the top of the page
 
+Quote Post
burleson
post Mar 31 2017, 09:59 AM
Post #2


Advanced Member
***

Group: Members
Posts: 13,476
Joined: 26-January 04
Member No.: 13



Hi Krystian and welcome to the forum!

>> Any advice how to do it in the most effective way. As far as I know moving LOB segments can't be parallelised - am I right?

Please see here:

http://www.dba-oracle.com/t_move_table_lob_column.htm

************************************************************

>> As far as I know moving LOB segments can't be parallelised - am I right?

You can try using CTAS in parallel:

http://www.dba-oracle.com/t_move_table_lob_column.htm

also, remove all indexes,constraints and re add them later.

http://www.dba-oracle.com/t_insert_tuning.htm




--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
Krystian
post Mar 31 2017, 11:02 AM
Post #3


Newbie
*

Group: Members
Posts: 2
Joined: 31-March 17
Member No.: 51,873



Thank you, Donald
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 25th July 2017 - 09:31 PM