• 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 i will find the duplicate rows count from employee table in oracle9i.

    how i will find the duplicate rows count from employee table in oracle9i.

    gettosrinivas35 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 9i Support

    Hi, Can anybody please let me know that how long Oracle Corporation will support Oracle 9i database? Regards, Satyajit

    Choton5 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:
  • Report taking long time before opening

    Hi All We are running Oracla based ERP solution. 9i , D2K and JVM. Everyday after 6 PM all the reports are taking long time before opening I am using HP Proliant DL 380 G5 server with 2 GB RAM having 2 partitions . C mirrored 2 x 72 GB SAS HDD. D drive with 4 SAS 72 GB HDD RAID 5. Wetried changing...

    Vksumanlal5 pointsBadges:
  • error in reunnig sql plus

    when runnig sql plus of oracle 9i,after giving puser id and password protocol adapter error is there..iused both id an pw i.e. system and manager or scott/tiger

    Krshah5 pointsBadges:
  • ORA-27101 error when migrating Oracle 9i to AD domain

    We are running Oracle 9 on a Windows 2003 box. We moved the server from a Windows domain to an AD domain. We then get an error messages looking like this: ORACLE not available ORA-27101 When we back out of the changes, everything works fine again. Any ideas? Thank you.

    OracleATE190 pointsBadges:
  • Windows 2003 ENterprise edition with Oracle 9i . And there are 32GB RAM in the server

    We use Windows 2003 ENterprise edition with Oracle 9i . And there are 32GB RAM in the server. The 32GB RAM is recognized by the server with Win2003 in ‘properties’. My question is a) whether the 32GB RAM is recognized with Oracle 9i ? If not ,how can I do ? b) How can I notarize how many RAM is...

    JasonTan5 pointsBadges:
  • Migrating data from Oracle 9i Database to SQL Server 2005

    I would like to migrate the data from all used-defined tables in Oracle 9i Database to SQL Server 2005. I know of options like Linked Server, SSIS, SSMA for Oracle and BCP. Which amongst these is the best way to achieve data migration?

    SQL Server Ask the Experts2,585 pointsBadges:
  • what is the best STORAGE solution for ORACLE db – SAN or NAS ?

    one of my project is very critical for the client . the application will run in 10 different sites . the infrastructure of each site will be : 4 linux servers (2 for ORACLE DB , 2 for websphere) + 1 linux/win server for backup software + DB oracle (~100GB) + storage. i have a very good experience...

    Mhonmhon0 pointsBadges:
  • Windows 2003 Datacentre 32 bit with Oracle 9i 32 bit

    We have procured an application for archiving of reports. Initially we were suggested to go for Windows 2003 ENterprise edition 32 bit (R2) with Oracle 9i 32 bit. After about 1 year of rolling out, we found that application became very slow. To enhance the room for memory, we went for memory...

    KGA5 pointsBadges:
  • Installing oracle 9i

    is it possible to install qracle 9i on a windows 2003 environment

    Rr2424185 pointsBadges:
  • How to switch to IMP/EXP Utility of multiple installs of Oracle on same client?

    I have installed Oracle 9i and Oracle 10g on one Windows XP machine and two Oracle homes were successfully created - as i can switch between them using the Home Selector. I then tried the same install on another box with Windows XP, but when I use the Home Selector I get a message telling me only...

    OracleATE190 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