How To Export Your Connection Information to a File

Q

How To Export Your Connection Information to a File? - Oracle DBA FAQ - Introduction to Oracle SQL Developer

✍: FYIcenter.com

A

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>

2016-07-11, 31478👍, 1💬