RE: problems with exp and expdb in 10gR2

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nilo Segura
>Sent: 10 March 2006 14:53
>To: Hallas, John, Tech Dev
>Cc: oracle-l_at_freelists.org
>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_at_gb.vodafone.co.uk> 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?
>
>
>

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