Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Export Roles

Posted on 2006-06-26
1
Medium Priority
?
1,597 Views
Last Modified: 2012-06-27
Hello all,

I have two Oracle 9i servers. I have recreated everything on the backup server from the production server.

I want to recreate the roles from the production box on the backup server, how can I transfer the roles easiest?

Thanks
0
Comment
Question by:TRAININGBSC
1 Comment
 
LVL 14

Accepted Solution

by:
sathyagiri earned 375 total points
ID: 16984260
Do a full export, but with ROWS=N parameter
Find the ROLE commands in the export file using "grep" or something similar. Redirect the output to a file and use that file to create roles on your target database

Or

You could look at the source database's data dictionary views and use dynamic sql to extract and create the DDL for the ROLES.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

926 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question