Re: import from Oracle 9 to 10 hanging

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

Thanks

--
LSC


On 6/29/07, Stefan Knecht <knecht.stefan@xxxxxxxxx> wrote:


Of course you can export sys:

oracle@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@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
>



--
=========================

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@xxxxxxxxxxxx
http://www.trivadis.com

=========================

Other related posts: