Feeds:
Posts
Comments

Posts Tagged ‘exp’

A quick sharing….

Last few days bask we were have to migrate a schema from 10g R2 on Solaris 10 64 bit to 11g R2  on windows 32 bit using traditional exp/imp. Exp was successful (as usual), but while importing we were facing below error.

Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 – Production

Export file created by EXPORT:V10.02.01 via conventional path

Warning: the objects were exported by SYSTEM, not by you

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
export client uses US7ASCII character set (possible charset conversion)
. importing USER1’s objects into USER2

ORA-01435: user does not exist
Import terminated successfully with warnings.

we were using below syntax…..

imp system/oracle@DB_NAME file=’c:\dumpfile.dmp’ log=c:\logfile.log grants=n fromuser=<Schema_from>touser=<Schema_to>;

We were facing this issue from last 3 days, finally found the cause of the problem(A silly mistake):

The above command is working as a cmd command other than sql/plsql command so we should not use “;” at the end of the syntax.

set ORACLE_SID=<SID>

imp system/oracle@***** file=’c:\dumpfile.dmp’ log=c:\logfile.log grants=n fromuser=<Schema_from> touser=<Schema_to>

this will sort out the error…..

Hope this helps..

Thanks & Regards

Nimai Karmakar

Read Full Post »

Johribazaar's Blog

Just another WordPress.com weblog

Ayurveda and Yoga

Site for Ayurveda and Yoga articles

SanOraLife

Few adventures in my slow running life...

pavankumaroracledba

4 out of 5 dentists recommend this WordPress.com site

ORACLE WRITES

Technical Articles by Kanchana Selvakumar

SAP Basis Cafe

SAP Basis Cafe - Exploring SAP R/3 Basis World

Life Is A Mystery

This Is Wihemdra's Blog...I Share What I Have

ursvenkat's Blog

Oracle Applications DBA Blog

The Ivica Arsov Blog

Database Management & Performance

gumpx

DBA's online diary