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.
=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

--
http://www.freelists.org/webpage/oracle-l