Technical Articles

Technical Oracle Articles

Can you create objects in a READ ONLY tablespace?

Hi Oracle geeks,

Last Friday, I’ve noticed a strange thing happening in my Database: I’m able to create objects in a tablespace which is marked READ ONLY !!!

Don’t believe this?? See the below

SQL> create tablespace ro datafile ‘/xxx/RO.DBF’ size 10M AUTOEXTEND ON;
Tablespace created.

SQL> alter tablespace ro read only;
Tablespace altered.

SQL> select status from dba_tablespaces where tablespace_name=’RO’;

SQL> sho user

andy huang's picture

How to use Incarnation in Oracle 10G

OS:Red Hat Linux As 5
DB Version:

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.

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.

Basics of Partition Tables in Oracle

Basics of Partition Tables

Common ORA errors

Below are some ORA-ERROR which every DBA face:

1. ORA-00600/ORA-07445
Clause: Most likely it is related to bug
Solution: go to metalink and apply patch set.

2. ORA-03113
Clause: It is generic error means lots of reason behind this.
Solution: Depends on condition but best way to search on google/forms.

3. ORA-04031
Clause: Mis-configuration of SGA, insufficient memory
Solution: Sametime need to add memory on system, or sametime need to reduce SGA memory Database Certified with E-Business Suite

Oracle, the second patch set for the 11gR2 database, is now certified with with E-Business Suite and is available for download in 32 and 64-bit.

You can download it from only your meta link account credential.

Patch No: 10404530

Oracle E-Business Suite Release 11i


* + ATG PF.H RUP 6 and higher

Certified Platforms

Partition Exchange by Example

One of the great features about partitioning, and most specifically range-based partitioning, is the ability to load data quickly and easily with minimal impact on the current users using:

alter table call exchange partition data_2007 with table call_temp;

dwaipayan19861's picture

Playing with Oracle Lobs

LOBs deal with unstructured data, the ones which are the most difficult to store and retrieve in a relational database.

In this article, I am going to discuss extensively and manipulate the ORACLE

* LOBs that are stored in the database itself like BLOB,CLOB,NCLOB ,and

* LOBs like BFILE which are Stored outside the database as Operating System files.

First let us create a directory :

create or replace directory my_dir as 'D:\pics';
Directory created.

Advance BI Publisher Concepts - Sorting in RTF Template

I am sharing a nice article on RTF template design written by one of our senior consultant Mr. Venkat from Adiva Consulting.

The objective of this post is to explain the “sorting” capabilities available in the RTF. Many might
already be aware of the standard BI Publisher syntax for sorting in the RTF template:


Subscribe to RSS - Technical Articles