Operating System - HP-UX
1745928 Members
4519 Online
108723 Solutions
New Discussion юеВ

copy schema from one database to another

 
SOLVED
Go to solution
Ratzie
Super Advisor

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...
3 REPLIES 3
Ratzie
Super Advisor

Re: copy schema from one database to another

Sorry using Oracle 10g
Sandeep_Chaudhary
Trusted Contributor
Solution

Re: copy schema from one database to another

incremental export is the solution.
Gerald Thai
Occasional Advisor

Re: copy schema from one database to another

Why don't you use Oracle Materialized Views to move the data from the tables?