oracle - How to solve ORA-04063: view "SYS.ALL_QUEUE_TABLES" has errors? -


jdev version 11.1.1.7.1

i using oracle database 10g xe & able connect db , retrieve tables in hr schema. when trying create "business components table" getting above mentioned error. have uninstalled jdeveloper , once again reinstalled it. still getting same error.

here description of error :-

the following sql statement failed :  select /*oracledictionaryqueries.all_oracle_object_query(3)*/    o.object_name, o.object_type, o.object_id   all_objects o  o.owner = ? ,    o.object_name ? ,    o.object_type in (?, ?, ?) ,    o.subobject_name null ,    o.secondary = 'n' ,    ( o.object_type <> 'index' or      (       exists (select 1                 all_indexes                i.owner = o.owner               ,    i.index_name = o.object_name          ,    i.dropped = 'no'              )      )    ) ,    ( o.object_type <> 'trigger' or      (       exists (select 1                 all_triggers tr                tr.owner = o.owner               ,    tr.trigger_name = o.object_name               ,   (   tr.base_object_type <> 'table'                      or exists ( select 1 all_tables t2                                   t2.owner = tr.table_owner                                  ,    t2.table_name = tr.table_name                             ,    t2.dropped = 'no'                                 )                     )              )      )    ) ,    ( o.object_type <> 'type' or      exists (select 1                 all_types t                t.owner = o.owner               ,    t.type_name = o.object_name)    ) ,    ( o.object_name not 'aq$%' or      not exists      ( select 1          all_queue_tables qt         o.owner = qt.owner        ,    (   o.object_name = 'aq$'||qt.queue_table                or o.object_name 'aq$'||qt.queue_table||'^_%' escape '^'                or o.object_name 'aq$^_'||qt.queue_table||'^_%' escape      '^')       )    ) union select /*oracledictionaryqueries.all_table_oracle_query*/    x.table_name ,     'table' object_type ,     (select o.object_id      all_objects o     o.owner = x.owner    , o.object_type = 'table'    , o.object_name = x.table_name) object_id ( select t.table_name, t.owner   all_tables t  t.owner = ? ,    t.nested = 'no' ,    t.table_name ? ,    t.iot_name null ,    t.secondary = 'n' ,    t.dropped = 'no' minus select qt.queue_table, qt.owner   all_queue_tables qt  qt.owner = ? ,    qt.queue_table ? minus select mv.mview_name, mv.owner   all_mviews mv  mv.owner = ? ,    mv.mview_name ? minus select mvl.log_table, mvl.log_owner   all_snapshot_logs mvl  mvl.log_owner = ? ,    mvl.log_table ? minus select ru.table_name, ru.owner   all_tables ru  ru.table_name 'rupd%' ,    ru.temporary = 'y' ,    ru.owner = ? ,    exists (select 1              all_tab_columns atc             atc.owner = ru.owner            ,    atc.table_name = ru.table_name            ,    atc.column_name = 'change_vector$$') ) x union select t.table_name ,     'table' object_type ,     (select o.object_id      all_objects o     o.owner = t.owner    , o.object_type = 'table'    , o.object_name = t.table_name) object_id   all_object_tables t  t.owner = ? ,    t.table_name ? ,    t.iot_name null ,    t.nested = 'no' ,    t.secondary = 'n' ,    t.dropped = 'no' 

can please me out ?

assuming database not corrupted, possible cause of user you're logged in database doesn't have permission access sys.all_queue_tables view. test can execute select * sys.all_queue_tables. if you're unable select data all_queue_tables, have dba grant appropriate access (you need select) or, if system have access appropriately privileged account, log in privileged user , execute grant select on sys.all_queue_tables whatever_user_needs_access, replacing whatever_user_needs_access user name need give access grant to. best of luck.


Comments

Popular posts from this blog

java - Date formats difference between yyyy-MM-dd'T'HH:mm:ss and yyyy-MM-dd'T'HH:mm:ssXXX -

c# - Get rid of xmlns attribute when adding node to existing xml -