| 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
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 SYSAbout 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-lReceived on Fri Jun 29 2007 - 02:49:26 CDT
 |
 |