Re: Number of Rows Created in CTAS across DBLINK

this works locally, no reason why it shouldn't work with a db link:

begin
  execute immediate 'create table this as select * From that';   dbms_output.put_line('Created THIS with ' || to_char(SQL%ROWCOUNT) ||' rows.');
end;
/

SQL*Plus is just too lazy to show you the number of rows, so use execute immediate to get at the cursor variable.

• mcs

"Arup Nanda" <arupnanda_at_hotmail.com> wrote in message news:c60879a3.0311071235.339d57a1_at_posting.google.com...
> Hello All,
>
> When I create a table TARGET as
>
> CREATE TABLE TARGET AS SELECT * FROM SOURCE_at_DBLINK1
>
> where SOURCE is a view in a remote system, how do I find out how many
> rows were created?
>
> Any help will be appreciated.
>
> Thanks.
>
> Arup
Received on Fri Nov 07 2003 - 14:56:46 CST