All Tags » 10.2.0.4 (RSS)

Browse by Tags

  • XML parsing

    Hi I am trying to parse the data from XMLTYPE value. Below is the xml file which I have loaded. Now I am trying to select data from the XML type using below query but I am getting error. Can you please help. SQL> SELECT a.xml.extract('//xdp:xdp/xfa:datasets/xfa:data/Email2Inv/text()').ge tStringVal...
    Posted to PL / SQL (Forum) by software on 02-14-2010
  • Urgent

    Dear Sir, One of our very important client, was using 8.0.4 database on HP-UNIX.They were compling the Pro*c reports .They are getting a perfect output report.Recently, we have migrated the old database to New 10.2.0.4 database on a new RHEL 5 Server. we have compiled the old Pro*c reports successfully...
    Posted to HP-UX (Forum) by software on 08-16-2009
  • Oracle Directory Object

    Hi, I am trying to use data pump to extract data locally to my pc from an Oracle db that runs on unix. My app user (Prod_app) has create any directory priv and I was able to create a directory (c:\). I can view this directory in dba_directories and it is owned by SYS. select * from dba_directories where...
    Posted to 10.x (Forum) by software on 06-30-2009
  • ORA-03114: not connected to ORACLE - This may have corrupted data

    We have a client and server that has been upgraded to Oracle 10.2.0.4. When we run an application after a while it crashes. (The crashes are as frequent as 5 times a day.) The error in the logs is ORA-03114: not connected to ORACLE - This may have corrupted data We have checked our firewall as in the...
    Posted to 10.x (Forum) by software on 06-26-2009
  • sqlldr simple csv file into Oracle exisitng table

    Guys I would like a simple csv file to be uploaded into oracle database using sqlldr my table CREATE TABLE DEL_MANAGER_TAB (DELIVERY_ID varchar2(20), CASE_ID varchar2(255), APPLIED_BY varchar2(20), DATE_ENTERED DATE, COMMENTS varchar2(255)) I want to use sqlldr I am using the followijng control file...
    Posted to Oracle (Forum) by software on 06-23-2009
  • Recommended patches for Strm

    Hi We have configured streams on 10.2.0.4. We do not have RAC environment. We got a list of patches that are recommended for Oracle streams. 6915767, 6134664, 7263055, 7033630, 7480651, 7363767, 5933656 1. If we upgrade from 10.2.0.4 to 10.2.0.5 do we cover all this patches or not? 2. What would be the...
    Posted to 10.x (Forum) by software on 06-23-2009
  • Resizing a Tablespace When Data Beyond the RESIZE Value

    Hello, I have a Big File Tablespace (BFTS) that I created on the large size to ensure an import could be accomodated OK. After this process I want to reclaim the excess space but when I try to resize it in EM (dbconsole) or from SQLPlus I get the message: "Failed to commit: ORA-03297: file contains...
    Posted to Oracle (Forum) by software on 06-15-2009
  • ORA-01843: not a valid month

    Hi when I try to execute a procedure which will select data from table1 and move data to table2 I am getting this error message ORA-01843: not a valid month NLS_DATE_FORMAT - DD-MON-RR NLS_DATE_LANGUAGE - AMERICAN below is the sample code. The problem is the DOB is not getting updated and inserted into...
    Posted to Oracle (Forum) by software on 06-12-2009
  • ORA-29344 Owner validation failed when importing transportable tablespaces using impdp

    I wanted to move our database from Windows 32-bit to AIX 64-bit, both running Oracle 10.2.0.4.0 using transportable tablespaces method and expdp/impdp tools. I did everything I suppose to (we have tested this method before on smaller databases) and I've ended with following error when importing tablespaces...
    Posted to 10.x (Forum) by software on 06-11-2009
  • How to recover an Oracle 10.2 db from a cold backup on Win XP

    I have an Oracle database on my local Windows XP machine that I use for development and testing. Up to now, I have done regular exports of selected schemas for backup purposes. Even though I have managed to automate this over the years, I still find it a bit tedious. It would be much easier to simply...
    Posted to 10.x (Forum) by software on 06-11-2009
Page 1 of 2 (16 items) 1 2 Next >