Seema,
Probably Last_DDL_Time in DBA_Objects, though that just tells you the last
time any DDL was executed on the object.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL
Jack
No!
thx
-Seema
From: Jack C. Applewhite [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: LAST REBUILD INDEX
Date: Mon, 01 Apr 2002 08:53:33 -0800
Seema,
Probably Last_DDL_Time in DBA_Objects, though that just tells you
]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: LAST REBUILD INDEX
Date: Mon, 01 Apr 2002 08:53:33 -0800
Seema,
Probably Last_DDL_Time in DBA_Objects, though that just tells you the last
time any DDL was executed on the object.
Jack
Jack
8.1.6
From: Jack C. Applewhite [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: LAST REBUILD INDEX
Date: Mon, 01 Apr 2002 10:17:42 -0800
Seema,
What version are you on? For 8.1.7.3.0 under Win2k Last_DDL_Time in
DBA_Objects