RC_DATAFILE |
VALID |
05/12/2002 |
05/12/2002 |
|
|
DB_KEY |
NUMBER |
|
|
|
|
N |
|
|
NO |
NO |
NO |
|
DBINC_KEY |
NUMBER |
|
|
|
|
N |
|
|
NO |
NO |
NO |
|
DB_NAME |
VARCHAR2 |
8 |
|
|
|
N |
|
|
NO |
NO |
NO |
|
TS# |
NUMBER |
|
|
|
|
N |
|
|
NO |
NO |
NO |
|
TABLESPACE_NAME |
VARCHAR2 |
30 |
|
|
|
N |
|
|
NO |
NO |
NO |
|
FILE# |
NUMBER |
|
|
|
|
N |
|
|
NO |
NO |
NO |
|
CREATION_CHANGE# |
NUMBER |
|
|
|
|
N |
|
|
NO |
NO |
NO |
|
CREATION_TIME |
DATE |
7 |
|
|
|
Y |
|
|
NO |
NO |
NO |
|
DROP_CHANGE# |
NUMBER |
|
|
|
|
Y |
|
|
NO |
NO |
NO |
|
DROP_TIME |
DATE |
7 |
|
|
|
Y |
|
|
NO |
NO |
NO |
|
BYTES |
NUMBER |
|
|
|
|
Y |
|
|
NO |
NO |
NO |
|
BLOCKS |
NUMBER |
|
|
|
|
Y |
|
|
YES |
YES |
YES |
|
BLOCK_SIZE |
NUMBER |
|
|
|
|
N |
|
|
NO |
NO |
NO |
|
NAME |
VARCHAR2 |
1024 |
|
|
|
Y |
|
|
YES |
YES |
YES |
|
STOP_CHANGE# |
NUMBER |
|
|
|
|
Y |
|
|
NO |
NO |
NO |
|
STOP_TIME |
DATE |
7 |
|
|
|
Y |
|
|
NO |
NO |
NO |
|
READ_ONLY |
NUMBER |
|
|
|
|
N |
|
|
NO |
NO |
NO |
|
RFILE# |
NUMBER |
|
|
|
|
Y |
|
|
NO |
NO |
NO |
|
INCLUDED_IN_DATABASE_BACKUP |
VARCHAR2 |
3 |
|
|
|
Y |
|
|
NO |
NO |
NO |
|
AUX_NAME |
VARCHAR2 |
1024 |
|
|
|
Y |
|
|
NO |
NO |
NO |
Total: 20 column(s)
RMAN |
DBMS_RCVMAN |
PACKAGE BODY |
0 |
Total: 1 used by reference(s)
OLAPSYS |
DBA$OLAP2_DIM_LEVELS |
VIEW |
1 |
OLAPSYS |
DBA$OLAP_DIM_LEVELS |
VIEW |
1 |
Total: 2 use reference(s)
CREATE OR REPLACE FORCE VIEW "RMAN"."RC_DATAFILE" ("DB_KEY", "DBINC_KEY", "DB_NAME", "TS#", "TABLESPACE_NAME", "FILE#", "CREATION_CHANGE#", "CREATION_TIME", "DROP_CHANGE#", "DROP_TIME", "BYTES", "BLOCKS", "BLOCK_SIZE", "NAME", "STOP_CHANGE#", "STOP_TIME", "READ_ONLY", "RFILE#", "INCLUDED_IN_DATABASE_BACKUP", "AUX_NAME") AS
select dbinc.db_key,
dbinc.dbinc_key,
dbinc.db_name,
ts.ts#,
ts.ts_name tablespace_name,
df.file#,
df.create_scn creation_change#,
df.create_time creation_time,
df.drop_scn drop_change#,
df.drop_time,
dfatt.blocks*df.block_size bytes,
dfatt.blocks,
df.block_size,
dfatt.fname name,
df.stop_scn stop_change#,
df.stop_time,
df.read_only read_only,
df.rfile#,
ts.included_in_database_backup,
df.clone_fname aux_name
from dbinc, ts, df, dfatt
where dbinc.dbinc_key = ts.dbinc_key
and ts.dbinc_key = df.dbinc_key
and ts.ts# = df.ts#
and ts.create_scn = df.ts_create_scn
and df.dbinc_key = dfatt.dbinc_key
and df.file# = dfatt.file#
and df.create_scn = dfatt.create_scn
and dfatt.end_ckp_key is null
List of views