Database-Oracle [Introduction to Oracle system utilities]

1. Application Development)

SQL * Plus E: \ oracle \ ora81 \ bin \ sqlplusw. exe

2. database administration)

Database Configuration assistant database configuration ASSISTANT: Create, configure, and delete Databases

DBA studio integrates multiple database tools into one applicationProgram. DBA studio manages the following objects:

Examples: including startup, shutdown, and routine routines.

Solution: includes tables, indexes, and oracle8 objects.

Security: includes user accounts, roles, and permissions.

Storage space: Includes tablespaces, data files, and rollback segments.

Sqlplus worksheet SQL * Plus Tool

E: \ oracle \ ora81 \ bin \ oemapp. Bat Worksheet

3. Enterprise Manager)

Configuration assistant Oracle Enterprise Manager Configuration auxiliary tools to manage the server Archives

Console logon to the OEM Manager (Oracle Enterprise Manager)

4. Migration tool (Migration utilities)

Oracle data migration Assistant Port oracle7 database and upgrade oracle8 to Oracle8i

5. Network Administration)

Net8 assistant network configuration section (connection description tnsnames. ora, listener. ora)

The net8 configuration assistant function is similar to the preceding one. It provides basic configurations. For advanced configuration operations, or for details about configuring other parts of net8 not included in this tool, use net8 assistant Oracle ODBC test to connect to and test Oracle ODBC

6. DOS window utilities

Svrmgrl ORACLE Server Management: Oracle Server Manager

E: \ oracle \ ora81 \ bin \ svrmgrl. exe

SQL * Plus used in the SQL * Plus DOS window

E: \ oracle \ ora81 \ bin \ sqlplus. exe

LSNRCTL listener Management Program

E: \ oracle \ ora81 \ bin \ LSNRCTL. exe

EXP/IMP logical backup and recovery tools

E: \ oracle \ ora81 \ bin \ exp. EXE, E: \ oracle \ ora81 \ bin \ imp. exe

SQL * loader large data insertion Tool

E: \ oracle \ ora81 \ bin \ sqlldr. exe

Orapwd tool for changing sys or internal passwords

E: \ oracle \ ora81 \ bin \ orapwd. exe

Ocopy Oracle copy Tool

E: \ oracle \ ora81 \ bin \ ocopy. exe