Habilitando e utilizando OMF – Oracle Managed Files
Eu prefiro utilizar OMF. Para que ficar perdendo tempo colocando nome de DATAFILEs em ordem? Veja que no teste abaixo, o DATAFILE é criado já em AUTOEXTEND ON, evitando algumas dores de cabeça.
[oracle@nerv00 ~]$ sqlplus / AS SYSDBA
SQL*Plus: Release 11.2.0.2.0 Production on Fri Oct 8 07:53:52 2010
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
SQL> SET PAGES 1000
SQL> SET LINES 210
SQL> CREATE TABLESPACE TESTE;
CREATE TABLESPACE TESTE
*
ERROR at line 1:
ORA-02199: missing DATAFILE/TEMPFILE clause
SQL> SHOW PARAMETER DB_CREATE_FILE_DEST;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest string
SQL> ALTER SYSTEM SET DB_CREATE_FILE_DEST='/u01/app/oracle/oradata';
System altered.
SQL> CREATE TABLESPACE TESTE;
Tablespace created.
SQL> COL FILE_NAME FORMAT A80
SQL> SELECT FILE_NAME, BYTES, AUTOEXTENSIBLE, INCREMENT_BY FROM DBA_DATA_FILES;
FILE_NAME BYTES AUT INCREMENT_BY
-------------------------------------------------------------------------------- ---------- --- ------------
/u01/app/oracle/oradata/CATALOGO/users01.dbf 5242880 YES 160
/u01/app/oracle/oradata/CATALOGO/undotbs01.dbf 68157440 YES 640
/u01/app/oracle/oradata/CATALOGO/sysaux01.dbf 660602880 YES 1280
/u01/app/oracle/oradata/CATALOGO/system01.dbf 754974720 YES 1280
/u01/app/oracle/oradata/CATALOGO/example01.dbf 362414080 YES 80
/u01/app/oracle/oradata/CATALOGO/datafile/o1_mf_teste_6bxy6w5y_.dbf 104857600 YES 12800
6 rows selected.
SQL>