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