Oracle - Recent User Comments
| Code | When | Id | Who | |
|---|---|---|---|---|
| PLS-00323 | 11/03/2010 15:43:26 | 7 | Joe | |
| Great help. One of my parameters was spelled differently in the header. I changed it and the package compiled. | ||||
| PLS-00435 | 11/03/2010 09:27:01 | 3 | Abhi | |
| Is this any kind of joke ? | ||||
| ORA-01610 | 28/02/2010 17:01:21 | 16 | Ion | |
| Simply awesome , after googling for more than 2 hours this solution fixed my issue .... THANKS A ZILLION !!!!!!! |
||||
| TNS-01150 | 24/02/2010 22:07:33 | 2 | Oz | |
| lsnrctl is the program found in $ORACLE_HOME/bin that is used to control (start/stop etc) the oracle listener. | ||||
| TNS-01150 | 23/02/2010 19:36:32 | 1 | Right Said Fred | |
| I'd like to know what LSNRCTL means. | ||||
| TNS-00525 | 23/02/2010 04:22:56 | 2 | vikas | |
| stop listener delete /tmp/.oracle restart listener |
||||
| ORA-27071 | 16/02/2010 17:44:51 | 1 | huichobeto | |
| No es necesario que coloques esos errores, si yo quisiera la descripción checo el alert, o los trace.... seria mejor poner la solución |
||||
| LRM-00123 | 12/02/2010 21:19:45 | 1 | None | |
| worthless information... | ||||
| ORA-02256 | 12/02/2010 15:45:22 | 1 | Jamie Ibrio | |
| Your explanation is a statement of the error, not an explanation of it. | ||||
| ORA-01939 | 11/02/2010 11:14:54 | 1 | krishna kumar | |
| Hi friend this web site really help me to solve my related problem. | ||||
| ORA-14155 | 11/02/2010 08:05:44 | 2 | SWAMY CHINNAM | |
| ALTER TABLE TABLE_NAME RENAME COLUMN OLD_NAME TO NEW_NAME; I GAVE THIS QUERY BUT IT GAGE ERROR,WHAT DID DO THE MISTAKE. | ||||
| ORA-06508 | 10/02/2010 10:03:28 | 1 | Chandra Kishore Kovuru | |
| When I faced this problem, I checked for all procedures status in user_objects, to my surprise I found two packages with the same name one in valid state and another in invalid state. When I dropped the package both of them got dropped and later created the package the problem was resolved. | ||||
| SP2-1503 | 10/02/2010 09:05:01 | 4 | fantasticvibs | |
| Thx a ton Nilofer... worked for me too... was about to reinstall oracle. | ||||
| PLS-00328 | 09/02/2010 17:58:31 | 1 | Derek Asamoah | |
| Another suggestion is to check parameters and return types in the body to confirm they match the declaration. | ||||
| TNS-00530 | 09/02/2010 17:43:01 | 1 | YO | |
| Poner solucion, gracias | ||||
| PLS-00231 | 09/02/2010 10:10:09 | 1 | Fabio Gemesio | |
| Add the called function in the specification... | ||||
| SP2-1503 | 09/02/2010 04:14:27 | 3 | Satish | |
| Thanks again Nilofar, it worked for me too. I have Windows 7 | ||||
| TNS-12545 | 08/02/2010 06:44:08 | 5 | Vijay | |
| Thanks, it worked.. | ||||
| ORA-01720 | 07/02/2010 16:26:33 | 2 | Shlooks | |
| USER_A : SOME_TABLE USER_B : SOME VIEW AS SELECT * FROM USER_A.SOME_TABLE USER_C : Should select from USER_B.SOME_VIEW Because USER_C needs to read from USER_A, the "middle" user, USER_B must granted with "grant option" as: GRANT SELECT ON USER_A.SOME_TABLE to USER_B WITH GRANT OPTION; |
||||
| ORA-00603 | 06/02/2010 23:14:31 | 2 | Manu | |
| Yes, this solution is useless, even the same error appears if you login again and run catproc.sql | ||||
| ORA-01610 | 06/02/2010 02:01:10 | 15 | ovey | |
| Nice post... You are a DBA master... :) | ||||
| ORA-01610 | 06/02/2010 01:50:26 | 14 | Ben | |
| I need help I'm a new DBA can anybody tell me how to create a controlfile from a trace file | ||||
| ORA-00906 | 05/02/2010 06:21:38 | 5 | avinash | |
| create table avi ( myname char(10) NOT NULL, myroll integer NOT NULL, primary key, myclass integer DEFAULT = '12', ); error is ORA-00906: missing left parenthesis how do i rectify it.??????/ plz help me |
||||
| ORA-02231 | 04/02/2010 09:02:00 | 1 | pooja wankhede | |
please tell me the solution for this type of error |
||||
| ORA-01147 | 26/01/2010 07:58:31 | 2 | Mike | |
| The problem is; 'Smith' isn't a dba and shouldn't be allowed anywhere near an Oracle database under any circumstances, especially not for money. | ||||
| ORA-01159 | 24/01/2010 06:50:23 | 1 | aakanksha | |
| Can you please tell how to recover forom this error,?? | ||||
| LPX-00651 | 20/01/2010 15:54:52 | 1 | Raj | |
| Can you please provide more details on this | ||||
| SP2-1503 | 20/01/2010 02:13:43 | 2 | Varun | |
| Great Help Nilofer.. Thanks.. It worked !! | ||||
| PLS-00435 | 18/01/2010 16:35:56 | 2 | Bibi | |
| I confirms, it helps me soooo much !!! |
||||
| INS-41317 | 15/01/2010 00:27:25 | 1 | rac setup | |
| This error sucks. | ||||
| ORA-02180 | 14/01/2010 00:26:39 | 1 | edward | |
| I pecified datafile. On script created by enterprise manager console. and I get this error. | ||||
| ORA-00963 | 13/01/2010 17:26:19 | 1 | what | |
| What's and interval type? | ||||
| SP2-1503 | 13/01/2010 12:33:48 | 1 | Nilofer | |
| Check if the user running the command has Administrative access. If running on Vista, select the .exe and use "Run as Administrator" option | ||||
| TNS-12555 | 11/01/2010 19:57:45 | 1 | Wayne Champlin | |
| I found that a user had tried to start the listener (and the database) as an unauthorized user. I went to /var/tmp/.oracle and made sure that that directory was owned by oracle:dba and so were all the files in that directory. What I found were files owned by that user who had attempted to start the listener. | ||||
| SP2-0934 | 05/01/2010 20:07:04 | 1 | Ahmed Samir | |
| very nice | ||||
| RMAN-20021 | 28/12/2009 21:33:39 | 1 | nabin | |
| plz someone comment on the issue, i have exact same problem. | ||||
| ORA-01224 | 25/12/2009 10:07:54 | 1 | Pyfsmsmn | |
| It's serious | ||||
| ORA-01610 | 22/12/2009 15:09:21 | 13 | dheeraj | |
| Hi can you please let me know the syntax for the 4th command "create controlfile from trace file". Thanks in advance. | ||||
| PLS-00310 | 15/12/2009 11:58:32 | 1 | philippeko | |
| change the name of your table or another object of your DB. http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2170326695312#14061139459426 |
||||
| ORA-21779 | 11/12/2009 15:43:39 | 2 | Developer too | |
| Youre right man, this is one of the most stupid error messages i ever saw. But thanks for the oracle solution "you should avoid this operation" - even better than the error itself. | ||||
| ORA-01742 | 10/12/2009 17:59:33 | 1 | skl | |
| cool | ||||
| ORA-16416 | 09/12/2009 10:21:33 | 1 | aakanksha | |
| can u plz provide more information on how to rectify this error instead of waiting for synchronisation | ||||
| ORA-03206 | 06/12/2009 20:10:58 | 1 | Useless | |
| The action to be performed is quite vague!! | ||||
| ORA-22828 | 26/11/2009 14:25:44 | 1 | Some One | |
| There is an article on the Oracle website "How to pass LOBs as parameters from Java to a Database Stored Procedure" which says we can pass larger params than 32K but actually I could not get it to work... I also used the "SetBigStringTryClob" connection param method. Does not work either. | ||||
| PLS-00642 | 12/11/2009 09:38:00 | 1 | ncarco | |
| This error can be experienced when trying to store select into results into varray. Try doing a select with bulk collect into instead. | ||||
| ORA-01841 | 29/10/2009 14:29:46 | 1 | Ram Gupta | |
| Hi I m getting this kind of error. How i resolve this | ||||
| SP2-0519 | 23/10/2009 07:31:48 | 1 | Nagaraj | |
| Hi Guys I have used below command for copying the table from other than default space; SQL> copy from TST03 to TST03Temp tablespace PSAPPD1NEW; Enter FROM password: SP2-0519: FROM string missing Oracle Net @database specification still it is not working. |
||||
| PLS-00320 | 14/10/2009 20:44:33 | 1 | BBB | |
| Good explanation....... | ||||
| ORA-01157 | 08/10/2009 10:38:10 | 1 | kanchan | |
| try this: sql>alter database datafile 2 offline drop; sql>alter database open; |
||||
| ORA-01610 | 06/10/2009 15:35:11 | 12 | Christine | |
| So simple and yet so perfect. THANK YOU SO MUCH! | ||||