Re: ad & txk 9 upgrade

Posted by Adhrushta on
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ad-txk-9-upgrade-tp2945p3005.html

When i check AD_DDL and AD_INST,they are valid.

I run tese command;

create or replace public synonym AD_DDL for system.AD_DDL
create or replace public synonym AD_INST for system.AD_INST

but patch still getting error,after that I also comment syntax but still same error;

#prompt
#prompt --- create public synonyms for ad_inst and ad_ddl
#
#declare
#cursor ddls is
#select 'create or replace public synonym '||list.synname||
#       ' for system.'||list.synname as text
#from   (select trim(t.column_value) synname
#        from   xmltable(('"AD_DDL","AD_INST"')) t) list
#where  not exists (select null from dba_synonyms where
#                   synonym_name = list.synname and owner='PUBLIC'
#                   and table_name=synonym_name and table_owner='SYSTEM');
#begin
#  for ddl in ddls
#  loop
#    execute immediate ddl.text;
#  end loop;
#end;
#/
#
#prompt