Hi,

I have two DB servers and they originally contain identical DB. However, since people update database B and the export dump from database B is done regularly, what is the safest way to import the dump file into database A? All the objects and data are in a single user's schema.

Should I drop the user, recreate it, and then import from the dump file? Will I be missiing something if I do it this way?

Thanks!