novembro 2013 Alex Zaballa - DBA Oracle - ex-Oracle ACE Director, OCM, OCA, OCP, OCE, OCS

domingo, 24 de novembro de 2013

O GUOA foi oficialmente lançado em Angola!
Entre no site para conferir as fotos do Evento e aproveite para se registrar! (www.guoa.org)

Como recuperar uma package, function ou procedure dropada acidentalmente

15:33 No comments

select object_id,object_name,object_type from dba_objects where object_name = 'OWA_UTIL';

select source
from sys.source$
as of timestamp(sysdate - 1)
where obj#=6298
order by line

Após o upgrade para 11.2.0.4 - unable to delete any rows from table with context index due to error: "PLS-00306: wrong number or types of arguments in call to 'SYNCRN'" (Doc ID 1586704.1)

14:33 No comments

After upgrade to 11.2.0.4 unable to delete any rows from table with context index due to error: "PLS-00306: wrong number or types of arguments in call to 'SYNCRN'" (Doc ID 1586704.1)

connect / as sysdba
alter session set current_schema=CTXSYS;

create or replace procedure syncrn (
ownid IN binary_integer,
oname IN varchar2,
idxid IN binary_integer,
ixpid IN binary_integer,
rtabnm IN varchar2,
srcflg IN binary_integer,
smallr IN binary_integer
)
authid definer
as external
name "comt_cb"
library dr$lib
with context
parameters(
    context,
    ownid ub4,
    oname OCISTRING,
    idxid ub4,
    ixpid ub4,
    rtabnm OCISTRING,
    srcflg ub1,
    smallr ub1
);
/