Re: Getting Number of Rows in CTAS across DBLink

From: Daniel Fink <Daniel.Fink_at_Sun.COM>
Date: Fri, 07 Nov 2003 13:19:59 -0800
Message-ID: <F001.005D601D.20031107131959@fatcity.com>

Arup,

Any chance there will be an index on the table?

Daniel

>
> "Arup Nanda"

   <orarup_at_hotmail.com>                To:        Multiple
   Sent by:                    recipients of list ORACLE-L
   ml-errors_at_fatcity.com       <ORACLE-L_at_fatcity.com>
                                       cc:
    11/07/2003 12:34 PM                Subject:        Getting
    Please respond to ORACLE-L Number of Rows in CTAS across
                               DBLink

>
>
>
> List,
>
> When I create a table as select * from another table across a
> dblink, how do I find out how many rows were created in the
> table? Is there a statistic somewhere, documented or
> otherwise, that tells me how many rows were fetched?
>
> Currently I am using a rather convoluted approach - using the
> statistic, bytes received via SQL*Net to dblink, and dividing
> that by the average row size to get an approximate idea of the
> number of rows. However, this approximation is far from even
> reasonably accurate; and since the rowsize can change
> radically, it can be way off the mark. Any help or pointers
> will be highly appreciated.
>
> Thanks.
>
> Arup Nanda
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel Fink
  INET: Daniel.Fink_at_Sun.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).

Received on Fri Nov 07 2003 - 15:19:59 CST