Category Archives: Database

Resolved ORA-12154: TNS:could not resolve the connect identifier specified

ORA 12154 Error

This issue is faced in some versions of oracle as ORA-12154: TNS: Could not resolve service name. Mostly this issue comes in Oracle 10g and Oracle 11g Express edition which i have faced. When you or any application try to connect to an Oracle Service via Oracle Networking SQL*Net, it looks up the connect data

ORA-00600: internal error code – Fixed

ORA-00600 internal error code

In my previous articles you have learned how to fix ORA-01722: invalid number and ORA-28056: Writing audit records to Windows Event Log failed. In this article i will show you how to fix ORA-00600: internal error code. Oracle Error: ORA-00600: internal error code. How to resolve ORA-00600: internal error code? Just follow these steps to

Fixed: ORA-01722: invalid number

Ora-01722 Invalid Number

One of my friends asked me to resolve the oracle “ORA-01722: invalid number” error. He was getting this error while generating reports through an application from oracle 10g database. I suggested him the solution of this problem because I had also faced same problem few months ago. Before describing solution of this problem, it is

Fixed: ORA-28056: Writing audit records to Windows Event Log failed

Ora-28056 event log failed

Today I tried to connect with Oracle Database 11g and got ORA-28056 error. Oracle Database was installed on Windows Server 2003. I just issued the following command and got this error. START > RUN > CMD C:\>sqlplus /nolog SQL*Plus: Release 11.2.0.2.0 Production on Fri Jan 23 13:40:09 2014 Copyright (c) 1982, 2010, Oracle.  All rights

Create a Table from another Table in Oracle SQL

create a table

In my previous article, you have seen how to create a Table and Global Temporary Table in Oracle. In this article, you will learn how to create a table from another table. 1) How to create a Table from an Existing Table? 2) How to create a Table from an Existing Table with filtered data?

Create Normal Table and Global Temporary Table in Oracle

create table

We can create two types of Table in Oracle. 1) Normal Table (CREATE TABLE Command) 2) Global Temporary Table (CREATE GLOBAL TEMPORARY TABLE Command) How to create a Normal Table in Oracle? The create table command allows you to create normal table in Oracle. The syntax of CREATE TABLE command is as follows: CREATE TABLE

Alter Table Command in Oracle SQL

alter table command

The ALTER TABLE command allows you to rename an existing Oracle table to a new table. The same command can also be used to add, modify, or drop a column from an existing Oracle table. How to Alter a Table in Oracle? Syntax to rename a table: ALTER TABLE <table-name> RENAME TO <new-table-name>; Example: Suppose

Fixed – ORA-19809: limit exceeded for recovery files

ORA-19809 limit exceeded

When you try to connect with Oracle Database and it throws an error message ORA-19809: limit exceeded for recovery files. It means archive destination (db_recovery_file_dest) has been full. Following error will appear in the alert log file if you try to shutdown a database or switch a log file: ORACLE Instance flash – Archival Error

Siteground SALE
60% OFF SiteGround WordPress Hosting – $3.95/month (Exclusive Offer !!!)