Is IMPORT & EXPORT is platform
dependent
Please help me to find the soultion
for this,,,,
I'll explain to you my problem....
1. I have a Unix server Running
Oracle 7.2
2. I have a user called 'Namankan'
on Oracle DB
3. I have to shift the entire tables
of user 'Namankan' from this System to a new server running Windows XP
(or NT) with Oracle 8 (Not 8i)
If you are going to suggest me that
I spool the entire data into text files and import them by running SQL*Loader
in the new system, Pls dont suggest.......coz
i) Data is too large, ii) Table
level validations in database will not allow the data to go in.
I have tried making a .dmp file
using exp command on Unix Machine with default parameters, and have exported
the entire data into a file called Intecons.dmp which is 175 MB, zipped
into 28MB
Then I have taken this file onto
Windows system with Oracle 8 and tried to import it through Imp80 command
It says
* Invalid Header Information, OS
different (some such 2-3 lines)
As suggested by someone in a yahoo
chat room, I Have tried to change the header information in .dmp file using
a hex editor, I matched it to same as it was in a sample .dmp I made using
exp80 command on my windows machine.......... Sometimes, it asks 2-3 questions
and after replies starts dumping junk......... sometimes it hangs the system
I also came across to a data extraction
program NXTract, however, its similar to spooling of files, even if it
extracts data from .dmp file, so it is useless for me
Puneet Sachar
IMP/EXP IS NOT PLATFORM DEPENDANT!!!!!!!!
Gawd Hex editor hacking on dmp binary
files.... thatz weird!!!
The guy who gave you that advice
is either brilliant
or
....let me leave this here
Firstly:
With the Oracle EXPORT and IMPORT
utilities you can transfer data objects between Oracle databases,
even if they reside on platforms with different hardware and software
configurations.
ie: Dump files also aren't
OS-specific; as a result, you can use Export/Import to transfer data between
databases on different platforms.
Secondly:
Exporting data from a lower version
of oracle into a higher version===no problem
The vice versa ==== got to do it
tactically!!
IN your case Puneeth:
From 7.3.3 to 8 => Use the EXPORT
7.3.3 to export the data from the 7.3.3 database and IMPORT 8 to import
the data into the 8 database. This should work just fine without any dependancy
on the OS.
The PROBLEM of yours could be simple
as this:
Did you use ftp to transfer the
dmp file from the unix system in to ur target machine?
IF SO: did you type
ftp>bin
before you did the transfer?
When transferring the export dump
file over a network, the file has to be transmitted in binary mode.
Transmitting export files in character
mode (ASCII) causes errors when the file is imported.
If the problem is still not solved
post the errors that are being logged so that we could actually understand
the problem come up with some clear cut answer!!!
I see that you have actually posted
a similar posting somewhere where you have suggested to pay the person
who helps you get through this.... so is that offer still valid here :+)
Channesh
As per oracle corp:
When creating an export dump file for an import into
a higher release database (e.g.: from Oracle8i to Oracle9i), use a version
of the EXPORT utility that is equal to the version of the source database
(= lowest version = Oracle8i in this case).
The export FAILS if you use a HIGHER release export version.
For example, if you use the export 9.0.1 utility the
export data from an 8.1.7 database, you will get the errors:
EXP-56
Oracle error 942 encountered
ORA-942
table or view does not exist
EXP-0
Export terminated unsuccessfully
Solution: use the lowest release export utility (8.1.7
in this case).
Hence I dnt think you can use oracle8 exp on the oracle7.3
database and get things right....!!
And i totally agree HEX editor on dmp files==bad idea.
Channesh
Have a Oracle Question
Do
you have an Oracle Question?
Oracle Books
Oracle
Certification, Database Administration, SQL, Application, Programming Reference
Books
Oracle Application
Oracle
Application Hints and Tips
Oracle Home
Oracle
Database, SQL, Application, Programming Tips
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
All product names are trademarks of their respective
companies.
The site www.erpgreat.com is not affiliated with or endorsed
by any company listed at this site.
Every effort is made to ensure the content integrity.
Information used on this site is at your own risk.
The content on this site may not be reproduced
or redistributed without the express written permission of
www.erpgreat.com or the content authors.
|