1. User's Guide
  2. Using Oracle SQLcl
  3. Managing Stored Connections
  4. Import Connections

2.5.4 Import Connections

Connections are imported from the path specified. The path should point to a JSON file containing connections exported from SQL Developer. By default, connections with the same name as an existing connection are ignored. To change this behavior, the -DUPLICATES option can be used.

Syntax

connmgr|cm import {OPTIONS} {PARAMETERS}

Options

Option Description
-duplicates

{ignore|rename|replace}

Indicates how to handle imported connections whose names match an existing connection.

  • IGNORE: Skips the duplicate connections.
  • RENAME: Renames the duplicate connections by appending a unique number to the end of the name.
  • REPLACE: Replaces the existing connection with the new connection.

Parameters

Parameter Description
<path> A single file or directory containing one or more connections to import. If the path is an archive file, the archive is checked for a single connection definition. If the path is a JSON file, it is checked for legacy connection definitions. If the path is a directory, it is checked for more archives containing connection definitons.

Example

To import a connection:

SQL> CONNMGR IMPORT -DUPLICATES REPLACE mywallet.zip