| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> SUBSTR IN BLOBS, does anyone know how to do it :)
Hi I can't get a substr from a blob I tried substrb too but it doesn't works
FUNCTION Comparar( bLob12 BLOB, bLob22 BLOB ) RETURN VARCHAR2 IS
nCantidad INTEGER := 32767;
nRetval INTEGER;
cReturn VARCHAR2(2000);
bLob1 blob := SUBSTR(BLOB12,1,20000);
bLob2 blob := SUBSTR(BLOB22,1,20000);
BEGIN DBMS_LOB.OPEN (bLob1, DBMS_LOB.LOB_READONLY);
DBMS_LOB.OPEN (bLob2, DBMS_LOB.LOB_READONLY);
nRetval := DBMS_LOB.COMPARE(bLob1, bLob2, nCantidad, 1, 1);
IF nRetval = 0 THEN
cReturn:='T';
ELSE cReturn:='F';
END IF; DBMS_LOB.CLOSE (bLob1);
DBMS_LOB.CLOSE (bLob2);
RETURN cReturn;
END; on 2/10/04 3:13 AM, Nuno Souto at dbvision_at_optusnet.com.au wrote:
> ----- Original Message -----
> From: "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk>
>>
>> Yes, NTFS is most definitely susceptible to fragmentation - in the sense
> th=
>> at a single datafile may get split into multiple pieces all over the
shop.
> =
>> If you have an NT based laptop take a look at the disk using the disk
> defra=
>> gmenter in administrative tools (you can just run an analyze and not
> actual=
>> ly do any defragmenting).=20
>
>
> And these things, like most others in NTFS, are fully configurable.
> For those interested, I do recommend reading the FULL description
> of the "fsutil" command. New in XP, I believe it was there
> in W2K Pro and ES but undocumented. It allows you to
trim/control/configure
> most of these file system parameters.
>
> Some are VERY relevant to Oracle.
>
> This is an interesting tech note in the M$ website:
>
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol
> /winntas/maintain/optimize/instant.asp
>
> watch out for wrapping, try this if all else fails:
> http://tinyurl.com/27sgv
>
> And of course, don't forget:
> http://tinyurl.com/elct
> if you REALLY want to bump up those DFMBR read sizes for FTS!
> This last one also has a bearing on the minimal portion/fragment
> that a file can be split into at create time, although I've only
> seen that described outside of M$ (undoco?).
>
>
> Don't forget one very important thing: BY DEFAULT, NTFS is configured
> to provide optimal "file server" functionality.
> That's HEAPS of SMALL files, in the Queen's language.
>
> Nothing could be more removed from the reality of Oracle db files:
> FEW, VERY LARGE files.
>
> So, be prepared for heaps of tuning/configuring. And for Pete's sake
> (or any other of Pete's drinks that turn you on), do NOT create Oracle
> database files in anything other than a freshly formatted NTFS
> partition!!!!!
>
> To their credit, M$ nowadays provides incredible amounts of doco of good
> to very good quality in their site. That was not always the case...
>
>
>
>
> Or, take the easy way out: install 10g, give it unformatted (raw)
> partition(s) to manage and be done with all these problems.
> (and if you believe that, you're really brave...)
> :D
>
> Cheers
> Nuno Souto
> in sunny Sydney, Australia
> dbvision_at_optusnet.com.au
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue Feb 10 2004 - 08:00:18 CST
 |
 |