Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center