Re: Feedback of rows

In article <1056455079.39745_at_ernani.logica.co.uk>, mash1830- yahoo_at_yahoo.com says...
> 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
>
>
>

Create the table in one step and the populate separately using a

insert into ....
select from ....

statement?

-- 

jeremy