Posted in Uncategorized on September 25, 2008 | 1 Comment »
Whenever I used to find out the info of any fixed table(x$) I used to do this by a workaround. I used to set the trace, run the query and see the table’s name. For example, if we are looking for the V$log’s fixed table name so I would do something like that ,
<code>
SQL> select [...]
Posted in Troubleshooting, tagged imp-00020, imp-00058, ora-01438, oracle 8.1.7.4 on September 18, 2008 | Leave a Comment »
Errors are not really a welcome stuff . Yesterday, I was importing a dump file (from 8.1.7.4) into 10.2.0.3 and hit
IMP-00020: long column too large for column buffer size (number).
After doing some googling and searching on metalink came to know (not sure though) that it was some bug in 8.1.7.4. And the solution [...]
Posted in Uncategorized on September 17, 2008 | 5 Comments »
Well this was not supposed to be a post but it was asked over Forums.oracle.com that can we do the transport of the tablespace in the same database after some testing?So the answer is yes. Now I was originally going to post it over there only but thanks to new Jive software, I couldn’t so [...]
Posted in Research on September 16, 2008 | 1 Comment »
Well Oracle is changing and I believe that there are alot changes which are happening “under-the-hood”. I just got a question over Forums that can Shared Pool shrink if we are using ASMM?Well the docs say no that wont be possible. Well the answer as per docs is No,its not possible that oracle will [...]
Posted in Uncategorized, tagged EM, Netproperties on September 11, 2008 | 1 Comment »
Today in my program, we hit with an almost uncertain error. We were trying to create listener using EM console but it was throwing us an error that the location is not the right one when the location was perfectly alright. I am not sure what actually is the error but despite the best effort, [...]
Posted in Uncategorized on September 10, 2008 | Leave a Comment »
Just read from Justin’s blog, Oracle is going to put an Oracle Listen promotion over its web site. Check this, http://blogs.oracle.com/otn/2008/09/oracle_listens_1.html
So it means that we would actually get a chance to tell Oracle what we want? Cool, now that’s what I call real close to the customers and listening to their heartbeat! Good work. It [...]
