Recent content by DoubleH

Hi, I know it is a bit late to answer your post.. But thought will post this... I know that in oracle you can database links that can refer to non-oracle databases. I am sure if that is possible, with the use of database link, copying the structure of the table and the data should not be a...

Hi, Try DBMS_JOB and schedule them. Thanks, DOUBLEH

Hi Musafa, Thanks for the quick and effective reply. I am wondering where would I find the docs. Do you have the oracle technet URL docs link that has a link to the differences between oracle 8i and oracle 9i on a programmers point of view. When I searched I could find only the differences from...

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, The best solution for your requirement is to write a stored procedure wherein you can use UTL_FILE and use your files and then call this stored procedure from your VB. Thanks & Regards, DoubleH

Hi, There are lot of ways by which you can do the health checkups of your database. You can calculate data hit ratio by querying the dictionary and make an analysis of your database usage. You can also check out the library hit ratio and the library cache access details, by which you will come...

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, You can use host commands directly by typing sql>host ls I am not sure of how to get the listing from the oracle directory. Thanks & Regards, DoubleH

Hi, As Sem had mentioned, also issue update on the column where column value is null. Thanks & Regards, DoubleH

DBMS_JOB will be a better solution for this problem. Using cron or at for updating one simple column is not necessary. Is it possible for you to give alter table command, then using that you can set the default automatically which will be the best solution for your case. Thanks & Regards, DoubleH

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, We are developing an orbix client for an ssl enabled visibroker server. The IOR that has been provided to us is having only one port. Can the Orbix2.3 connect to SSL enabled visibroker 4.5.1 version?. If so, please elaborate. Thanks in Advance, DoubleH Thanks & Regards, DoubleH

Hi, Regular users do not have write on that directory. Only root can do that. For examples some files are missing from /opt/local/bin in which only root can log in. Some other directories(like weblogic directories) are also missing for which the users have write access. But I checked the...

Hi, Some of the files under weblogic server. And some files from /opt/local/bin eg: metasend, splitmail, etc... Thanks, DoubleH Thanks & Regards, DoubleH