var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: privileges/roles for exchange partition
I have a basic question: what privileges do you need for 'exchange partition ' to work in a stored procedure ?
I have been getting error:
ORA-20001: ORA-00942: table or view does not exist
Even though the user has select, update , insert,delete.references
privileges on all the three tables involved in my archiving procedure.
thanks for your help
It looks like we cannot use public synonyms for the following clause:
v_string := 'ALTER TABLE efdr_cash_handoff_stg EXCHANGE PARTITION '||
'part_'||p_day_of_week||' WITH TABLE efdr_cash_intrmdt '||
' UPDATE GLOBAL INDEXES ' ||
' PARALLEL (DEGREE 4) ';
EXECUTE IMMEDIATE v_string;
Am I correct?
Thanks for clarifications