Search results for query: *

Hi, Is there anything special that we need to look for while migrating from Oracle 8i to oracle 9i on an application's point of view. Is there any basic differences between 8i and 9i, that should be tested elaborately. Thanks in advance, DOUBLE H

Hi, We got ORA-24327 error when one of our Java - JDBC programs tried to connect to Oracle. But the next day when the Weblogic server was restarted by our application restart scripts, everything is fine...the same code which threw the error works fine. And I enquired the DBA there regarding...

Hi, We are having some driver problems with Oracle/Websphere settings. Our websphere supports jdk1.2 and above. But oracle8.1.6 comes with lower version of jdk. And so the jdbc programs search for the driver in the classes12.zip in $ORACLE_HOME/jdbc/lib. So it possible for us to download the...

Hi, We are developing an Orbix2.3 client with C++ for an SSL enabled Visibroker 4.5.1 server with an IOR having single port(SSL enabled). Can the Orbix client connect to the server? If so, please elaborate. We also have a doubt regarding how to manually generate single port SSL enabled IORs in...

Hi, Some of the files and directories are missing. Could anyone respond me with some possible reasons for this. The OS is Sun Solaris 5.6 Thanks, Double H Thanks & Regards, DoubleH

Hi, Some of the files including directories are missing in Solaris 5.6. Can anyone help me out????? Thanks in advance, Double H Thanks & Regards, DoubleH

Hi, I would like to know whether are there any ways to find out the timestamp at which a particular row was inserted?. Thanks & Regards, DoubleH

Hi, We have a perl program which uses oraperl to login to one of the databases. We get the error ORA-1004 - default username/password logon denied. That particular database has been upgraded to 9i. When we try to connect from sqlplus directly we are able to connect with the same username...

Hi, I am new to DB2. Pls tell me some links which will emphasize more on how to write DB2 stored procedures. Thanks & Regards, DoubleH

Hi, We have a perl program which uses oraperl to login to one of the databases. We get the error ORA-1004 - default username/password logon denied. That particular database has been upgraded to 9i. When we try to connect from sqlplus directly we are able to connect with the same username...

Hi, How to pass some parameters from a C/C++ program to a shell script? It will be helpful if You could give me a sample of it. Thanks in advance. Thanks & Regards, DoubleH

Hi, I have a shell script in my windows'95 system and I would like to run the same shell script in my Unix server by logging in progrmmatically by writing a batch program in my windows. Pls throw some light over here. Thanks & Regards, DoubleH

Hi, I am a Oracle Certified Professional in Development Track for 8i and I am also a Sun Certified Java Professional. I heard there is some certification upgradation for both of them through Oracle corp. Please help me in knowing about this. And I would like to know what is the syllabus for the...

Hi, I would like to know the command that's used to change the unix kernel parameters. Thanks & Regards, DoubleH

Hi, In my application, someone has accidentally ran a db_create script which is supposed to remove all the db files and then create a new database. But, in between the db_create had failed saying problem in shmmax. So, if we change the kernel parameter to a higher value, will it work...

Hi, I have written the following scipt: sqlplus uname/pwd <<here spool txt select * from emp; spool off; here Now I don't want the query to appear in the spooled file.. How could I do it?..Is there any set _____ off???? And also I would like to make the column separator as | instead...

hi, i have a problem when i query a long data type in SQL plus running on Solaris. I am not able to get the full length of the data. Even after setting. sql> set long 20000... can anyone give me a solution. Thanks & Regards, DoubleH

Hi, I have deleted some 1 million records in a table. But I am not able to see any improvements in that particular tablespace. The number of free blocks are the same. The database is Oracle 7.3. Can someone help me out in this regard. Thanks & regards, DoubleH

Hai, I have to identify the session in which the application has logged on to the database. The problem is that client is JDBC client and so, i am not able to find out the key. For eg. if 100 application users have logged on, then how can i find out the session in which a particular application...

Hai, How to test for cartesian product in a view? Is there any tool available for that? Thanks, DoubleH