DBA

Tasks typically handled by a database administrator, such as installation, patching, configuration, migration, security, troubleshooting, monitoring, backup, recovery.

Thumbnail image for ORA-55610: Invalid DDL statement on history-tracked table

ORA-55610: Invalid DDL statement on history-tracked table

If Oracle Total Recall is enabled on a table and want to truncate or drop the table, you are in for a problem: error “ORA-55610: Invalid DDL statement on history-tracked table”. How to work around this error.

Read the Full Article →
Thumbnail image for Oracle Total Recall for Tracking History

Oracle Total Recall for Tracking History

Most applications need an audit trail or history of changes for important entities in the database. This requirement is easily implemented with Oracle Total Recall, a tool that tracks all transactional changes to a table.

Read the Full Article →
Thumbnail image for 10 Important Lessons in Data Modeling

10 Important Lessons in Data Modeling

Follow these ten data modeling guidelines to make sure that your application database design is accurate, usable and scalable.

Read the Full Article →
Thumbnail image for The Difference between User and Schema in Oracle

The Difference between User and Schema in Oracle

As an Oracle developer, you have probably wondered at some point: do user and schema in Oracle really mean the same thing? And if they do, why does Oracle have two names for it? This post sheds light on the difference between user and schema in Oracle.

Read the Full Article →
Thumbnail image for Drop and Recreate All Foreign Keys on Oracle Table

Drop and Recreate All Foreign Keys on Oracle Table

You might need to reistate a dropped table in Oracle, and in doing so, restore the foreign keys as well. Here’s how to drop and recreate all foreign keys on an Oracle table.

Read the Full Article →
Thumbnail image for ORA-02449: Solving the DROP TABLE Dilemma

ORA-02449: Solving the DROP TABLE Dilemma

Quick workaround to error ORA-02449. When you want to drop and recreate an Oracle table, but Oracle does not let you do so due to foreign key references.

Read the Full Article →
Thumbnail image for How to Add Table Column at Specific Position

How to Add Table Column at Specific Position

In Oracle, the ALTER TABLE command to add column appends the column to the end of all existing columns. What if you want the new column at a specific position in the table, not at the end? Here’s how to add a new column at a specific position.

Read the Full Article →
Thumbnail image for Unlock Database User Account in Oracle Express Edition

Unlock Database User Account in Oracle Express Edition

Quick tip to unlock database user account in Oracle Express Edition (XE) – this is among the first things you’d need to do when you start using Oracle XE.

Read the Full Article →
Oracle Views

20 Things You Should Know About Oracle Views

This one just might fail the Duck Test. It looks like a table, acts like a table, responds to SQLs like a table – but it is NOT a table. Learn about features and best practices for dealing with Oracle views.

Read the Full Article →
Thumbnail image for What is CTAS?

What is CTAS?

When you want to base your Oracle table structure and data on an existing table, you use CTAS. Learn what that acronym means.

Read the Full Article →
Page 3 of 4
1
2
3
4