Database Utilities (MOSC)

MOSC Banner

Spacing in METADATA generation

in Database Utilities (MOSC) 2 commentsAnswered ✓

Hey all,

Question when executing the below i get blank spaces in the output spool. I added the output file for easier viewing of the spacing


set long 20000 longchunksize 20000 pagesize 0 linesize 1000 feedback off verify off trimspool on

column ddl format a1000

begin

DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform, 'SQLTERMINATOR', TRUE);

DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform, 'PRETTY', TRUE);

DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform, 'SEGMENT_ATTRIBUTES', FALSE);

DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform, 'STORAGE', FALSE);    

DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform, 'EMIT_SCHEMA', FALSE);

end;

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