- Open Oracle SQL Developer.
- In the Connections tab on the left-hand side, right-click Connections and select New Connection.
- In the New / Select Database Connection dialog box, enter the Connection Name. For example, to connect to Model schema, enter MODEL. (This value must be similar to the name of schema given in the ‘config.txt’ file)
- Enter the schema username and password in the Username and Password fields respectively. For example, for Model schema, enter MODEL / MODEL (These values must be similar to the values given in the ‘config.txt’ file)
- Ensure the correct Hostname, Port, and SID are given in the respective fields.
- Click Test. If the credentials are correct the connection to the schema will be successful.
- Click Connect.
- After schema connection is established, check if you are able to view the schemas contents.
|
