Chapter 37:The Hitchhiker’s Guide to the Oracle9i Data Dictionary717The analyze command can
lượt xem 4
download
Chapter 37: The Hitchhiker’s Guide to the Oracle9i Data Dictionary 717 The analyze command can be used to generate a listing of the chained rows within a table. This listing of chained rows can be stored in a table called CHAINED_ROWS. To create the CHAINED_ROWS table in your schema, run the utlchain.sql script (usually found in the /rdbms/ admin subdirectory under the Oracle home directory). To populate the CHAINED_ROWS table, use the list chained rows into clause of the analyze command, as shown in the following listing: analyze TABLE BIRTHDAY list chained rows into CHAINED_ROWS; The CHAINED_ROWS table lists the Owner_Name, Table_Name, Cluster_Name (if the...
Bình luận(0) Đăng nhập để gửi bình luận!
CÓ THỂ BẠN MUỐN DOWNLOAD