Home » RDBMS Server » Server Administration » Cloning Schema
icon7.gif  Cloning Schema [message #211559] Fri, 29 December 2006 06:54 Go to next message
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.
Re: Cloning Schema [message #211561 is a reply to message #211559] Fri, 29 December 2006 07:02 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://orafaq.com/faq/import_export
Previous Topic: ora-12638
Next Topic: How to schedule a trigger
Goto Forum:
  


Current Time: Fri Sep 20 05:41:00 CDT 2024