15/02/2019 11:47
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

1 answersclick here to view

14/02/2019 11:47
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.

2 answersclick here to view

13/02/2019 11:47
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

2 answersclick here to view

12/02/2019 11:47
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.

2 answersclick here to view

11/02/2019 11:47
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

2 answersclick here to view

10/02/2019 11:47
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

4 answersclick here to view

09/02/2019 11:47
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

1 answersclick here to view

08/02/2019 11:47
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

3 answersclick here to view

06/02/2019 11:47
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

6 answersclick here to view

05/02/2019 11:47
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

1 answersclick here to view

04/02/2019 11:47
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

1 answersclick here to view

03/02/2019 11:47
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

6 answersclick here to view

02/02/2019 11:47
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

3 answersclick here to view

01/02/2019 11:47
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

4 answersclick here to view

31/01/2019 11:47
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

5 answersclick here to view

eDiscover
Helpforce eDiscover provides technical articles updated each day
Click the logo to go back to the main page
Databases

Helpforce eDiscover RSS feed contains the latest technical articles in RSSWe have a vast archive of technical informationA database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality in a way that supports processes requiring this information. This category deals with general databases and more specific vendor products such as MySQL and Oracle.

Search eDiscover
  
Categories

Click an icon to go to that category

Helpforce eDiscover contains articles about Microsoft Windows Helpforce eDiscover contains articles about Apple products and MacOS Helpforce eDiscover contains articles about Linux and POSIX operating systems Helpforce eDiscover contains articles about Helpforce Helpforce has a large variety of technical information and articles for you to read Helpforce eDiscover contains articles about databases, MYSQL, SQL Server Oracle Helpforce eDiscover contains articles about Java, JVM and the JRE Helpforce eDiscover contains articles about the QNX operating system Helpforce eDiscover contains articles about Oracle Solaris and Open Solaris Helpforce eDiscover contains articles about RISC OS, Acorn and the BBC Micro Helpforce eDiscover contains articles about Amiga and AmigaOS