How to get a DDL statement for all Sequences in a user
Hi all...
How to get a DDL statement for all Sequences in a user. I tried following spool
script. It is giving ORA-31603:
***********************************************************************************
set pagesize 0
set long 90000
set feedback off
set echo off
spool c:\create_index.sql
SELECT DBMS_METADATA.GET_DDL('INDEX',a.OBJECT_NAME) from user_objects a where a.OBJECT_TYPE ='SEQUENCE' order by a.OBJECT_NAME;
spool off;
exit
***************************************************************************************
Thanks in advance,
Pal