开发者

Oracle Database: how to move table create$java$LOB$TABLE into a new table space, this table has a LOB column

开发者 https://www.devze.com 2023-02-08 11:09 出处:网络
I need move table create$java$LOB$TABLE (only has 1 row data, and 1 column is LOB column) in a user schema to new table sapce, Why can\'t I drop it and recreate it with the data saved f开发者_JAVA百科

I need move table create$java$LOB$TABLE (only has 1 row data, and 1 column is LOB column) in a user schema to new table sapce, Why can't I drop it and recreate it with the data saved f开发者_JAVA百科rom exp?


Why would you want to drop it if you only want to move it.

ALTER TABLE ... MOVE

amd

ALTER TABLE table_name MOVE LOB(lob_columnname) STORE AS (TABLESPACE new_tablespace_name);
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号