Best way to refresh Database
Hello,
I have a database full of data, 11.1, let's call that DB1. And I want to reload/refresh the data and any other schema changes from another database, DB2.
Can I do a full export of DB2 and a full import into DB1? If I do this, how would I set up DB1 for pre-import, drop user cascade for most of DB1? What do I do with users like SYSMAN and DBSNMP?
Or would it be better to export all but the system related schema's, individually from DB2 and load them individually into DB1? What's the best way to do that - drop the user, recreate them then import?
I have a database full of data, 11.1, let's call that DB1. And I want to reload/refresh the data and any other schema changes from another database, DB2.
Can I do a full export of DB2 and a full import into DB1? If I do this, how would I set up DB1 for pre-import, drop user cascade for most of DB1? What do I do with users like SYSMAN and DBSNMP?
Or would it be better to export all but the system related schema's, individually from DB2 and load them individually into DB1? What's the best way to do that - drop the user, recreate them then import?
0