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@(protected)
>Sent: 10 March 2006 14:53
>To: Hallas, John, Tech Dev
>Cc: oracle-l@(protected)
>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@(protected):
>
>  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?
>
>
>

--
http://www.freelists.org/webpage/oracle-l