ORA-01919: role 'XDBADMIN' does not exist

[n_srinath4u]

Hi,

I have used the following code for creating user and granting role to that user. But i am

getting error while granting role as
ORA-01919: role 'XDBADMIN' does not exist!!..
Please let me know where i went wrong...
I am using Oracle9i for this, my OS is windowXP.

create user xDemo identified by demo
default tablespace users
temporary tablespace temp
quota unlimited on users;

grant create session,
alter session,
create table,
create trigger,
create type,
create any directory,
drop any directory,
xdbadmin
to xDemo;

thanks,

Srinath N

[davey23uk]

do you have the xdb intsalled?

[n_srinath4u]

nop, how do i install xdb. where do i get it?

[davey23uk]

https://metalink.oracle.com/metalink...&p_id=243554.1

[n_srinath4u]

ThanQ I got it. I am using Oracle9i release 1 which does't support XML DB. I've installed 10g then it worked and i think it also work for oracle9i release 2.

Srinath N.