Re: Copying PeopleSoft instances via Export/Import

From: Dennis Buddenborg <buddman_at_flash.net>
Date: Fri, 22 Jan 1999 15:08:54 GMT
Message-ID: <36A894C5.43EBA994@flash.net>

John, We're running PS 6.02 and the following ten PS tables are the ones that I DO NOT overlay with source data. This will leave your security intact on your destination database. I've been performing this procedure to refresh our development and testing instances from our production instance with great success for some time. Prior versions of PS didn't affect as many tables.

pslock, psoprdefn, psauthitem, psprcsrqst, ps_prcsdefn,ps_serverdefn, ps_serverclass, psprcsprfl, psprcsrqstxfer and psprcsrunctnl

Good luck,
Dennis Buddenborg
OCP DBA - Valeo, Inc.

John Koo wrote:

> 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 Fri Jan 22 1999 - 09:08:54 CST