Oracle Tag Directory

Browse Alphabetically:

Featured Oracle Questions

  • ORA-00604: error occurred at recursive SQL level 1 ORA-01555: snapshot too old: rollback segment number 0 with name \

    I am getting this error in my system: ORA-00604: error occurred at recursive SQL level 1 ORA-01555: snapshot too old: rollback segment number 0 with name. How can I resolve this issue?

    chethanhb5 pointsBadges:
  • Oracle licensing: I need the documents related with the file F0092

    Needs to identify named users in JDE World and One World to ensure compliance with Oracle Licenses. A user may have multiple profiles in multiple environments which in Oracle's eyes would be counted as one named user We are looking at using the following fields to capture a unique identifier that...

    Bhuvanendar5 pointsBadges:
  • ORA-01000: maximum open cursors exceeded

    I'm getting the ORA-01000: maximum open cursors exceeded in one XML. How do I resolve this? All result set and statements are closed in finally block.

    Nikhitasuresh5 pointsBadges:
  • Getting ORA-00904 error message when writing an inner JOIN query

    I'm pretty new to Oracle and I'm trying to write an inner JOIN query, like this: SELECT Employee.EMPLID as EmpID, Employee.FIRST_NAME AS Name, Team.DEPARTMENT_CODE AS TeamID, Team.Department_Name AS teamname FROM PS_TBL_EMPLOYEE_DETAILS Employee INNER JOIN PS_TBL_DEPARTMENT_DETAILS Team ON...

    ITKE351,905 pointsBadges:
  • Getting ORA-00905 error message: Missing keyword

    I've been trying to do a SELECT INTO using Oracle. Here's my query: SELECT * INTO new_table FROM old_table; But I keep getting this error: SQL Error: ORA-00905: missing keyword 00905. 00000 - "missing keyword" Has anyone seen this before? If so, what should I do? Thank you very much.

    ITKE351,905 pointsBadges:
  • Getting ORA-02436 when checking a constraint in Oracle

    I've been trying to check the following constraint but Oracle keeps returning an error. Here's what I have so far: ALTER TABLE Table1 ADD (CONSTRAINT GT_Table1_CloseDate CHECK (CloseDate > SYSDATE), CONSTRAINT LT_Table1_CloseDate CHECK (CloseDate <= SYSDATE + 365)), CONSTRAINT...

    ITKE351,905 pointsBadges:
  • Getting ORA-00979 error message with Oracle query

    In my query, I keep getting the ORA-00979 error message: SELECT cr.review_sk, cr.cs_sk, cr.full_name, tolist(to_char(cf.fact_date, 'mm/dd/yyyy')) "appt", cs.cs_id, cr.tracking_number from review cr, cs, fact cf where cr.cs_sk = cs.cs_sk and UPPER(cs.cs_id) like '%' || UPPER(i_cs_id) || '%' and...

    ITKE351,905 pointsBadges:
  • Getting ORA-06508 error message: PL/SQL: could not find program unit being called

    I'm currently using Oracle 10g and Toad 11.5. I'm trying to call an API from an anonymous block. So when I recompile the API after adding "DBMS_output.put_line" and then execute the block, I keep getting this error: "ORA-06508: PL/SQL: could not find program unit being called". But when I end the...

    ITKE351,905 pointsBadges:
  • Best practices of RAID configuration of StorEdge HDS 9960 and Oracle 10g R2

    Hello, what are the best practices of RAID configuration of HDS 9960 storage and Oracle. Currently we are using now Mirroring RIAD 1+0 with 4 disks (2+2). Will the second option of Mirroring 4+4 give us better performance than 2+2 disks? Thanks in advance. P.S. the Oracle instance is OLTP.

    Donpatrona5 pointsBadges:
  • Getting ORA-01008 error message: Not all variables bound

    I've only used Oracle several times but I'm having trouble understanding why I'm getting this error. I've been using Oracle's ODT.NET with C# with the following code in a query's WHERE clause. WHERE table.Variable1 = :VarA AND (:VarB IS NULL OR table.Variable2 LIKE '%' || :VarB || '%') AND (:VarC...

    ITKE351,905 pointsBadges:
  • Getting a ORA-12514 error message: TNS:listener does not currently know of service requested in connect descriptor

    I have an application that's running locally (through Oracle 11g) for the past week and it's been working fine. However, I'm now getting this: ORA-12514 TNS:listener does not currently know of service requested in connect descriptor error. I've already tested the connection with TNSPing which...

    ITKE351,905 pointsBadges:
  • Getting ORA-011033 error message: Oracle initialization or shutdown in progress

    I've been trying to connect to an Oracle user through TOAD or Oracle Enterprise Manager but I keep getting this error: ORA-011033: ORACLE initialization or shutdown in progress What should I do here?

    ITKE351,905 pointsBadges:
  • How do I solve the ORA-00933: SQL command not properly ended error message?

    For the past few weeks, I've been using an OLEDB provider for ADO.NET connecting to an Oracle database. Currently in my loop, I'm doing this insert: insert into ps_tl_compleave_tbl values('2626899', 0, TO_DATE('01/01/2002', 'MM/DD/YYYY'), 'LTKN', 'LTKN', '52', TO_DATE('01/01/2002', 'MM/DD/YYYY'),...

    ITKE351,905 pointsBadges:
  • Oracle: How to string to date with milliseconds

    I'm trying to convert the following string to date in Oracle: 2004-09-30 23:53:48,140000000 I've already using this: to_date('#', 'YYYY-MM-DD HH24:MI:SS,FF9') But I keep getting this error message: ORA-01821: date format not recognized. Would anybody have a suggestion on what I should do here?

    ITKE351,905 pointsBadges:
  • How can I resolve the ORA-30926 error in Oracle?

    In Oracle, I keep getting this error message every single time I run a query: ORA-30926: unable to get a stable set of rows in the source tables Here's the query as well: MERGE INTO table_1 a USING (SELECT a.ROWID row_id, 'Y' FROM table_1 a ,table_2 b ,table_3 c WHERE a.mbr = c.mbr AND b.head =...

    ITKE351,905 pointsBadges:
  • Receiving ORA-00918 error when running SQL query

    In Oracle, I keep getting this ORA-00918 error: Column ambiguously defined when I'm running this SQL query: SELECT * FROM (SELECT DISTINCT(coaches.id), people.*, users.*, coaches.* FROM "COACHES" INNER JOIN people ON people.id = coaches.person_id INNER JOIN users ON coaches.person_id =...

    ITKE351,905 pointsBadges:
  • Getting ORA-01882 error when accessing Oracle database through a Java application

    I've been trying to access an Oracle database through a Java application but when I try to run the app, I keep getting this error: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found Anyone have an idea on what I should do here?

    ITKE351,905 pointsBadges:
  • Receiving ORA-01033 error message on Oracle 11g

    I recently installed Oracle 11g on Windows 7 and everything has been working great. But now I keep getting this error message: ORA-01033: ORACLE initialization or shutdown in progress. I've tried to figure it out but I'm still getting the error. I tried connecting as "SQLplus sys/sys as sysdba" but...

    ITKE351,905 pointsBadges:
  • Error installing linux on Dell Poweredge 2950

    I'm trying to install Novell Linux OS on a  Dell Poweredge 2950 server. 64-bit with raid and sas drives but i am getting a "no hard disk found" error

    ITKE351,905 pointsBadges:
  • ORA-01722 invalid number where clause in update statement. I want to log this error in error log table

    Oracle ora-01722 invalid number where clause in update statement. I want to log this error in error log table. How can i log?? Below is my Update statement, here empid is number. UPDATE SARVESH_TEST_ERR_TB SET empid = empid WHERE empid ='aaa' LOG ERRORS INTO SARVESH_ERR_LOGS_TB ('Error while...

    sarvesh02025 pointsBadges:

Browse Alphabetically:

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