Re: Problems with DBMS_METADATA

sati_82 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

This is likely a character set issue given your .pl domain: Check metalink.

And, of course, make sure that (A) it is a table, and (B) that you are identifying the correct schema. Be sure you are not looking at a synonym for example.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org