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

Exporting data from a server and saving dump file to client

I have an Oracle server and a client. I want to export data from the server and save the dump file in the client directly, since I do not have sufficient space on my server. Is this possible? If so how can I do it?

I have an Oracle server and a client. I want to export data from the server and save the dump file in the client directly, since I do not have sufficient space on my server. Is this possible? If so how can I do it?
On your client, you'll have to configure a TNS alias to point to your database. This involves adding lines to your client's ORACLE_HOME/network/admin/tnsnames.ora configuration file that look similar to the following:
my_db =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )
You can use the Network Configuration Assistant to update this file as well. The wizard prompts you for all of the required information. You'll need to know the database host name or IP address, the port of your Oracle listener and the service name, or ORACLE_SID of the database. You can call the TNS alias anything you want. In my example above, I called this alias "my_db". Now that the TNS alias is set up, you can connect the export utility to the database by using the "username/password@tns_alias" convention. The following is an example of exporting the entire database with the TNS alias I created above:
exp userid=system/manager@my_db file=my_db.dmp full=y

Dig Deeper on Oracle database design and architecture

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