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);
精彩评论