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 =========================