Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by DoubleH

  1. DoubleH

    Copying db2 table to Oracle database

    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...
  2. DoubleH

    Running Procedures in Parallel

    Hi, Try DBMS_JOB and schedule them. Thanks, DOUBLEH
  3. DoubleH

    Diff between Oracle 8i and Oracle 9i

    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...
  4. DoubleH

    Diff between Oracle 8i and Oracle 9i

    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
  5. DoubleH

    Loading a text file...automation

    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
  6. DoubleH

    Oracle 8i Health Check

    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...
  7. DoubleH

    ora - 24327

    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...
  8. DoubleH

    Retrive directory content.

    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
  9. DoubleH

    scheduling an update query , how

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

    scheduling an update query , how

    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
  11. DoubleH

    Is it possible to Classes12.zip with Oracle8.1.6

    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...
  12. DoubleH

    orbix client and ssl enabled visibroker server

    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...
  13. DoubleH

    A need to use VisiBroker and Orbix together. Is it possible???

    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
  14. DoubleH

    urgent : files missing

    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...
  15. DoubleH

    files & directories missing

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

Part and Inventory Search

Back
Top