Importando imp and valid objects

Verificar los objetos inválidos: 

 SELECT  *   from   dba_objects  order by   owner,  object_type

SELECT *     FROM DBA_OBJECTS
   WHERE owner = 'SYS' and object_name = 'ENABLED$INDEXES' and
            object_type = 'TABLE' and rownum <=1;

  SELECT COUNT(*) "ERRORS DURING RECOMPILATION" from utl_recomp_errors;

 ALTER INDEX Esquema.indice_Name REBUILD TABLESPACE name_tbs;

USUARIOS

SELECT * from all_USERS ORDER BY USERNAME ;

SELECT *  FROM dba_users  ORDER BY 1;
SELECT username, password, external_name  FROM dba_users  ORDER BY 1;

First import the dump by excluding the indexes and later import the same dump by including the indexes as below.   

1.)  impdp system/xxxx DUMPFILE=SHAIK72_01.dmp LOGFILE=SHAIK72_imp.log remap_schema= SHAIK72:SHAIK72  exclude=indexes 

2.)  impdp system/xxxx  DUMPFILE=SHAIK72_01.dmp LOGFILE=SHAIK72_imp1.log remap_schema= SHAIK72:SHAIK72  include=indexes 

Referencia: 

http://neeraj-dba.blogspot.mx/2011/12/ora-39083-object-type-indexstatistics.html

http://neeraj-dba.blogspot.mx/2011/11/ora-39082-created-with-compilation.html

http://ora-39112.ora-code.com/

Actualizaciones a Tablespace y Datafile

Actualizaciones a Tablespace y Datafile 

ADD DATAFILE
ALTER TABLESPACE TBS_IIIII2007_DAT01 ADD DATAFILE
   'C:\DATABASES\DB01\DATAFILES\TBS_IIIII2007_DAT01_FILE02.DBF' SIZE 10M;

DROP DATAFILE
ALTER TABLESPACE TBS_IIIII2007_DAT01 DROP DATAFILE
   'C:\DATABASES\DB01\DATAFILES\TBS_IIIII2007_DAT01_FILE02.DBF';
ALTER DATABASE DATAFILE '/u02/oracle/rbdb1/users03.dbf'     AUTOEXTEND OFF;

CONSULTA LOS DATA FILES
SELECT * FROM DBA_DATA_FILES ;

MOVIENDO UN TABLESPACE
alter table table_name move tablespace users;

UN ERROR COMÚN
-- ORA-01652: unable to extend temp segment by 128 in tablespace TBS_01

BORRANDO UN TABLESPACE
DROP TABLESPACE TBS_01
   INCLUDING CONTENTS AND DATAFILES;

CREANDO UN TABLESPACE
 CREATE TABLESPACE TBS_01
 DATAFILE       '/u0......../TBS_01.DBF'  SIZE 20M,
                '/u0......./TBS_02.DBF' SIZE 20M
 EXTENT MANAGEMENT LOCAL
 SEGMENT SPACE MANAGEMENT AUTO;

MODIFICANDO UN TABLESPACE OPCIONES
ALTER DATABASE DATAFILE '/u0....../TBS_02.DBF'  RESIZE 200M;

ALTER TABLESPACE TBS_CB_CVP ADD DATAFILE '/u0....../TBS_03.DBF'  SIZE 50M;

ALTER TABLESPACE users
    ADD DATAFILE '/u0x/.../users03.dbf' SIZE 10M
      AUTOEXTEND ON
      NEXT 512K
      MAXSIZE 250M;

INCREMENTO EN AUTOMÁTICO
ALTER DATABASE DATAFILE '/u0..../TBS_CB_CVP_06.DBF' AUTOEXTEND ON;
alter table table_name move tablespace users;

UN ERROR COMÚN
-- ORA-01652: unable to extend temp segment by 128 in tablespace TBS_01

BORRANDO UN TABLESPACE
DROP TABLESPACE TBS_01
   INCLUDING CONTENTS AND DATAFILES;

CREANDO UN TABLESPACE
 CREATE TABLESPACE TBS_01
 DATAFILE       '/u0......../TBS_01.DBF'  SIZE 20M,
                '/u0......./TBS_02.DBF' SIZE 20M
 EXTENT MANAGEMENT LOCAL
 SEGMENT SPACE MANAGEMENT AUTO;

MODIFICANDO UN TABLESPACE OPCIONES
ALTER DATABASE DATAFILE '/u0....../TBS_02.DBF'  RESIZE 200M;
ALTER TABLESPACE TBS_CB_CVP ADD DATAFILE '/u0....../TBS_03.DBF'  SIZE 50M;
ALTER TABLESPACE users
    ADD DATAFILE '/u0X/... /users03.dbf' SIZE 10M
      AUTOEXTEND ON
      NEXT 512K
      MAXSIZE 250M;

INCREMENTO EN AUTOMÁTICO
ALTER DATABASE DATAFILE '/u0..../TBS_CVP.DBF' AUTOEXTEND ON;

Dropping a Tablespace

Dropping a Tablespace: Example
The following statement drops the tbs_01 tablespace and drops all referential integrity constraints that refer to primary and unique keys inside tbs_01:

DROP TABLESPACE tbs_01 
    INCLUDING CONTENTS 
        CASCADE CONSTRAINTS; 

Deleting Operating System Files: Example
The following example drops the tbs_02 tablespace and deletes all associated operating system datafiles:

DROP TABLESPACE tbs_02
   INCLUDING CONTENTS AND DATAFILES;

Moviendo hacia otro tablespace tablas e índices en oracle

Moviendo hacia otro tablespace tablas e índices en oracle

Para mover una tabla y/o indice de un tablespace a otro se debe aplicar un ALTER como los siguientes

