Hi,

If the random number (blob_id) is more or less evenly spread, you could
use that.

Greetings,

Bas

-----Oorspronkelijk bericht-----
Van: Jerry Friedman
[mailto:oracledba-ezmlmshield-x68995020.[Email address protected]
Verzonden: dinsdag 9 oktober 2007 17:01
Aan: LazyDBA Discussion
Onderwerp: RE: partitioning blobs

It is a value_length. a number showing the number of bytes for the
blob.

I wish I had a date, but I don't. It is a third party COTS product.

So, how should I partition this table?

Thanks.

Jerry



________________________________

From: Manash Baruah [mailto:[Email address protected]
Sent: Tue 10/9/2007 10:33 AM
To: Jerry Friedman
Subject: RE: partitioning blobs



**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email, **and removed
any attachments, and kept your email address secret **from this person,
and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal **Anything below this line is the original email text



Hi Jerry,

Could you please tell what is stored in value and its significance...??


Thanks & Regards,
Manash Pratim Baruah | Tech Mahindra Ltd.
Sharda Centre, Off Karve Road, Pune - 411004, India.
www.techmahindra.com



-----Original Message-----
From: Jerry Friedman
[Email address protected]
Sent: Tuesday, October 09, 2007 7:52 PM
To: LazyDBA Discussion
Subject: partitioning blobs

Hi all,

I have a table with 3 columns, no dates.

Only the blob, blob_id (random number but unique PK) and value.

How would you suggest I partition the blob?

TIA,

Jerry


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



========================================================================
====================================================


Disclaimer:

This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may
review the policy at <a
href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahind
ra.com/Disclaimer.html</a> externally and <a
href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahind
ra.com/Disclaimer.html</a> internally within Tech Mahindra.

========================================================================
====================================================






---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


Oracle LazyDBA home page