in
All Tags » oracle 10g (RSS)

Browse by Tags

  • How to loop through the values

    How to loop through the values selected from my below query? For each PROD_FOLER_ID selected from the below SELECT query I want to execute the below INSERT statement. If my SELECT statement returns 3 values then it has to instert one row with prod_folder_id as nothing plus 3 rows with the returned values...
    Posted to Oracle (Forum) by software on 06-02-2010

  • ORA-31011: XML parsing failed

    Hi All, Thanks in advance for help me in this solution. Sample xslt code in merging two xml files are working on 9i but not on 10g. Can you help me on this.. Here is code.. ********************PLSQL code************** -- XML Parser for PL/SQL Example 5: PL/SQL -- xslsample.sql -- This file demonstates...
    Posted to XSLT (Forum) by software on 05-31-2010

  • Using Crystal Reports XI, Oracle 10g and Windows 7 64bit

    I recently upgraded to Windows 7, we using Oracle and Crystal Reports XI. I downloaded the 32 bit version of Oracle to avoid all the installer issues of Windows 7 (6.1 being too high for what oracle expects blah blah). I can connect to the database with no problems but am unable to connect to Crystal...
    Posted to 10.x (Forum) by software on 03-15-2010

  • Oracle, Oracle Enterprise Manager, Oracle 10g, Application Server Control

    Ok, difficult to word this in the best possible way....... Going into Oracle Enterprise Manager 10g - Application Server Control through this link http://oracle-oid:18100 Shows the list of System Components, which you can start, stop, restart, delete instance etc. Is it possible to schedule the restarting...
    Posted to 10.x (Forum) by software on 03-06-2010

  • Error  while creating a materialized view or refreshing any view.

    Hi, I am getting a strage error while creating a materialized view on Oracle database. We were able to create or refresh view earlier to this and there were no problems at all. But now when I try to create a materialized view on the database I am getting error like ORA-04063: package body "SYS.DBMS_LOGSTDBY"...
    Posted to 10.x (Forum) by software on 02-28-2010

  • Is compatible JDBC Oracle 10g with Engine Database 11g?

    Hi, Is compatible JDBC driver Oracle 10g with Engine Database 11g?
    Posted to 10.x (Forum) by software on 02-28-2010

  • sqlplus: command not found

    Hi, Im trying to connect to an Oracle database running on Red Hat, but I get the following message when trying to start SQL*Plus $ sqlplus -bash: sqlplus: command not found This is the first time Im trying to connect to the database. Could you help me/suggest a solution/reason why this is happening...
    Posted to Oracle (Forum) by software on 02-27-2010

  • Audit SYSDBA vs AUDIT_SYS_OPERATIONS

    Hi, I have audit_sys_operations=FALSE. However, in DBA_PRIV_AUDIT_OPTS I have the attached options for the SYSTEM account. So, my question is are the DBA activities being monitored or not? What would be the difference between both settings? Thanks. Code Snippet: 1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12...
    Posted to 10.x (Forum) by software on 02-22-2010

  • How to enable Auto tuning feature in Oracle 10g?

    How to enable Auto tuning feature in Oracle 10g? Which is the parameter in init.ora file to be added?
    Posted to 10.x (Forum) by software on 02-17-2010

  • How do I resolve ORA-00132: error

    I tried starting up my development database and got the following error: C:\>sqlplus "/as sysdba" SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jan 8 11:33:33 2010 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to an idle instance. SQL> startup ORA-00119: invalid...
    Posted to 10.x (Forum) by software on 02-15-2010
Page 1 of 27 (267 items) 1 2 3 4 5 Next > ... Last ยป