Re: Export/Import ... Error

In article <93f65984.0107151706.76fe9906_at_posting.google.com>, jkyf0131_at_hotmail.com says...
>
>Any idea where I can find those document?
>In somewhere of the OS? (my OS is Solaris5.6)
>Or I have to buy it?
>

vi /usr/include/errno.h

which on solaris will point to

/usr/include/sys/errno.h

where you find:

#define ENOSPC 28 /* No space left on device */

which mean Sybrand hit the proverbial nail on the head. Your disk be full.

>Thanks for any help.
>
>regards,
>JK
>
>
>"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
>news:<tkviie611rgd1c_at_beta-news.demon.nl>...
>> "JK Yao" <jkyf0131_at_hotmail.com> wrote in message
>> news:93f65984.0107131948.156d1ff5_at_posting.google.com...
>> > dear all,
>> >
>> > I have Oracle 7.3.4 installed on Solaris7 in E3000 box.
>> > When I export my database use follow command:
>> >
>> > exp sys/password full=y file=expdat.dmp
>> >
>> > There are following error after export some tables ..
>> >
>> > EXP-00015: error on row 38067 of table CUSTOMER_ORDER_LINE_HIST_TAB,
>> > column DATE_ENTERED, datatype 12
>> > EXP-00222:
>> > System error message 28
>> > EXP-00002: error in writing to export file
>> > EXP-00002: error in writing to export file
>> > EXP-00000: Export terminated unsuccessfully
>> >
>> >
>> > Anyone know what is that and how can I solve it? Any tool to check
>> > what's the problem?
>> > Please help. Any hint will be very appreciated.
>> >
>> > thanks in advance,
>> > JK
>>
>> Look in your Solaris documentation what system error 28 is.
>> One of the most frequent reasons for exp to fail is a full filesystem. That
>> can be easily verified by ordinary shell commands, no tool needed.
>>
>> Hth,
>>
>> Sybrand Bakker, Senior Oracle DBA

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp