Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!logbridge.uoregon.edu!newshub.sdsu.edu!elnk-pas-nf2!newsfeed.earthlink.net!newsfeed.news2me.com!newsfeed2.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!sn-xit-02!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: "Steve Ashmore" Newsgroups: comp.databases.oracle.misc Subject: Re: Import error ORA-01917... 'READ_ALL_DATA' Date: Mon, 7 Jul 2003 16:15:47 -0500 Organization: Posted via Supernews, http://www.supernews.com Message-ID: References: X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Complaints-To: abuse@supernews.com Lines: 33 Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:129110 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" wrote in message news:CViOa.122$Ag6.16678@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. > >