SQL> alter database datafile '/oracle/oradata/orcl/ant_1.dbf' autoextend off;
Database altered.
SQL> select tablespace_name,file_name,bytes/1024/1024,maxbytes/1204/1024,autoextensible from dba_data_files;
TABLESPACE_NAME FILE_NAME BYTES/1024/1024 MAXBYTES/1204/1024 AUT
------------------------------ ---------------------------------------- --------------- ------------------ ---
USERS /oracle/oradata/orcl/users01.dbf 5 27869.1163 YES
SYSAUX /oracle/oradata/orcl/sysaux01.dbf 270 27869.1163 YES
UNDOTBS1 /oracle/oradata/orcl/undotbs01.dbf 25 27869.1163 YES
SYSTEM /oracle/oradata/orcl/system01.dbf 450 27869.1163 YES
ANTY /oracle/oradata/orcl/ant_1.dbf 150 0 NO
5 rows selected.
SQL> conn sa/oracle
Connected.
SQL> select count(*) from aa;
COUNT(*)
----------
11844
SQL> select * from ant_1;
NAME SE GRADE
----- -- ----------
li w 60
ff m 90
SQL>
阅读(1767) | 评论(0) | 转发(0) |