- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- need Oracle file size larger than 2g
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
тАО04-19-2000 03:46 AM
тАО04-19-2000 03:46 AM
need Oracle file size larger than 2g
We are using HP UX 11 with a Oracle 7.2.3 database and Baan 4c software. We are
having trouble with our Oracle database. We are getting a Oracle error
indicating that our tables are full but when we check the tables still have
500M of space left on them.
Our tables should be sized at 2048 but the maximum size that Unix will allow
is 2000.
How do we break the 2g file size barrier?
Larry
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-19-2000 05:15 AM
тАО04-19-2000 05:15 AM
Re: need Oracle file size larger than 2g
2Gig barrier. It is not possible, to my knowledge, for this attribute to be
changed after teh filesystem has been created. You will need to create new
filesystems using the -o largefiles option for mkfs (or the -l option for
newfs) and transfer your datafiles to the new filesystems.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-19-2000 11:36 PM
тАО04-19-2000 11:36 PM
Re: need Oracle file size larger than 2g
files (>2G). For example:
fsadm -F hfs -o largefiles /dev/vg02/lvol1
Will modify the named hfs filesystem to support largefiles. For more
information see the man page for fsadm(1M) or fsadm_FS-TYPE(1M) (where FS-TYPE
is the type of the filesystem you are trying to modify).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-21-2000 03:20 AM
тАО04-21-2000 03:20 AM
Re: need Oracle file size larger than 2g
you need to do it on the character device instead of the block device as
reported in the man pages.
The syntax is:
#fsadm -F vxfs /dev/vg00/rlvol4
Nancy
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-01-2000 11:39 PM
тАО06-01-2000 11:39 PM
Re: need Oracle file size larger than 2g
To the best of my knowledge FSADM is not used for HFS file system type.
The syntax is correct like
fsadm -F vxfs -o largefiles -b 2048 /dev/vg01/file system
but if you want to extend your file system i think at the time of creation of file system we can define the -o largefiles option like
newfs -F vxfs/hfs -o largefiles /dev/dsk/rfile system name
HFS files can be extended with lvextend and extendfs command.
Regards
Nikhil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-03-2000 12:09 AM
тАО07-03-2000 12:09 AM