Re: Problems with DBMS_METADATA

On Jan 11, 10:08 am, "sati_82" <krys_..._at_interia.pl> wrote:
> Hi,
>
> I have a problem with DBMS_METADATA packet.
>
> I try to move database schema from one database to another. For moving
> table definitions (DDL) I log in source schema and use the query below
> for each table:
>
> SELECT DBMS_METADATA.GET_DDL('TABLE','table_name','table_user') FROM
> DUAL
>
> For the majority of tables everything is ok., but some of them throw an
> error:
> ORA-31603: object "table_name" of type TABLE not found in schema
> "table_user"
> 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
>
> It's very strange, because I'm sure that this table exists in schema
> "table_user". To ensure I run the query: SELECT * FROM user_tables
> WHERE table_name = 'table_name' and this query returns me 1 proper row.
>
> Could you please analize the problem and suggest the solution?
> Thanks and regards,
> Krystian

As you don't specify the exact command, my only suggestion can be all parameters are case-sensitive as far as I know.

-- 
Sybrand Bakker
Senior Oracle DBA