Privs Required on Schema Import 1

[Michael42]

Hello,

In and Oracle 9i database on Solaris 8 I am performing a schema import of the user\schema APP. Before I do the import I drop the user APP and recreate it giving the user connect and resource privs.

Though I perform the import as sys (imp / parfile=myfile.params) when I perform the import I get errors saying that it does not have privs to create various schema objects. To fix this I also grant DBA to the APP user and the import works OK. I then remove DBA after the import.

What privs can I give this user other than DBA so as I can perform a schema import described above?

Thanks,

Michael42

 

[oradba101]

Hi, Michael42

IMP_FULL_DATABASE perhaps?

Regards,


William Chadbourne
Oracle DBA

 

[Michael42]

oradba101,

Sorry to take so long to get back to you on this. YES this worked! I wanted to be 100% sure before responding.

Thanks,

Michael42