Re: 8.1.7 Backup and Restore

>
> 1 export will dump the create tablespace definitions, so import will
create
> them
> 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
> 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
>
>

1 and 2.
You are right about this, I did change the platform, from Novell to Win2000, and by doing that the drive specifikation didn't work. Therefor the IMP didn't create the tablespace.

After I manually created the tablespaces I did the Import again.

3.
The users that didn't have any obejcts, didn't create. (I don't know why)

5.
After importing the system tablespace. The database didn't work. I couldn't even start it up right.
If this might have something to do with the change of platform I don't know.

6.
I did the same procedure again after reinstalling the database. And this time without importing the SYSTEM schema. And this time everything woorked out right.

So in this case. I had to import the schemas one at a time. Or you can create a list of schemas to import, but it's about the same.

And for your final remark.
 > In short: your post is almost completely incorrect and misleading.

My post was a report of my observation from doing this my self. A therefor it cannot be incorrect. It might be misleading if this situation is different, otherwise it's not.

Regards
  Rene S. Nielsen Received on Sat Aug 17 2002 - 21:23:09 CEST