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

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 Fri Apr 03 1998 - 00:00:00 CST