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.