Hi > Our backup scritps use the traditional exp tool... and we found > this in the log... By the way... Remember that neither exp nor expdp exports the user XDB (and a couple more...) even if a full database export is performed. I.e. another backup is usually needed... Regards, Chris >-----Original Message----- >From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On >Behalf Of Nilo Segura >Sent: 10 March 2006 14:53 >To: Hallas, John, Tech Dev >Cc: oracle-l@xxxxxxxxxxxxx >Subject: Re: problems with exp and expdb in 10gR2 > >Yes, all the ORA- errors I mentioned are from the exp/expdp 10gR2 tools. > >Support said that I should create a script to dump the data from the >"offending" tables in a table >that could be understood by SQL*Loader (for later recovery), or that I could >do a TS point in time >recover if required... > >All of them very "straighforward" solutions to implement and maintain. :( > > >They also said that expdp is certainly the way to go... :D > > > >On 3/10/06, Hallas, John, Tech Dev <John.Hallas@xxxxxxxxxxxxxxxxx> wrote: > > Interesting and worrying problem, as you say > Obvious question but I assume you are using 10g exp to export the table > with the binary_float column? > > Have Oracle come back and suggested what you are supposed to do yet? > > Moreover I wonder why datapump does not export the XML objects. Is it > ever likely to? > > > -- //www.freelists.org/webpage/oracle-l