recommended method to reorganize tables with blob data type
Hi,
what is the best way/recommended method to reorganize tables with blob data type from below available methods(db version 10gr2)
1.exp/imp or expdp/impdp
2.DBMS_REDEFINITION ONLINE REORGANIZATION
3segment advisor (shrink space).
4.alter table move/CTAS
ALTER TABLE <table with_lob> MOVE LOB(c/blob_column) STORE AS (
TABLESPACE <same tablespacename> )
/
what is the best way/recommended method to reorganize tables with blob data type from below available methods(db version 10gr2)
1.exp/imp or expdp/impdp
2.DBMS_REDEFINITION ONLINE REORGANIZATION
3segment advisor (shrink space).
4.alter table move/CTAS
ALTER TABLE <table with_lob> MOVE LOB(c/blob_column) STORE AS (
TABLESPACE <same tablespacename> )
/
1