| chain row [message #62373] |
Sat, 17 July 2004 21:35  |
mb
Messages: 51
Registered: March 2001
|
Member |
|
|
hi,
what is the meaning of CHAIN ROWS and CHAINED_ROWS table ?
thanks a lot
|
|
|
|
| Re: chain row [message #62374 is a reply to message #62373] |
Sat, 17 July 2004 23:06  |
Frank Naude
Messages: 4589
Registered: April 1998
|
Senior Member |
|
|
Hi,
The CHAINED_ROWS table doesn't have a column called "CHAIN ROWS". Are you maybe using a query with column aliases?
SQL> desc chained_rows
Name Null? Type
----------------------------------------- -------- ----------------------------
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
Best regards.
Frank
|
|
|
|
| Re: chain row [message #62512 is a reply to message #62374] |
Mon, 26 July 2004 00:45 |
mb
Messages: 51
Registered: March 2001
|
Member |
|
|
hi, thank you
I don't know the meaning of chain row ,exactly.
would u please explain what is chain row and when we use it , thanks a lot.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
