How to Create a Scheduler Job in Oracle 12c
The Oracle 12c Scheduler example here creates a simple job that runs a stored Programming Language/Structured Query Language (PL/SQL) procedure. The Read More…
Category: Oracle 12c
Compile Invalid Objects using UTLRP.SQL and UTLIRP.SQL in R12
This is a SQL script which Invalidates PL/SQL modules (procedures, functions, packages, types, triggers, views in a database). This script expects stRead More…
Basics of Automatic Memory Management in Oracle 12c
Memory management is an important component of working with instances in your database. Oracle 12c gives you three ways to manage the memory in your Read More…
12c: Plugging unplugging Database
To open database at startup manually: How did you configure your database? Did you check the option for Pluggable database? If yes, please make suRead More…
CDB Creation 12c
dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName cdb12c -sid cdb12c -createAsContainerDatabase true -numberOfPdbs 2 -pdbName pRead More…
12c: Working with Oracle Multitenant
Working with Oracle MultitenantEnvironment: Oracle Database 12c (12.1.0) Installed on Windows 7 Creating a CDB creates a service whose name is theRead More…
Adding Node To Oracle RAC Database
Summary: ============================================================== This presentation will provide detail steps for Oracle DBA and Linux EnRead More…
New features in Database 12c
Database 12c brought with it many new features. There are improvement in many areas and new concepts. Most notable is the concept of Container databRead More…
New features in Oracle Database 12c Release 1
Oracle Database 12c, c for cloud, a multi-tenant database management system, with nearly 500 new features.
Released on June 26, 2013 SQL: IncreaseRead More…