Re: DB-Copy for testing on same machine...

Hello!

You may copy 1:1 your database using RMAN. For example : duplicate target database to <new_database>. If need, more detail by e-mail.

Best regards.
Yaroslav

"R. Schicht" <schicht_at_vie.ce.philips.com> ???????/???????? ? ???????? ?????????: news:3AAF8DA7.852534C1_at_vie.ce.philips.com...
> Hello, i am using Oracle 7.3.4 on HP-UX!
>
> I have to create a new instance for testing purposes on the same machine
> -> no problem, i have done this already.
>
> The final test-database should be a 1:1 copy of the original!
>
> My first idea was a FULL-export of the DB and to import it into the
> test-DB.
> But this is not possible, because the pathes of the files are hardcoded
> in the dumpfile.
> So i tried to change all this pathes with a little sed-script -> the
> altered file was smaller than the original, even though the original
> path is shorter than the altered (Dumpfiles have a special
> fileformat...).!! It´s also not possible to edit a dumpfile with an
> editor.
>
> Does anyone know a possibility to do a 1:1 copy on the same machine.
>
> (My last chance is, to export all users with a USER-Export and import
> them, but this means to manual create all tablespaces and so on. I
> gladly would avoid this if possible!).
>
> Thank you in advance.
>
> Kind regards
>
> R. Schicht
>
Received on Wed Mar 14 2001 - 10:24:46 CST