- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- File size getting limited
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-30-2007 10:19 PM
тАО07-30-2007 10:19 PM
When i try to extract records from oracle the file size in unix is getting limited to 2GB. The actual size should be 9GB.Is this an oracle error or unix error?
i just extract like
connect
spool
select query
spool off
-Mayilvahanan
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-30-2007 10:30 PM
тАО07-30-2007 10:30 PM
Solution# fsadm /opt
fsadm: /etc/default/fs is used for determining the file system type
largefiles
# fsadm /
fsadm: /etc/default/fs is used for determining the file system type
nolargefiles
Pete
Pete
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-30-2007 10:35 PM
тАО07-30-2007 10:35 PM
Re: File size getting limited
Could be the filesystem has not been set to enable largefiles >2GB
with OnlineFFS
# fsadm -F vxfs /filesystem
# fsadm -F vxfs -o largefiles /filesystem
without OnlineJFS
# fsadm -F vxfs /dev/vgXX/lvolX
# umount /filesystem
# fsadm -F vxfs -o largefiles /dev/vgXX/lvolX
Regards,
Robert-Jan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-31-2007 12:59 AM
тАО07-31-2007 12:59 AM
Re: File size getting limited
You should enable largefiles support on the file system as mentioned. If this cannot be done immediately, you may wish to create a new file system using SAM and enable the largerfiles support there itself. Then once mounted, you can proceed with the spool operation.
Also, to get a better performance, it is preferrable not to echo the output to the current session screen.
good luck!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-31-2007 10:59 PM
тАО07-31-2007 10:59 PM