I don’t know a bit about Apache HTTP server but faced one issue in office…so thought about writing it here ;) We are having a 3 tier setup where Oracle Application Server 10g was there on AIX 5.3. It runs Apache HTTP server and we needed to access the files outside DocumentRoot. A bit of googling revealed that we could use Alias for that. Basically we need to add the following small piece of text to httpd.conf file: ...
Our application (3 tier, Front end Forms10g and back end 10gR2) provides user with a front end to refresh the mviews. That form has 2 columns showing mview name and the comment against it. Recently i saw that while opening this front end ORA-01403 NO DATA FOUND was being raised. I opened the fmb and found that it was populating comments from DBA_TAB_COMMENTS. In 10g the comments against mviews are stored in DBA_MVIEW_COMMENTS unlike till 9i where it was in ALL_TAB_COMMENTS. So there was a little modification required. ...
Just upgraded my blog to Wordpress 2.6. There are few new things. This video from Wordpress summarizes the new stuff:
Aman made me aware about not being able to post any comments on my blog. I checked and found that everything was fine with Firefox but in IE 6 it was not possible to post a comment. I was using Did You Pass Math plugin to stop comment spam and it had some problems in IE. I disabled it for the time being and installed WP-SpamFree. Everything seems to be fine except that it doesn’t allow very small comments and i haven’t been able to figure out where that setting is ? (yea…i am really poor with this web stuff :( ). ...
Just had a glimpse. OTN forums has got a new look. A bunch of new features has also been added. Some of the new things i noticed are: That simple editor is now rich text editor. Also supports emoticons. You can add tags to a post and it displays the tag cloud (for all the posts) on right side. A post can be marked as a question and then there will be some points system based on answers. That list of Top users doesn’t show those users n ACEs. It display a new list of people instead. Report Abuse button has been added (with each reply). May be there are some other changes too. That is what i noticed in the very first look. ...
I just opened OTN forums and found: High availability live ;)
author: Sidhu category: oracle-general guid: http://amardeepsidhu.com/blog/?p=79 tag: database title: A database - one tablespace & one datafile url: /blog/a-database-one-tablespace-one-datafile/ Today I was checking OTN forums and came across a thread. OP’s concern was: One of the db i am supporting has about 3.3 Terabytes capacity and the application is using only 1 huge tablespace with one big file. the system is linux 4 , 32 bit. oracle version is 10.2.0.4 Is there a limit of space for a tablespace when you consider insert/delete/query performance? ...
I had got an export of a database and had to import it to a new database. The only difference was that in new database few of the large tables were partitioned. So instead of partitioning it after the import, i thought about pre-creating the tables (with partitioning) and then run import with ignore=Y . Everything went fine. But later on the front end application gave some error and we came to know that default values for columns in some tables were not set. I did some googling and didn’t find much. Then i posted the same to OTN forums and came to know that if the table pre-exists, import doesn’t take care of default values of columns. Metalink note 224727.1 discusses this. So if you are pre-creating the tables and there are some default values for any columns, set it manually, don’t rely on import for this. Same is true for impdp as well. ...
I just opened the Oracle Community page and : Comments Comment by Eddie Awad on 2008-04-22 23:44:33 +0530 Hi Amardeep, As you may have noticed already, OracleCommunity.net is back online now 🙂 Cheers! Comment by Sidhu on 2008-04-23 06:55:02 +0530 Eddie You know what…i was expecting your comment… Cheers !
Today I was searching for an error message in metalink and it was giving strange messages. Then i came to know that the error message contained “%” character and metalink was not really happy searching for it. Rather it showed a confusing message: Pretty strange…