Re: ExportObjects: is "Unable to loca te LOB segment” fatal?

Anthony Tuininga <[email protected]> Wed, 27 Jan 2016 16:16:01 -0700
Newsgroups gmane.comp.python.db.cx-oracle
Message-ID <CAE1XR-6fiMMHTGOnBWmy2YM1em3B067cY3=m1BFauD7TWZBtqA@mail.gmail.com>
Hi Mark,

If you use the -t option you will get traceback that should help you figure
things out. It is trying to read from either dba_segments or user_segments
(depending on if you used the --use-dba-views option) and is unable to
locate the row. Considering it is referencing TLC.DEFINITION and you are
connecting as FOO I'd guess you want to use --use-dba-views.

And yes, that error is indeed fatal. :-(

Anthony

On Wed, Jan 27, 2016 at 4:04 PM, Mark Harrison <[email protected]>
wrote:

> I’m getting this error on one of our dev databases.
>
> 1.  What is the cause of this?  How can I find the problem table
> definition?
>
> 2. Is this fatal to ExportObjects, I.e. will processing continue?
>
> $ ExportObjects --default-tablespace --default-storage —schema=foo/bar
> Describing synonyms...
> Describing sequences...
> Describing tables...
> 14:48:19.170 Unable to locate LOB segment TLC.DEFINITION
>
>
> ------------------------------
> DISCLAIMER: The information transmitted is intended only for the person or
> entity to which it is addressed and may contain confidential and/or
> privileged material. Any review, re-transmission, dissemination or other
> use of, or taking of any action in reliance upon this information by
> persons or entities other than the intended recipient is prohibited. If you
> received this in error, please contact the sender and destroy any copies of
> this document and any attachments.
>
>
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
> _______________________________________________
> cx-oracle-users mailing list
> cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140

_______________________________________________
cx-oracle-users mailing list
cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users