Re: Copying PeopleSoft instances via Export/Import

From: ba la <bala_at_hotmail.com>
Date: Sun, 17 Jan 1999 23:00:42 +0800
Message-ID: <77stiq$ghk3@news.asiaonline.net>

You can backup the control file to trace and modify the trace file as trace.sql

create controlfile reuse set database "new_instance" ......

then modify your init.ora to set the db_name to your new instance, duplicate the whole set of database files to another location in the same host.

svrmgrl>startup nomount ;
svrmgrl> @trace.sql
svrmgrl> alter database open resetlogs;

Ken Chow

John Koo wrote in message <36A29A5C.3C0A_at_i-wave.net>...
>Javier Gorostiaga wrote:
>>
>> How can I copy a PeopleSoft HR Oracle 7.3.3 instance to another instance
>> on the same box without overlaying the security of the target database.
>> The security tables need to stay unchanged. Anyone with experience in
>> this??
>> Javier Gorostiaga
>
>Not too sure what you really want but you might try
>table export and then import or
>schema export and then import.
>
>John Koo
>johnkoo_at_i-wave.net
Received on Sun Jan 17 1999 - 09:00:42 CST