ORA-14450: attempt to access a transactional temp table already in use Mindsforest 04:01:00 Add Comment Edit ORA-14450: attempt to access a transactional temp table already in use I need to alter the global temp. table but its not letting me a... Read More
ORA-01483: invalid length for DATE or NUMBER bind variable Mindsforest 03:37:00 Add Comment Edit Question: I’m getting an "ORA-01483: invalid length for DATE or NUMBER bind variable" error with the following code: Answe... Read More
FRM-30425: Summarized database item must reside in a block with Query All Records or Precompute Summaries set to Yes. Mindsforest 23:17:00 Add Comment Edit FRM-30425: Summarized database item must reside in a block with Query All Records or Precompute Summaries set to Yes. Solution: It s... Read More
ora-02299 cannot validate duplicate keys found Mindsforest 23:18:00 Add Comment Edit down vote favorite can anybody help with me with this? id | Name -------- 1 | aaa 2 | bbb 3 | aaa > alter table ... Read More
Oracle Errors and Solutions Mindsforest 05:13:00 2 Comments Edit ORA-00060: deadlock detected while waiting for resource ORA-00936:missing expression ORA-02063 remote db error and how to fix it ORA-00... Read More
ORA-01422: exact fetch returns more than requested number of rows Mindsforest 04:25:00 Add Comment Edit ORA-01422 : exact fetch returns more than requested number of rows Cause: The number specified in exact fetch is less than the rows ret... Read More
PLS-00222: no function with name exists Mindsforest 04:24:00 Add Comment Edit PLS-00222: no function with name 'string' exists in this scope Cause : An identifier being referenced as a function was not dec... Read More
ORA-28009: connection to sys should be as sysdba or sysoper Mindsforest 04:23:00 Add Comment Edit Cause: Connect sys/password is no longer a valid syntax. Action: Try connect sys/password as sysdba or connect sys/password as sysoper... Read More
ORA-21000:error number argument to raise_application_error is out of range Mindsforest 04:22:00 Add Comment Edit ORA-21000:error number argument to raise_application_error of stringstring is out of range Cause:An attempt was made to specify a number... Read More
ORA-12154: TNS:could not resolve the connect identifier specified - Oracle Error Mindsforest 03:57:00 Add Comment Edit ORA-12154 : TNS:could not resolve the connect identifier specified - ORA-12154 Error/ Oracle Error Cause : A connection to a database or... Read More