Re: 8.1.7 Backup and Restore
From: Rene S. Nielsen <renesn_at_image.dk>
Date: Sat, 17 Aug 2002 00:10:24 +0200
Message-ID: <3d5d796a$0$27667$edfadb0f_at_dspool01.news.tele.dk>
Date: Sat, 17 Aug 2002 00:10:24 +0200
Message-ID: <3d5d796a$0$27667$edfadb0f_at_dspool01.news.tele.dk>
[Quoted] The EXPORT is not a substitute for a backup, since it dosn't create your tablespaces and it dosn't copy your control file.
When moving from one database to another using EXPORt and IMPORT. Do remember to create the users, and the tablespaces before running the import.
[Quoted] Also do not import the sys and system schemas, since they where createde during install of the new database.
The best way is just import one schema at a time. something like this
IMP81 system/manager_at_prod.world fromuser="username" touser="username" file=d:\oracle\dumpfile.dmp log=d:\oracle\logfile.log
Something like this should do the trick
Regards
Rene
Received on Sat Aug 17 2002 - 00:10:24 CEST