Re: Export/Import logs

From: Mark Bole <makbo_at_pacbell.net>
Date: Sat, 22 Oct 2005 16:53:59 GMT
Message-ID: <H8u6f.5514$q%.3599@newssvr12.news.prodigy.com>

dbaplusplus_at_hotmail.com wrote:
> I am using Oracle 10.1.0.4 on HP UNIX 11i. I did a full export and
> see following in export log:
>
> . . exporting table AINVDISC 0 rows
> exported
> . . exporting table ALERTMSG
> . . exporting table ALLOC_STRAT 0 rows
> exported
>
> Why there are no rows shown by ALERTMSG. I looked in database, ALERTMSG
> is a table, it has no rows. Same is true for AINVDISC and ALLOC_START.
> What is different about ALERTMSG.
>

Try this:

select TEMPORARY from user_tables where TABLE_NAME = 'ALERTMSG';

If you get 'Y', there's your answer.

-Mark Bole Received on Sat Oct 22 2005 - 11:53:59 CDT