Home » RDBMS Server » Backup & Recovery » help for export
help for export [message #134028] Tue, 23 August 2005 06:21 Go to next message
lucius
Messages: 1
Registered: August 2005
Junior Member
Hi all,
I have one problem:
into a server I have a db with Oracle 9.2.0.1, into my notebook I have Oracle 9.2.0.4 and I have to do a export of the DB.
When I do export, I have a message of errors because the release it's 9.2.0.4.0 it's too much high.
I cannot use the function exp on the server,so, exist one solution for this problem?


Thank you all in advance

Lucio
Re: help for export [message #134036 is a reply to message #134028] Tue, 23 August 2005 06:55 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> I have a message of errors because the release it's 9.2.0.4.0 it's too much high
Posting those erros would always be more useful.

You have not mentioned your target database and source database.
Assuming you want to copy data from server to your notebook, you
have two options.
export using the lower version and import using the lower version.
Login to server(lower version).
do an export
exp dba/pass@serverdatabase
do an import into the notebook ( create tnsconnections to talk to notebook).
imp dba/pass@notebookdatabase

or

Login to your notebook ( where you have a higher version of oracle).
Now you need to install exp views ( of this higher version) into the server, so you can export from notebook.
login as sys to notebook database.
run scrip $ORACLE_HOME/rdbms/admin/catexp.sql
Now from notebook.
exp dba/pass@serverdatabase
imp dba/pass@notebookdatabase


Previous Topic: pls help on the steps of hot and cold backup
Next Topic: Language Problem while exporting and importing data
Goto Forum:
  


Current Time: Thu Mar 28 08:52:18 CDT 2024