Re: populating tables based on some v$ views
- From: "Gints Plivna" <gints.plivna@xxxxxxxxx>
- To: JBECKSTROM@xxxxxxxxx
- Date: Tue, 5 Dec 2006 18:25:48 +0200
And yea thought a bit more :) - you can use gv$ instead:
SQL> drop table q;
Table dropped.
Elapsed: 00:00:00.00
SQL> create table q as select * from gv$version;
Table created.
Elapsed: 00:00:00.00
SQL> insert into q@dlink select * from gv$version;
5 rows created.
Elapsed: 00:00:00.01
SQL>
Gints Plivna
http://www.gplivna.eu
--
//www.freelists.org/webpage/oracle-l
Other related posts:
