Re: Copying PeopleSoft instances via Export/Import

I'm surpised at some of the tables in your list -- not to say it won't work but a few might not be needed (and a few others might be). My experience is 7.0/7.5 however.

I've exported the following tables and re-imported them to retain operator security (password and base access rights). As someone else pointed out, there are other tables that may contain security info (query security trees for example).

	PSOPRCLS
	PSOPRDEFN
	PSOPROBJ
	PSAUTHPRCS
	PSAUTHSIGNON
	PSAUTHITEM
	PSPRCSPRFL
	PSACCESSPRFL <- somewhat optional
	PS_SCRTY_QUERY

Always make a backup of course. You may want to take the run control tables too if your OPRID's are all different, however that is *alot* of tables to find.

Dennis Buddenborg <buddman_at_flash.net> wrote:
: 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