Eliminar claves foraneas

SELECT 'ALTER TABLE '|| TABLE_NAME || ' DROP CONSTRAINT ' || CONSTRAINT_NAME 
|| ' ;'
FROM dba_constraints where constraint_type = 'R' and status = 'ENABLED'
and owner='nombreEsquema';