Search

Top 60 Oracle Blogs

Recent comments

July 2010

Announcing the Co-Operative PeopleTools Table Reference

I have created a reference to the PeopleTools tables and views on my website. 

In the course of my work on PeopleSoft, I spend a lot of time looking at the PeopleTools tables. They contain meta-data about the PeopleSoft application. Much of the application is stored in various tables that are maintained by Application Designer. Some tables provide information about the Data Model. Others contain configuration data that is maintained via PeopleTools components in the PIA.

Many of my utility scripts query information from PeopleTools tables, and some also update them. Of course, that is strictly not supported, but if you understand how the tables fit together it can be done relatively safely.  So, it is very helpful to be able to understand what is in these tables.

Installing systemtap on OEL5, update 5

Systemtap is a scripting language for analyzing linux systems. Systemtap needs debuginformation to be able to know what is going on. Systemtap is considered the “answer” to Sun/Oracle’s DTrace. Systemtap and DTrace differ, most notably because DTrace doesn’t need additional software (debug information) for both kernel and userspace. Let’s see how Systemtap can be installed [...]

World Cup, Insync10 and Coming Index Block Dumps

Well after a month of watching the World Cup during these long cold Canberra nights, my beloved Spain have finally, at long long last, after years and years of bitter disappointment and despair, have deservedly won the World Cup !! Iniesta, you legend, you will never have to buy a drink ever again, whenever or wherever you walk [...]

Writing Some Chapters in a Book

My friend Karen Morton asked if I would be willing to contribute to a book that she is working on (i.e. write a few chapters). Of course I said yes. The book’s title is Pro Oracle SQL and it is to be published by Apress sometime before the end of the year (my first deadline is fast approaching).

Karen is the lead author, but there are also several co-authors involved in this project, all of whom I have a lot of respect for. Here’s the List (in alphabetical order by last name):

Robyn Sands
Riyaj Shamsudeen
Jared Still

Don’t Knows

One of the biggest problems in learning is that you don’t know how much you don’t know, and this reises two questions: how do you find out that there are huge gaps in your knowledge that need to be filled ? how do you know whether or not the material you’re learning from is any [...]

Dropping and creating tables in read only tablespaces?!

You probably already know that it’s possible to drop tables in Oracle read only tablespaces… (You did know that already, right? ;-) Here’s a little example:
SQL> create tablespace ronly datafile '/u03/oradata/LIN112/ronly.01.dbf' size 10m;
Tablespace created.
SQL> create table test tablespace ronly as select * from all_users;
Table created.
SQL> alter tablespace ronly READ ONLY;
Tablespace altered.
SQL> drop table test;
Table dropped. I just dropped a table from a read only tablespace!

Dropping and creating tables in read only tablespaces?!

You probably already know that it’s possible to drop tables in Oracle read only tablespaces… (You did know that already, right? ;-) Here’s a little example:
SQL> create tablespace ronly datafile '/u03/oradata/LIN112/ronly.01.dbf' size 10m;
Tablespace created.
SQL> create table test tablespace ronly as select * from all_users;
Table created.
SQL> alter tablespace ronly READ ONLY;
Tablespace altered.
SQL> drop table test;
Table dropped. I just dropped a table from a read only tablespace!

Dropping and creating tables in read only tablespaces?!

You probably already know that it’s possible to drop tables in Oracle read only tablespaces… (You did know that already, right? ;-) Here’s a little example:

SQL> create tablespace ronly datafile '/u03/oradata/LIN112/ronly.01.dbf' size 10m;

Tablespace created.

SQL> create table test tablespace ronly as select * from all_users;

Table created.

SQL> alter tablespace ronly READ ONLY;

Tablespace altered.

SQL> drop table test;

Table dropped.

I just dropped a table from a read only tablespace! Well, perhaps it’s because that instead of dropping the table was put into recyclebin instead (which is a data dictionary update)? Let’s check which segments remain in the RONLY tablespace:

SQL> select owner,segment_name,segment_type from dba_segments where tablespace_name = 'RONLY';

OWNER   SEGMENT_NAME                    SEGMENT_TYPE
------- ------------------------------- ------------------
TANEL   BIN$ix7rAUXZfB3gQKjAgS4LXg==$0  TABLE

Indeed, it seems that the table segment wasn’t actually dropped. Well, let’s purge the recycle bin to try to actually drop the table segment:

Dropping and creating tables in read only tablespaces?!

You probably already know that it’s possible to drop tables in Oracle read only tablespaces… (You did know that already, right? ;-) Here’s a little example:
SQL> create tablespace ronly datafile '/u03/oradata/LIN112/ronly.01.dbf' size 10m;
Tablespace created.
SQL> create table test tablespace ronly as select * from all_users;
Table created.
SQL> alter tablespace ronly READ ONLY;
Tablespace altered.
SQL> drop table test;
Table dropped. I just dropped a table from a read only tablespace!

Dropping and creating tables in read only tablespaces?!

You probably already know that it’s possible to drop tables in Oracle read only tablespaces… (You did know that already, right? ;-) Here’s a little example:
SQL> create tablespace ronly datafile '/u03/oradata/LIN112/ronly.01.dbf' size 10m;
Tablespace created.
SQL> create table test tablespace ronly as select * from all_users;
Table created.
SQL> alter tablespace ronly READ ONLY;
Tablespace altered.
SQL> drop table test;
Table dropped. I just dropped a table from a read only tablespace!