ORA-06512 at string line string Tips and Example

Filed on:January 26, 2010

Cause: Backtrace message as the stack is unwound by unhandled exceptions. This is basically to indicate where a particular error number occurred in an operation.

Filed under: Oracle Errors by admin
No Comments »

Alter system kill session in Oracle

Filed on:January 20, 2010

Alter system kill session – command in Oracle. This post explains scenarios when you may need to use this command

Filed under: Oracle DBA Scripts by admin
No Comments »

Oracle create or replace Stored Procedure example basics

Filed on:January 8, 2010

A very simple and easy to understand example of Stored procedure. An Oracle stored procedure is an Oracle object that you create using PL/SQL. PL/SQL is a procedural language which is used by Oracle developers to process and manipulate data stored in an Oracle database.

Filed under: PL/SQL Tutorial by admin
No Comments »

How to view all tablespaces and their size in an Oracle database?

Filed on:

You want to view all tablespaces and their sizees in your Oracle database? Learn a very simple query that gives you that ability.

Filed under: Oracle FAQ by admin
No Comments »

What is the function of PMON (process monitor)

Filed on:

Answer: This Oracle core process is responsible for recovering/freeing up resources when a user process fail. It cleans up the cache of the failed user process.

Filed under: Oracle FAQ by admin
No Comments »

Oracle tablespace concept and increasing size of Oracle tablespace

Filed on:

This post explains the Oracle tablespace concept and provides all the commands that you will need to administer Oracle tablespaces.

Filed under: Oracle Concept by admin
No Comments »

How to increase number of extents in an INDEX?

Filed on:

Use
ALTER INDEX schemaz.Ind_IDX1  STORAGE ( MAXEXTENTS UNLIMITED);
or
ALTER INDEX schemaz.Ind_IDX1 STORAGE ( MAXEXTENTS 700);
depending on what you need.

Filed under: Oracle FAQ by admin
No Comments »

What is the difference between TRUNCATE and DELETE?

Filed on:

Learn TRUNCATE command : TRUNCATE a table you can not rollback the data. But when you DELETE data from a table you can execute rollback to get back your deleted data (that is if you run this before you commit the transaction).

Filed under: Oracle FAQ by admin
No Comments »

How to Enable or Disable a constraint an Oracle constraint?

Filed on:

Sometime you may want to ENABLE or DISABLE a constraint for some reason. Learn here the way to do it.

Filed under: Oracle Concept, Oracle FAQ by admin
No Comments »



Similar Posts