Re: I need to change size of constraints during export/import

Rachel,

Thanks - this seems like a winner!

Andy

Rachel Carmichael <rachel.carmichael_at_citicorp.com> wrote in article <3524E1FA.4C4872DE_at_citicorp.com>...
> Andy,
>
> If you do an export and then import with rows=n show=y and
> log=<some logfilename>, then what you get in the logfile is a list of ALL
> commands used to recreate the tables, including the constraint commands.
> Unfortunately not in a pretty format (it takes some heavy editing to make
it
> executable). But you could import into the test db with no constraints,
then
> manually add them using the logfile script as a guide, since it will also
> include sizing parameters.
>
> Hope this helps
>
>
> Rachel
>
> Andy Hardy wrote:
>
> > Hi,
> >
> > I have a production database which has been fully sized for its
predicted
> > data capacities.
> >
> > I have produced an export of that database with the intention of
creating a
> > smaller version for testing/development purposes. The current data in
the
> > production system is very small compared to the space allocated.
> >
> > I've used the 'indexfile' option to create a script which I've edited
to
> > get reasonable table and index sizes, unfortunately I haven't found a
way
> > to resize the constraints.
> >
> > Any ideas?
> >
> > Andy
>
>
>
>
Received on Sat Apr 18 1998 - 09:08:56 CDT