Commenting on my blog

2 Replies

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 🙁 ).

The display of single post in IE is still broken. Some issues with the theme i am using, i guess. Will try to fix that.

If you have any difficulty in reading or commenting on the post, please let me know at amardeepsidhu at gmail dot com.

Thanks 🙂

OTN forums get a new look

2 Replies

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.

Nice change indeed ! I am not happy with the font though, it is very small 🙁

A database – one tablespace & one datafile

Leave a reply

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?

Single datafile of 3.3 TB 🙂

Awesome !

Kudos to the designer 😉

Import and default values for columns

Leave a reply

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.