How To Export Your Connection Information to a File in Oracle?

SQL Developer allows you to export your connection information into an XML file. Here is how to do this:

• Right-click on Connections
• Select Export Connection...
• Enter File Name as: \temp\connections.xml
• Click OK

Open \temp\connections.xml, you should see an XML message like this:

<?xml version = '1.0'?>
<!DOCTYPE connections>
<connections>
   <connection>
      <JDBC_PORT>1521</JDBC_PORT>
      <HOSTNAME>127.0.0.1</HOSTNAME>
      <ConnectionType>JDBC</ConnectionType>
      <DeployPassword>false</DeployPassword>
      <user>HR</user>
      <ConnectionName>Local_XE</ConnectionName>
      <SID>XE</SID>
      <JdbcDriver>oracle.jdbc.driver.OracleDriver
         </JdbcDriver>
      <PWD>
         <![CDATA[0519D91AA309BF15EA9E54BF55F863710496...]]>
      </PWD>
      <ORACLE_JDBC_TYPE>thin</ORACLE_JDBC_TYPE>
   </connection>
</connections>

⇒ Run SQL*Plus Commands in SQL Developer in Oracle

⇐ Run SQL Statements with SQL Developer in Oracle

⇑ Introduction to Oracle SQL Developer

⇑⇑ Oracle Database Tutorials