Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Feedback of rows
If this is a long operation, then query V$SESSION_LONGOPS. It will tell
you how your session is progressing. You'll have to do this from another
session though.
HTH,
Brian
Mahesh wrote:
>
> Hi ,
>
> Oracle 9.2.0 on SunOs 5.6
> ===================
>
> Wanted to know if there is any way of getting a feedback of rows created in
> a table during a "CREATE TABLE....AS SELECT...FROM TABLE" , instead of
> executing "SELECT COUNT(*) FROM TABLE" or Analysing the table after the
> create has finished .
>
> Just wanted to avoid another full scan of the table created as these are
> quite huge (around 20 mil records)
>
> Thanks in advance,
>
> Mahesh
> E: mash1830_at_yahoo.com
-- =================================================================== Brian Peasland oracle_dba_at_remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three"Received on Tue Jun 24 2003 - 09:44:51 CDT