Unfair limitations of Oracle Database 10G

Unfair limitations of Oracle Database 10G

Oracle one of great database Product and it takes more than 50% of market share. But I’m honestly saying Oracle has very unfair limitations. Few of them are,

• Database name length (no of Digits) – 8

• Table, Procedure...Etc name length (no of Digits) – 30

But recently I was come across Oracle Installation Problem,

1. “Invalid command line argument. Execute VSJITDebuggar /? for Help”. Javaw.exe has encountered a Problem and need to close.
2. “An unhandled win32 exception occurred in Javaw.exe [5676] “

I was nearly spent more than 1 week but I couldn’t found any solution. Unfortunately there haven’t any blog or article related this. Luckily Buddy (Buddhika Karunatilake) find out the solution. The problem was my Oracle installation contain folder path too long. (“C:\Documents and Settings\Administrator\Desktop\Oracle\ Oracle-10.2.0.1.0-WinNT-Base\database”) I found few oracle articles about oracle limitation,

1. http://www.oracle.com/technology/products/ias/bpel/htdocs/soa_training_10133_installation_instructions.html - (Check 2. Installing the software)
2. http://download.oracle.com/docs/cd/B19188_01/doc/B15917/limitations.htm
3. http://www.mssqlcity.com/Articles/Compare/sql_server_vs_oracle.htm
4. http://www.gc.maricopa.edu/business/oracle/docs/Oracle8iDocs/server.815/a67790/ch4.htm