Re: problems with dbms_metadata

all_objects has owner as MY_SCHEMA as well.

cheers

abhijith <abhijit_at_nomail.com> wrote in message news:<3EF2C004.6070105_at_nomail.com>...
> 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 Sun Jun 22 2003 - 17:47:47 CDT