Home » Infrastructure » Linux » how to import into windows from linux (windows 7 64 bit , Linux 4.0 64 bit)
how to import into windows from linux [message #565849] Fri, 07 September 2012 06:22 Go to next message
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 - 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 - 64bit
With the Partitioning, OLAP, Data Mining and Real Application Testing options

IMP-00009: abnormal end of export file
IMP-00000: Import terminated unsuccessfully
Re: how to import into windows from linux [message #565854 is a reply to message #565849] Fri, 07 September 2012 06:48 Go to previous message
Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...
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.

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

Current Time: Sun May 26 18:47:38 CDT 2024