Re: Display Database Structure?

Thank you very much for your answer!

Is there a simple command to find out all the table spaces in my database?

Regards,

Vince Collins

On Wed, 02 Feb 2000 00:20:13 -0500, Jerry Gitomer <jgitomer_at_erols.com> wrote:

>Vince Collins wrote:
>>
>> What is the SQL command for listing all the databases/tables/views
>> when you first log in?
>>
>> How do you display the current structure of a table/view?
>>
>> I have purchased the Oracle Press book titled "Oracle - A Beginners
>> Guide" and have not found the previous questions anywhere in the book.
>>
>> Please help if you can get a chance!
>>
>> Regards
>>
>> Vince Collins
>
>Assuming you have DBA privileges:
>
> SELECT tablespace_name FROM DBA_TABLESPACES;
>
> SELECT owner, table_name FROM DBA_TABLES;
>
> SELECT owner, view_name FROM DBA_VIEWS;
>
> DESC table_name
>
> DESC view_name
>
>Note that the last two commands are SQL*Plus commands and that they
>do not require a semicolon.
>
>hth
>--
>Jerry Gitomer
>Once I learned how to spell DBA, I became one.
Received on Thu Feb 03 2000 - 13:37:37 CST