- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: export command
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
тАО03-31-2005 01:06 AM
тАО03-31-2005 01:06 AM
export command
"EXP-00015: error on row 16234 of table BILL_IMAGES, column BI_IMAGE, datatype 24
EXP-00222:
System error message 27
EXP-00002: error in writing to export file
EXP-00002: error in writing to export file
EXP-00000: Export terminated unsuccessfully"
If this error appears to have an error on the table BILL_IMAGES, How can i export my database excluding that table/s.
thanks
regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2005 01:08 AM
тАО03-31-2005 01:08 AM
Re: export command
Did you run out of space in your filesystem during the export??
live free or die
harry d brown jr
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2005 01:12 AM
тАО03-31-2005 01:12 AM
Re: export command
System error message 27
I think export growing over 2GB size and the your FS does not support it. Check it.
mount -p | grep "/FS"
Does it support largefiles?
If not you will have to enable it and then try.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2005 01:24 AM
тАО03-31-2005 01:24 AM
Re: export command
"newfs -F vxfs -o largefiles /dev/lan01/rora7".
thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2005 02:39 AM
тАО03-31-2005 02:39 AM
Re: export command
You probably should export your database per schema (can do many at once), and then a second no-rows database export of the whole database.
Then, import the whole database - no rows first, then schema at a time. This will probably go a long way to control the size of the file, as well as allow you to import multiple schemas at a time after the initial no-rows import. You'll gain speed, and reduce your import time.
Re: NFS - is it possible that even though the file system can handle large files, the NFS mount cannot ??? Also, I've seen many errors using NFS for large file transfers - it will usually be just small timeouts - but get enough of them and the whole process fail s to complete with a write error. I guess my basic advice is try not to use NFS - export to local disk then copy over the other machine. If the other machine is the one with the disk space - then install an Oracle client there (on the NFS host machine), and run the export from that machine, letting SQLNET handle the traffic for you, instead of NFS.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2005 02:40 AM
тАО03-31-2005 02:40 AM
Re: export command
Which NFS do you run? Version 2 or 3 ?
AFAIK version 2 is default for HPUX10.20. This version does not support largefiles option.
HTH
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2005 03:01 AM
тАО03-31-2005 03:01 AM
Re: export command
mkfifo -m 660 /tmp/mypipe
Now start a process attempting to read from that pipe:
cat < /tmp/mypipe > /xxx/yyy/zzz &
or
dd if=/dev/mypipe of=/xxx/yyy/zzz &
Now start your exp but output to /tmp/mypipe.
Because you are writing to a device node, exp doesn't have the same limitations --- eventhough ultimately the output is going to a file.
WEhen you are finished, rm /tmp/mypipe.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2005 03:11 AM
тАО03-31-2005 03:11 AM
Re: export command
from /usr/include/sys/errno.h:
define EFBIG 27 /* File too large */
from man 2 errno:
[EFBIG] File too large. The size of a file exceeded the maximum file size (for the file system) or ULIMIT was exceeded (see ulimit(2)), or a bad semaphore number in a semop() call (see semop(2)).
In other words, the file is too big for the destination file system. Your export will have to be directed to a local disk if it exceeds 2Gb since there is no support for large files on NFS in 10.20.
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2005 03:30 AM
тАО03-31-2005 03:30 AM
Re: export command
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2005 04:01 AM
тАО03-31-2005 04:01 AM
Re: export command
thanks