Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can't "describe" USER_TABLES?

Re: Can't "describe" USER_TABLES?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1998/03/17
Message-ID: <3511b9e9.13684917@192.86.155.100>#1/1

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  



Opinions are mine and do not necessarily reflect those of Oracle Corporation  

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US