Redo Log Group Editor
Use the Redo Log Editor to view, create, or alter Redo Logs.
|
About Redo Logs |
Every Oracle database has a set of two or more redo log files, collectively known as the database's redo log. Oracle uses the redo log to record all changes made to data. The characteristics and usage of this database object are described in Oracle documentation. |
Ways to Open The Redo Log Group Editor
| Icon | Action | Description |
|---|---|---|
| |
From the Main Menu View Menu | Visual Object Editors | Redo Log Group Editor |
Open the Redo Log Group Editor. |
 |
From DB Navigator Right click on a Redo Log Group object and click Open. |
Open the selected Redo Log Group object in the Redo Log Group Editor. |
Role Editor
Use the Role Editor to view or create roles.
|
About Roles |
A Role is a set of privileges that can be assigned to or removed from a user. (Use the User Editor to create and grant or revoke roles and privileges to users.) The characteristics and usage of this database object are described in Oracle documentation. |
Requirements
To edit roles:
- You must have the CREATE ROLE system privilege.
-
Query the Oracle Data Dictionary with DBA Views. For more information, see DBA Dictionary Views.
Ways to Open The Role Editor
| Icon | Action | Description |
|---|---|---|
| |
From the Main Menu View Menu | Visual Object Editors | Role Editor |
Open the Role Editor. |
| |
From DB Navigator Right click on a Role object and click Open. |
Open the selected Role object in the Role Editor. |
Materialized View Editor
Use the Materialized (Snapshot) View Editor to view, create or define snapshots.
| About Snapshots | A snapshot is a segment that contains the result of a query. The snapshot typically contains local copies of remote objects. From Oracle 8i onwards a materialized view is equivalent to a snapshot but allows queries to be dynamically and transparently rewritten to use the materialized view. |
Using The Editor
Editor Toolbar
| Icon | Tool Tip | Description | ||||||
|---|---|---|---|---|---|---|---|---|
 |
Create new Materialized view |
Open the New Materialized View dialog.
| ||||||
 |
Open object from DB |
Open the Select Materialized View dialog. Select the materialized view from the database. | ||||||
 |
Clone current Materialized view | Create a clone of the selected materialized view. You will be prompted in the New Materialized View dialog to enter new name. | ||||||
 |
Revert to pervious Materialized view | Undo or revert any modifications made to the view. | ||||||
 |
Generate SQL for changes | Generate SQL code for the changes made. | ||||||
 |
Apply changes to DB | Apply changes to the database. |
Editor Tabs
| Tab | Description |
|---|---|
|
Details |
|
|
Refresh |
|
|
Storage |
|
|
Master Info |
Display the owner, table and links for the materialized view (after the materialized view has been saved). |
Ways to Open The Materialized View Editor
| Icon | Action | Description |
|---|---|---|
| |
From the Main Menu View Menu | Visual Object Editors | Materialized View Editor |
Open the Materialized View Editor. |
| |
From DB Navigator or Find objects Dialog Right click on a Materialized View object and click Open. |
Open the selected Materialized View object in the Materialized View Editor. |
Sequence Editor
Use the Sequence Editor to view, create, or alter sequences.
|
About Sequence Objects |
A sequence is an Oracle object that delivers a unique number, incremented by some specified amount, every time it is requested. Sequences are usually used to generate a primary key for a table or for a set of tables. You can use the sequence to create unique number that you can use in your tables as primary identifiers. The characteristics and usage of this database object are described in Oracle documentation. |
Ways to Open The Sequence Editor
| Icon | Action | Description |
|---|---|---|
| |
From the Main Menu View Menu | Visual Object Editors | Sequence Editor |
Open the Sequence Editor. |
| |
From DB Navigator or Find objects Dialog Right click on a Sequence object and click Open. |
Open the selected object in the Sequence Editor. |