Oracle: minimal user rights

create user hypplan identified by hypplan;
grant create session,resource,connect to hypplan;
grant create view to hypplan;

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;