-
Export problem.
Oracle : 8i
Solaris : 8
-----------------------------------
. about to export XYZ's tables via Conventional Path ...
. . exporting table STREET_AL 466880 rows exported
. . exporting table STREET_AR 398841 rows exported
. . exporting table STREET_AZ 377858 rows exported
. . exporting table STREET_CA 1558305 rows exported
. . exporting table STREET_CO 397432 rows exported
. . exporting table STREET_CT 185807 rows exported
. . exporting table STREET_DC 17572 rows exported
. . exporting table STREET_DE 63807 rows exported
. . exporting table STREET_FL 1237520 rows exported
. . exporting table STREET_GA 697323 rows exported
. . exporting table STREET_IA 410395 rows exported
. . exporting table STREET_ID 162258 rows exported
. . exporting table STREET_IL 943717 rows exported
. . exporting table STREET_IN 576405 rows exported
. . exporting table STREET_KS 427038 rows exported
. . exporting table STREET_KY 379777 rows exported
. . exporting table STREET_LA 425243 rows exported
. . exporting table STREET_MA 377629 rows exported
. . exporting table STREET_MD 309608 rows exported
. . exporting table STREET_ME 142321 rows exported
. . exporting table STREET_MI 712903 rows exported
. . exporting table STREET_MN 548022 rows exported
. . exporting table STREET_MO 622111 rows exported
. . exporting table STREET_MS 289272 rows exported
. . exporting table STREET_MT 141816 rows exported
. . exporting table STREET_NC 813093 rows exported
. . exporting table STREET_ND 185487 rows exported
. . exporting table STREET_NE 234219 rows exported
. . exporting table STREET_NH 110628 rows exported
. . exporting table STREET_NJ
EXP-00015: error on row 196247 of table STREET_NJ, column STREET_NAME, datatype 1
EXP-00222:
System error message 27
EXP-00002: error in writing to export file
EXP-00002: error in writing to export fileSegmentation Fault
Any idea why my export keep crashing?
Thanks.
-
check how much space remaining in the export location.
df -k
-
Only 46% full. It is writing to a local disk.
-
What is the size of the xport file..? Is LARGEFILES enabled in the file system level
-
It more then 6 gig. How do I check and change LARGEFILES enabled in the file system level?
-
Check with your system administrator. Also check the ulimit for the oracle user...
-
ulimit for oracle:
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 8192
coredump(blocks) 0
nofiles(descriptors) 256
vmemory(kbytes) unlimited
-
go to the export directory and run the commands .. post it
df -k .
ls -l
-
ls -la
total 5189592
drwxrwxrwx 2 oracle dba 4096 Dec 3 12:36 .
drwxrwxrwx 14 root root 4096 Jan 7 2003 ..
-rw-r--r-- 1 oracle dba 2147483647 Dec 3 12:59 xyz.dmp
df -k
/dev/md/dsk/d64 118492036 52738560 65753476 45% /a10_02d
-
It more then 6 gig. How do I check and change LARGEFILES enabled in the file system level?
-rw-r--r-- 1 oracle dba 2147483647 Dec 3 12:59 xyz.dmp
ie 2147483647 bytes = 1.99999GB
From where di you get 6GB???
Use compress method of export or
split the export file.
Anyhow LARGEFILES will not help you..
See this..
http://www.dbasupport.com/forums/sho...light=EXP00015
http://www.dbasupport.com/forums/sho...threadid=37714
Last edited by Thomasps; 12-04-2003 at 08:49 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|