INSERT statement in oracle is a DML ( Data Manipulation Language) command. It is used to insert new rows into the oracle tables in the oracle database Syntax INSERT INTO <table_name>(col1, col2, … column_n )VALUES(value1, value2, … value_n ); Heretable_name: Table where new records need to be insertedcol1,col2: is the column in the tablesvalue1,value2….: are […]
INSERT statement in Oracle Read More »
The error ORA-01427 is raised, when a sub-query returns more than one row to an Equality or in-Equality operator. The reason being there are restrictions on the legal comparison operators.The single row subquery operator are Symbol Meaning = equal > greater than >= greater than or equal < less than <= less than or equal
ORA-01427: single-row subquery returns more than one row Read More »
We often get situation where we need to increase the size of the redo log files as log switches are very frequent.Increasing the redo log files sizes decreases the log switches and improves the performance of the database.There is no resize command for redo log files, we have to recreate redo log i,e dropped and
ADD /Drop redo log files in Oracle database Read More »
Here are the EBS R12 start and stop scripts valid for both R12.0 and R12.1 for the EBS maintenance activities R12 start and stop scripts The scripts are their in the directory $ADMIN_SCRIPTS_HOME ($INST_TOP/admin/scripts) adstpall.sh – stop all servicesadstrtal.sh – start all servicesadapcctl.sh – start/stop/status Apacheadformsctl.sh – start/stop/status OC4J Formsadoacorectl.sh – start/stop/status OC4J oacoreadoafmctl.sh –
EBS R12 start and stop scripts Read More »
RMAN-20004 Problem When Recovery catalog has been configured.and Production Database has been cloned and a connection has been made from the clone to Catalog database using rman with out changing the DBID of the clone,then we are in some trouble Then when you try to backup the production instance with the catalog,The backup fails with
How to correct Oracle RMAN-20004 Backup failure Read More »
In this Oracle tutorial, we will provide information on how to recover the datafile in Dataguard environment We have a Oracle Production env TSPRD which is having the Standby Database TSSTD CaseStudy 1: Suppose one of the file(For example file# 11) on the primary side(TSPRD) got corruptedThe only solution is to restore the file and recover itInstead
How to recover the datafile in Dataguard Environment Read More »
