Number of Rows Created in CTAS across DBLINK

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:35:23 CST