Re: migrating from 8.1.7 to 9i how to keep same user_id

BGT wrote:
> I've got hundreds of user_ids used in dozens of tables and we use the
> USER_ID as part of our application security and audit trail.
> I was in the habit of just moving the PWD.ORA file into a new database
> when both were 8.1.7 Will this work with different versions?
> If I migrate to 9i or 10G how can I keep the same user_id without
> haveing to go through a massive conversion of millions of records?
>

create user bla identified by values 'xxxxxxx'.

Which every full system import session will do.

-- 
Regards,
Frank van Bortel