Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can't "describe" USER_TABLES?
A copy of this was sent to cjc_at_interport.net (Cheng-Jih Chen) (if that email address didn't require changing) On 17 Mar 1998 11:59:09 -0500, you wrote:
>
>This is on a 8.0.3 database. I've re-run catalog.sql at couple of
>times now, but I can't seem to "describe user_tables" to get the
>structure of that synonym. I can however select from there. Any ideas
>what's going on?
>
>Thanks.
sqlplus bug in 8.0.3, fixed in 8.0.4.
slqplus wants you to specify the owner of the object if you do not own it (it cannot describe synonyms in 8.0.3). So
SQL> desc sys.user_tables
will work as it will describe the VIEW user_tables instead of the public synonym user_tables.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Tue Mar 17 1998 - 00:00:00 CST