With rule-based it was quite easy: you made sure an index on that column was used and the results returned in the desired order, immediately. But if...

Frank Bergemann

01-14-2011 01:59 AM
Gerard H. Pille

Dear group, We are using Oracle 10g on linux RAC with 4 nodes. We have a small table, no more than 300 rows, but most people will...

charles

01-13-2011 04:14 AM
Jonathan Lewis

I have a SR priority 2, ORA-07445. SR Number is 3-2695873331. They haven't responded in five days. Look at this: Update from Customer 10-Jan-2011...

Mladen Gogala

01-11-2011 09:29 PM
Mladen Gogala

I started the sqlplus through : http://homer:5560/isqlplus/ but did not opened . I tried : oracle @ Homer /export/home/oracle/database>lsnrctl...

happy

01-10-2011 11:10 AM
joel garry

malargeetha20119159686702 (AT) gmail (DOT) com

geethu

01-10-2011 07:52 AM
geethu

This is happening at a 2 node windows 2003 rac with 96G ram (free ram about 70G) Release of grid infrastructure is 11.2 Database 10.2.0.5. When too...

HansP

01-06-2011 06:40 PM
John Hurley

If it is to double your income next year then explore working on Part Time, Freelance, Virtual ERP Assignments,Work in Surplus Time and Earn upto...

ERP Expert

01-03-2011 06:04 PM
John Hurley

Hi, Some one could tel me ? Sometimes a user account is locked and I do not know why? Can someone tell me how to log the lock? thank's

eliot06

12-31-2010 10:48 AM
joel garry

I have a query that returns results like this: Month Agent Cases Worked ---------------- ----------- ----------------------- Sept ...

master44

12-30-2010 12:57 PM
Mark D Powell

Joel: # Now even though management is entirely unwilling to give Oracle any more money than they have to, my immediate management does...

valigula

12-30-2010 12:06 PM
Mladen Gogala

Hi, Please find the all open SAP requirements and let me know on which you are interested and fit. In case you are not available please forward this...

amit

12-27-2010 12:23 PM
joel garry

We are trying to add a new node to our existing cluster. The new node has 4x8c, while the existing ones have 4x4, definitely different chip...

charles

12-25-2010 10:37 AM
onedbguru

http://forums.oracle.com/forums/thread.jspa?threadID=2148417&tstart=0 I hate being teased ;-) jg -- @home.com is bogus. Coffee doesn't believe that...

joel garry

12-23-2010 05:02 PM
Matthias Hoys

Hi, Oracle Version:10.2.0.4 Solaris 5.10 I have a materialized view that is associated with a table and is updated on COMMIT. When we update the...

z1hou1

12-22-2010 05:14 PM
z1hou1

I've got non-partitioned table which I have to move to partitioned table. I've decided to move it to hash partitioned table with 16 partitions. It is...

Micha³ Jab³oñski

12-18-2010 01:15 PM
Micha³ Jab³oñski

hopefully goodbye to cursor: pin S wait on X.

bdbafh

12-15-2010 10:50 PM
bdbafh

h/t actual oracle person posting on oracle-l: http://www.oracle.com/go/?&Src=7027600&Act=54&pcode=WWOU10044054MPP047 jg -- @home.com is...

joel garry

12-15-2010 07:34 PM
HoneyMonster

ORAERP - The Knowledge Center for Oracle ERP Professionals - Looking Beyond the Possibilities http://www.oraerp.com

oraerp.com - The Knowledge Center for Oracle ERP Professionals - Looking Beyond the Possibilities

12-15-2010 07:20 PM
John Hurley

Hi, Is there a way, on 10g and 11i, to create a set of 4 tablespaces, each of which is set to autoextend, so that the entire set of tablespaces has...

if_investor@yahoo.com

12-13-2010 08:57 PM
onedbguru

On Dec 10, 2:20*am, "Preston" <dontwant... (AT) nowhere (DOT) invalid> wrote: lol, I can imagine the naming you'll have 14 years from now with...

HoneyMonster

12-13-2010 12:15 PM
joel garry

I am using new_time to convert US EDT to GMT. Currently there is a difference of 5 hours between EDT and GMT; but Oracle function shows difference of...

zigzagdna

12-12-2010 05:47 PM
John Hurley

if i don't have access to create a trigger, but can add/drop/alter tables. is there a way to define an automatic column (by sequence) in the create...

fel0niousmonk

12-09-2010 09:58 PM
Mladen Gogala

All mainstream and most alternative media on the internet are tightly controlled, to get real info from real alternative sources watch this video in...

Maxxy

12-09-2010 03:23 PM
Maxxy

Mladen Gogala wrote,on my timestamp of 5/12/2010 8:33 AM: You mean Larry will go for another plastic surgery "stretch"? ;)

onedbguru

12-08-2010 09:27 PM
Noons

Hi, I hope this is the right place to post this, if not, I apologize. I am a UNIX admin who'd like to learn installing Oracle on Sun Cluster 3.3 as...

Rick Smith

