Oracle - Recent User Comments
| Code | When | Id | Who | |
|---|---|---|---|---|
| PLS-00323 | 03/09/2010 22:04:20 | 9 | Shahzad | |
| "02/07/2008 15:50:09 by Rajesh I had declared the fucntion in the body but was getting the error because my return type in spec was number and in the body was integer" I encountered exactly same thing and fixed it after seeing your post and debugging for almost an hour. |
||||
| ORA-01610 | 02/09/2010 19:47:42 | 18 | vivek | |
| hi i am also following d same steps but this error occur ORA-01610: recovery using the BACKUP CONTROLFILE option must be done pls help me |
||||
| ORA-01439 | 01/09/2010 12:33:41 | 2 | Felipe | |
| Thanks This solution worked for me! |
||||
| ORA-32004 | 26/08/2010 23:30:51 | 2 | tkeb | |
| Check out this link to find obsolete parameters. http://www.oraclekonsulent.dk/en/index.php?blog_id=114 To find deprecated parameters issue the following SQL: select name from v$parameter where isdeprecated = 'TRUE'; Then look in your pfile for a matching parameter. |
||||
| ORA-02018 | 25/08/2010 10:52:41 | 4 | parkour | |
| Thanks. | ||||
| ORA-31640 | 25/08/2010 08:48:32 | 2 | Gunjan | |
| Please provide an appropriate solution. | ||||
| ORA-00904 | 24/08/2010 14:15:46 | 5 | Dara Fann | |
| Oracle SQL has extensions for specialized features such as Oracle*Text and Oracle SQL has a "contains" clause for finding specific strings within an Oracle*Text index. Oracle Text works with traditional data columns and also with XML, MS-Word docs and Adobe PDF files that are stored within Oracle. Oracle Text has several index types: CTXCAT Indexes - A CTXCAT index is best for smaller text fragments that must be indexed along with other standard relational data (VARCHAR2). WHERE CATSEARCH(text_column, 'ipod')> 0; CONTEXT Indexes - The CONTEXT index type is used to index large amounts of text such as Word, PDF, XML, HTML or plain text documents. WHERE CONTAINS(test_column, 'ipod', 1) > 0 CTXRULE Indexes - A CTXRULE index can be used to build document classification applications. See my notes here on using Oracle Text indexes. Using the CONTAINS clause The Oracle documentation for the contains clause notes the basic syntax: CONTAINS( [schema.]column, text_query VARCHAR2 [,label NUMBER]) RETURN NUMBER; Oracle gives this example of invoking the SQL contains clause: CREATE TABLE accumtbl (id NUMBER, text VARCHAR2(4000) ); INSERT INTO accumtbl VALUES ( 1, 'the little dog played with the big dog while the other dog ate the dog food'); INSERT INTO accumtbl values (2, 'the cat played with the dog'); CREATE INDEX accumtbl_idx ON accumtbl (text) indextype is ctxsys.context; PROMPT dog ACCUM cat SELECT SCORE(10) FROM accumtbl WHERE CONTAINS (text, 'dog ACCUM cat', 10) > 0; The Oracle Text SQL Operator documentation notes: "The following example searches for all documents in the in the text column that contain the word oracle. The score for each row is selected with the SCORE operator using a label of 1: SELECT SCORE(1), title from newsindex WHERE CONTAINS(text, 'oracle', 1) > 0; The CONTAINS operator must be followed by an expression such as > 0, which specifies that the score value calculated must be greater than zero for the row to be selected. When the SCORE operator is called (for example, in a SELECT clause), the CONTAINS clause must reference the score label value as in the following example: SELECT SCORE(1), title from newsindex WHERE CONTAINS(text, 'oracle', 1) > 0 ORDER BY SCORE(1) DESC; |
||||
| ORA-00607 | 16/08/2010 14:16:15 | 2 | A Verma | |
| Nice help provided. Thanks | ||||
| ORA-06577 | 16/08/2010 05:01:23 | 1 | Andrew de Ridder | |
| Well thats very dry and witty, but not at all useful. | ||||
| TNS-12545 | 05/08/2010 15:07:26 | 8 | Lakshmi | |
| Thanks a lot!! | ||||
| ORA-12728 | 04/08/2010 23:26:28 | 1 | Tom | |
| Seriously? Why do you even bother putting such a page up? | ||||
| ORA-39726 | 30/07/2010 15:20:40 | 4 | Rui | |
| This is the only thing that worked for me on Oracle 10g: ALTER TABLE <TABLE_NAME> Move Nocompress; ALTER TABLE <TABLE_NAME> Drop Column <COLUMN_NAME>; ALTER TABLE <TABLE_NAME> compress; |
||||
| SP2-1503 | 27/07/2010 20:38:59 | 6 | Sandeep | |
| Thanks It works. Had similar problem with PL SQL developer | ||||
| ORA-30657 | 26/07/2010 08:14:50 | 5 | shashanka | |
| f u c k o f f | ||||
| INS-32010 | 23/07/2010 12:28:07 | 1 | Sye Agha | |
| how to get rid of this error while installing oracle 11g. Even i hve tried every type of password but still geting the same error. kinldy provide an example of this. | ||||
| TNS-01151 | 19/07/2010 08:24:33 | 1 | Binyam form addis ababa | |
| thank you very much. i got the solution for my problem | ||||
| ORA-01440 | 09/07/2010 15:09:21 | 1 | pat | |
| it did not work for me | ||||
| ORA-12808 | 08/07/2010 16:10:11 | 1 | Andy D. | |
| Let me know if you were able to solve this. I maybe able to help. Thanks, Andy D. http://www.FranklinFaces.com |
||||
| ORA-12800 | 08/07/2010 16:09:37 | 1 | Andy D. | |
| Let me know if you were able to solve this. I maybe able to help. Thanks, Andy D. http://www.FranklinFaces.com |
||||
| IMP-00028 | 08/07/2010 07:51:07 | 1 | Farookh Mohammed | |
| VVVVVVVVVVVVVVV. Thank's for this info. |
||||
| ORA-01882 | 29/06/2010 16:00:53 | 5 | Harsha | |
| Thanks a lot!!! this worked for us... |
||||
| IMP-00008 | 28/06/2010 11:16:43 | 1 | Gabskh | |
| This error may occur in mknod imp if ther is no space at the destination of pipe | ||||
| ORA-56920 | 24/06/2010 21:30:52 | 1 | JC | |
| Wow. informative | ||||
| ORA-00265 | 24/06/2010 20:35:45 | 4 | seshu | |
| hi friends try this SQL> startup mount force; ORACLE instance started. Total System Global Area 2097152000 bytes Fixed Size 1268460 bytes Variable Size 704644372 bytes Database Buffers 1375731712 bytes Redo Buffers 15507456 bytes Database mounted. SQL> alter database archivelog; alter database archivelog * ERROR at line 1: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode SQL> alter database open; Database altered. SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global Area 2097152000 bytes Fixed Size 1268460 bytes Variable Size 704644372 bytes Database Buffers 1375731712 bytes Redo Buffers 15507456 bytes Database mounted. SQL> SQL> SQL> SQL> alter database archivelog; Database altered. SQL> alter database open; Database altered. |
||||
| ORA-00265 | 24/06/2010 19:49:24 | 3 | seshu | |
| i followed the action that specified but i am getting same error is there any other solution for this ? | ||||
| TNS-12545 | 23/06/2010 10:48:30 | 7 | Sandeep | |
| Thanks..for the suggestion | ||||
| ORA-00906 | 22/06/2010 14:31:48 | 6 | emeka | |
| create table staffs ( staff_id integer constraint staffs_uq unique key, first_name varchar2(12), last_name varchar2(12), sex varchar2(3), dob date, mar_stat varchar2(8), salary number, job_id varchar2 ); pls wats wrong with this query |
||||
| ORA-06532 | 17/06/2010 14:47:59 | 5 | Roberto | |
| Esta usando Loop, cuidado talvez aja a necessidade de limpar o array a cada loop. | ||||
| ORA-22992 | 17/06/2010 08:53:09 | 3 | PIerro | |
| Looool actually they do jsut like any DBA. which are all communists !!! :) (just kidding, but that is exactly the kind of answer we get from our dba's !!!) | ||||
| ORA-29348 | 13/06/2010 22:02:34 | 1 | Jahldor | |
| Bilmasalarin chochogimga yozasanlami? | ||||
| ORA-21779 | 10/06/2010 13:09:23 | 3 | Yuriy | |
| It's not so bad. Our very expensive product sometimes provides a user by 'very informative' call stack. | ||||
| ORA-01830 | 07/06/2010 15:33:35 | 2 | Gediminas | |
| I have a problem too, but it's a bit different. INSERT INTO PROJEKTAI (Nr, Pavadinimas, Svarba, Pradzia, Trukme) VALUES (Projektai_Vykdytojai_Nr.NEXTVAL,'Studentu apskaita','Maza','01/01/2005', 12) Error report: SQL Error: ORA-01830: date format picture ends before converting entire input string |
||||
| TNS-00525 | 07/06/2010 04:40:34 | 3 | peter.s | |
| great tip this fixed my problem /tmp has a .oracle dir also |
||||
| LRM-00123 | 02/06/2010 15:27:52 | 4 | Alex.Betin | |
| This link might help: http://oracleappstechnology.blogspot.com/2009/02/lrm-00123-invalid-character-0-found-in.html |
||||
| RMAN-06403 | 31/05/2010 16:24:04 | 1 | SFF | |
| THIS IS NOT PROPER SOLUTION | ||||
| ORA-31640 | 30/05/2010 06:51:14 | 1 | Datapumpman | |
| What kind of answer is that? | ||||
| ORA-39762 | 27/05/2010 06:10:51 | 1 | viswam | |
| how to solve the above problem | ||||
| PLS-00323 | 25/05/2010 16:43:50 | 8 | Chris | |
| My variable type was mentioned varchar in body instead of varchar2 which caused this problem. Thanks for your help. | ||||
| ORA-12703 | 19/05/2010 17:35:45 | 1 | Kase | |
| I got this exact error on my application after running a offline backup. To resolve this we had to shutdown the application and then reboot the database server. When we brought back up the applicaiton the error cleared. |
||||
| ORA-38305 | 19/05/2010 12:10:13 | 2 | tom | |
| sys cant flash bak his tables?.. i can flash bak a dropped user table,bt once sys dropped any table it cant flashbak. showin that file does not exists in recyclebin o/p SQL> flashback table aju to before drop; flashback table aju to before drop * ERROR at line 1: ORA-38305: object not in RECYCLE BIN |
||||
| TNS-12545 | 13/05/2010 11:17:43 | 6 | rita | |
| Thanks,It's really worked for me. great job. | ||||
| ORA-24248 | 08/05/2010 13:58:22 | 2 | Admin | |
| Use the More Info >> link to find out More Info | ||||
| LRM-00123 | 07/05/2010 17:56:18 | 3 | Sri | |
| Idiot of Highest grade | ||||
| ORA-01866 | 05/05/2010 19:51:25 | 1 | Pablo | |
| I got ORA-01866 in Oracle Containers for J2EE 10g (10.1.3.4.0) in production environmente but when I am Using ADF in JDeveloper 10.1.3.4 I don't get this error in Development Environment Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi |
||||
| ORA-24248 | 05/05/2010 14:34:39 | 1 | mike | |
| very helpful; I never would have guessed | ||||
| ORA-31011 | 05/05/2010 11:01:55 | 1 | V | |
| What about wrong charset? | ||||
| SP2-1503 | 04/05/2010 20:11:06 | 5 | Joumdanisatioo | |
| Thanks, Would you please tell me the steps I have to do to solve this problem, I'm using Windows 7 | ||||
| ORA-02778 | 30/04/2010 22:47:56 | 3 | mona | |
| thanks omar ,its work | ||||
| RMAN-10038 | 28/04/2010 22:04:42 | 2 | tmv | |
| Increasing orastack oracle.exe from 500k to 1mg resolved our channel errors. | ||||
| ORA-15231 | 28/04/2010 17:07:08 | 1 | User | |
| Big help | ||||