craig Site Admin
Joined: 19 Feb 2006 Posts: 40
|
Posted: Thu Feb 12, 2009 11:18 am Post subject: create snapshot tables ddl |
|
|
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; |
|