RE: Sqlplus "spool" and "dd" worked in 8, but not in 9?
- From: "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx>
- To: <Michael.Kline@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 26 Apr 2005 11:30:10 -0500
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@xxxxxxxxxxxxxxxxx QuadTech, Sussex, WI USA
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
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.
=20
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.
=20
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.
=20
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?????"
=20
I've requested them to run the thing with no "dd" or pipe. Version 9 may
support spool files over 2gb.
=20
Anyone else have input on this?
=20
Michael Kline
--
//www.freelists.org/webpage/oracle-l
Other related posts:
