Oracle

Standby Asking for archive that is older then standby
I restored a cold backup and standby control file from 6/26. When I recover it's asking for an archive file from 6/21 even though the database was restored from a cold backup on 6/26. Our cold backup performs a checkpoint and logfile switch prior to taking the DB down for cold backup. ... 27 Jun 2008 22:25

Attach & detach tablespace
Hello In SQLServer I detach from one server and then attach it to another server. Is something like this possible with Oracle ? thanks Sunit ... 27 Jun 2008 20:22

Analytics question maybe - combine over lapping date rows
On Oracle 10G, lets say I have a table that looks like this: create table t1 (key varchar2(10), start_dtm date, end_dtm date); and I have data some of which over laps: insert into t1 values ('1234', to_date('01/01/2001', 'DD/MM/YYYY'), to_date('30/03/2001', 'DD/MM/YYYY')); insert into t1 values ('1234', to_d... 1 Jul 2008 14:23

Tree walking ordering at top of tree
Hi I have the following query against the table create table employees ( id number, manager_id number, name varchar2(100)); select e.id,lpad(e.name,length(e.name)+(level-1)*2,'-') from employees e start with e.id in (select e2.id from employees e2 where e... 1 Jul 2008 05:08

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