Feedback of rows

From: Mahesh <mash1830-yahoo_at_yahoo.com>
Date: Tue, 24 Jun 2003 12:44:38 +0100
Message-ID: <1056455079.39745@ernani.logica.co.uk>

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 Received on Tue Jun 24 2003 - 06:44:38 CDT