Q
Problem solve Get help with specific problems with your technologies, process and projects.

Exporting tables to the main server

How can I export the tables in Oracle 8.0.3.0.0 so that I can copy the tables with data from different nodes to the main server?

How can I export the tables in Oracle 8.0.3.0.0 so that I can copy the tables with data from different nodes to the main server?
By different nodes, do you mean RAC nodes, or remote databases? In either case, you can use the exp utility with a "where" clause to gather specific rows, like this:
     exp scott/tiger tables=emp query="where job='SALESMAN' and sal<1600"
I would recommend Dave Moore's book "Oracle Utilities" for complete details on the nuances of Oracle export.

Here are my notes on using exp:

http://www.remote-dba.net/teas_rem_util8.htm

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close