C:\>sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.6.0 - Production on 星期六 7月 28 09:54:30 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
连接到:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
SQL> select sum(bytes)/1024/1024/1024 from dba_data_files
2 where tablespace_name='EYGLE';
SUM(BYTES)/1024/1024/1024
-------------------------
28.1152344
SQL> set timing on
SQL> drop tablespace eygle including contents and datafiles;
表空间已丢弃。
已用时间: 00: 00: 14.01