HPE Community
Operating System - HP-UX
1753947 Members
7885 Online
108811 Solutions
New Discussion юеВ

Re: copy schema from one database to another

 
SOLVED
Go to solution
Ratzie
Super Advisor

тАО09-30-2008 08:32 AM

тАО09-30-2008 08:32 AM

copy schema from one database to another

Is there a simple way to copy one schema over to another database.
We want to do reporting on it, so bring over the entire schema MINUS A COUPLE TABLES on a daily basis at a certain time every day.
Import/export...
But, can I do it everyday on only data that has changed? And minus some tables...
0 Kudos
Reply
3 REPLIES 3
Ratzie
Super Advisor

тАО09-30-2008 01:02 PM

тАО09-30-2008 01:02 PM

Re: copy schema from one database to another

Sorry using Oracle 10g
0 Kudos
Reply
Sandeep_Chaudhary
Trusted Contributor

тАО09-30-2008 09:53 PM

тАО09-30-2008 09:53 PM

Solution

Re: copy schema from one database to another

incremental export is the solution.
Reply
Gerald Thai
Occasional Advisor

тАО10-01-2008 08:20 AM

тАО10-01-2008 08:20 AM

Re: copy schema from one database to another

Why don't you use Oracle Materialized Views to move the data from the tables?
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.