Export problem.

Printable View

12-04-2003, 08:06 AM
Puja

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.
12-04-2003, 08:08 AM
Thomasps

check how much space remaining in the export location.

df -k
12-04-2003, 08:10 AM
Puja

Only 46% full. It is writing to a local disk.
12-04-2003, 08:12 AM
Thomasps

What is the size of the xport file..? Is LARGEFILES enabled in the file system level
12-04-2003, 08:18 AM
Puja

It more then 6 gig. How do I check and change LARGEFILES enabled in the file system level?
12-04-2003, 08:23 AM
Thomasps

Check with your system administrator. Also check the ulimit for the oracle user...
12-04-2003, 08:27 AM
Puja

ulimit for oracle:

time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 8192
coredump(blocks) 0
nofiles(descriptors) 256
vmemory(kbytes) unlimited
12-04-2003, 08:31 AM
Thomasps

go to the export directory and run the commands .. post it

df -k .
ls -l
12-04-2003, 08:39 AM
Puja

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
12-04-2003, 08:44 AM
Thomasps

Quote:

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
12-04-2003, 08:47 AM
rajabalachandra

hi,

try exporting that problematic table (STREET_NJ) alone.

whether it is the problem with the table or not.
12-04-2003, 08:49 AM
Puja

It would be total of more then 5gig ( 6 gig aprox ) once I finish exporting all tables.

I will try compress method.

Thanks for your help.
12-04-2003, 08:56 AM
Puja

exporting that problematic table (STREET_NJ) alone works fine.Problem start when I try a full dadabase export.

Thanks
12-04-2003, 07:02 PM
jlakhani

Puja,
try exporting to a compressed pipe(inline compression). I think that will solve your problem. Keep in mind that if you have partitions its much easier to perorm partition exports..
12-05-2003, 01:01 AM
Thomasps

Quote:

Originally posted by Puja
It would be total of more then 5gig ( 6 gig aprox ) once I finish exporting all tables.

I will try compress method.

Thanks for your help.

I was asking you the size of the export file when the export fails. Refer the links I gave, you will get the scripts to compress or compress and split.