intTypePromotion=1
zunia.vn Tuyển sinh 2024 dành cho Gen-Z zunia.vn zunia.vn
ADSENSE

Chapter 37:The Hitchhiker’s Guide to the Oracle9i Data Dictionary717The analyze command can

Chia sẻ: Nguyễn Hà Mỹ Ngọc | Ngày: | Loại File: PDF | Số trang:0

67
lượt xem
4
download
 
  Download Vui lòng tải xuống để xem tài liệu đầy đủ

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...

Chủ đề:
Lưu

Nội dung Text: Chapter 37:The Hitchhiker’s Guide to the Oracle9i Data Dictionary717The analyze command can

ADSENSE

CÓ THỂ BẠN MUỐN DOWNLOAD

 

Đồng bộ tài khoản
2=>2