Thanks Tim. That gives me somewhere to look. I'll set up a test table
sometime this week and try it out for future reference. If I come up with
anything I'll post it back here.
Jay
-Original Message-
Sent: Sunday, September 22, 2002 6:23 PM
To: Multiple recipients of list ORACLE-L
J
Jay,
I've not played with that particular command lately, but it is likely that
V$TRANSACTION can provide some info. For example, when I'm doing a TRUNCATE
on a large table, I have found that the value in the column USED_UREC (i.e.
number of undo records created) on V$TRANSACTION corresponded to
A drop unused columns checkpoint was interrupted opn a large table.
As a result the table is not readable while we are running ALTER TABLE DROP
COLUMNS CONTINUE
Is there any way to determine how far it has gotten? There is no entry in
V$SESSION_LONGOPS.
Thanks.
Jay Miller
--
Please see the