Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Export/Import ... Error

Re: Export/Import ... Error

From: JK Yao <jkyf0131_at_hotmail.com>
Date: 15 Jul 2001 18:06:01 -0700
Message-ID: <93f65984.0107151706.76fe9906@posting.google.com>

Any idea where I can find those document? In somewhere of the OS? (my OS is Solaris5.6) Or I have to buy it?

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
Received on Sun Jul 15 2001 - 20:06:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US