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: Easy question

Re: Easy question

From: <harfordr_at_ncr.disa.mil>
Date: 1997/06/10
Message-ID: <865948887.5063@dejanews.com>#1/1

I'd get a copy of ERwin 2.6 and reverse engineer the database schema (which pulls in, among other things, table/index definitions and referential integrity rules). You can the forward engineer the ERwin diagram and run a report to get a text file with the requisite SQL statements.

Bob Harford
DBA
IMC In article <01bc7575$b4054940$2f010b0a_at_-47->,   "Hugo Juan Jordan" <hugojuan_at_iies.es> 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

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet
Received on Tue Jun 10 1997 - 00:00:00 CDT

Original text of this message

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