Submitted by John Watson on Thu, 2012-07-12 06:38
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.
Submitted by andy huang on Wed, 2012-06-06 09:05
OS:Red Hat Linux As 5
Submitted by mahir.quluzade on Tue, 2012-06-05 05:25
Submitted by John Watson on Tue, 2012-05-15 03:26
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.
Submitted by vamsi kasina on Wed, 2012-05-09 17:42
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
Submitted by mohan_krishnan83 on Sat, 2012-04-14 10:31
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.
Submitted by girish.rohini on Wed, 2012-04-11 09:43
DB Version: 10.2.0.4
Users: TESTUSR (Table Owner)
TESTUSR_PKG (Package Onwer)
TESTUSR_APP (Application Owner)
create table test_tbl(a number);
Submitted by sbh_orafaq on Wed, 2012-04-11 01:52
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.
Submitted by giteshtrivedi on Tue, 2012-01-17 23:55
Basics of Partition Tables
Submitted by John Watson on Sun, 2012-01-01 06:41
The old Oracle join syntax really should be consigned to history.