Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export/Import
HI!
You have to grant the correct rights.
grant IMP_FULL_DATABASE to <username>
grant EXP_FULL_DATABASE to <username>
this works for 7.3.4.
Hope this helps!
Thorsten
Kathinka Diehl schrieb:
>
> <junlei_at_my-deja.com> schrieb:
> >
> > The fromuser and touser parameters only require the username, not
> > password.
>
> THX, this have worked.
>
> But now I have the problem, that I have to import these datas in another
> database. Exort: user1_at_db1 and import: user2_at_db2.
>
> I have tried these users:
>
> userid=user1/passwort1_at_db1 or user2/passwort2_at_db2 or internal
> fromuser=user1
> touser=user2_at_db2
>
> But the error message ist: Only a DBA can import a file exported by another
> DBA.
>
> userr1_at_db1 has exported the data, all users have the DBA-rights. If I try to
> connect with internal, I have the same results.
>
> What's wrong?
>
> Best regards
> Kathinka
Received on Sat Nov 06 1999 - 04:37:15 CST