How to create a DDL for a schema

I am new to Oracle and would appreciate some help from you gurus out there :-)

I want to create a DDL for all the tables and indexes under a certain schema. I tried to execute these commands:

 SELECT DBMS_METADATA.GET_DDL('TABLE',u.table_name, 'XAL_SUPERVISOR')

      FROM ALL_TABLES u;
 SELECT DBMS_METADATA.GET_DDL('INDEX',u.index_name, 'XAL_SUPERVISOR')

      FROM ALL_INDEXES u;

But this didn't work.....

I got these error messages:

ERROR:

ORA-31603: object "SEG$" of type TABLE not found in schema "XAL_SUPERVISOR"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA_INT", line 2857
ORA-06512: at "SYS.DBMS_METADATA_INT", line 3192
ORA-06512: at "SYS.DBMS_METADATA_INT", line 4078
ORA-06512: at "SYS.DBMS_METADATA", line 326
ORA-06512: at "SYS.DBMS_METADATA", line 410
ORA-06512: at "SYS.DBMS_METADATA", line 449
ORA-06512: at "SYS.DBMS_METADATA", line 615
ORA-06512: at "SYS.DBMS_METADATA", line 1221
ORA-06512: at line 1

ERROR:
ORA-31603: object "I_UNDO1" of type INDEX not found in schema "XAL_SUPERVISOR"

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 628
ORA-06512: at "SYS.DBMS_METADATA", line 1221
ORA-06512: at line 1

Can anyone explain what I did wrong ?

Regards
Odd B Andersen
ErgoGroup AS
Oslo, Norway Received on Wed Oct 19 2005 - 06:26:19 CDT