Helpforce provides free 24/7 online technical support

Hi!I've a strange (for me at last) performance problem.
I've two very similar tables FORM_TROUBLETICKET_9 and FORM_SERVICETICKET_4.
Because of this similarity I have somtimes to query the data in one of the two tables, somtimes I have to query the data in both tables. So I use a union all view FORM_XTICKET.
The thing is, that the same query is don within one or two seconds if performed on the table directly but lasts up to 10 minutes when performed on the view.
I've done an explain.... read more

I've lost some scripts that I used to create some rather complex views inOracle 8.1.7. How can I query the database to recover the original SQLsthat were used to create the views? Thank you for your help.

Platform - Oracle EE 10.2 on AIX 5.3 User complains that application runs fine on Monday but is slow byFriday. We think we have found an issue with OS i/o (MetaLink note271444.1 and related), but in getting there I took the usual route ofchecking the currency of the table stats. Selecting dba_tables for onOWNER and sorting on last_analyzed, we found that most of the tableshad been analyzed in the last six days, but they were in groups ...
some analyzed Apr 23, some Apr 24, etc. There was also.... read more

If inside a program I want to send multiple SQL statements inside asingle batch, how is this done inside a program? I'm using .Net and OracleDataAdapter to submit an OracleCommand.
Whenever I try to send multiple select statements I get an errorcomplaining the SELECT needs an INTO clause, or if I try multipleTRUNCATE statements I get an error complaining about a missing option.
I've tried using semicolons and forward slashes, but no luck.

I've been trying to create a partition at the end of a table & gotora-14074/ metalink advised I should use the split syntax but I can'tseem to get it to work Please find enclosed example SQL> ALTER TABLE DS_ORGANISATION SPLIT PARTITION START_DATE_2006 VALUESLESS THAN TO_DATE('01-01-2007', 'DD-MM-YYYY') TABLESPACE DSTPDATSML2; I am trying to add a partition ...does anyone have the rightsyntax/advisce? Thanks in advance for any help you can givecheersChris B PS Oracle is.... read more

Hi, We have a table like this: CUSTOMER_ID PRODUCT_ID FORMAT STATUS DATE_ADDED DATE_MODIFIED We also have a history table like this: CUSTOMER_IDPRODUCT_IDFORMATSTATUSSOURCEDATE_ADDED We want to put a trigger on the first table such that when a record isinserted or updated it will make the entry to the history table.
However, the problem is the 'SOURCE' column on the history table. Itis not present or needed in the first table.
Entries into the first table are done through a PL/SQL p.... read more

Hi, I'm new to Oracle so I thought someone here might be able to help me.
I'm trying to do a schema import using imp and i get the following inthe import log file (below). It looks like the like PLS-00201: identifier 'SYS.DBMS_LOGREP_IMP' must be declared is where the errorcascade begins. How do I declare 'SYS.DBMS_LOGREP_IMP' ? import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR characterset. importing EXMETA's objects into EXMETAIMP-00017: following statem.... read more

I recently installed my first Cisco ASA-5500 security box. It is avery impressive piece of equipment, with a bewildering array ofcapabilities. The feature that find most intriguing is that it goesabove (in the ISO/OSI sense) the IP, TCP and UDP layers, presumablyinspecting whether a message or packet contains a virus or othermalware.
What I would like to clarify, because is a matter of dispute amongsome colleagues, is exactly what applications and operating systemsare being inspected. My buddie.... read more

Hello, Always with my dataguard with oracle 10g...
Mays I ask you for two informations ? 1/ Is it possible to create the OEM console fa physical standby ? I have my production database create with the wizard. So the OEM console isautomaticaly created. With the service. (I'm under windows).
I make up my dataguard configuration manually. So the OEM console is notcreated. But I would like to pre-create a console If I realize a switchoveror if one day I haver to do a failover...
Is it possible .... read more

I need to perform queries on Oracle database from C/C++ program onSolaris. I have very extensive experience with C/C++ and MS Windows OSbut close to none with Solaris or Oracle. Our database adminstratortold me that we do not have any documentation, he does not know if wehave any C libraries for accessing Oracle database. The onlyinformation he provided me with is that we have Oracle version 9.2.0.7(Oracle 9i) and Solaris 10. Any help with where to get Oracle Clibraries (header and lib files) an.... read more

Hi, I have a 9i database on which I am trying to make a database connectionto a 10g database. Whenever I try to connect, I get an error saying: ORA-12645: Parameter does not exist.
I get the same error when trying to connect to the 10g database usingthe 9i sqlplus. Does anyone know if it is possible to create adatabase link from 9i to 10g, or is there a forward compatibility issuehere? Many thanks,Keith

Hi Steve, We are designing an application, at the heart of which is a very largetable expected to be of size 592 GB (493 GB Table and 100 GB index) atthe end of 7 Years after granular purging is employed. In terms ofrecords, the number of records is expected to be around 3.5 billion.
This is so because it is linked to a real time application which feedsreal-time data. The sample design of the table is such that it has thefollowing columns Dataitem_id Varchar2(50) Applicable_at date Gnt.... read more

Hi All, I am doing database programming using VB.Net and Oracle DB 8.1.7.
when there is command select ...into... in the following procedure,it doesn't insert anything and also no error return to the application.
When I comment those command, it does insert records even they arenull.
What's wrong with my select statement?I can select value when I run the command in sqlplus.
Anyone can have idea? Thanks in advanced.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++.... read more

Hi, This is weird. RMAN backs up our database each night and produces onefile, except last night it started generating more than one with weirdfile sizes: -rw-r----- 1 oracle oracle 732364800 Jun 29 03:18ora_06292009_NI00_13056-rw-r----- 1 oracle oracle 3815219200 Jun 30 03:44ora_06302009_NI00_13068-rw-r----- 1 oracle oracle 3570401280 Jul 1 03:38ora_07012009_NI00_13080-rw-r----- 1 oracle oracle 3692068864 Jul 2 03:46ora_07022009_NI00_13092-rw-r----- 1 oracle oracle 3912351744 Jul 3 0.... read more

All, I am encountering an issue with gathering stats from an OLEDBconnection when the stats to be gathered include a composite index. Ireceive the ambiguous OraOLEDB: ORA-03113: end-of-file oncommunication channel from the calling program and even if myanonymous block has an exception handler it is never fired. Below is asimple vbs script to replicate the problem. I am running Oracle9iEnterprise Edition Release 9.2.0.6.0 on Win2k with ADO v2.8 but havereplicated this using several other configu.... read more

eDiscover

Click the logo to go back to the main page

Databases

Search eDiscover

Categories