Starting SQL*Plus and Connecting to the Database The section describes how to start SQL*Plus and connect to the database from both the command line and the Windows Start menu. For a new installation, you connect to the database using either the SYS or SYSTEM database accounts. When you enter SYS...
Taking a Tablespace Offline You may want to take a tablespace offline for any of the following reasons: ■ To make a portion of the database unavailable while still allowing access to the remainder of the database ■ To make an application and it...
To manage PDBs using DBCA: 1. Start DBCA as described in "Starting DBCA" on page 2-11. 2. In the Manage Pluggable Databases window, select one of the PDB operations and click Next. 3. In the Database List window, select the CDB in which to perform the selected PDB operation and click ...
Undo Tablespace With automatic undo management, undo data is stored in an undo tablespace. Undo tablespaces have additional properties beyond those of permanent tablespaces. There can be multiple undo tablespaces, but only one can be active fo...
Using Advisors to Optimize Database Performance Oracle Database includes a set of advisors to help you manage and tune your database. This section contains background information about these advisors and instructions for their use. The following topics are covered: ■ About Advisors ■ About the ...
Using the Oracle Suggested Backup Strategy The Oracle suggested backup strategy is a scheduled disk backup strategy that protects your data and provides efficient recoverability to any point in the user-specified recovery window (time period). It leverages the incrementally updated backup featur...
Validating Selected Backups Validating specific backups checks whether these backups exist and can be restored. It does not test whether the set of available backups meet your recoverability goals. For example, image copies of data files for several tablespaces from your database may exist, each...
Viewing Tablespace and Data File Information You can use EM Express to view configuration, size, and status information about tablespaces and data files. To view tablespace information: 1. In EM Express, from the Storage menu, select Tablespaces. The Tablespaces page
What This Guide Is Not Oracle Database 2 Day DBA is task-oriented. The objective is to describe why and when administrative tasks must be performed. Where appropriate, it describes the concepts necessary to understand and complete a task...
Creating a Database Connection A database connection is a SQL Developer object that specifies the necessary information for connecting to a specific database as a specific user of that database. You must have at least one database connection (existing, created, or imported) to use SQL Developer....
