已连接到 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 
已连接为 SYS
SQL> select status from v$instance;STATUS
------------
MOUNTED
SQL> select * from v$tablespace;       TS# NAME                           INCLUDED_IN_DATABASE_BACKUP BIGFILE FLASHBACK_ON ENCRYPT_IN_BACKUP
---------- ------------------------------ --------------------------- ------- ------------ -----------------
         0 SYSTEM                         YES                         NO      YES          
         1 UNDOTBS1                       YES                         NO      YES          
         2 SYSAUX                         YES                         NO      YES          
         4 USERS                          YES                         NO      YES          
         3 TEMP                           NO                          NO      YES          
         6 EXAMPLE                        YES                         NO      YES          6 行 已选择SQL> select * from v$datafile;     FILE# CREATION_CHANGE# CREATION_TIME        TS#     RFILE# STATUS  ENABLED    CHECKPOINT_CHANGE# CHECKPOINT_TIME UNRECOVERABLE_CHANGE# UNRECOVERABLE_TIME LAST_CHANGE# LAST_TIME   OFFLINE_CHANGE# ONLINE_CHANGE# ONLINE_TIME      BYTES     BLOCKS CREATE_BYTES BLOCK_SIZE NAME                                                                             PLUGGED_IN BLOCK1_OFFSET AUX_NAME                                                                         FIRST_NONLOGGED_SCN FIRST_NONLOGGED_TIME
---------- ---------------- ------------- ---------- ---------- ------- ---------- ------------------ --------------- --------------------- ------------------ ------------ ----------- --------------- -------------- ----------- ---------- ---------- ------------ ---------- -------------------------------------------------------------------------------- ---------- ------------- -------------------------------------------------------------------------------- ------------------- --------------------
         1                9 2005-8-30 13:          0          1 SYSTEM  READ WRITE             696567 2006-2-11 21:56                     0                          696567 2006-2-11 2          534906         534907 2006-1-15 1  513802240      62720            0       8192 D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF                                        0          8192 NONE                                                                                               0 
         2           532340 2005-8-30 17:          1          2 ONLINE  READ WRITE             696567 2006-2-11 21:56                     0                          696567 2006-2-11 2          534906         534907 2006-1-15 1   36700160       4480            0       8192 D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF                                       0          8192 NONE                                                                                               0 
         3             6100 2005-8-30 13:          2          3 ONLINE  READ WRITE             696567 2006-2-11 21:56                     0                          696567 2006-2-11 2          534906         534907 2006-1-15 1  272629760      33280            0       8192 D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF                                        0          8192 NONE                                                                                               0 
         4             9769 2005-8-30 13:          4          4 ONLINE  READ WRITE             696567 2006-2-11 21:56                     0                          696567 2006-2-11 2          534906         534907 2006-1-15 1    5242880        640            0       8192 D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF                                         0          8192 NONE                                                                                               0 
         5           559871 2006-1-15 16:          6          5 ONLINE  READ WRITE             696567 2006-2-11 21:56                     0                          696567 2006-2-11 2               0              0              104857600      12800    104857600       8192 D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE01.DBF                                       0          8192 NONE                                                                                               0