Parameters Used in Command Line

Host

The name or IP address of the Oracle Server host to which to connect. Direct mode only.

Port

Specify Oracle Server connection port; default value is 1521. Direct mode only.

Server

Set the name of the Oracle database to which to connect. Not available in the direct mode.

Service Name

Specify an alias to an Oracle database instance (or many instances). Direct mode only.

SID

Specify a unique name for an Oracle database instance. Direct mode only.

Note

The Service Name parameter can be used instead of SID.

User Id

The name of the user account on the Oracle server. The default Oracle user is scott.

Password

The password of the user account on the Oracle Server.

Connect Mode

Specify how you want to connect to the Oracle server. This parameter is set to Normal by default. dbForge Studio for Oracle allows you to connect to SYSDBA and SYSOPER administrative privileges selecting SYSDBA or SYSOPER options.

Home

Select an Oracle client to be used. Not available in the direct mode.

Direct

Select to connect to the Oracle server by the direct mode.

Unicode

Gets or sets a value indicating whether the UTF8 character set will be used.

Pooling

Gets or sets pooling mode.

Transaction Scope Local

Enables support for non-distributed transactions in the Transaction Scope implementation.

Enlist

Gets or sets a Boolean value that indicates whether the connection is automatically enlisted in the current transaction context.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for Oracle.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for Oracle?