Here is the simple script for cloning the Oracle profiles.
SET serveroutput ON DECLARE CURSOR c_profiles IS SELECT PROFILE, RESOURCE_NAME, LIMIT FROM dba_profiles ORDER BY PROFILE, resource_name; s_PROFILE dba_profiles.PROFILE%TYPE ; s_prev_PROFILE dba_profiles.PROFILE%TYPE ; s_RESOURCE_NAME […]