GPO ( Grupo de Profissionais Oracle )
A maior comunidade Oracle do Brasil !

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>
Share

You may also like...

Deixe um comentário

O seu endereço de e-mail não será publicado.