| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: import from Oracle 9 to 10 hanging
Yes, thanks for the clarification.
Joel Patterson
Database Administrator
joel.patterson_at_crowley.com
x72546
904 727-2546
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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.
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_at_crowley.com <Joel.Patterson_at_crowley.com > 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_at_crowley.com x72546 904 727-2546 ________________________________ From: oracle-l-bounce_at_freelists.orgimporting 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?
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dennis Williams
Sent: Thursday, June 28, 2007 2:39 PM To: Andreas.Haunschmidt_at_voestalpine.com Cc: oracle-l_at_freelists.org 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
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 -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 29 2007 - 07:01:48 CDT
 |
 |