Oracle Question

pts.
Tags:
Oracle
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Kurthp
    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
    195 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following