Extracting DDL of large role.
This is being attempted in 19.13.
Hopefully this is quite a simple one, but I’m getting frustrated in my attempts.
I’m hoping to migrate some roles from one database to another. The plan was to use the commonly used role_ddl.sql written by Tim Hall many years ago. This is the code.
-- -----------------------------------------------------------------------------------
-- File Name :
https://oracle-base.com/dba/script_creation/role_ddl.sql
-- Author : Tim Hall
-- Description : Displays the DDL for a specific role.
-- Call Syntax : @role_ddl (role)
-- Last Modified: 28/01/2006
-- -----------------------------------------------------------------------------------
set long 20000 longchunksize 20000 pagesize 0 linesize 1000 feedback off verify off trimspool on