Re: Easy question

From: Detlev Goebel <detlev.goebel_at_gzs.de>
Date: 1997/06/10
Message-ID: <339D1788.1C73@gzs.de>#1/1

Hugo Juan Jordan wrote:
>
> In order to document the structure of a database, they have asked me to
> obtain a text file with all the SQL statements needed to build the same
> database that I am running in a Oracle server 7.3.. I'm sure it must be
> very easy to obtain, but I have no idea.
> Any suggestions?
>
> I'm very sorry to ask silly questions, but I'm still very far from really
> good ones.
>
> Thanks in advance.
>
> Hugo Juan

Hugo,

I never heard of silly questions did you? Your requirements are not trivial at all. You have to look up several system views to get your information :
sys.all_tables - to get all information about tables like storage and

                 tablespace where they reside.
sys.dba_tab_columns - for al columns of those tables (names, datatype,
                      length and default values).
sys.all_indexes - for indexes on those tables.
sys.dba_index_columns - for the columns of those indexes.

sys.all_constraints - for the constraints on those tables. sys.all_views - for the views.

Maybe the tablespaces, the user informations, datafiles and so on.

if you'll write scripts take care about it.

Otherwise I'm sure there are some tools anywhere in the net to do this. Perhaps anyone else can provide some URL's.

Good luck

Detlev

-- 
Detlev Goebel

mailto:detlev.goebel_at_gzs.de
---------------------------

Received on Tue Jun 10 1997 - 00:00:00 CDT