Revision: 30588
Updated Code
at September 29, 2010 18:29 by kamilch
Updated Code
DECLARE
src_schema varchar2(256) := 'EMPIK_DYNAMO_01';
target_schema varchar2(256) := 'EMPIK_PORTAL_BETA_1';
CURSOR src_objects IS
select table_name as object_name from all_all_tables where owner = src_schema
union
select sequence_name as object_name from all_sequences where sequence_owner = src_schema;
BEGIN
FOR next_row IN src_objects LOOP
BEGIN
execute immediate 'CREATE or REPLACE SYNONYM ' || target_schema || '.' || next_row.object_name || ' for ' || src_schema || '.' || next_row.object_name;
EXCEPTION WHEN OTHERS THEN
dbms_output.put_line('ERROR WHILE CREATING SYNONYM FOR: ' || next_row.object_name);
dbms_output.put_line(SQLERRM);
END;
END LOOP;
END;
/
Revision: 30587
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at August 17, 2010 23:15 by kamilch
Initial Code
DECLARE
CURSOR dynamo_tables IS select * from all_all_tables where owner = 'DYNAMO';
BEGIN
FOR next_row IN dynamo_tables
LOOP
execute immediate 'CREATE or REPLACE SYNONYM '||next_row.table_name||' for DYNAMO.'||next_row.table_name;
END LOOP;
END;
/
Initial URL
Initial Description
Initial Title
CREATE SYNONYMS
Initial Tags
Initial Language
PL/SQL