Answers

Question and Answer:

  Home  Oracle Database

⟩ How To Export Your Connection Information to a File?

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: empconnections.xml

► Click OK

Open empconnections.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>

 209 views

More Questions for you: