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

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

migrating 9206 from windows to linux

From: Chris Stephens <cstephens16_at_gmail.com>
Date: Sat, 24 Sep 2005 11:12:07 -0400
Message-ID: <d95e860705092408125b1dd49d@mail.gmail.com>


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:

 "ALTER SESSION SET CURRENT_SCHEMA= "CAMDECSMD""

IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
IMP-00000: Import terminated unsuccessfully


...but that user is there.

here is the Very basic script i used:

#!/bin/bash

/oracle/u01/app/oracle/product/9.2/bin/exp system/k1mchee_at_dev9_old full=y file=/
oracle/ORAEXPORTS/dev9full.dmp statistics=none buffer=5000000 log=dev9full.log

/oracle/u01/app/oracle/product/9.2/bin/imp system/k1mchee_at_dev9 file=/oracle/ORAE
XPORTS/dev9full.dmp buffer=5000000 log=dev9imp.log full=y

any ideas on what could possibly be happening?

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Sep 24 2005 - 10:14:40 CDT

Original text of this message

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