-
I've got a problem migrating tables from HP-UX to AIX. We are doing the migration using export/import, however the design of the database means that userid's from dba_users in the source database are used for auditing.
A table gms_users shows the personal details for each user_id in dba_users. This table is then used to provide auditing details on any DML operations.
At the moment the user_id's on the dba_users table in the source database dont run sequentially as users have been deleted over the years.
Am I right in assuming that on import all the user_id's in dba_users will be re-assigned so the gaps will dissapear?
Is there anyway of stopping this and keeping the user_id's as they are? Otherwise all the details in gms_users will be incorrect.
Thanx in advance
Fraze
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
|