Home » RDBMS Server » Server Administration » export
export [message #59259] Thu, 06 November 2003 12:50 Go to next message
rajesh
Messages: 173
Registered: November 1998
Senior Member
hi what may the problems will
come when exporting 8i db to 9i how can we do it whether we have to set any enviroment variables
thanks in advance
rajesh
Re: export [message #59275 is a reply to message #59259] Fri, 07 November 2003 10:12 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Are you migrating the database across the same platform ?
Just export using 8i exp and import using 9i imp. Try to retain the same NLS_LANG environmental variable for both sessions..
If the database charactersets are different,make sure your 9i is a superset of 8i's set ,to avoid conversions.
Previous Topic: Oracle 8i Authentication
Next Topic: sql tunning & undo managment
Goto Forum:
  


Current Time: Fri Sep 20 08:39:40 CDT 2024