Home » RDBMS Server » Server Administration » Cloning Schema
icon7.gif  Cloning Schema [message #211559] Fri, 29 December 2006 06:54 Go to next message
Messages: 1
Registered: December 2006
Location: Argentina
Junior Member
Hi, I'm new in the Oracle World. I've just started to work in a company that owns a little Server Oracle 8.x. I'm developing an application (in VB.NET) that talks with the Oracle DB, but now I've to install the first release of the app and have to create a Production/Developer schema.
So, my question is " How I do that" I'm running over an schema with Users/Tables/SP/Triggers, etc. So I want to replicate all this object in another schema just to continue developing and testing without touching the Real Data. And, of course, I want to copy all new data from Productive schema to de Developer schema on demand.

Can anyone help me with that ? I would really appreciate.
Re: Cloning Schema [message #211561 is a reply to message #211559] Fri, 29 December 2006 07:02 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Previous Topic: ora-12638
Next Topic: How to schedule a trigger
Goto Forum:

Current Time: Sat Oct 22 04:43:35 CDT 2016

Total time taken to generate the page: 0.13182 seconds