Re: Duplicating Oracle DB w/o Schema or Scripts
From: Phil Herring <revdoc_at_uow.edu.au>
Date: 1997/08/04
Message-ID: <5s378b$2go$1_at_wyrm.its.uow.edu.au>#1/1
Copyright 1997 Phil Herring. This article may not be reproduced for profit.
Received on Mon Aug 04 1997 - 00:00:00 CEST
Date: 1997/08/04
Message-ID: <5s378b$2go$1_at_wyrm.its.uow.edu.au>#1/1
In article <01bc9c87$de327ce0$be3c2299_at_tomremote> Tom Patton, Tom-n-Tracy_at_msn.com writes:
>Does anyone know of a method to generate a sql script or schema
>to create the tables, views, etc, of an Oracle/7 database?
Export can create a text file that lists all of the create table and create index statements needed to create a schema. Specify INDEXFILE=<file> on the command line.
However, to paraphrase Elmer Fudd: be vewy, vewy careful. Foreign keys and triggers can make this exercise much harder than it first appears.
Copyright 1997 Phil Herring. This article may not be reproduced for profit.
Received on Mon Aug 04 1997 - 00:00:00 CEST