Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: migrating 9206 from windows to linux

RE: migrating 9206 from windows to linux

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Mon, 26 Sep 2005 07:56:50 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF35FC5C@EXCNYSM0A1AJ.nysemail.nyenet>


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-l
Received on Mon Sep 26 2005 - 06:59:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US