No, I do not try this.Quote:
Originally posted by marist89
Are you trying to describe a table across a database link? There have been problems with this as well.
chris
Printable View
No, I do not try this.Quote:
Originally posted by marist89
Are you trying to describe a table across a database link? There have been problems with this as well.
chris
connect to DB from SQL*PLUS then describe the object see what happens.
hi ,
first of all tell me,do u want to desc the cammand or the object if u want to desc the object and it is in ur scheme then just type
DESC table emp ;
and if u what to desc the cammand so start the EXPLAIN cammand and then rerun the cammand
Doesnt sound like a the bug we were hitting. Is the table owned by the same user that you are doing the desc as. If not then you have to do to desc. or you can create a public synonym for that table as sys or system:
create public synonymfor . ;
Originally posted by fraze
Doesnt sound like a the bug we were hitting. Is the table owned by the same user that you are doing the desc as. If not then you have to do to desc. or you can create a public synonym for that table as sys or system:
create public synonymfor . ;
Post didnt come out correctly. Should read
Doesnt sound like a the bug we were hitting. Is the table owned by the same user that you are doing the desc as. If not then you have to do to desc as. if not then you have to do
desc OWNER.TABLE_NAME
or create a public synonym for the table:
create public synonym TABLE_NAME for OWNER.TABLE_NAME;