Fwd: import from Oracle 9 to 10 hanging

Missed the list off the reply.

• Forwarded message ---------- From: Niall Litchfield <niall.litchfield_at_gmail.com> Date: Jun 29, 2007 12:36 PM Subject: Re: import from Oracle 9 to 10 hanging To: Joel.Patterson_at_crowley.com

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.org [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 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

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l