Re: Simple questions about Import/Export

Rick Denoire <100.17706_at_germanynet.de> wrote in news:7fn1st4k4q8bcoau0inb2tgrgerhmv7m1g_at_4ax.com:

> Hello
>
> I need a copy of a production DB ("prod") for experiments, let's call
> it "test". I have already set up "test" by executing an backup'ed
> trace file from "prod" and copying "prod"'s files to the machine where
> "test" runs (after first having shut down "prod").
>
> I guess that it would be easier just to use the export utility on
> "prod" and import the dmp file into "test", but I am not sure if that
> will work, because:
>
> "test" is an instance on a different machine;
>
> the instance name "test" differs from the original "prod";
>
> I don't know if an import would overwrite the content of "test" with
> the content of "prod" or if the data will be just added (I need an
> exact copy, so it should overwrite);
>
> I don't know if a hot export of "prod" would be consistent to be
> importet into "test". I am talking about full export/import. It would
> be fine if I could make those exports without shutting down the "prod"
> DB.
>
> Excuse me for these questions but I am a UNIX admin who just happens
> to have participated in an Oracle Admin Training three weeks ago and
> have no experience at all. In the training course, we handled the
> export/import utilities very short and only as a way to backup
> databases. In my case, I don't want a backup but a second instance to
> play with.
>
> Oracle 8.1.7/Solaris 2.7
>
> Thanks
>
> Rick
>
>
>

They way I clone my production DB is to shut it down. Launch a whole bunch of "rcp" commands; one per file. After all the rcp's have completed, I bring up "prod" on both systems. This approach is certainly faster than doing exports & imports.

HTH & YMMV! Received on Sun Oct 07 2001 - 19:12:51 CDT