ALTER TABLE NOMBRE_ESQUEMA.NOMBRE_TABLA MOVE TABLESPACE NOMBRE_TABLESPACE;

ALTER INDEX NOMBRE_ESQUEMA.NOMBRE_INDICE REBUILD TABLESPACE NOMBRE_TABLESPACE;

Generar el movimiento de tablas desde un esquema a otro caso de que se selecciona toda la lista de tablas de un esquema y crea el SQL anterior.
Se continua con la tabla de indices.


select 'ALTER TABLE NOMBRE_ESQUEMA.' || table_name || ' MOVE TABLESPACE NOMBRE_TABLESPACE;' from all_tables where owner = 'NOMBRE_ESQUEMA'

select 'ALTER INDEX NOMBRE_ESQUEMA.' || index_name || ' REBUILD TABLESPACE NOMBRE_TABLESPACE;' from all_indexes where table_owner = 'NOMBRE_ESQUEMA'


Fuente de información:
http://gonzalo.aro.cl/blog/2010/07/07/moviendo-hacia-otro-tablespace-tablas-e-indices-en-oracle/

Referencias

1.- Solaris
http://www.sunfreeware.com/

2.- Unix Linux
http://www.techieblogger.com/2009/10/linux-unix-ubuntu-solaris-cheat-sheets.html
http://www.ite.educacion.es/formacion/materiales/85/cd/REDES_LINUX/unix/Permisos_de_archivos_y_carpetas.html
http://es.tldp.org/LinuxFocus/pub/mirror/LinuxFocus/Castellano/September2001/article216.shtml
2.1.- Básico Unix
http://iie.fing.edu.uy/~vagonbar/unixbas/tutorial.htm

3.- Bases de Datos
http://www.databasejournal.com/

4.- Administración de sistemas
http://rm-rf.es/
http://systemadmin.es/

5.- Centos y Heartbeat 
http://rm-rf.es/cluster-http-en-alta-disponibilidad-con-centos-heartbeat/

6.- Documentación Oracle 11.1 (11 g Release 1 (11.1) )
http://www.oracle.com/pls/db111/homepage

7.- Documentación Oracle 11.2  (11 g Release 2 (11.2) )
http://www.oracle.com/pls/db112/homepage

8.- Procesadores
http://www.10stripe.com/featured/cpu/amdcores.php
http://vjavierf.wordpress.com/2011/02/05/sistemas-operativos-y-arquitecturas-de-32-y-64-bits/#comment-225

9.- Oracle Software Delivery Nube
https://edelivery.oracle.com/

10.- Oracle
http://www.oracle-base.com/index.php
http://www.orasite.com/
https://wikis.oracle.com/dashboard.action
https://support.oracle.com/
http://mioracle.blogspot.mx/2008/02/memoria-de-oracle.html

11.- Inicio y arranque de Oracle en gráfico según ...
http://vjavierf.wordpress.com/2010/10/29/arrancar-parar-base-de-datos-oracle/#encuesta
http://vjavierf.wordpress.com/2011/03/21/abriendo-una-base-de-datos-oracle/

12.- Oracle y otros
http://psoug.org/index.htm
http://psoug.org/library.html
http://psoug.org/reference/buffer_pools.html#.UE5sc_wjUCU.gmail

13.- Arquitectura Oracle base de datos
http://deckerix.com/blog/explorando-la-arquitectura-de-la-base-de-datos-oracle/

14.- Tareas automáticas
http://www.alcancelibre.org/staticpages/index.php/configuracion-uso-crond
http://www.ajpdsoft.com/modules.php?name=News&file=article&sid=379#.UFDLe8Fy7Z9
http://web.mit.edu/rhel-doc/3/rhel-sag-es-3/ch-autotasks.html
http://www.freebsd.org/doc/handbook/configtuning-cron.html

15.- Respaldamos
http://www.linkedin.com/leads?crid=1027483&cid=85491&clickUrl=0_b5aN5ZLb9eMriiQlD0taY6o6cGEUtV2e68UkJSy4ccpG0qsXwSVsyMzRFoVIl4uR40nZA1IGAeBmJKxm8Er9gdkiSur5MMl3rfKodWRtM3o&eid=1054637&etype=CMPY&h=3Wdc&cspt=http%3A%2F%2Fwww.linkedin.com%2Fcsp%2Fcts%3Fv%3D1%26cs%3D0_b3SvrmYfvRva3BledZduGxm-s5l199jCRYp6rCpToIbDMC7p45SdizMXFIX16kv9QNaxIj6SRgY3dCVG95vQ-sB2UIBdW47C2gnuQn0w8eZ7AITepAzB34WiS-2KKF5qGCNNZccS-TwcBAkwORD5YefIEw1Iv5Y7gWByNFyHLSRdojDj391duXwE7NOeOAYWvGOyUugas39mdob7fWsVkHfq1DhoDNq9teS0ODOlYL1

16.- Reportes
http://jasperforge.org/index.php?q=project%2Fireport

Frase de Larry

“Individually and collectively, they continue to validate our stringent hiring standards through their attitudes and achievements. Our selection criteria are extensive and demanding. We look for the kind of people with whom we want to work on a daily basis: people with track records of exceptional achievement in school and business, people with strong self-motivation and an uncommon drive to excel, and, every bit as important, people who are well-rounded and fun to be around.”

-Larry .J. Ellison, CEO

Formato para el archivo /etc/crontab

Formato para el archivo /etc/crontab.

http://web.mit.edu/rhel-doc/3/rhel-sag-es-3/ch-autotasks.html

http://www.freebsd.org/doc/handbook/configtuning-cron.html

http://www.alcancelibre.org/staticpages/index.php/configuracion-uso-crond