OraFAQ Forum: Server Utilities » Import from 64bit to 32bit

Home » RDBMS Server » Server Utilities » Import from 64bit to 32bit (ORACLE 11g R1)

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

Import from 64bit to 32bit [message #469270]

Wed, 04 August 2010 02:06

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

Report message to a moderator

Re: Import from 64bit to 32bit [message #469272 is a reply to message #469270]

Wed, 04 August 2010 02:07

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

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

Report message to a moderator

Re: Import from 64bit to 32bit [message #469277 is a reply to message #469272]

Wed, 04 August 2010 02:13

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

Report message to a moderator

Re: Import from 64bit to 32bit [message #469281 is a reply to message #469270]

Wed, 04 August 2010 02:18

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 1883 times)

Report message to a moderator

Re: Import from 64bit to 32bit [message #469284 is a reply to message #469281]

Wed, 04 August 2010 02:20

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

Senior Member
Account Moderator

Quote:

Job "SYSTEM"."SYS_EXPORT_FULL_01" successfully completed at 10:49:30

What is the problem?

Regards
Michel

Report message to a moderator

Re: Import from 64bit to 32bit [message #469287 is a reply to message #469284]

Wed, 04 August 2010 02:29

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

Report message to a moderator

Re: Import from 64bit to 32bit [message #469293 is a reply to message #469287]

Wed, 04 August 2010 02:40

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

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

Report message to a moderator

Re: Import from 64bit to 32bit [message #469298 is a reply to message #469270]

Wed, 04 August 2010 02:50

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

Report message to a moderator

Re: Import from 64bit to 32bit [message #469299 is a reply to message #469298]

Wed, 04 August 2010 03:22

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

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