Re: Exp from a user and import into another

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: Wed, 22 Sep 1999 11:39:26 +0100
Message-ID: <ojECyEAeHL63Ewj7@ahardy.demon.co.uk>

In article <01bf04d5$179f1530$7eda17a2_at_vanoli-zd>, Virgile Vanoli <virgile.vanoli_at_bfs.admin.ch> writes
>Hello,
>I want to export from an user and import into another user without having
>the full_imp_database role. Is this possible ?
>
>Thanks
>
>Virgile

If you have permission to become the user, then I should think so.

imp73 newuser/newpassword_at_newdb fromuser=olduser

I think that you get a warning message about the objects being from another user.

Sorry to be vague, but I usually only do this with dba users.

Andy
--
Andy Hardy. PGP key available on request

Received on Wed Sep 22 1999 - 05:39:26 CDT