Cloning Schema [message #211559] |
Fri, 29 December 2006 06:54 |
ELEGANCE
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.
|
|
|
|