Re: user_errors + DDL

On 2 Aug 1997 19:50:15 GMT, qiao-li_at_cs.uiuc.edu (Li Qiao) wrote:

To startwith, USER_ERRORS is just a public synonym for a view owned by SYS (called USER_ERRORS). So, I am not sure how you deduced that USER_ERRORS was a table in every schema.

Also, if you wish to see the tables owned by a user, just do, select object_name
from all_objects
where owner = 'XXXX'
and object_type = 'TABLE';

DDL stands for Data Definition Language. CREATE TABLE, DROP TABLE etc are examples for DDLs. Please check the initial chapters of SQL Lang Ref for a detailed description of the above.

Hope this helps.
sm

>Hi there,
>
> The other day I stumbled onto an allusion of
>table 'user_errors'. After checking that it indeed
>exists, I began to wonder how many other default
>tables are there for one user? I don't have any
>luck with Oracle on-line manuals, and would appreciate
>any comments.
>
> Another thing, what's DDL? Which kind of SQL
>statements constitute DDL?
>
> Thanks.
>
>
>--
> Qiao
>
>---- all man were equal, they all came from stardust. ----
Received on Mon Aug 04 1997 - 00:00:00 CDT