Watch Craig Silveira (Director, Sales Engineering, EnterpriseDB Corporation) as he uses the GUI-based Migration Studio to migrate the HR demo database from Oracle Express Edition to Postgres Plus Advanced Server. After migration Craig demonstrates simple command line tools to resolve common troubleshooting issues.

Mentat Technologies announces the new minor update of DreamCoder for Oracle version 4.2.5.0.

Mentat Technologies is happy to announce the new version of DreamCoder for Oracle version 4.2, a powerful oracle database tool for administration and development.

Its flexibility and compatibility, in addition to a low price-point, make it a must-have tool for application developers who are increasingly working with oracle databases.

MySQL a liberado una intersante guia para el escalamiento y replicación de una base de datos MySQL en idioma español.

Why this script?
Most of the FK's defined in an Oracle DB, are not created using the on delete cascade option, since that is (most of the times) not wanted at all.
But sometimes records must be deleted while it is not allowed to do so, because there are child records (or a complete tree of child records) present.
For cases like that I use a script that searches the DB for child recs, using the SYS views.

When you apply Row Level Security to a table, which has constraints, like a primary key or a unique constraint, then these constraints are evealuated regardless of the RLS policy. Of course this makes sense, especially in the case of a primary key, but it can be a problem with a unique constraint.

Read the entire article at: http://bar-solutions.com/wordpress/?p=10