Home » RDBMS Server » Backup & Recovery » Connecting Oracle 10g Database from Oracle 8i Client for backup (Oracle 10g R2, Oracle 8.0.6)
Connecting Oracle 10g Database from Oracle 8i Client for backup [message #383683] Thu, 29 January 2009 12:53 Go to next message
bazish
Messages: 28
Registered: August 2006
Junior Member
We installed Oracle 10g R2 on Windows 2003 Enterprise Server on IBM Server Machine at our head office. In our city office we have Oracle 8i Database (8.0.6) installed, we don't need to make online entry in both but we do need some table's backup from Oracle 10g database to import into Oracle 8i database and via versa.

how can we take backup from Oracle 10g for specific tables to import into oracle 8i database?

we have one system at Headoffice containing Oracle8i Database (8.0.6), we tried to take backup of Oracle 10g from that system by using EXP utitily but it gives TNS Error.

Any solutions.????
Re: Connecting Oracle 10g Database from Oracle 8i Client for backup [message #383686 is a reply to message #383683] Thu, 29 January 2009 13:22 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>Any solutions.????
>but it gives TNS Error.
Fix the error.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you
Re: Connecting Oracle 10g Database from Oracle 8i Client for backup [message #383688 is a reply to message #383683] Thu, 29 January 2009 13:39 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't connect 10g database from a 8.0 client.
Export/unload on the database server and ftp, or use a 10g client.

Regards
Michel
Previous Topic: RMAN DUPLICATE error
Next Topic: Restore error RMAN-03015,RMAN-06026,RMAN-06023
Goto Forum:
  


Current Time: Fri Dec 09 15:54:34 CST 2016

Total time taken to generate the page: 0.29640 seconds