Re: Import error ORA-01917... 'READ_ALL_DATA'

Hi Martin,
unless you are doing a full export/import, roles are not created in the target database.
So, since in this case your role is not in the target instance, and this is not an ORACLE
supplied role, you will need to create your role.

To create a role you need the CREATE ROLE system privilege.

Best of luck:

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com
Author of: 'So You Want to be an Oracle DBA?'

"Martin Saintonge" <msaintonge_at_calabrio.com> wrote in message news:CViOa.122$Ag6.16678_at_news20.bellglobal.com...
> Hi,
>
> When importing a .dmp file with the 'From User' 'To User' option, I get
> the error ORA-01917, User or Role does not exist 'READ_ALL_DATA'.
>
> Why does my user do not have this default role and what privilege is
> required to create this role?
>
> regards,
> The dev team.
>
>
Received on Mon Jul 07 2003 - 16:15:47 CDT