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>

Leave a Reply

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

Esse site utiliza o Akismet para reduzir spam. Aprenda como seus dados de comentários são processados.