Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: import from Oracle 9 to 10 hanging

Re: import from Oracle 9 to 10 hanging

From: LS Cheng <exriscer_at_gmail.com>
Date: Fri, 29 Jun 2007 10:48:47 +0200
Message-ID: <6e9345580706290148q77755fa9hf50e7a5f86e1a0b4@mail.gmail.com>


export full does not export sys (and several), may be that sounds better ;-)

Thanks

--
LSC


On 6/29/07, Stefan Knecht <knecht.stefan_at_gmail.com> wrote:

>
> Of course you can export sys:
>
> oracle_at_lappy:/u00/app/ucc/ [ORA9206] exp owner=sys file=sys.dmp
>
> Export: Release 9.2.0.6.0 - 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 9.2.0.6.0 - Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.6.0 - 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.
>
> Stefan
>
> 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
> >
>
>
>
> --
> =========================
>
> Stefan P Knecht
> Consultant
> 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
> stefan.knecht_at_trivadis.com
> http://www.trivadis.com
>
> =========================
-- http://www.freelists.org/webpage/oracle-l
Received on Fri Jun 29 2007 - 03:48:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US