/
dimension_ddl.sql
28 lines (22 loc) · 1.29 KB
/
dimension_ddl.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
--==============================================================================
-- GPI - Gunther Pippèrr
-- Desc: DB Links DDL
--==============================================================================
set linesize 250 pagesize 3000
define USER_NAME = &1
set long 1000000
ttitle left "create DDL for all DIMENSION of this user &&USER_NAME. " skip 2
select '-- DIMENSION OWNER : '||owner||chr(10)||chr(13)||dbms_metadata.get_ddl('DIMENSION',object_name,owner ) ||';'||chr(10)||chr(13) as stmt
from dba_objects
where object_type='DIMENSION'
and owner=upper('&&USER_NAME.')
/
-- fix it to plsql block to use parameter
-- set the transformation attributes
-- dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'PRETTY', true );
-- dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'SQLTERMINATOR', true );
-- dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'REF_CONSTRAINTS', false);
-- dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'OID', false);
-- dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'SEGMENT_ATTRIBUTES', false);
-- dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM, 'TABLESPACE', true );
ttitle off