Archive for the 'Partitioning' Category

Which indexes on partitioned tables did i forgot to make local?

March 26th, 2008

SELECT table_name
,index_name
FROM user_indexes
WHERE _name IN (SELECT table_name FROM user_part_tables)
AND      partitioned = ‘NO’

(when having ORA-14075 then this little querie might help you find those global indexes on partitioned tables)

Filed under:  Database, Partitioning | No Comments

Partitioning based on a virtual column.

March 11th, 2008

Lets see here a very cool example of something virtual that really DOES work!
In Oracle Database 11g, a new feature called Virtual Columns allows you to create a column that is not stored in the table but rather is computed at run time.
That is already cool, but what is even more fun is that you [...]

Filed under:  Database, Oracle 11g, Partitioning | No Comments