Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Easy question
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 UsenetReceived on Tue Jun 10 1997 - 00:00:00 CDT