RAID stands for Redundant Array of Inexpensive Disks. Managing a large number of individual disk drives can be very difficult since you must balance the database files across all of these disk drives in order to spread out the I/O load. In order to simplify this task, provide for optimal performance, and provide a fault-tolerant …
What is RAID(Redundant Array of Inexpensive Disks) Read More »
ORA-00942 is one of the many errors which Oracle developer ,Oracle DBA often gets. Lets first look at the OERR output Cause: The Oracle table or Oracle view entered does not exist, a synonym that is not allowed here was used, or a view was referenced where a table is required. Existing user tables and views …
How to Solve ORA-00942 table or view does not exist Read More »
Description ORA-00936 : missing expression is one of the common error everybody working in Oracle SQL must have faced some time. This generally happens when you omit important thing in the Sql statement i.e you left out an important chunk of what you were trying to run Reference : Oracle documentation Cause of ORA-00936 : missing expression …
Oracle documentation We receive this error ORA-01652 while inserting data,creating index, table when we don’t have enough space in tablespace. Solution is to add sufficient space in the tablespace identified in the error ORA-01652 There are three ways to do it Add datafile to the tablespace Resize the existing datafile in the tablespace auto-extent the …
ORA-29913 is one of the common error when working with external tables in Oracle database. We would be looking at various ways the error can be produced and what can be done to resolve the error (1) External File not found or permission incorrect SQL> select * from Scott.example_external_table;select * from example_external_table*ERROR at line 1:ORA-29913: …
What are Concurrent Managers Concurrent Managers are the controllers of background processing for Oracle Applications. The main function of Concurrent Managers is to regulate and control process requests based upon a set of rules. It is a technique used to execute non interactive, data-dependent programs simultaneously in the background. Oracle Applications comes with predefined managers, …
Top 30 Most Useful Concurrent Manager Queries Read More »
