Re: recreating a database using export/import

A brief description would be to
1: full export as system with rows=N
2: full export by owner(s) with at least rows=y

3: create all the objects by importing the file from step 1 4. get the rows imported by importing by owner using the output of step 2

HTH
Chuck ccisaac_at_mtu.edu

Glenn Stauffer (stauffer_at_swarthmore.edu) wrote:
: I am testing the performance of different block sizes in a test database
: and am attempting to use export/import to load my test database with a copy
: of my production system. What is the proper approach for doing this? If I
: just do a straight import into a fresh instance, I get failures because the
: object owners are not there - ie, the user information doesn't get loaded
: first out of the import file.
:
: Thanks,
:
: Glenn Stauffer
Received on Thu Dec 19 1996 - 00:00:00 CST