Oracle and more - Amardeep Sidhu

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 :

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…

I recently upgraded my blog to Wordpress 2.5. The manual process is real cumbersome. Today I came across few plugins which help in almost automating the upgrade stuff.

Wordpress Automatic upgrade: As per description this plugin first takes backup and then upgrades. I didn’t try this one, though.

Instant Upgrade: I upgraded one of my blog using this. It doesn’t take care of backup but otherwise the upgrade was super smooth. Just few clicks and you are done.

Happy upgrading !

If you use Gtalk and Winamp simultaneously and tried to set the currently playing track as your status, you might have been faced by Gtalk hanging. I also struggled with this for 2 weeks until  I did a bit of googling and got a link which gives a trick to get rid of the problem.

The trick is to create an empty winamp.m3u file in \Program Files\Winamp folder and you are done.

Finally finally finally a small sticky has been posted on OTN Database forums homepage. But its there only on Database forums page not on PL/SQL. It reads like:

Posters, please mind these common-sense rules when participating here:

- When asking a question, provide all the details that someone would need to answer it. Consulting documentation first is highly recommended. (See http://blogs.oracle.com/shay/2007/03/02 for more hints.)
- When answering a question, please be courteous; there are different levels of experience represented here. A poorly worded question is better ignored than flamed - or better yet, help the poster ask a better question.

Thanks for doing your part to make this community as valuable as possible for everyone!

- OTN

That means Database forum enjoys most number of flames

Few days ago i posted about DBAzine being down. I was just checking to see if its back.

Its rocking now.

Welcome back DBAzine.com

Just finished upgrading to Wordpress 2.5. Everything seems to be working fine.

Another issue I just came to know that wherever i am using syntaxhighlighter to format the code, it doesn’t display properly in Internet Explorer. May be something to do with the plugin. Will try to fix it. It works fine in Mozilla.

Today I was upgrading 10gR1 to 10gR2 (10.2.0.1) on Linux x86. The upgrade went almost fine (except that I had to install one package and change few kernel parameters) but while running DBUA to upgrade databases, it gave an error:

Could not get database version from the Oracle Server component. The CEP file rdbmsup.sql does not provide the version directive

and

Start of root element expected. Upgrade Configuration file
'C:\Oracle10g2\cfgtoollogs\dbua\test\upgrade5\upgrade.xml' is not a valid XML file.

I searched in the metalink and found that this all happens due to customized glogin.sql file which was there in my case also. And removing that customization made DBUA rock

You might want to check here, here and here.