Re: repeated full imports...

I think a faster way would be to recreate the instance from scratch, provided
you have a script to do this, and then run the import.

Steve Perry wrote:

> I need to reload a 5 gig Oracle 7.3.4 database over and over for
> testing.
> We don't have the space to save of the datafiles and overlay them each
> time. The users require a minimal amount of downtime for this refresh.
>
> When I repeatedly did full imports into the database without dropping
> the system user, I got a lot of RI errors and unique key erorrs...
> I was going to drop the schemas (30) and do user imports, but I
> started testing dropping all users, including system, so the only user
> left was sys. Before importing, I recreated the system user and
> provided the grants. This seems to work ok, and I don't get any
> errors.
> Is there any problem doing it this way???
> Is there a better approach?
>
>

--
Met vriendelijke groet,
kind regards,

Frank van Bortel
Technical consultant Oracle
V&L Informatica BV

Work                           Home
Postbus 545                    Hunzestraat 4
7500 AM Enschede               7555 WB Hengelo
(31)53.434.1500                (31)74.242.5046