select pkey,
backup_type,
file_type,
keep,
keep_until,
keep_options,
status,
fname,
tag,
media,
recid,
stamp,
device_type,
block_size,
completion_time,
compressed,
obsolete,
bytes,
bs_key,
bs_count,
bs_stamp,
bs_type,
bs_incr_type,
bs_pieces,
bs_copies,
bs_completion_time,
bs_status,
bs_bytes,
bs_compressed,
bs_tag,
bs_device_type,
bp_piece#,
bp_copy#,
df_file#,
df_tablespace,
df_resetlogs_change#,
df_creation_change#,
df_checkpoint_change#,
df_ckp_mod_time,
rl_thread#,
rl_sequence#,
rl_resetlogs_change#,
rl_first_change#,
rl_first_time,
rl_next_change#,
rl_next_time,
con_id
from table(v_listBackupPipe)
SELECT PKEY
,
BACKUP_TYPE
,
FILE_TYPE
,
KEEP
,
KEEP_UNTIL
,
KEEP_OPTIONS
,
STATUS
,
FNAME
,
TAG
,
MEDIA
,
RECID
,
STAMP
,
DEVICE_TYPE
,
BLOCK_SIZE
,
COMPLETION_TIME
,
COMPRESSED
,
OBSOLETE
,
BYTES
,
BS_KEY
,
BS_COUNT
,
BS_STAMP
,
BS_TYPE
,
BS_INCR_TYPE
,
BS_PIECES
,
BS_COPIES
,
BS_COMPLETION_TIME
,
BS_STATUS
,
BS_BYTES
,
BS_COMPRESSED
,
BS_TAG
,
BS_DEVICE_TYPE
,
BP_PIECE#
,
BP_COPY#
,
DF_FILE#
,
DF_TABLESPACE
,
DF_RESETLOGS_CHANGE#
,
DF_CREATION_CHANGE#
,
DF_CHECKPOINT_CHANGE#
,
DF_CKP_MOD_TIME
,
RL_THREAD#
,
RL_SEQUENCE#
,
RL_RESETLOGS_CHANGE#
,
RL_FIRST_CHANGE#
,
RL_FIRST_TIME
,
RL_NEXT_CHANGE#
,
RL_NEXT_TIME
,
CON_ID
FROM TABLE(V_LISTBACKUPPIPE)
|
|
|