Oracle Tag Directory

Browse Alphabetically:

Featured Oracle Questions

  • Large NQS_*.TMP files

    Hello,I am BI Developer/Consultant and i am currently cluless on the issues with large NQS_*.TMP files in OBIEE. I am currently on obiee - 11g - 11.1.1.7. I see that after selecting a dashboard report, a NQS_*.TMP file is created in...

    moehashim5 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'),...

    ITKE827,890 pointsBadges:
  • I am presently in Oracle apps Technical Consultant, If i learn OBIEE, what are the benifts to my future career? Is really it improves my career?

    Hi All,       I am currently in IT Industry as Oracle Apps Technical Consultant since last 3 years.       I have learn OBIEE (Admin and Presentations Services) and around 6 months work experiance in OBIEE (Admin and Presentation Services). Now, my confusion is is really help this way of...

    Prasadrm5 pointsBadges:
  • ORA-00979 error message in Oracle query

    In Oracle, I keep getting the ORA-00979 error message with my query. Here's what it looks like: 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)...

    ITKE827,890 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?

    ITKE827,890 pointsBadges:
  • ORA-01445: cannot select ROWID from a join view without a key-preserved table

    Hello, For the first time in my IT-life I've encountered following error message when I try to run query using ROWID on a view: ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table I found something about key-preserved tables, but I'm not sure that my...

    LukyFox25 pointsBadges:
  • ORA-12699: Native service internal error in Oracle 8i

    Hi, I am trying to pull the data from Oracle 11i to Oracle 8i with the help of DB link. It's stating that "ORA-12699: Native service internal error." I did in the Oracle 8i server file changes sqlnet.ora --> SQLNET.AUTHENTICATION_SERVICES= () I have executed the below listed commands:...

    Chidambaram5 pointsBadges:
  • ORA-01009: Missing mandatory parameter

    Dear Friends I have this script in the WHEN-BUTTON-PRESSED Button DECLARE LOC_FLAG NUMBER; BEGIN :IM_NEW_ITEMS.COLOR_CODE := TO_CHAR(NVL(:IM_NEW_ITEMS.COLOR_CODE,0)); :IM_NEW_ITEMS.SHAPE_CODE := TO_CHAR(NVL(:IM_NEW_ITEMS.SHAPE_CODE,0)); SELECT NVL(FIN_FLAG,0) INTO LOC_FLAG FROM IM_CLASS WHERE...

    MAY05659292714145 pointsBadges:
  • Getting a ORA-1403 AND 6512 on following script

    GETTING ORA 1403 AND -- This script will check indexes to find candidates for rebuilding. -- Run this script in SQL*Plus as a user with SELECT ANY TABLE -- privileges. set serveroutput on size 100000 DECLARE SQL_STR VARCHAR2(1000); vOwner SYS.ALL_INDEXES.owner%TYPE; /* Index Owner */ vIdxName...

    COBOL1115 pointsBadges:
  • Receiving Rep: 1401: cf titleformula fatal PL/SQL error occurred, ORA:06508 error

    Sir, I keep having problems with this error. Please help me find the solution: Rep: 1401: cf titleformula fatal PL/SQL error occurred, ORA:06508

    adilmehfooz5 pointsBadges:
  • What is normalization?

    Can anyone explain to me what is normalization?

    982750 pointsBadges:
  • OLTP in Oracle

    While using OLTP in Oracle 10g standard edition, does row level locking happen? What are its benefit?

    Akansha150 pointsBadges:
  • 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...

    ITKE827,890 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.

    ITKE827,890 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...

    ITKE827,890 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...

    ITKE827,890 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...

    ITKE827,890 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.

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

Following