Svenson's Bulletin Board

[craig]

create table dba.snapshot_dbm
as ( SELECT * FROM TABLE(SNAPSHOT_DBM( 0)) as pg ) definition only;
create table dba.snapshot_fcm
as ( SELECT * FROM TABLE(SNAPSHOT_FCM( 0)) as pg ) definition only;
create table dba.snapshot_database
as ( SELECT * FROM TABLE(SNAPSHOT_DATABASE('PRODDW_1', 0)) as pg ) definition only;
create table dba.snapshot_tbs
as ( SELECT * FROM TABLE(SNAPSHOT_TBS('PRODDW_1', 0)) as pg ) definition only;
create table dba.snapshot_bp
as ( SELECT * FROM TABLE(SNAPSHOT_BP('PRODDW_1', 0)) as pg ) definition only;
create table dba.snapshot_appl
as ( SELECT * FROM TABLE(SNAPSHOT_APPL('PRODDW_1', 0)) as pg ) definition only;
create table dba.snapshot_appl_info
as ( SELECT * FROM TABLE(SNAPSHOT_APPL_INFO('PRODDW_1', 0)) as pg ) definition only;
create table dba.snapshot_statement
as ( SELECT * FROM TABLE(SNAPSHOT_STATEMENT('PRODDW_1', 0)) as pg ) definition only;