SQL> select object_name from user_objects;
no rows selected
SQL> select segment_name from user_segments;
no rows selected
SQL> create table test1 as select * from ecds.MSG_MESSAGELOG;
Table created.
SQL> select segment_name,segment_type from user_segments;
SEGMENT_NAME SEGMENT_TYPE
--------------------------------------------------------------------------------- ------------------
TEST1 TABLE
SYS_IL0000324358C00006$$ LOBINDEX
SYS_LOB0000324358C00006$$ LOBSEGMENT
SQL> desc test1
Name Null? Type
----------------------------------------------------------------------------------------------------------------- -------- -----------------------------------------------------------------
回收带Lob字段表占用的空间
最新推荐文章于 2023-11-24 12:19:21 发布