Home » RDBMS Server » Server Utilities » Import from 64bit to 32bit (ORACLE 11g R1)
icon14.gif  Import from 64bit to 32bit [message #469270] Wed, 04 August 2010 02:06 Go to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Hi all,

I have taken export from ORACLE 11g R1 64-bit software and now when I am trying to import it on ORACLE 11g R1 32-bit version, I am not able to do so.
Is it possible to import from export file take from 64-bit to 32-bit version?
Thanks
Deepak
Re: Import from 64bit to 32bit [message #469272 is a reply to message #469270] Wed, 04 August 2010 02:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"I am not able to do so" is not an Oracle error. Nobody can help with just this information.

"Is it possible to import from export file take from 64-bit to 32-bit version?" Yes.

Regards
Michel
Re: Import from 64bit to 32bit [message #469277 is a reply to message #469272] Wed, 04 August 2010 02:13 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

SIR for you to help me out of this issue, I can post the export logs as well as the error logs that i am getting at the time of import.

Regards
Deepak
Re: Import from 64bit to 32bit [message #469281 is a reply to message #469270] Wed, 04 August 2010 02:18 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

below are the logs in the file that were generated at the time of export.
  • Attachment: expfull.log
    (Size: 117.75KB, Downloaded 1610 times)
Re: Import from 64bit to 32bit [message #469284 is a reply to message #469281] Wed, 04 August 2010 02:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Job "SYSTEM"."SYS_EXPORT_FULL_01" successfully completed at 10:49:30

What is the problem?

Regards
Michel
Re: Import from 64bit to 32bit [message #469287 is a reply to message #469284] Wed, 04 August 2010 02:29 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

At the time of import I am not able to import it on machine with 32-bit ORACLE 11gR1 software.

Regards
Deepak
Re: Import from 64bit to 32bit [message #469293 is a reply to message #469287] Wed, 04 August 2010 02:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You still did not give any information about this "I am not able to import it".
Do you know how to import?
Is your server power on?
Is your database started?
Have you an account on this database?
Do you know the syntax of import command?
Is the file on your target server?
Are you old enough to import these data?

Regards
Michel
Re: Import from 64bit to 32bit [message #469298 is a reply to message #469270] Wed, 04 August 2010 02:50 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Hello Sir,

Sorry for a bit late reply I was bit busy with in my office.
below are the import logs.

Import: Release 11.1.0.6.0 - Production on Tuesday, 03 August, 2010 18:08:10

Copyright (c) 2003, 2007, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31694: master table "INPOWER"."SYS_IMPORT_FULL_01" failed to load/unload
ORA-02354: error in exporting/importing data
ORA-02373: Error parsing insert statement for table "INPOWER"."SYS_IMPORT_FULL_01".
ORA-00904: "ORIGINAL_OBJECT_NAME": invalid identifier




Regards
Deepak
Re: Import from 64bit to 32bit [message #469299 is a reply to message #469298] Wed, 04 August 2010 03:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Export is 11.1.0.7 and import 11.1.0.6, maybe there differences in format.
So either upgrade target to 11.1.0.7 (or try to import in a test database with this version) either use old export/import and not datapump.

You can also search on MOS (ex-Metalink) if there is any reported bug.

Regards
Michel

[Updated on: Wed, 04 August 2010 03:23]

Report message to a moderator

Re: Import from 64bit to 32bit [message #469330 is a reply to message #469299] Wed, 04 August 2010 04:43 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Thanks for the reply Sir, Is the S/W version ie. 64-bit to 32-bit going to effect the import.

Regards
Deepak
Re: Import from 64bit to 32bit [message #469336 is a reply to message #469330] Wed, 04 August 2010 04:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No one I'm aware of.

Regards
Michel
Re: Import from 64bit to 32bit [message #469342 is a reply to message #469336] Wed, 04 August 2010 05:05 Go to previous message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Thanks for your help Sir. I really Appreciate that.

Regards
Deepak
Previous Topic: importing dump
Next Topic: Importing Dump From Higher Database Version 2 Lower.
Goto Forum:
  


Current Time: Thu Mar 28 17:44:08 CDT 2024