12-08-2010 09:26 PM
Rick Smith

Hi, i have a performance problem for distributing selected data to parallel pipelined functions. The worker-threads are started with huge delay,...

Frank Bergemann

12-08-2010 01:06 PM
Frank Bergemann

Suddenly I can't open any of my physical standby databases read only. Alert log snippet and trace files follow post. I'm running 9.2.0.1.0 on all...

Myles

12-08-2010 11:00 AM
joel garry

Hi all, Environment Various applications that use jdbc connection pool: WebLogic 8 (and higher) and Tomcat 6 application servers, various versions...

Radoulov, Dimitre

12-07-2010 12:21 PM
Radoulov, Dimitre

Hi, I have the following problem The update is very long (more than 4 hours) table T_SUBJECTVISITFORMITEMS is 3M rows How can I do that more...

bob123

12-06-2010 11:18 AM
joel garry

======================= please see this code sample: ======================= drop table parallel_test; CREATE TABLE parallel_test ( id ...

Frank Bergemann

12-04-2010 01:12 PM
Frank Bergemann

Hi, Any experiences on Oracle's Goldengate on long-time-no-response - replication ? We have a case where several databases are not accessible for a...

eh

12-02-2010 05:12 PM
phil_herring@yahoo.com.au

On Wed, 01 Dec 2010 10:59:54 -0800, joel garry wrote: Install Text::CSV from CPAN. You can do that by invoking "cpan" and typing "install...

Mladen Gogala

12-01-2010 09:36 PM
Mladen Gogala

Q= What is the firing sequence in oracle forms of the below triggers: - On-Insert - On-Delete - On-Update when in forms, we insert, delete and...

Sonal

12-01-2010 12:23 PM
joel garry

Hi I have created a traditional physical standby instance from a hot backup using a standby controlfile etc. from the primary db (10.2.0.4). Not...

Johne_uk

11-28-2010 08:09 PM
Pratheep

Description I am looking for a simple oracle SQL query to compare results of two select statements, and write result to text file. (I am open for...

Mubashir

11-27-2010 12:50 PM
Mladen Gogala

Hello It must be an obvious thing I can't see because it's late Friday afternoon... Why does the last request return nothing ? SQL> insert into...

Syltrem

11-26-2010 08:21 PM
Syltrem

Hi, I wanted to know what oracle database startup time depends on? Does size of database matter or it is constant on the same machine?

alex123

11-26-2010 12:03 PM
joel garry

salaaaam frndzz bohat se log google adsense account banate hain lakin domain ka error aa jata hai or log batate b nahi hai k kyun ata hai or kuch...

poma jani

11-25-2010 07:31 AM
poma jani

salaaaam frndzz bohat se log google adsense account banate hain lakin domain ka error aa jata hai or log batate b nahi hai k kyun ata hai or kuch...

poma jani

11-25-2010 07:29 AM
poma jani

I have one for my local user group in January that can perhaps be cleaned up and then might be useable in OOW 2011. ( Looks like too late for Hotsos...

John Hurley

11-24-2010 04:17 PM
BicycleRepairman

Hi, what is the general rule about calculate statistics on the dictionnary in 9i and 10g ? Thanks in advance

bob123

11-24-2010 02:26 PM
bob123

Gartner says social computing to change the face of IT and business Gartner has identified the impact of social media as one of four broad trends...

JTP PR

11-21-2010 06:17 AM
JTP PR

Hi, I need to import a 20 MB mysql 5 dumpfile, It includes create table and data. The target db is XE - which maybe makes it harder? Any ideas? Much...

syd_p

11-18-2010 06:26 PM
onedbguru

Joel: # I must say, I came to the conclusion long ago linux was incompatible with commercial interests - and certainly my personal desktop interests...

Jack

11-18-2010 03:14 PM
Jack

Hi, I found many posts about this problem, but didn't find a simple answer. I use 10.2 database. I have couple of complex...

Maikku

11-18-2010 12:23 PM
John Hurley

This is regarding a problem we are facing during report(.xls) creation which is done using a procedure triggered by a job run. The report file(.xls)...

dhanlakshmi

11-16-2010 11:52 PM
Tim X

On Nov 16, 5:18*am, Mick <mjms... (AT) gmail (DOT) com> wrote: Well, it looks like my initial comment about running a unpatched 10.2.0.1 is...

Randolf Geist

11-16-2010 08:14 AM
Mladen Gogala

I have a query which is running very poorly (Oracle Database 10g Release 10.2.0.1.0 ): SELECT objecttype.id_object FROM PHY_ALL_OBJECTS...

Mick

11-15-2010 05:37 AM
Randolf Geist

Dear Everyone, as you know the price of the Oil is more and more increasing, while the oil supply is decreasing. Moreover Oil is causing wars,...

........

11-10-2010 12:38 PM
........

I am an avid user of tora, the open source TOAD lookalike which works on both Windows and Linux. Windows version installs seamlessly, with...

Mladen Gogala

11-10-2010 11:37 AM
Mladen Gogala