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: 10673
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Previous Topic: ora-12638
Next Topic: How to schedule a trigger
Goto Forum:

Current Time: Thu Jul 20 18:08:50 CDT 2017

Total time taken to generate the page: 0.07113 seconds