Re: list table names in a export dump file (9i)

From: Roger Xu <wellmetus_at_gmail.com>
Date: Tue, 1 Dec 2009 16:50:10 -0600
Message-ID: <eb64345d0912011450o5f736bfewc2ecd7ac969f9131_at_mail.gmail.com>

I will ask them to send me the tablelist with the dump file - I think this is the easiest way.
thank you all!

On Tue, Dec 1, 2009 at 4:42 PM, Allen, Brandon <Brandon.Allen_at_oneneck.com>wrote:

> You have to “specify FULL=Y or provide FROMUSER/TOUSER or TABLES “ with
> the import command in addition to show=y just as the error indicates.
>
>
>
> But, wouldn’t it be easier to just generate the truncate script with a
> query on the source database like this:
>
>
>
> select ‘truncate table ‘ || table_name || ‘;’ from dba_tables where <insert
> desired filter conditions here>;
>
>
>
> Regards,
>
> Brandon
>
>
>
> ------------------------------
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Dec 01 2009 - 16:50:10 CST