Re: Export/Import ... Error

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 21 Jul 2001 21:37:11 GMT
Message-ID: <tkviie611rgd1c@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 Received on Sat Jul 21 2001 - 16:37:11 CDT