Creation Options In this window, select any of the following options for creating the database: ■ Create Database—Select this option to create your database now. ■ Save as a Database Template—Select this option to save the database definition as a template to use at a later time. ■ Generate Dat...
Database Credentials In this window, specify the passwords for the administrative accounts such as SYS, SYSMAN, and DBSNMP. On Microsoft Windows operating systems only: If during the installation you specified a non-administrator, low privileged Windows User Account as Oracle Home User, you are...
Deciding on Installation Choices Oracle Universal Installer guides you through an interview phase where you specify your choices for installation and database creation. The exact sequence of steps depends on your operating system. As you progress through the installation, you are presented with ...
Dedicated Server Mode—This mode allows a dedicated server process for each user process. Select this option when the number of total clients is expected to be small, for example, 50 or fewer. You might also choose this option when database clients typically make persistent, long-running requests ...
Initialization Parameter File Initialization parameters are used by the Oracle instance at startup to determine the run-time properties and resources for the database. Some parameters can be set or modified while the database is running. Other initialization parameters require the database to be...
Initialization Parameters The links in this window provide access to additional windows that enable you to change the default initialization parameter settings. These parameters fall into the following categories: ■ Memory ■ Sizing ■ Character
Large object (LOB) columns are used to contain unstructured data (such as text or streaming video), and can hold terabytes of information. To create a LOB column using SQL Developer, click the Advanced checkbox when creating a table. Then click LOB Parameters to see the options available when cre...
Managing Program Code Stored in the Database This section describes your responsibilities as a database administrator (DBA) for program code that is stored in the database. It contains the following topics: ■ About Program Code Stored in the Database ■ Validating (Compiling) Invalid Schema Objec...
Managing Schema Objects This chapter discusses the creation and management of schema objects. It contains the following sections: ■ About Schema Objects ■ About Schema Object Management Privileges ■ About SQL Developer ■ Managing Tables ■ Managing Indexes ■ Managing Views ■ Managing Program...
Managing the Oracle Instance This chapter provides background information about the Oracle instance and instructions for managing the instance. This chapter contains the following sections: ■ Overview of the Oracle Instance and Instance Management ■ Shutting Down and Starting Up the Oracle Inst...
