Enter user-name: SYS as sysdba
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> SELECT NAME
2 FROM V$DATAFILE;
NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/ORA11DEV/system01.dbf
/u01/app/oracle/oradata/ORA11DEV/sysaux01.dbf
/u01/app/oracle/oradata/ORA11DEV/undotbs01.dbf
/u01/app/oracle/oradata/ORA11DEV/users01.dbf
/u01/app/oracle/oradata/ORA11DEV/example01.dbf
/u01/app/oracle/oradata/ORA11DEV/examsql01.dbf
6 rows selected.
SQL> SELECT NAME, STATUS, BYTES, BLOCK_SIZE, BLOCKS
2 FROM V$DATAFILE;
V$DATAFILE_HEADER
SQL> SELECT NAME, TABLESPACE_NAME
2 FROM V$DATAFILE_HEADER;
