Re: imp a user
From: sybrandb <sybrandb_at_gmail.com>
Date: Wed, 26 Mar 2008 07:04:43 -0700 (PDT)
Message-ID: <a8045be1-74fa-4de8-9c6c-47241351be35@i29g2000prf.googlegroups.com>
Date: Wed, 26 Mar 2008 07:04:43 -0700 (PDT)
Message-ID: <a8045be1-74fa-4de8-9c6c-47241351be35@i29g2000prf.googlegroups.com>
On Mar 26, 1:50 pm, "timo" <timo.ta..._at_luukku.com> wrote:
> Hi, I'm confused; please advice me how to import single user from a dmp-file
> to DB where that user simply does not yet exist ?
>
> I'd rather not like to first create a 'skeleton'-user and the
> ...fromuser...touser... ; I'd like to bring that user as it is in that
> dmp-file with grants and all ...
>
> Thank,
> BR,
> Timo
Both creating the user and using fromuser/touser are compulsory.
-- Sybrand Bakker Senior Oracle DBAReceived on Wed Mar 26 2008 - 09:04:43 CDT