Re: populating tables based on some v$ views

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_at_dlink select * from gv$version;

5 rows created.

Elapsed: 00:00:00.01
SQL> Gints Plivna
http://www.gplivna.eu

--
http://www.freelists.org/webpage/oracle-l