RE: ALTER TABLE DROP COLUMNS CONTINUE - how far has it gotten

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

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 the number of extents in the table being truncated. When I queried DBA_SEGMENTS to find the number of extents for the table, I found that the TRUNCATE finished when USED_UREC hits the same number as the number of extents, hence my assumption about the meaning of the value in USED_UREC.

I don't know if you might be able to find similar info for a DROP COLUMNS command, but I'd guess that USED_UREC might correspond to the number of rows being modified by the DROP COLUMN, so having the original NUM_ROWS or COUNT(*) on the table might be helpful. Since you are doing a CONTINUE operation, even if this was true it might be difficult to gauge where you are currently since you probably don't know how many rows you had processed in the previous transaction(s)...

For query purposes, V$SESSION.TADDR joins to V$TRANSACTION.ADDR...

Hope this helps...

-Tim

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Sunday, September 22, 2002 3:03 PM

> 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 official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Miller, Jay
> INET: JayMiller_at_TDWaterhouse.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gorman
  INET: Tim_at_SageLogix.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: JayMiller_at_TDWaterhouse.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).