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 -> Re: migrating from 8.1.7 to 9i how to keep same user_id

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

From: <bdbafh_at_gmail.com>
Date: 18 Jun 2005 09:18:26 -0700
Message-ID: <1119111506.274683.16710@f14g2000cwb.googlegroups.com> 





Without passing judgement on your particular problem, don't use exp/imp
to unload and reload your data into a new database. Migrate the
existing database via a scripted approach or use the database migration
assistant (gui app).



start here:


http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10763/toc.htm



make sure that your backups are in order and test before you migrate
for real.



-bdbafh
Received on Sat Jun 18 2005 - 11:18:26 CDT












Original text of this message













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