Oracle Question
I have just started working with a client who has had a large database application written in oracle. The application has been mirrored onto a training server with a small amount of data.
I would like to create 4 different training databases on the same server (after a server upgrade) with a different URL pointing to the different databases for 4 trainers to have their own training area.
My question is how much of a job is this to do. Time scales and work involved ? The client is quite willing to pay a fair price but the quote if for a HUGE amount of money when I think it is a relatively straight forward task to an oracle expert.
Answers greatly appreciated.
Thanks
Chris Gee
g-training.
Software/Hardware used:
Software/Hardware used:
ASKED:
July 18, 2007 2:36 PM
UPDATED:
July 19, 2007 11:12 AM
Answer Wiki:
ChrisGee,
You may want to consider using the Oracle Label Security and Virtual Private Database features with a single database for training. Here is a link to more info:
http://download-west.oracle.com/docs/cd/B10501_01/network.920/a96578/intro.htm#1008265
Hope this helps.
Charles
To see all answers submitted to the Answer Wiki: View Answer History.
Hi Chris.
There are a couple of ways to do this. If the client is using Oracle’s RMAN utility to do backups, there is a way to quickly duplicate an entire database using RMAN. I use this method frequently and it works very well and with minimal time.
Another way, would be to use a tool like TOAD, which allows you to generate scripts based on the existing database. You could use it to generate the base database & tablespaces (after editing the scripts), and then do a full export from the existing training database and import into the newly created database.
Option 2 would require a bit more time but either could be done relatively quickly for someone with Oracle experience.
Check out this link for a list of various tools.
http://searchoracle.techtarget.com/tip/1,289483,sid41_gci1057867,00.html
Cheers…Peter