Blog Blog 齋

The real name of the exam is “Oracle E-Business Suite R12: Install, Patch and Maintain Applications“, and the certificate is called “Oracle EBS R12 Applications Database Administrator Certified Professional“. What long names!!

If you were looking for “brain dumps”, you came to a wrong page. There will be no sample questions / answers here. Instead, these are tips based-on the self-study for the exam. 

(閱讀全文)

The book was divided into 4 parts, tackling 4 areas of Oracle tuning:”Data Model”, “SQL Code”, “Physical and Configuration” and “Database Statistics”. Personally, I would think the book has two main parts: application-level (part 1-2) and system-level (part 3-4).

When I read the application-level parts, I thought this is definitely one of the worst Oracle book I've seen. Actually, it is very likely the worst computer-related book in the universe. The book is filled with misconceptions, false facts and over-simplifications. If I were not intended to write this review, I would have given up reading it after at most 6 chapters. It seemed I was proof-reading the book. Fortunately I didn't buy the book, but borrowed it from the library.

(閱讀全文)

Don't be silly… You still need to install something. But not in Windows.

This article discuss how to run a virtual machine on a windows machine under a Linux LiveCD, using a virtualization software like VMWare or VirtualBox. As a result, it is possible to do whatever you want in the virtual machine, including run Oracle. Perfect when you are not allowed (or not preferred) to install something in your windows, but allowed reboot with CD and create some huge files.

(閱讀全文)

Q: You have a table storing the materials and another table storing the consumer requests on the materials. Materials are stored in different batches, each containing a different quantity of stock. Both the material and consumer tables have a sequence field, indicating which material is to be consumed first and which request is to be served first respectively. You need to allocate the material to the consumers, allocating enough quantity. For example:

Material Table

Record ID	Material ID	Ordering	Stock
RM1	M1	1	25
RM2	M1	2	15
RM3	M1	3	15
RM4	M1	4	35
RM5	M2	1	5
RM6	M2	2	35

Consumer Table

Record ID	Material ID	Ordering	Requested Qty
RC1	M1	1	30
RC2	M1	2	50
RC3	M2	1	10
RC4	M2	2	20
RC5	M1	3	10
RC6	M1	4	20

Expected Output

				Reference Matching Quantities
Material ID	Material Record ID	Consumer Record ID	Allocated Qty	Stock	Requested Qty
M1	RM1	RC1	25	25	30
M1	RM2	RC1	5	15	30
M1	RM2	RC2	10	15	50
M1	RM3	RC2	15	15	50
M1	RM4	RC2	25	35	50
M1	RM4	RC5	10	35	10
M1	–	RC6	Unallocated due to no stock		10
M2	RM5	RC3	5	5	10
M2	RM6	RC3	5	35	10
M2	RM6	RC4	20	35	20

(閱讀全文)

Summary:

Although dbca (Database Configuration Assistant) in Oracle 11g allow you to enable Database Vault during database creation. It seems to missed something and leave the database barely usable. This document discuss what's wrong and how to remedy (in my case).

(閱讀全文)

This article describes the Database Duplication feature of Oracle 10g. The article will first describe the database duplication in detail. Afterwards, issues specific on Windows will be discussed and addressed.

The article is based on the following environment:

Source Database:

• Windows XP
• Oracle 10g XE
• Oracle Installation in D:\oraclexe

Destination Database:

• Windows XP
• Oracle 10g XE
• Oracle Installation in C:\oraclexe 

(閱讀全文)

DUAL is an interesting table in Oracle. You use it to do dirty work, like obtaining the SYSDATE, or doing some calculation when you lose your calculator. There is only one row, and no one care what is stored in the row. It is more funny if you are a Chinese, because it sounds like a foul word in Chinese.

Undoubtedly, you have doubt about what will happen if DUAL has more or fewer (i.e., 0) rows. What if it is dropped, and how about recreating it?

Let's try various DML and DDL statements with DUAL…

(I know no one will follow this document, but if you want to try the experiment below, make sure to ensure you have a usable backup of the database.)

(閱讀全文)