行迁移或行连接

行迁移或行连接

SQL> @?/rdbms/admin/utlchain.sql

表已创建。

SQL> desc chained_rows;
 名称                                      是否为空? 类型
 ----------------------------------------- -------- ----------------------------
 OWNER_NAME                                         VARCHAR2(30)
 TABLE_NAME                                         VARCHAR2(30)
 CLUSTER_NAME                                       VARCHAR2(30)
 PARTITION_NAME                                     VARCHAR2(30)
 SUBPARTITION_NAME                                  VARCHAR2(30)
 HEAD_ROWID                                         ROWID
 ANALYZE_TIMESTAMP                                  DATE

SQL>
SQL> select * from chained_rows;

未选定行

 select 'analyze table '|| table_name ||' list chained rows into chained_rows;' from user_tables;