Database Administration (MOSC)

MOSC Banner

Right command to move a LOB to another Tablespace

A LOB with simple column name can be moved to a different tablespace using the following command.


alter table "OWNER"."TABLE_NAME" move lob("COLUMN_NAME") STORE AS (TABLESPACE "NEW_TBS");


However, we've some LOBs with COLUMN_NAMEs as listed below.


"USER_DATA"."PARAMETER_LIST"

"USER_DATA"."HEADER"."PROPERTIES"

"USER_DATA"."TEXT_LOB"


How can we move LOBs with such COLUMN_NAMEs?


Thanks,


Kashif.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center