Re: Display Database Structure?

Try

select distinct tablespace_name from sys.dba_tables ( if you have access to that) - use all_tables if you do not...

also, check out sys.dba_objects for info on what's in your database...

hth

vcollins_at_mediaone.net (Vince Collins) wrote:

>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.

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Thu Feb 03 2000 - 14:24:44 CST