Oracle

simple to Check someone who locking some objects on database

Session 1:
SQL> connect scott

SQL> select * from EMP where empno=7900 for update ;

Session 2:

SQL> connect / as sysdba

Find sid and other information on lock view with object_name.

select OBJECT_ID, OWNER,OBJECT_NAME ,l.sid , l.block from dba_objects o, V$LOCK l where l.ID1=o.OBJECT_ID and object_name = '&object_name' ;

SQL> select OBJECT_ID, OWNER,OBJECT_NAME ,l.sid , l.block from dba_objects o, V$LOCK l where l.ID1=o.OBJECT_ID and object_name = 'EMP' ;

Necesito redefinir "en-vivo" la tabla SCOTT.EMP01 de acuerdo a la siguiente formula: columna deptno=deptno+10 y además utilizar particiones.

Quizas alguien se pregunte: ¿Como puedo crear/alterar una tabla con NVARCHAR(4000)

Al consultar la documentación de Oracle, podrán darse cuenta que el tipo de datos NVARCHAR2 depende de la configuración del conjunto de caracteres (National Character Set)

Perhaps Someone ask why I can create/alter table with NVARCHAR2(4000)

If they read on Oracle Docs, they'll know NVARCHAR2 data type depend on National Character.

The maximum column size allowed is 4000 characters when the national character set is UTF8 and 2000 when it is AL16UTF16. The maximum length of an NVARCHAR2 column in bytes is 4000. Both the byte limit and the character limit must be met, so the maximum number of characters that is actually allowed in an NVARCHAR2 column is the number of characters that can be written in 4000 bytes.

La semana pasada en todoexpertos.com, recibi una pregunta sobre como instalar Oracle Server 9i en Oracle Enterprise Linux 5.2.

Como ustedes saben Oracle Server 9i esta en fase de soporte extendido (solo para el release 9.2.0.8) y verificando la matriz de certificación, el mix OEL5.2 y 9.2.0.X no esta certificado. En base a esto respondi al interesado estos datos y la conveniencia de probar con Oracle 10g u 11g.