Get DDL from Oracle schema

Get DDL from Oracle repository

Hyperion Planing relation schema for migration repository from other RDB

set heading off;
set echo off;
Set pages 999;
set long 90000;

spool ddl_tbl.sql

select
DBMS_METADATA.GET_DDL(‘TABLE’,u.object_name)
from
user_objects u
where
object_type = ‘TABLE’
spool off;

spool ddl_ind.sql
select
DBMS_METADATA.GET_DDL(‘INDEX’,u.object_name)
from
user_objects u
where
object_type = ‘INDEX’
spool off;