RE: problems with exp and expdb in 10gR2

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: <nilosegura@xxxxxxxxx>
  • Date: Fri, 10 Mar 2006 15:19:10 +0100

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


Other related posts: