Re: OEM Data Manager - How to import to a user different from the exporting user
From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 22 Oct 1998 11:53:38 GMT
Message-ID: <362f8622.2535152_at_netnews.worldnet.att.net>
Date: 22 Oct 1998 11:53:38 GMT
Message-ID: <362f8622.2535152_at_netnews.worldnet.att.net>
On Tue, 20 Oct 1998 18:56:27 GMT, mkaushik_at_harvestinc.com wrote:
>Occasionally we need to export schema objects and data
>created by user1 in database1 into database2 for user2.
>
>How does one do that ? Even if the export mode is "TABLE"
>during export, the import utility complains that the same
>user does not exist.
I don't use OEM data manager, but I can tell you how to do this from the command line. Using the import utility from the command line, you do something like this:
import system/manager_at_whatever file=XXX log=YYY fromuser=scott touser=herman
The above is all one line. It will import all of scott's objects into herman's schema.
regards,
Jonathan Received on Thu Oct 22 1998 - 13:53:38 CEST