Re: how to get a BLOB from a table to OS?

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 05 Jun 2005 23:17:38 -0700
Message-ID: <1118124575.91021@yasure>

dominica_at_gmail.com wrote:
> DA Morgan wrote:
>

>>dominica_at_gmail.com wrote:
>>
>>>HI Daniel,
>>>
>>>Thank you very much for your help.
>>>Though, I am running 8.1.7.4 .
>>>I still will try it out.
>>>
>>>Actually, I found out it is very easy to do in Perl-DBI,
>>>but I just need to get Perl-DBI installed.
>>>
>>>Dominica
>>
>>Don't waste your time ... it is only going to work in 10g.
>>
>>Which given that 8i is in desupport is where your primary
>>focus should be: Upgrading.
>>
>>You will get superior performance.
>>Superior scalability
>>Superior security
>>SarbOx and HIPAA compliance capability
>>plus most importantly
>>A resume' that will get you another job.
>>--
>>Daniel A. Morgan
>>http://www.psoug.org
>>damorgan_at_x.washington.edu
>>(replace x with u to respond)

>
>
>
> Hi Daniel,
>
> Thanks for your help.
> I agree, don't waste too much time on this.
> Since I already behind on my "testing" of 10g upgrade schedule.
>
> I like "A resume that will get you another job".
> I like that :)
>
> May I ask you for something else?
> Do you have a copy of a SAMPLE 10g spfile??
> I know Oracle will have one. Usually I don't like the
> sample that come with oracle. Usually the parameter is too small.
> I would like to look at the undo tablespace and sizing and
> how you do it???
>
> My DB is around 150 G. Very fast OLTP,
> and the consistent get is around several million per minute.
> Sometimes, even go up to 10 million per minute for consistent get.
> Pretty crazy.
>
>
>
> Dominica

My SPFILE, or anyone else's, will be meaningless to you. You need to create your own based on the init.ora. Here's where to go to find the directions.

$ sqlplus /nolog

SQL> conn / as sysdba
SQL> shutdown immediate;
SQL> create spfile from pfile='<your init.ora file here';
SQL> startup;
SQL> show parameter spfile -- to see if you are using an spfile

Examples can be found at http://www.psoug.org click on Morgan's Library
click on SPFILE

and also at http://tahiti.oracle.com

HTH

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Mon Jun 06 2005 - 01:17:38 CDT