alter tablespace ts_name autoextend_clause
This clause is valid only for bigfile (single-file) tablespaces. Use this clause to enable or disable autoextension of the single data file in the tablespace. To enable or disable autoextension of a newly added data file or temp file in smallfile tablespaces, use the autoextend_clause of the database_file_clauses in the ALTER DATABASE statement
[oracle@rac1 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Wed Apr 18 22:37:12 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected.
SQL> create tablespace ts_smallfile datafile '/s01/oracle/oradata/orcl/small.dbf' size 5m;
Tablespace created.
SQL> alter tablespace ts_smallfile autoextend on next 5m;
alter tablespace ts_smallfile autoextend on next 5m
*
ERROR at line 1:
ORA-32773: operation not supported for smallfile tablespace TS_SMALLFILE
SQL> create bigfile tablespace ts_bigfile datafile '/s01/oracle/oradata/orcl/bigfile1.dbf' size 5m;
Tablespace created.
SQL> alter tablespace ts_bigfile autoextend on next 5m;
Tablespace altered.
SQL> alter database datafile '/s01/oracle/oradata/orcl/small.dbf' autoextend on next 5m;
Database altered.
SQL>
This clause is valid only for bigfile (single-file) tablespaces. Use this clause to enable or disable autoextension of the single data file in the tablespace. To enable or disable autoextension of a newly added data file or temp file in smallfile tablespaces, use the autoextend_clause of the database_file_clauses in the ALTER DATABASE statement
[oracle@rac1 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Wed Apr 18 22:37:12 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected.
SQL> create tablespace ts_smallfile datafile '/s01/oracle/oradata/orcl/small.dbf' size 5m;
Tablespace created.
SQL> alter tablespace ts_smallfile autoextend on next 5m;
alter tablespace ts_smallfile autoextend on next 5m
*
ERROR at line 1:
ORA-32773: operation not supported for smallfile tablespace TS_SMALLFILE
SQL> create bigfile tablespace ts_bigfile datafile '/s01/oracle/oradata/orcl/bigfile1.dbf' size 5m;
Tablespace created.
SQL> alter tablespace ts_bigfile autoextend on next 5m;
Tablespace altered.
SQL> alter database datafile '/s01/oracle/oradata/orcl/small.dbf' autoextend on next 5m;
Database altered.
SQL>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26870952/viewspace-2153076/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26870952/viewspace-2153076/