|
-
I agree that the export/import should work. Just a reminder that the export utility does NOT export data from the SYS or SYSTEM schemas (even if you do a FULL export). Therefore, the roles, privileges and users you have defined will not be part of your export. You can generate the role/privilege/user create scripts by querying the original database, then execute them against your target before you do your import. The plus doing it this way (rather than recreating from scratch) is that your users will not have to reset their database passwords (assuming their not "identified externally").
Tim
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|