| Oracle Export problem [message #63724] |
Tue, 02 November 2004 01:32  |
G.R.KISHNAKUMAR
Messages: 2
Registered: June 2004
|
Junior Member |
|
|
Iam having two machines-
1. Oracle 9i on Linux Redhat
2. Oracle 8i on Unixware7
I want to export a user present in the Oracle 8i database to the machine having Oracle 9i installed in it. Iam doing this because I don't have sufficient space in the Oracle 8i machine to accomodate the export file of that user. However Iam unable to export from Oracle 9i machine. Iam getting certain errors with 'ALTER SESSION...' or with the service.
I need to know if it's possible to do it. How to do it?
|
|
|
|
| Re: Oracle Export problem [message #63725 is a reply to message #63724] |
Tue, 02 November 2004 02:17  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
When there is a difference in the version realease, you have to do the export and import from the lower version.
else if you want to the other way,
You need to install the export / import views in the lower version.
In the host that has 9i create tnsentries to talk to the 8i database in other host.
from 9i machine
logged in as sys in sqlplus run the script
$ORACLE_HOME/rdbms/admin/catexp.sql
the from 9i machine do an export of 8i database to the local filesystem.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
