viernes, 16 de noviembre de 2012
Soporte
http://docs.oracle.com/cd/E25290_01/doc.60/e25224/registration.htm#autoId0
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL*Plus: Release 11.1.0.6.0
http://docs.oracle.com/cd/E27212_01/html/E29258/chdiggib.html
http://docs.oracle.com/cd/E27212_01/html/E29258/chdiggib.html
http://docs.oracle.com/cd/E24842_01/html/E23289/anonvscred-1.html
http://docs.oracle.com/cd/E22734_01/html/821-2816/gdwnt.html
http://www.oracle.com/technetwork/server-storage/solaris11/documentation/es-solaris-11-whatsnew-201111-1388222.pdf
http://docs.oracle.com/cd/E22734_01/html/821-2816/gavuu.html
domingo, 11 de noviembre de 2012
Sentencia SQL
-- Traduce
SELECT C.ID-C.ID+3153+ ROWNUM AS ASQQ FROM lengua.apyw C WHERE C.GRUPO =0 ORDER BY C.ID
SELECT C.ID-C.ID+3153+ ROWNUM AS ASQQ FROM lengua.apyw C WHERE C.GRUPO =0 ORDER BY C.ID
miércoles, 24 de octubre de 2012
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;
USUARIOS
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:
miércoles, 17 de octubre de 2012
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;
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;
miércoles, 3 de octubre de 2012
Dropping a Tablespace
Dropping a Tablespace: Example
The following statement drops the
Deleting Operating System Files: Example
The following example drops the
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/
miércoles, 12 de septiembre de 2012
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
Suscribirse a:
Entradas (Atom)