To take a tablespace offline: 1. In EM Express, from the Storage menu, select Tablespaces. The Tablespaces page appears. 2. Select the tablespace that you want to take offline. From the Actions menu, select Set Status, then Take
To view archived redo log file information: 1. In EM Express, from the Storage menu, select Archive Logs. The Archive Logs page appears. 2. View information on the Archive Logs page about the redo logs that have been archived. ...
Tools for Administering the Database The goal of this guide is to enable you to quickly and efficiently create an Oracle database, and to provide guidance in basic database administration. The following are some products, tools, and utilities you can use to achieve your goals as a database admin...
Viewing Database Storage Structure Information To assist you in managing the storage structures within your database, this section provides instructions for viewing information about the various database storage structures using EM Express. This section contains the following topics: ■ Viewing ...
Viewing Listener Configuration The Oracle Net listener (the listener) runs on your database host and handles incoming client requests. You can view the listener status at the command line. To view information about the listener at the command line: 1. Open a command window. 2. Follow the steps ...
Configuring Recovery Settings This section explains how to configure settings used for instance recovery, media recovery, and fast recovery. It includes the following topics: ■ Configuring the Fast Recovery Area ■ Enabling Archiving of Redo Lo...
Enterprise Edition—This installation type is the full-featured Oracle Database product that provides data management for enterprise-level applications. It is intended for mission-critical, high-security online transaction processing (OLTP) and data warehousing environments. ...
From an existing template Using an existing template, you can create a new template based on the predefined template settings. You can add or change any template settings such as initialization parameters, storage parameters, or whether to use custom scripts. ...
Installing and Starting SQL Developer To install and start SQL Developer, you download a ZIP file and unzip it into a desired parent directory or folder, and then type a command or double-click a file name. ...
Managing Tables The following topics discuss database tables and how to create and modify them: ■ About Tables ■ Viewing Tables ■ Viewing Table Data ■ Example: Creating a Table ■ Modifying Table Attributes ■ Example: Loading Data into a Tabl...
