Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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.5046Received on Mon Apr 26 1999 - 04:33:13 CDT
![]() |
![]() |