Viewing Indexes You use SQL Developer to view the indexes in your database. To view indexes: 1. In the Connections navigator, navigate to the Indexes node for the schema that includes the index you want to view. If the index is in your own schema, navigate to the Indexes node in your schema. I...
Viewing Online Redo Log File Information You can use EM Express to view status and multiplexing information about online redo log files. To view online redo log file information: 1. In EM Express, from the Storage menu, select Redo Log Groups. ...
Viewing Roles You view roles on the Roles page of EM Express. To view roles: 1. Log into EM Express with a user account that has privileges to manage roles. An example of such a user account is SYSTEM. 2. From the Security menu, select Roles. The Roles page
Viewing Table Data Besides viewing table names and table definitions, you can view the data stored in the table, and the SQL statement used to display the data. You can also change the SQL statement to alter the results set. To view table data: 1. Search for a table as described in "Viewin...
Viewing Tables You can use SQL Developer to list all the tables in a specified schema, and to view the definitions of individual tables. To view tables: 1. In the Connections navigator, navigate to the Tables node for the schema that includes the table you want to display. If the view is in yo...
Viewing Undo Information You can use the Undo Management Details page to view the following information about your undo configuration: See Also: ■ Oracle Database Concepts for more inf...
Viewing User Accounts You view user accounts on the Users page of EM Express. To view users: 1. Log into EM Express with a user account that has privileges to manage users, for example, SYSTEM. 2. From the Security menu, select Users. The Users page
Working with Other Schema Objects You can manage other schema objects with SQL Developer, including the following: ■ Sequences A sequence is a database object that generates unique integers. Each time that you query the sequence, it increments its current value by a designated amount and return...
Scheduling Miscellaneous Backup Tasks In addition to implementing the Oracle suggested backup strategy described in "Using the Oracle Suggested Backup Strategy" on page 9-19, you can use customized backup Note: Supply the desired e-mail address in the MAILTO line. This line is optional...
Scheduling the Daily Backup—UNIX and Linux The following procedure uses the cron utility to schedule daily database backups at 2:00 a.m. To schedule the Oracle-suggested disk backup strategy: 1. Ensure that you are logged in to the database host as a user who is a member of the OSBACKUPDBA opera...
