TQ 试用 WP

winkstest@CCDB> SELECT name,ceil(bytes/1024/1024) MB,STATUS FROM v$datafile;
 
NAME                                                                 MB STATUS
------------------------------------------------------------ ---------- --------------
/oracle/oradata/ccdb/ccdb/system01.dbf                             1500 SYSTEM
/oracle/oradata/ccdb/ccdb/sysaux01.dbf                             1500 ONLINE
/oracle/oradata/ccdb/ccdb/undotbs01.dbf                            2985 ONLINE
/oracle/oradata/ccdb/ccdb/users01.dbf                               368 ONLINE
/oracle/oradata/ccdb/ccdb/example01.dbf                             100 ONLINE
/oracle/oradata/ccdb/ccdb/USER_DATA_01.DBF                            5 ONLINE
/oracle/oradata/ccdb/ccdb/WINKS_DATA_01.DBF                           5 ONLINE
/oracle/oradata/ccdb/ccdb/USER_DATA_01_WINKSTEST.DBF                  5 ONLINE
/oracle/oradata/ccdb/ccdb/WINKS_DATA_01_WINKSTEST.DBF                 5 ONLINE
/oracle/oradata/ccdb/ccdb/tq.dbf                                   4969 ONLINE
/oracle/oradata/ccdb/test/lmt_uniform.dbf                          8349 ONLINE
/oracle/oradata/ccdb/test/lmt_auto.dbf                             7138 ONLINE
 
已选择12行。

winkstest@CCDB> SELECT * FROM v$version;
 
BANNER
--------------------------------------------------------------------------------
Oracle DATABASE 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
CORE    11.1.0.6.0      Production
TNS FOR Linux: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production