Use Toad to manage local databases

Using Toad to manage local databases is more intuitive and convenient than using sqlplus, and easier to operate. For some large tables, the query results are clear at a glance. In general, the following steps are required:

Step 1: Install the local database

This process is no different from general installation, but pay attention to the following two points:

1. When installing the database, "Create a startup database (with an additional 720 MB)", specify the global database name: myOrcl and Database Password ****.

2. Click "password management" during the last step of installation to specify the passwords of scott, sys, and system users, and then confirm until the installation is complete.

Step 2: Modify the tnsnames. ora File

Open the tnsnames. ora file and configure it as follows:

MYORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = ***) (PORT = 1521 ))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = myOrcl)

)

)

* *** Indicates the Host Name of the local machine.

In order to facilitate the difference, here we will give myOrcl an alias to distinguish it from other databases in the Toad database drop-down list. Therefore, the modification is as follows:

ZyhMyOracle_1 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = ***) (PORT = 1521 ))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = myOrcl)

)

)

Step 3: Open Toad and connect to the local database

In this case, you can use Toad to connect to and manage the local database.

In this case, you can see the locally created database from the database drop-down list. The alias zyhMyOracle_1 is displayed here. Pay attention to the following two points:

1. User/Schema: scott, sys, system, and other users

2. Password: Password for tiger, change_on_install, and manager

After logging on to Toad, you can manage the data table.