Skip navigation.

Blogs

1Z0-052 Oracle DBA Admin 1 OCA Study Guide by Matthew Morris: Review

Matthew Morris (who makes many constructive and knowledgeable contributions to the forum) has written a series of study guides for the OCA/OCP exams. I asked him if I could have a copy of one to review. The result: it's very good. This is a copy of the review I put up on Amazon.

How to move a table from one schema to another

The other day, I was asked how to move a table from one schema to another. The answer, as we all know, is "you can't do that: you have to create a new table as a copy of the old one, or use export/import. It will take a long long time." Not true.

How to use Incarnation in Oracle 10G

andy huang's picture

OS:Red Hat Linux As 5
DB Version:10.2.0.4

[=16]In 9i,we open the database with resetlogs just only once when we do the incomplete recover,but in the 10g, it can open the database with resetlogs more than once,the flowing test is show how to open the database with resetlogs many times.
1.

Oracle Data Guard 11g – Overview Client Failover Configuration

Oracle Database 11g Release 2: Performance Tuning Tips and Techniques (Richard Niemiec)

I've been asked by the publishers to review "Oracle Database 11g Release 2: Performance Tuning Tips and Techniques" by Richard Niemiec of TUSC. Conclusion: it is good but not perfect. This is an extended version of the review I put up on Amazon.

R12 - XLA / FAH - Business Events in Create Accounting

vamsi kasina's picture

The following business events are disabled as default by Oracle.
For any custom process those can be enabled by users. But only extract and postprocessing events will be called in document mode.
Custom code / package can be used as a subscription to the respective business event.

oracle.apps.xla.accounting.preaccounting  - To identify the events, which will be processed by create accounting
oracle.apps.xla.accounting.extract        - To populate the transaction objects only for the events in xla_events_gt

FIne Grained Dependencies in Oracle 11g

Dependency Oracle schema is the place where all the Database objects get stored. This make a room for the entire set of objects under the Category of Data Storage ( Tables, Views) and Data Access (Stored Procedure ,Functions ,Packages and Triggers) .These Objects make a reference across all these objects to form the application.This is known as dependency.

Conventional Dependency Model If an Object B is being referrd from object A (ie Object A refers another Object B) , Object A is known as Dependant Object and Object B is Known as referenced Object.

Announcing my upcoming Book on Advanced Oracle PL/SQL Concepts (1Z0-146 Preparation handbook)

Hello,

It gives me great pleasure and honour to announce my upcoming book Oracle Advanced PL/SQL Developer Professional Guide with Pact Publishers. The book 'Oracle Advanced PL/SQL Developer Professional Guide' is focussed on the preparation of OCP (1Z0-146) examination. The book doesn't restricts its scope to the examination but aims to strengthen the advanced concepts in Oracle 11g PL/SQL.

The book has been reviewed by Oracle ACEs Kamran Agayev, Ronald Rood and Mohan Dutta. It is under production and is expected to be released by May, 2012.

Basics of Partition Tables in Oracle

Basics of Partition Tables

Partitioning is a method of splitting an object (a table or index) into separate parts (called partitions) based on some criterion that is assigned to the partition. The criterion might be a date range, a number range, or any other possible value. Imagine, for example, that you have a huge table that is driving you crazy because queries on it are really slow. You get so mad at this table that you take a logical hatchet and begin to slice the table up into many smaller tables is a partition.

Please use ANSI join syntax

The old Oracle join syntax really should be consigned to history.