|
|
Browse by Tags
- 10G
- database
- Development database on Windows
- Enterprise Edition
- enterprise manager
- Enterprise Server 10g
- HP -UX PARISC 64bit
- Memory Fault
- ORA-03114: not connected to ORACLE - This may have corrupted data
- oracle
- Oracle Database Enterprise Edition
- ORACLE ENTERPRISE SERVER
- Pro*C
- Problem in running Pro*C reports
- Sever
- sqlplus
-
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... -
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... -
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... -
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... -
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... -
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... -
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... -
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... -
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... -
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...