Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> full db export/import
hi list,
i wonder wat actually full db export has benefits over user level export, cuz full db export also makes the objects of user sys and system as part of the dump file (if i am right) , but the target database in which we are gonna import that dump file also have objects of system and sys already created then wats the point in exporting their objects too.
for example we have two databases, 1 production and other dev, we have almost 10 user schemas which we replicate from production db to development db using export/import. We use to drop all the existing objects of the schemas in dev database using scripts, and then import the dump file (which ofcourse contains only the 10 user schemas which we want to update on the dev db), but it takes a lot of time and hectic effort,
can anybody suggest a better method of doing same thing using export/import , and where does full db export/import fits in our situation.
thanks in advance
Arslan Zaheer Dar
Oracle Dba
Shaukat Khanum Cancer Hospital
Received on Mon Oct 22 2001 - 08:15:24 CDT
![]() |
![]() |