Oracle Technology Blog

OraTech Blog provides tips,tricks,scripts and how-to type answers for Oracle related technologies. I use these commands very often, so I thought it would be useful to share with everybody. Please feel free to include your comments/corrections/questions.

Thursday, November 30, 2006

How to move LOB objects or partition to different tablespace

alter table SCHEMA1.LOB_TABLE move lob(lob_column) store as (tablespace lob_ts);

ALTER TABLE PartitionTableName MOVE PARTITION PartitionName TABLESPACE NewTableSpace

alter table move partition lob () store as ( tablespace
)

1 Comments:

Blogger kagaoare said...

888 Casino App Download For Samsung Galaxy S10
888 is an 당진 출장안마 online 안성 출장안마 casino that 부산광역 출장마사지 brings a wealth of entertainment, games and 광주 출장샵 live entertainment to every device. With more than 5000 games to choose 광주광역 출장안마 from, you

7:56 AM  

Post a Comment

<< Home