Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!news3.google.com!sn-xit-04!sn-xit-08!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: DA Morgan <damorgan@psoug.org>
Newsgroups: comp.databases.oracle.server
Subject: Re: how to get a BLOB from a table to OS?
Date: Sun, 05 Jun 2005 23:17:38 -0700
Organization: Ye 'Ol Disorganized NNTPCache groupie
Message-ID: <1118124575.91021@yasure>
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
References: <1117852182.584855.44180@g43g2000cwa.googlegroups.com>   <1117891992.242673@yasure>   <1117924176.682608.216000@g44g2000cwa.googlegroups.com>   <1117935617.38505@yasure> <1118033800.644132.217920@z14g2000cwz.googlegroups.com>
In-Reply-To: <1118033800.644132.217920@z14g2000cwz.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Cache-Post-Path: yasure!unknown@oracle.advtechserv.com
X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/)
X-Complaints-To: abuse@supernews.com
Lines: 83
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:244406

dominica@gmail.com wrote:
> DA Morgan wrote:
> 
>>dominica@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@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@x.washington.edu
(replace x with u to respond)