Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: migrating 9206 from windows to linux
Chris,
This is why I do not totally depend on a full database export/import. I prefer to manually create tablespaces, roles, users and database links. I then only export and import schema's. To me, I like being more in control and not depending on the software to do the work and getting stung with something like this.
Tom
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Chris Stephens
Sent: Sunday, September 25, 2005 9:50 AM
To: Oracle-L Freelists
Subject: Re: migrating 9206 from windows to linux
this ended up being due to a user whose default tablespace no longer existed in the original database.
sorry for the waste of bandwidth.
On 9/24/05, Chris Stephens <cstephens16_at_gmail.com> wrote:
> I take a full export of the database on the windows machine. the log
> file contains no errors. on linux i created the database and all the
> tablespaces that are present on the old database. i do a full import.
> ...all the users get created but only some of the objects get created
> for some of the users. the import log is full of errors that users
> alread exist (but they didn't). the last entry is:
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Mon Sep 26 2005 - 06:59:03 CDT
![]() |
![]() |