• oracle error

    Hi, pl respond urgently The following error has occured while executing a package. The following error has occurred: ORA-21000: error number argument to raise_application_error of -6508 is out of range ORA-06512: at "ECW_LOADER.CREATE_CTL_RANGES", line 154 ORA-06512: at line 19

    Satyam1230 pointsBadges:
  • Deleting duplicate rows based on timestamps

    Hello.. I'm quite new to MYSQL.. I have a table with two fields : tag_in and time_in, where time_in is a timestamp field.. Some rows have the same value for tag_in.. I'd like to neaten up the database in 2 ways: 1. Delete rows with duplicate tag_in but removing the one with the oldest timestamp...

    Amateur20050 pointsBadges:
  • Database Upgrade

    1) I am migrating a database to 10G (from 9i) to a new server. The database is the backend for Forms and Reports (currently running 9iAS). How will moving the database to a new server, and upgrading, affect the current application server environment? Other than changing the TNS entry on the web...

    CBarton0 pointsBadges:
  • What is wrong with my code?

    Posed on behalf of SearchOracle member Deepa: Question: How can I get a oracle database connection? Here is a code to which accepts username and password and checks for validation. is it correct? Pls tel me import javax.servlet.*; import javax.servlet.http.*; import java.io.*; import java.util.*;...

    Margaret Rouse3,160 pointsBadges:
  • Need help with max function within a left outer join

    I need to search for a max timestamp of a column within a left outer join statement. I have tried many different combinations unsuccessfully.

    Sfss10230 pointsBadges:
  • Oracle Hash Partitioning.

    Hi, In Oracle hash paritioning do we have control over hash value based on which partitioning is done? My issue is - We have to make a design for datawarehouse application and in the landing area we are planning for range-hash partitionining based on the keys (and their volumes). Now, if we use...

    Techanalyst100 pointsBadges:
  • EMCA

    When trying to start EMCA I get the error message 'couldnt set locale correctly' also is it better to let EMCA build the database or should I do it.

    Gypsydavi0 pointsBadges:
  • ORACLE

    HOW CAN I MOVE DATA FROM EXCELL SHEET INTO ORACLE DATABASE TABLE

    Abcd1234110 pointsBadges:
  • blocking session

    hi i am new to oracle and i have a question that if a user session that is blocking other sessions and processes from accessing the oracle database so how we can overcome this problem?Could you please explain with example by using a sql command if you can. Would really appreciate. Regards Obaid

    Obaidiqbal0 pointsBadges:
  • 9i and 10g installation on the same server

    i have 9i installed on windows 2003 server. what i need to do is to install 10g on the same server as well. so, i'd like to know if there would be any difficulties if i do so. they both have to be able to run side by side.

    Kilroywashere0 pointsBadges:
  • Installing Oracle 10g on an external USB drive

    I have asked this question before but got no reply. I hope I have better luck this time. I have an external USB hard drive which I can plug into either of my two PC's. I would like to install Oracle 10g on the external USB hard drive and be able to access/use it from either PC. How do I go about...

    GunnyT0 pointsBadges:
  • Oracle 8.1.7 Rman commands

    I am trying to run Oracle 8i Rman and cannot find any explanation for the Rman command line. I can connect to the recovery catalog and the target and by using some examples of Rman run commands I can do certain things. But I need to know the commands?.. When I get an error saying Rman found THIS...

    IMSDBA0 pointsBadges:
  • Why do IT projects fail?-2

    Hi, I'm a Computer Engineering at CSU Chico. I'm conducting a research paper on "Why IT Projects Fail". If someone could give me an example of a failed projects, "failed" meaning that it didn't get finished on time, or the final project did not meet the requierments. Also if you could give a quick...

    Dbrazeau10240 pointsBadges:
  • Oracle 10G tuning statements

    Do you know of any new tuning techniques, or things I should be aware of that have changed in version 10G in terms of tuning SQL or PL/SQL statements? Thanks.

    Techiecat0 pointsBadges:
  • AMD vs INTEL….?

    Hi all, I`ve been a AMD fan as long as i know but i have a few questions for everyone! If INTEL`s chip specifies Pentium 4 3600(800FSB 1MB)LGA 775Pinn the we all know its 3.6GHZ! But Now WHY when we get to AMD specification of chipset : AMD Athlon64 ? 4000+ (PIB) 2.4GHZ, 939-Pin Processor (128 L1 +...

    Wazzup0 pointsBadges:
  • ORA-04098: trigger Trigger Name is invalid and failed re-validation

    Hi, I compiled the trigger in DB and tested it thru online application checkout. It worked fine. However, latter, users received an error in production environment as "ORA-04098: trigger <Trigger Name> is invalid and failed re-validation". Is it possible that compiled trigger object go...

    Pitreab0 pointsBadges:
  • AutoUpgrade error: ORA-04063: package body “APPS.AD_UPGRADE_VALIDATE” has errors

    RDBMS Version: 9.2.0.6 Operating System and Version: Windows 2003 Error Number (if applicable): ORA-04063: package body "APPS.AD_UPGRADE_VALIDATE" has errors We are upgrading oracle database to 9.2.0.6 and apps from 11.03 to 11.5.10. while running autoupgrade, we are getting the following error:...

    Ramana0524580 pointsBadges:
  • ASP with Unicode records -

    Has anyone displayed unicode records from sql server on web browser thru asp. my static strings are getting displayed fine but data from sql server shows junk like this....."???" any page directive needed in asp declartions? i am using utf-8 as meta content type

    Shalininiccoal0 pointsBadges:
  • Enabling Java in Oracle 8.1.7 – ORA-29540

    I got the error below while trying to UTL_SMTP package to send e-mail: ORA-29540: class oracle/plsql/net/TCPConnection does not exist Apparently my Oracle 8.1.7. db is missing some Java classes. Can someone tell me how to enable Java in 8.1.7?

    Oadegoke0 pointsBadges:
  • Synchronization of application servers

    hi all my company has about 30 application servers,so when i want to install something i have to do it on 30 servers which is very time consuming.due to this I Need a way to update all application servers using a single installation routine. can someone help please

    Eduado0 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