dc-test2<oracle>sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Feb 25 19:23:35 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> desc v$datafile;
SP2-0640: Not connected
SP2-0641: "DESCRIBE" requires connection to server
SQL> conn / as sysdba
Connected.
SQL> desc v$datafile;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE# NUMBER
CREATION_CHANGE# NUMBER
CREATION_TIME DATE
TS# NUMBER
RFILE# NUMBER
STATUS VARCHAR2(7)
ENABLED VARCHAR2(10)
CHECKPOINT_CHANGE# NUMBER
CHECKPOINT_TIME DATE
UNRECOVERABLE_CHANGE# NUMBER
UNRECOVERABLE_TIME DATE
LAST_CHANGE# NUMBER
LAST_TIME DATE
OFFLINE_CHANGE# NUMBER
ONLINE_CHANGE# NUMBER
ONLINE_TIME DATE
BYTES NUMBER
BLOCKS NUMBER
CREATE_BYTES NUMBER
BLOCK_SIZE NUMBER
NAME VARCHAR2(257)
PLUGGED_IN NUMBER
BLOCK1_OFFSET NUMBER
AUX_NAME VARCHAR2(257)
FIRST_NONLOGGED_SCN NUMBER
FIRST_NONLOGGED_TIME DATE
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/oracle/app/oradata/jttestdb1/system01.dbf
/oracle/app/oradata/jttestdb1/undotbs01.dbf
/oracle/app/oradata/jttestdb1/sysaux01.dbf
/oracle/app/oradata/jttestdb1/users01.dbf
/oracle/app/oradata/jttestdb1/sdenew.dbf
/oracle/app/oradata/jttestdb1/APP0103.DBF
/oracle/app/oradata/jttestdb1/portal.dbf
/oracle/app/oradata/jttestdb1/odi_default.dbf
/oracle/app/oradata/jttestdb1/orabpel.dbf
/oracle/app/oradata/jttestdb1/osb.dbf
/oracle/app/oradata/jttestdb1/TLINK_TAB_2009_2_001.DBF
查询oracle表空间
最新推荐文章于 2023-08-12 23:59:57 发布