To create a database using DBCA: 1. Start DBCA as described in "Starting DBCA" on page 2-11. 2. In the Database Operation window, select Create Database and click Next to start the guided workflow for creating a database. If you then ...
To create a description index on the SH.PRODUCTS table: 1. View the tables in the SH schema, by following the instructions in "Viewing Tables" on page 8-10. 2. Right-click the PRODUCTS table, and select Index, and then Create Index. The Create Index dialog box
To determine if a datafile can be restored to a specified SCN: RESTORE DATAFILE 1 VALIDATE UNTIL SCN 23456; Starting restore at 29-MAR-12 using channel ORA_DISK_1 channel ORA_DISK_1: starting validation of datafile backup set channel ORA_DISK_1: reading from backup piece /ade/b/191802369/oracl...
To determine if a specified tablespace can be restored: RESTORE TABLESPACE example VALIDATE; Starting restore at 29-MAR-12 using channel ORA_DISK_1 channel ORA_DISK_1: starting validation of datafile backup set channel ORA_DISK_1: reading from backup piece /ade/b/191802369/oracle/work/orcva/RD...
To grant the SYSBACKUP privilege to an existing user: 1. Log into EM Express as user SYS. Be sure to select the as sysdba check box on the Login page. See "Accessing the Database Home Page" on page 3-6. 2. From the Security menu, select Users. 3. On the Users page, click the name of t...
To manually configure the HTTPS port for EM Express: 1. Configure and start the Oracle Net Listener (the listener). You can use lsnrctl to start, stop, and view the status of the listener. 2. If the listener is running on a nonstandard port (for example, not 1521), then the init.ora file for the...
To modify the instance PGA size: 1. In EM Express, from the Configuration menu, select Memory. The Memory Management page appears. If the database has either automatic shared memory management o...
To perform a basic installation: 1. Log on to your computer as a member of the administrative group that is authorized to install Oracle Database software and to create and run the database. Refer to your operating system-specific documentation or contact your system administrator to determine w...
To perform a whole database backup when the database is open: 1. Connect RMAN to the target database as described in "Connecting to the Target Database" on page 9-9. 2. Ensure that your database is in ARCHIVELOG mode as described in "Enabling Archiving of Redo Log Files" on p...
To perform the Flashback Table operation: 1. Connect RMAN to the target database as described in "Connecting to the Target Database" on page 9-9. 2. Determine whether the table that you intend to flash back has dependencies on other tables. Use the following SQL query to determine the...
