Seems really weird, Could u please check the "owner" for AGREEMENTS from
all_objects.
Ecce Nihil wrote:
> I'm having problems using dbms_metadata.get_ddl. I have a table called
> agreements with the following entry out of user_objects...
>
> select OBJECT_NAME,OBJECT_TYPE,STATUS from user_objects where
> object_name='AGREEMENTS';
>
> OBJECT_NAME OBJECT_TYPE STATUS
> -------------- ------------------ -------
> AGREEMENTS TABLE VALID
>
> Then I execute...
>
> select dbms_metadata.get_ddl('TABLE','AGREEMENTS') from dual
>
> and get...
>
> ORA-31603: object "AGREEMENTS" of type TABLE not found in schema
> "MY_SCHEMA"
>
> Any ideas?
>
> thanks
Received on Fri Jun 20 2003 - 03:04:20 CDT
