Exporting ROLES in Oracle 9i 1

[spook007]

Anyone familiar on how to export ROLES in Oracle 9i. I do believe that if a full export is made, that the roles are also included in that export, but is there someway to just export the roles and not have to do a full export? Thanks!

 

[Turkbear]

AFAIK, you can export roles( which are just groups of privs)
only as part of some other export mode..
If FULL, then all privs will be exported.
If TABLE, then all on those tables
if USER, then all privs created by that USER

Why not just recreate the roles on the target database?

 

[cliousa]

ROLES are included only in the full db export.

It's not so hard to do full db export with rows=n. It should take no more than 5 minutes. Then open the dmp file with text editor, cut & past the CREATE ROLE and GRANT DDL statements are run then in SQL*Plus. Or you can use many tools to do that: DataBee, DBArtisan, custom PERL scripts.

Let me know if you need a link to these.


Hope that helps,

clio_usa - OCP DBA
------------------

http://www.dbaclick.com

 

[spook007]

Thanks guys... I appreciate your input!

 

[bookouri]

spook007, I just wondered what you finally decided to do. Im working on doing the same thing and just ran across this link. How did you finally solve your problem?

thanks

 

[spook007]

Bookouri;

I ended up doing a full export I had spent too much time trying to figure it out and I found it faster to simply do a full export.

 

[bookouri]

ouch! I really had hoped to avoid that...

 

[sem]

Bookouri, don't be affraid of full word, because with rows=n it's quite simple task.

Regards, Dima