Oracle
in [SQL]
|
Problems with Oracle Text (in Oracle 10g) Hi, I'm working on a project using Oracle Text, and wondering if it is possible display "relevant" parts of any documents returned by a search (in a similar fashion to Google). Heres a summary of what I have so far: CREATE TABLE news( news_id NUMBER, --Primary key: starts from "1" name VARCHA... 27 Jun 2008 12:08
ORA-27086: skgfglk: unable to lock file - already in use -> Instance "BOCHUM", status BLOCKED Was your cotrolfile DAMAGED ? Backup your control file and try to restart instance mv '/abl/apps/oracle/oradata/BOCHUM/control01.ctl' '/abl/apps/oracle/ oradata/BOCHUM/control01.bak' mv '/abl/apps/oracle/oradata/BOCHUM/control02.ctl' '/abl/apps/oracle/ oradata/BOCHUM/control02.bak' mv '/abl/apps/oracle/oradat... 1 Jul 2008 09:14
Fine tuning my queries ! Hi, My db has three columns : pool id, pool name and pool description 1. Pool id is unique 2. Pool name is always either suffixed by intl or core. But there is not formal constraint or foreign key relationships anywhere Given the pool id, I want to get back the pool descriptions for both the core and intl ver... 27 Jun 2008 13:10
ROWID, ROWNUM and views Here's some advice for you about the pseudo-columns ROWID, ROWNUM and their behaviour with views. * As a general rule avoid using ROWID espcially with complex views made up of multiple base tables where a DISTINCT clause is used. The DISTINCT clause will result in the SELECT statement with ROWID not returning an... 27 Jun 2008 18:19
Oracle ODBC scalability with increased user volumes Hi, We have an application that uses ODBC to connect our client application to an Oracle database. Currently we run at approximately 10-100 concurrent users with no major problem. A request has come in asking if the application would be able to support approximately 1000 concurrent users. My feeling on this is t... 27 Jun 2008 08:02
Need help: wio rease from 1% to more than 50% after increasing SGA size hi, we met problem with oracle8.1.7(on HP-UX) SGA tuning. The Oracle server runs on HP-UX11i. Previously, the server has 16GB RAM and 20CPU installed. The business data keeps increasing in past year which make us decide to install more RAM into server and more Cache into disk array. t... 28 Jun 2008 00:27
Louisiana Will Face Lawsuit If New Law Brings Religion Into Minulta on monelta suunnalta tiedusteltu, ett� ketk� on ne asiattomuuksia t�nne nettiin kirjoittavat kaverit, joista on tullut valtavasti valituksia heid�n �kyilless��n asiattomia ydinaiheisia materiaalejaan t�nne? No koska olen asian aina tienyt, niin voin kysyjille valaista pikkasen. Eli kyse on tosiaan TVO:n t... 26 Jun 2008 17:43
converting DB2 triggers to Oracle --CELKO-- wrote: I need to convert a bunch of DB2 triggers to Oracle. Is there any kind of tools for this? I think it would be more appropriate to ask this question in the Oracle group, but anyway ... A quick Google on "migration+db2+oracle+triggers" gives a couple of possible useful links on the very ... 27 Jun 2008 19:21
%rowcount on select into statements How could I find how many records has been passed by some select statement? for example, I have an select like: select sum(count(*) ) into retval from table1 where field1='1' group by field2, field3 having count(*)>1; so, I would like to have some like %RowCount attribute to find how m... 26 Jun 2008 17:43
query optimization Hi, One is been asked to me on query optimization and the question was, if you have to optimize a sql query which is dealing with 10 tables then tell me how will you go about. I cant use stored procedures. As I am not a DBA, I am a simple Java developer so I am not having any idea about this so I given a stupid a... 26 Jun 2008 16:41 |