|
Replies:
5
-
Pages:
1
-
Last Post:
Aug 3, 2010 2:06 PM
by: stbaldwin@multi...
|
Threads:
[
Previous
|
Next
]
|
|
Posts:
9
Registered:
10/8/08
|
|
|
|
LOB Segments
Posted:
Jul 27, 2010 3:33 PM
|
|
|
Hi all,
I thought previous versions of Toad allowed me to see the name of the
corresponding LOB column of a LOBSEGMENT when viewing Objects in a
Tablespace (right click, properties ??).
Did I imagine that? If not, how do I see that information now
(10.5.1.3)? If I did imagine it, is it possible to request that as an
enhancement - either as a tooltip or via some right click option.
Thanks,
Steve
|
|
|
Posts:
9
Registered:
10/8/08
|
|
|
|
Re: LOB Segments
Posted:
Jul 29, 2010 11:55 AM
in response to: stbaldwin@multi...
|
|
|
Any ideas on this?
Thanks,
Steve
On Wed, Jul 28, 2010 at 8:33 AM, Steve Baldwin
<stbaldwin@multiservice.com> wrote:
> Hi all,
>
> I thought previous versions of Toad allowed me to see the name of the
> corresponding LOB column of a LOBSEGMENT when viewing Objects in a
> Tablespace (right click, properties ??).
>
> Did I imagine that? If not, how do I see that information now
> (10.5.1.3)? If I did imagine it, is it possible to request that as an
> enhancement - either as a tooltip or via some right click option.
>
> Thanks,
>
> Steve
>
|
|
|
Posts:
343
Registered:
2/4/09
|
|
|
|
RE: Re: LOB Segments
Posted:
Jul 30, 2010 12:13 AM
in response to: stbaldwin@multi...
|
|
|
Morning Steve,
>> Any ideas on this?
I did reply, but I've been missing a few messages recently, I thought it
had vanished as well.
>> I thought previous versions of Toad allowed me to see the
>> name of the corresponding LOB column of a LOBSEGMENT when viewing
Objects in a
>> Tablespace (right click, properties ??).
Not that I can remember, sorry. However, my caveat is that I don't
actually use the "objects in a tablespace" feature very often.
I did try on a system here with LOBs and it doesn't appear to show what
you are after, no matter where I right click etc.
Cheers,
Norm. [TeamT]
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.
If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
|
|
|
Posts:
383
Registered:
10/30/09
|
|
|
|
RE: Re: LOB Segments
Posted:
Aug 3, 2010 7:22 AM
in response to: Norm [TeamT]
|
|
|
Go to Tablespace -> Objects. F4 on a LOBSEGMENT row and it should find the
corresponding table/column in an F4 dialog.
|
|
|
Posts:
343
Registered:
2/4/09
|
|
|
|
RE: Re: LOB Segments
Posted:
Aug 3, 2010 7:50 AM
in response to: jdorlon
|
|
|
>> Go to Tablespace -> Objects. F4 on a LOBSEGMENT row and it
>> should find the corresponding table/column in an F4 dialog.
It's on Ask Toad now:
http://asktoad.com/DWiki/doku.php/howto_see_which_table_a_lob_segment_be
longs_to
Cheers,
Norm. [TeamT]
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.
If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
|
|
|
Posts:
9
Registered:
10/8/08
|
|
|
|
Re: Re: LOB Segments
Posted:
Aug 3, 2010 2:06 PM
in response to: jdorlon
|
|
|
That works great. Thanks John.
Steve
On Wed, Aug 4, 2010 at 12:22 AM, John Dorlon < john.dorlon@quest.com > wrote:
Go to Tablespace -> Objects. F4 on a LOBSEGMENT row and it should find
the corresponding table/column in an F4 dialog.
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
