"Odd Bjørn Andersen" <odd.andersen_at_ergo.no> wrote in
news:1129721181.976837_at_makrell.interpost.no:
> 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
>
>
>
set long 32000
SELECT DBMS_METADATA.GET_DDL('TABLE',u.table_name, 'XAL_SUPERVISOR')
FROM DUAL;
Received on Wed Oct 19 2005 - 08:08:54 CDT
