Re: import from Oracle 9 to 10 hanging

  • From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
  • To: Joel.Patterson@xxxxxxxxxxx
  • Date: Fri, 29 Jun 2007 09:49:26 +0200

Of course you can export sys:

oracle@lappy:/u00/app/ucc/ [ORA9206] exp owner=sys file=sys.dmp

Export: Release - Production on Fri Jun 29 09:46:16 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Username: / as sysdba

Connected to: Oracle9i Enterprise Edition Release - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release - Production
Export done in UTF8 character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SYS
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SYS
About to export SYS's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. exporting synonyms
. exporting views

Note: I'm not saying you *should* ever exp/imp SYS to another database. Just
saying it's possible to do it.


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

(unless you are referring perhaps to SYSTEM).

Joel Patterson
Database Administrator
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


    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


Stefan P Knecht
Infrastructure Managed Services

Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg

Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27


Other related posts: