已连接到 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
已连接为 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
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货