Data Dictionary

Read-only reference tables and views for Oracle database metadata. Oracle’s data dictionary includes definitions of schema objects, tablespace and auditing information, etc. Most data dictionary views come in three flavors distinguished by their prefixes: DBA, ALL and USER.

Thumbnail image for Find Which Objects are INVALID in Oracle – and Why

Find Which Objects are INVALID in Oracle – and Why

Oracle objects become invalid when a dependency chain is broken. Here’s how to find invalid Oracle objects and how to make them valid again.

Read the Full Article →
Thumbnail image for Running Procedures Asynchronously with Oracle Job Scheduler

Running Procedures Asynchronously with Oracle Job Scheduler

Oracle PL/SQL provides the ability to run procedures asynchronously using Oracle job scheduler DBMS_SCHEDULER. Here’s how to create and run such jobs.

Read the Full Article →
DBMS_REDEFINITION for online table redefinition

DBMS_REDEFINITION: Convert Non-Partitioned Table to Partitioned [pre 12.2]

Partitioning a non-partitioned table in an Oracle pre-12.2 database, using DBMS_REDEFINITION built-in methods. Scripts and demo.

Read the Full Article →
Thumbnail image for In Which Package Is This Procedure Placed?

In Which Package Is This Procedure Placed?

Given that a stored procedure (whose name you know) sits in *some* PL/SQL package in the database, how will you find out the package in which the procedure is placed?

Read the Full Article →
Proxy authentication in Oracle

Proxy User Authentication in Oracle

Proxy user authentication in Oracle provides an effective way to manage both security and ease of setup, especially useful in a multi-user work environment.

Read the Full Article →
Check if JVM is Installed in Oracle

How to Check if JVM is Installed in Oracle

Creating Java source in Oracle gives an ORA error? Check if JVM is installed and valid in the Oracle database, this way.

Read the Full Article →
Thumbnail image for Oracle Partitioning: Range Interval Partitioning

Oracle Partitioning: Range Interval Partitioning

Create Oracle table partitions on-the-fly using range interval partitioning, a beautiful Oracle partitioning feature that obviates the need to pre-create database table partitions.

Read the Full Article →
Thumbnail image for How to Find out Your Oracle Database Version

How to Find out Your Oracle Database Version

Three ways to find out your Oracle database version in SQL and PL/SQL: using V$VERSION, V$INSTANCE, or DBMS_DB_VERSION constants.

Read the Full Article →
Thumbnail image for Find Number of Rows in Each Table in a Schema

Find Number of Rows in Each Table in a Schema

Ways to find out the number of rows in each table in a schema in Oracle – one via data dictionary lookup, the other via dynamic SQL.

Read the Full Article →
Thumbnail image for How to Delete Old Data from a Database Schema

How to Delete Old Data from a Database Schema

DELETE script or CTAS DROP-RENAME script: ways to purge old data from a database schema so that it retains only the current year’s rows in all the tables in the schema, and the rest of the data is erased.

Read the Full Article →
Page 1 of 2
1
2