Re: Importing just one table to another schema using imp

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Thu, 08 Apr 2004 22:35:06 GMT
Message-ID: <uskdc.16562$e17.2677@twister.nyroc.rr.com>

"Walt" <walt_askier_at_yahoo.com> wrote in message news:4075CD35.DCB6BD84_at_yahoo.com... --snip--
> How do you get it to just import the table and nothing else?
>
> Here's an example of the parfile
>
> FULL=n
> LOG=imp_8Apr2004.txt
> SHOW=y
> ROWS=n
> GRANTS=n
> CONSTRAINTS=n
> INDEXES=n
> FILE=e:\Imports\expdat.dmp
> Feedback=1000
> FROMUSER=SCHEMA1
> TOUSER=SCHEMA2
> TABLES=(mytable)
>
> Oracle 9.2 on W2k3.
>
> --
> //-Walt

How about:
userid=user/pass
fromuser=schema1
touser=schema2
indexes=n
constraints=n
buffer=102400000
rows=y
commit=y
statistics=none
grants=n
tables=(mytable)

Incidently you can skip the export of triggers in exp .. but cannot prevent the import in imp. So that you would need to drop them after import.

Anurag Received on Thu Apr 08 2004 - 17:35:06 CDT