[OAUGNet]-Re: Creating an instance from two source.

["Hariri, Marzieh (MGS)" <Marzieh.Hariri@ontario.ca>]

We have tons of customization.
What will happen to them?

Thanks 

-----Original Message-----
From: OAUG Net listserver [mailto:OAUGNet@oaug.com] On Behalf Of Singh,
Dinesh
Sent: Monday, September 29, 2008 3:25 PM
To: OAUG Net listserver
Subject: [OAUGNet]-Re: Creating an instance from two source.

You can just copy database files and clone database.Once DB cloning done
you can run autoconfig at both tier(DB and APPS). 

-----Original Message-----
From: OAUG Net listserver [mailto:OAUGNet@oaug.com] On Behalf Of Hariri,
Marzieh (MGS)
Sent: Monday, September 29, 2008 2:59 PM
To: OAUG Net listserver
Subject: [OAUGNet]-Creating an instance from two source.

 
Hello:
This question is for DBA gurus out there.
We are on 11.5.10.
We have a test instance that has not been used for a while and is quit
outdated with regards to setups (e.g. DFFs) and patches. 
This instance has a different dataset (e.g. Suppliers) from our PROD
which makes it perfect for testing due to confidentiality.
We want to refresh this instance from PROD but use this data set.
Is it possible to refresh this instance from Prod keep the setups but
delete live data and export the data from test instance?
Is there a list that identifies live data tables and system/setup (e.g
profile options) data?
Has anyone done this? 
I am not a DBA I hope I have explained it properly.
Any feedback is greatly appreciated.
 
Marzieh 

#############################################################
This message is sent to you because you are subscribed to the mailing
list <OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com> To switch to the FEED
mode, send any message to <OAUGNet-feed@oaug.com> To switch to the
DIGEST mode, E-mail to <OAUGNet-digest@oaug.com> To switch to the INDEX
mode, E-mail to <OAUGNet-index@oaug.com> Send administrative queries to
<OAUGNet-request@oaug.com>


#############################################################
This message is sent to you because you are subscribed to the mailing
list <OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com> To switch to the FEED
mode, send any message to <OAUGNet-feed@oaug.com> To switch to the
DIGEST mode, E-mail to <OAUGNet-digest@oaug.com> To switch to the INDEX
mode, E-mail to <OAUGNet-index@oaug.com> Send administrative queries to
<OAUGNet-request@oaug.com>


#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to  <OAUGNet-request@oaug.com>