Re: 8.1.7 Backup and Restore

"Rene S. Nielsen" <renesn_at_image.dk> wrote in message news:3d5d796a$0$27667$edfadb0f_at_dspool01.news.tele.dk...
> 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.
>
> 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
>
>
>

[Quoted] 1 export will dump the create tablespace definitions, so import will create them
[Quoted] 2 There is only need to precreate the tablespaces when - you have different drives
- or you are switching platforms
3 there is no need to precreate the users when using a full database export 4 The SYS schema is never exported
[Quoted] 5 The SYSTEM schema is exported, there is no reason not to import it. It does NOT contain the dictionary
6 There is no need to import users one at a time

In short: your post is almost completely incorrect and misleading.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address