Re: Importing just one table to another schema using imp

Anurag Varma wrote:
> "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.

> 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.

I get essentially the same behavior. I don't really care about the fact that it imports the indexes for the table even though I've told it not to. Likewise with the grants.

But the trigger import seems to be a real problem. It creates a trigger in the schema2 that acts on the table in schema1. The result is that schema2.mytable has no trigger (not really a problem) and schema1.mytable winds up with two triggers on it, one in each schema. Is this a known bug or what?

Note: I'm diagnosing this by using show=y, rows=n and looking at the SQL.

-- 
//-Walt
// 
//