Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> migrating from 8.1.7 to 9i how to keep same user_id

migrating from 8.1.7 to 9i how to keep same user_id

From: BGT <bgt0990_at_optonline.net>
Date: 17 Jun 2005 07:31:22 -0700
Message-ID: <1119018682.648848.259990@g49g2000cwa.googlegroups.com>


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? Received on Fri Jun 17 2005 - 09:31:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US