Switching a Log File When a log switch occurs, the log writer (LGWR) process stops writing to the current online redo log group and starts writing to the next available redo log group. After a log switch, the current online redo log group becomes inactive, and the next available online redo log ...
Switching Undo Tablespaces You can switch from one undo tablespace to another. To switch the undo tablespace: 1. Go to the Undo Management Details page, as described in "Viewing Undo Information" on page 6-20. 2.
SYS and SYSTEM Users The following administrative user accounts are automatically created when you install Oracle Database. They are both created with the password that you supplied upon installation, and they are both automatically gran...
SYSDBA and SYSOPER System Privileges SYSDBA and SYSOPER are administrative privileges required to perform high-level administrative operations such as creating, starting up, shutting down, backing up, or recovering the database. The SYSDBA system privilege is for fully empowered database adminis...
System Global Area The System Global Area (SGA) is a group of shared memory structures, known as SGA components, that contain data and control information for one Oracle Database instance. The SGA is shared by all server and background p...
Tablespace Status You can set tablespace status as follows: ■ Read Write Users can read and write to the tablespace after it is created. This is the default. ■ Read Only If the tablespace is created Read Only, then the tablespace cannot be written to until its status is changed to Read Write. ...
Tablespace Types There are three types of tablespaces: ■ Permanent You use permanent tablespaces to store your user and application data. Oracle Database uses permanent tablespaces to store permanent data, such as system data. Each user is a...
Test the new KING_VIEW view: 1. In the Connections navigator, navigate to the Views node in the HR schema and find the KING_VIEW, by following the instructions in "Displaying Views" on page 8-25. Managing Program Code Stored in the Database Managing Schema Objects 8-27 2.
Testing the Backup Script It is recommend that you run the script manually, to check for errors, before scheduling it. Your manual run of the script will start day one of the strategy, creating an incremental level 0 image copy of all datafiles. ...
The DDL Tab You can create and manipulate schema objects with SQL or with SQL Developer. When creating schema objects using SQL Developer, you can click the DDL tab to display the SQL statement that is the equivalent of the schema object properties that you specified with the graphical user inte...
