General
cancel
Showing results for 
Search instead for 
Did you mean: 

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
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?