Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: import dump into database
"With power comes responsabilities".
Use your powers wisely Wendy.....
Regards,
Marc Mazerolle
Stephane Faroult wrote:
> wendy ng wrote:
> >
> > Hello,
> > I am importing a dump file using Oracle Enterprise Manager where I logged in
> > as 'system/manager_at_alias name'. However, becoz the dump file is exported
> > not using the same but as a user, I am having warning messages such as
> > 'Database is exported by "username", not by you'; meaning not as
> > system/manager. Although I know I need to delete the repositories later, is
> > there any other way where I can
> > 1). still log in as 'system/manager'
> > 2). import the dump that is exported by some other user
> > 3). specify the fromuser / touser (like in Unix)
> > Please help, I a newbie interms of NT platform matters....
> > Many thks,
> > wendy ng
> As you said, it's a warning message. As an ordinary user, you cannot
> import a full database export, for instance, because it requires
> privileges usually associated with DBAs, and to import data from
> somebody else you need fromuser=... touser=... But as a DBA you can do
> whatever you want, even if you are not the original DBA. All DBAs are
> equal (although SYS is more equal than the others).
> --
> Regards,
>
> Stéphane Faroult
> Oriole Corporation
> ------------------------------------------------------------------
> http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
> ------------------------------------------------------------------
Received on Tue Mar 30 1999 - 14:00:02 CST