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
Post a Comment