| Import from 10Gr2 64bit -> 10Gr1 32 bit [message #175463] |
Fri, 02 June 2006 06:34  |
satfreaxx
Messages: 1
Registered: June 2006
|
Junior Member |
|
|
Hello,
I'm trying to import a dump from a 10gR2 database (X86_64) to a 10gR1 32 bit database.
From the 10gR1 imp client this is what i have:
Import: Release 10.1.0.3.0 - Production on Mer. Mai 31 03:53:29 2006
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V10.02.01 via conventional path
Warning: the objects were exported by TOTO, not by you
import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
. importing TOTO's objects into TOTO2
IMP-00008: unrecognized statement in the export file:
finishing by an error.
UPDATE:
exporting only a few tables and using the parameter RECORDLENGTH=65535 during export and import it seems to work althought there's still the error:
IMP-00008: unrecognized statement in the export file.
But tables are correctly imported.
And From the 10gR2 imp client via SQL*NET:
Import: Release 10.2.0.2.0 - Production on Fri Jun 2 13:14:15 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
IMP-00058: ORACLE error 6550 encountered
ORA-06550: line 1, column 33:
PLS-00302: component 'SET_NO_OUTLINES' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
IMP-00000: Import terminated unsuccessfully
Is there a way to import from 64bit to 32bit databases ?
Thanks for your replies.
Fred.
[Updated on: Fri, 02 June 2006 08:40] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
