> 文章列表 / Page 325

Materialized Views and Refresh Types This practice will familiarize you with the various features and privileges to ensure successful creation of a materialized view from a base table. 1) Grant the ne...

Event: 10231 Text: skip corrupted blocks on _table_scans_ ------------------------------------------------------------------------------- Cause: Action: Corrupt blocks are skipped in table scans, and ...

PURPOSE This document provides an example of DBMS_REPAIR as introduced in Oracle 8i. Oracle provides different methods for detecting and correcting data block corruption - DBMS_REPAIR is one option. W...

PURPOSE ------- The purpose of this article is to explain briefly the structure of the syntax to event-based trace generation. Setting an event: The structure of the trace syntax ---------------------...

Script: -- NAME: RACDIAG.SQL -- SYS OR INTERNAL USER, CATPARR.SQL ALREADY RUN, PARALLEL QUERY OPTION ON -- ------------------------------------------------------------------------ -- AUTHOR: -- Michae...

Oracle9i provides extended date and time support across different time zones with the help of new datetime data types and functions. To understand the working of these data types and functions, it is ...

This practice will demonstrate the concept of extent, wrap and shrink in rollback segment utilization. You will: Use the create rollback segment and alter rollback segment syntax. Examine the V$ROLLST...

Good network security is accomplished by utilizing port and protocol screening with routers, firewalls, and Intrusion Detection Systems.Port and protocol screening with routers, firewalls, and Intrusi...

This practice uses common UNIX and NT Oracle utilities to practice enabling AUDIT on a database. You will: See the procedure to enable and disable Oracle AUDIT on a database. Understand the SQL comman...

This practice uses common UNIX and Windows NT Oracle utilities to review database user objects’ key roles and permissions. You will: 1. See default user objects and their default passwords. 2. Underst...