怎么查oracle的表空间,查询oracle表空间

最新推荐文章于 2024-10-08 06:21:20 发布

weixin_39637979

最新推荐文章于 2024-10-08 06:21:20 发布

阅读量108

点赞数

文章标签： Oracle SQL*Plus 数据文件视图数据库连接

dc-test2sqlplus /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