9

In SQL Developer, there is no command to create a connection based on an existing connection, and just change some of the connection attributes, like the username and password. Edit->Copy is disabled. So how can this be done?

1 Answer 1

25
  1. Click the green + button in the Connections tab.
  2. Select the connection to duplicate
  3. Simply edit the name of the connection. If you follow the steps below, this will not rename the connection, but will create a new one.
  4. Edit the other connection parameters as required.
  5. Click Test, and check for a Success message subtly hidden near the bottom left corner of the dialog box.
  6. Click Connect

Your new connection will now be connected. It's not very intuitive, but it works.

Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.