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

"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'.

READ_ALL_DATA is as far as I can see NOT a default role (at least in current versions of Oracle)

>
> Why does my user do not have this default role and what privilege is
> required to create this role?

create role and the ability to grant the privileges that the role has. I'd be prepared to bet that you have a script to be run as system somewhere that creates this role.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK