Solved

Export Roles

Posted on 2006-06-26
1
1,593 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 125 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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

821 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