Re: import question

From: Svend Jensen <Master_at_OracleCare.Com>
Date: Thu, 10 Jan 2002 21:36:49 +0100
Message-ID: <3C3DFB61.4050603@OracleCare.Com>

ed zappulla wrote:

> Is it possible to import all the tables from a user except 1? Oracle 8.1.6
>
> imp touser=aUser fromuser=bUser rows=y constraints=y grants=y indexes=y
> file=x.dmp
>
>
>
>
>

You can use the table=(tab1,tab2,....) option of import, or create a dummy table with the name of the table u dont want to import, and then import with option ignore=y, then drop the dummy table.

/Svend Jensen Received on Thu Jan 10 2002 - 14:36:49 CST