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