• oraoledb non working WHERE clause character comparison

    Are there WHERE clause character comparisons that do not work when using oraoledb? I have a SQL query that is well formed and works with both Oracle 9 and Oracle 10g client, but will not execute when parsed via oraoledb.

    Jsl255 pointsBadges:
  • Oracle9i Release 1.0.2.2.2a Application Server Install – Enterprise Edition

    I am installing the Forms and Reports Server component only first. But it hangs when it get to 100% and it is saying "Installing Oracle9i Application Server 1.0.2.2.2a" It hangs after prompting a blank command line and it seems it is trying to run something. Here is the last line on the...

    Stecjohn15 pointsBadges:
  • run oracle 9i with Windows Server 2003 Domain Controller

    sir i have windows server 2003 server with DC.just want to install oracle 9i server on that server. and confiugre clinet on widows xp client side.i want to run oracle 9i client through domian user.is any setting or rights of domain user that the user will be able to run oracle application like SQL....

    Swapnesh15 pointsBadges:
  • Oracle ERP single signon using Active Directory

    We are on Oracle 9i and will like to implement a solution to allow Oracle ERP users to signon using Microsoft Active Directory. Thanks Thanks

    Morounfolu15 pointsBadges:
  • Oracle9i Performance Issue

    I got Oracle9i R2 database running on windows 2003. On a very busy day I got very bad performance with Average Disk Queue Length very high on the performance monitor. There is heaps of free RAM and I am running Raid 10. I am still new to Oracle, so I need some help. Thanks and regards.

    Stecjohn15 pointsBadges:
  • Plz tell something about FILE AUTHENTICATION

    How can we set up a file authentication in oracle9i?

    989986944515 pointsBadges:
  • Insert superscript text into Oracle database

    how can i insert superscript or subscript text to the data base i have colomn called measuments Units and i want to insert quadratic meter M2 or Cubing meter M3 am using oracle 9i pleeez help

    Rosealzubi115 pointsBadges:
  • upgrade from Oracle 9i to 10g

    I am trying to upgrade a copy 9i Production database to 10g. Using DBUA tool. After selecting the DB for the past 20 hrs the process is still running with no progress. Alert log has the message on MMNL. What are the possible ways to upgrade a 9i DB to 10g. Have followed the oracle docwith no...

    224453GL5 pointsBadges:
  • rep-002

    I am getting error "rep-002:Unable to retrieve a string from the report builder message file " while opening a existing report in Reports 9i...How to solve this?

    Yegneshv5 pointsBadges:
  • Linking sqlserver to oracle

    How do I create a link to oracle 9i form sqlserver I can tnsping oracle, I can connect via sqlplus, I can connect in odbc admin, I can connect via a udl, I can connect via ssis but I get ORA-12154: TNS:could not resolve the connect identifier specified when I try to set up a link in the management...

    Wgself65 pointsBadges:
  • Oracle 9iAS Components

    I have a Oracle9i AS release 1 server. how can I find out what components installed on this server? it was installed by someone ages ago. thanks and regards.

    Stecjohn15 pointsBadges:
  • Errors: Violation of UNIQUE KEY constraint ‘UN_FILENAME’. Cannot insert duplicate key in object

    when i am migrating data from oracle9i to SQL2005 i am getting the error Errors: Violation of UNIQUE KEY constraint 'UN_FILENAME'. Cannot insert duplicate key in object how should i solve the problem

    Lava5 pointsBadges:
  • oracle 9i instalation

    hello guys I have recently started learning SQL and I am trying to install 9i (database or software where I can practice SQL quires). Long time ago I started learning SQL on that time it was personal oracle7 I installed and used to do my practice...but now I have heard that you can install 9i on...

    11g5 pointsBadges:
  • update date value in oracle 9i

    What is the code to update a date value in oracle 9i from vb.net

    Venomwi5 pointsBadges:
  • How do I stop my VB6 application on a Windows2003 server using up all the connections on my 9i DB?

    The root of the problem seems to be w3wp.exe interacting with the 10g client we use to attach to the 9i DB (due for upgrade to 10g soon). I can't really change the VB component since it's also required to run on Windows2000 - which it handles with no problems against the same DB. Also can't upgrade...

    Alexanderph5 pointsBadges:
  • how can i resolve oracle error 00103

    I am getting the following error when running the below procedure from TOAD. I have ora 9i OS Windoes XP. CREATE OR REPLACE PROCEDURE SP_CALL_PROCEDURE22 (BUSINESS_UNIT1 in varchar2) IS CURSOR C1 IS SELECT BUSINESS_UNIT,VOUCHER_ID,INVOICE_ID,VENDOR_ID,GROSS_AMT FROM PS_VOUCHER WHERE BUSINESS_UNIT=...

    150919745 pointsBadges:
  • Oracle Data types

    I am just learning an ORACLE 9i Book and i was seen that in number Data type the Range is Lies between 1 to 38 in Decimal And -84 to 127 of Scale Range How it is possible because these Fraction degits are subtratect from whole degits ex:- var1 number (5,25);--------------(1)--it is possible? var2...

    Tejas5 pointsBadges:
  • RAID configuration for Oracle database

    Presently we have a 9iOracle database sized at approximately 50MEG on an HP-UX 11.11 server on a SAN. Our software app vendor is telling us that we should have the database on RAID 10 for better performance. They have done benchmarking with DB sized at what ours will be in the future. (Multi...

    Roadkill0 pointsBadges:
  • Export parameters TABLESPACES, TRANSPORT_TABLESPACE in Oracle 9i

    Do we need to set the parameters TABLESPACES, TRANSPORT_TABLESPACE to export table spaces and transportable table spaces meta data even when the parameter FULL = y. Please suggest me what to do for this case.

    Vini Chandamama100 pointsBadges:
  • performance and tuning examination guides

    What would you recommend as good study guides for performance and tuning 9i exam

    Cece5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following