SYSAUX 8192 ONLINE PERMANENT LOGGING
UNDOTBS1 8192 ONLINE UNDO LOGGING
TEMP 8192 ONLINE TEMPORARY NOLOGGING
USERS 8192 ONLINE PERMANENT LOGGING
ZCHBKJ 8192 ONLINE PERMANENT LOGGING
6 rows selected.
SQL> col file_name for a50
SQL> select file_id,file_name,tablespace_name,status,bytesfrom dba_data_files;
FILE_ID FILE_NAME TABLESPACE_NAME STATUS BYTES
------------------------------------------------------------ --------------- ----------------------------
4/home/oracle/oracle/oradata/mdsp/users01.dbf USERS AVAILABLE 36241408000
3/home/oracle/oracle/oradata/mdsp/undotbs01.dbf UNDOTBS1 AVAILABLE 99614720
2 /home/oracle/oracle/oradata/mdsp/sysaux01.dbf SYSAUX AVAILABLE 744488960
1/home/oracle/oracle/oradata/mdsp/system01.dbf SYSTEM AVAILABLE 765460480
5/home/oracle/oracle/oradata/mdsp/ZCHBKJ.dbf ZCHBKJ AVAILABLE 524288000
SQL> select username,created from dba_users;
USERNAME CREATED
------------------------------------------------------------------------
MGMT_VIEW 15-AUG-09
SYSTEM 15-AUG-09
DBSNMP 15-AUG-09
SYSMAN 15-AUG-09
IMUSE01 30-OCT-10
ZCH 10-NOV-10
SYS 15-AUG-09
OUTLN 15-AUG-09
FLOWS_FILES 15-AUG-09
MDSYS 15-AUG-09
ORDSYS