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, 27144👍, 1💬