05 Mayıs 2009 Salı

profile scripts with dbms_metadata.get_ddl

set feedback off
set heading off
set long 4000
SELECT dbms_metadata.get_ddl('PROFILE',profile) FROM dba_profiles WHERE profile != 'DEFAULT'

0 yorum: