RE: import from Oracle 9 to 10 hanging
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <niall.litchfield@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 29 Jun 2007 08:01:48 -0400
Yes, thanks for the clarification.
Joel Patterson
Database Administrator
joel.patterson@xxxxxxxxxxx
x72546
904 727-2546
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Niall Litchfield
Sent: Friday, June 29, 2007 7:37 AM
To: Oracle-L
Subject: Fwd: import from Oracle 9 to 10 hanging
Missed the list off the reply.
---------- Forwarded message ----------
From: Niall Litchfield <niall.litchfield@xxxxxxxxx >
Date: Jun 29, 2007 12:36 PM
Subject: Re: import from Oracle 9 to 10 hanging
To: Joel.Patterson@xxxxxxxxxxx
Joel
DBMS_EXPORT_EXTENSION is a supplied packaged used by exp. I think the
issue here is that the import is hanging on a call to this procedure,
not on importing the procedure. If so I'd have thought an SR might be
productive.
cheers
Niall
On 6/28/07, Joel.Patterson@xxxxxxxxxxx <Joel.Patterson@xxxxxxxxxxx >
wrote:
I do you import SYS objects if you cannot export them even with
a full export?
(unless you are referring perhaps to SYSTEM).
Joel Patterson
Database Administrator
joel.patterson@xxxxxxxxxxx
x72546
904 727-2546
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dennis Williams
Sent: Thursday, June 28, 2007 2:39 PM
To: Andreas.Haunschmidt@xxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: import from Oracle 9 to 10 hanging
Andreas,
Haven't experienced this particular problem, but since
nobody has replied yet, here are some ideas.
Offhand, it seems your problem might be that you are
importing SYS objects. At least that is where you say your import is
hanging. But on the other hand you say that you are importing 4 users,
so I'm confused. Are you doing a full import?
I'm guessing you mean that you exported using 9i using the
EXP utility (rather than imp utility).
Assuming that you aren't trying to import the SYS objects,
you might try exporting specific types of objects and then importing
them. Maybe just tables to see if it completes.
The name of the object sounds like maybe export is trying to
reset some object after import. You might Google that name since it is
pretty unique, and also check Metalink.
Another trick is that you can take the export file and run
it through the Unix "strings" command and get a text file that can be
used to create the objects (ROWS=N). You may have to format for line
length. But you could run that in SQL*Plus and it might run and if it
didn't you might get a better idea of where the problem lies.
Dennis Williams
--
Niall Litchfield
Oracle DBA
http://www.orawin.info <http://www.orawin.info/>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
