OraFAQ Forum: Linux » how to import into windows from linux

Home » Infrastructure » Linux » how to import into windows from linux (windows 7 64 bit , Linux 4.0 64 bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to import into windows from linux [message #565849]

Fri, 07 September 2012 06:22

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

Hello i have export my scott schema from my linux system 4.0 64 bit using this

[oracle@localhost bin]$ exp system/oracle file=/Software/ts.dmp log=/Software/ts.log owner=scott

than i have import into my oracle i have install into windows 7 64 bit using this

F:\oracle\product\10.2.0\db_1\BIN>imp system/oracle@tamr file=F:\ts.dmp log=F:\t
s1.log fromuser=scott touser=scott statistics=none

Import: Release 10.2.0.4.0 - Production on Fri Sep 7 15:29:36 2012

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

IMP-00009: abnormal end of export file
IMP-00000: Import terminated unsuccessfully

Report message to a moderator

Re: how to import into windows from linux [message #565854 is a reply to message #565849]

Fri, 07 September 2012 06:48

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If you transfert your file in binary mode you should have no problem during import.

YOu can also use Data Pump with the option network_link.

Regards
Michel

Report message to a moderator

Previous Topic:	Oracle 10G Installation on RHEL 6
Next Topic:	Oracle report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 07:21:56 CST 2024