limitation on spool file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: limitation on spool file

Hybrid View

  1. #1
    Join Date
    Aug 2000
    Location
    NJ
    Posts
    54

    Angry

    I have done extraction of large table data (4GB table) using Oracle client (Client on NT) and with Oracle server on NT, AIX and Solaris platforms without any problem. The scripts are run on SQLPLUS and is a plain select statement extracting into a pipe-delimited txt file. The extraction went fine as long as Oracle client is on NT.

    But if I use Oracle cleint on UNIX (AIX and Solaris), the extraction cuts of at 2GB without any error message.

    Is there a way to get around this problem.


    Thanks in advance,

    Geo

  2. #2
    Join Date
    Apr 2000
    Posts
    126

    Wink

    There is a 2G limit on files in your UNIX environment. If available for you platform, you would need the SA to modify your file system to handle files larger than 2G.

  3. #3
    Join Date
    Aug 2000
    Location
    NJ
    Posts
    54

    Angry

    I made sure that the system (is large file enabled : ie the filesystem to where I am writing the spool file to is large file enabled)
    But oracle software is installed on a mount poit /u01 where large file support is not eanbled. but this should not cause a problem as none of the oracle files a re greater than 2GB.
    But I made sure that the fialsystem to which I am spooling to
    is larg file enabled.

    could there be any other reason.

    i can spool a 4GB table to faltfile if I use NT oracle client (with oracle server residing on AIX or Solaris).

    Thanks in advance



    Geo

  4. #4
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Talking



    Just spool half to one file and half to another.

    - Magnus

  5. #5
    Try using PIPES
    Ramon Caballero, DBA, rcaballe@yahoo.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width