Oracle和MySQL - 博客园

DBMS_REPAIR example

摘要： 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... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(359) 评论(0) 推荐(0)

Materialized Views and Dimensions

摘要： Materialized Views and Refresh TypesThis 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 nece... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(214) 评论(0) 推荐(0)

Function Based Indexes and Global Temporary Tables

摘要： A nonunique index can be used to enforce a primary key or unique constraint.In Oracle8i indexes can be rebuilt without locking the table.The DROP COLUMN option of the ALTER TABLE command is restartabl... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(159) 评论(0) 推荐(0)

Known Oracle Internal Stack Call Meaning

摘要： ksedmp # KSE: dump the process state ksfdmp # Call relevant dump routine kgeasi # Raise an error on an ASSERTION failure (IGNORE) ktcrab KTC: Kernel Tr... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(205) 评论(0) 推荐(0)

Practice:Demonstrating the Key TCP/IP Protocols

摘要： This practice uses common UNIX and Windows NT utilities to visualize key TCP/IP protocols. You will: See IP information using the IPCONFIG utility. Understand and overcome IP fault situations using t... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(135) 评论(0) 推荐(0)

Practice:Demonstrating Database User Objects, Roles and Permissions

摘要： 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.... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(173) 评论(0) 推荐(0)

Practice:Demonstrating Oracle AUDIT Concepts and Procedures

摘要： 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 comma... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(170) 评论(0) 推荐(0)

EVENT:10228 trace application of redo by kcocbk

摘要： Error: ORA 10228Text: trace application of redo by kcocbk-------------------------------------------------------------------------------Explanation: This is NOT an error but is a special EVE... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(140) 评论(0) 推荐(0)

EVENT:10212 check cluster integrity

摘要： Error: ORA 10212Text: check cluster integrity-------------------------------------------------------------------------------Explanation: This is NOT an error but is a special EVENT code. ... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(198) 评论(0) 推荐(0)

Know Oracle Date And Time Function

摘要： 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 ... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(364) 评论(0) 推荐(0)