| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Sqlplus "spool" and "dd" worked in 8, but not in 9?
The developer managed to compare one script that did work and found he
had about 4-5 "set" options different than the one that worked.
Unfortunately, he pulled ALL the different options, so it's hard to say which one, but the script works like a champ.
He also tried a "direct spool" no "dd" and this is working and was beyond the 2.6GB limit at 11:30 and should still be going.
Maybe, if we get the time, we'll put those 4-5 options back in and see which one caused it to die.
Thanks to one and all.
That's what this group is all about.
Michael Kline
Database Administration
Outside 804.261.9446
Cell 804.744.1545
3-9446
> -----Original Message-----
> From: Jesse, Rich [mailto:Rich.Jesse_at_quadtechworld.com]
> Sent: Tuesday, April 26, 2005 12:30 PM
> To: Kline.Michael; oracle-l_at_freelists.org
> Subject: RE: Sqlplus "spool" and "dd" worked in 8, but not in 9?
>
> I don't think it's a 9i issue, at least not with 9.2.0.5.0 on HP/UX
11.11 using vxfs. I just tried
> this and the spool created fine up to 2154009964 bytes (>2GB) before I
killed it.
>
> Make sure the mountpoint(s) being used was/were created with
"largefiles", although I thought even
> without it the fs should handle up to 4GB-1 filesizes. Also make sure
your SQL*Plus settings are the
> same as they were in 8i. One guess would be that a setting changed or
was missed in the conversion
> (perhaps a login.sql file?).
>
> HTH! GL!
>
> Rich
>
> Rich Jesse System/Database Administrator
> rich.jesse_at_quadtechworld.com QuadTech, Sussex, WI USA
>
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> Sent: Monday, April 25, 2005 3:35 PM
> Subject: Sqlplus "spool" and "dd" worked in 8, but not in 9?
>
>
> Our group here had a "report" that went over 2gb.
>
>
> In version 8.1.7.4 on HPUX they did a pipe and then did a "dd of the
> pipe to the "over 2gb" file name.
>
>
>
> We converted the database to 9.2.0.4 and now this utility goes to
never,
> never land. Nothing gets written to the pipe and it appears dd never
> sees anything to make it's output file.
>
>
>
> I've not done the "digging" and this is the first I've seen this kind
of
> situation, but perhaps with other warehouses out there someone else
has
> already "been there, done that, this is what you do?????"
>
>
>
> I've requested them to run the thing with no "dd" or pipe. Version 9
may
> support spool files over 2gb.
>
>
>
> Anyone else have input on this?
>
>
>
> Michael Kline
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 26 2005 - 13:52:03 CDT
 |
 |