Oracle Help
in [SQL]
|
prioritize inserts i.s.o replication Hi all, I set up two dbs with streams replication (A and B) A gets all inserts that are replicated to B. When replication stops and is started again inserts into A lead to unacceptable commit times (20 seconds i.s.o the normal 200ms) while replication catches up at full speed. Is there a way to prioritize the ... 8 Jul 2008 04:53
Error updating materialized view Hi all, I'm trying to update a materialized view: EXECUTE DBMS_MVIEW.REFRESH('NED_PRODUCT_CARD_MV', 'C'); This commands hangs for a very long time (no idea if it'll ever complete). Hm, reminds me of the halting problem. When I terminate it with a Ctrl-C, I get the error message: ERROR at line 1: ORA-12008: e... 7 Jul 2008 13:31
Free Webinars on PMP Certification Awareness and Roadmap Dear Freinds I came across a website which conducts Free Webinars on PMP Certification (Project Management Institute, USA) Awareness and The Roadmap. It proved to be quite useful. This Training Institute also provides live online lectures on PMP Certification Preparation at very competitive rates and also have f... 7 Jul 2008 10:25
FREE SOFTWARE DOWNLOAD ONLINE FREE DOWNLOAD SOFTWARE http://freesoftware20.blogspot.com/ ... 7 Jul 2008 07:21
JDBC Driver 8.1.6 Hello, Is it possible to download somewhere JDBC Driver 8.1.6 ? I would need to connect an old Oracle 7 database (The oldest one I found is 8.1.7) Thanks in advance. ... 5 Jul 2008 15:35
training materials needed I'm looking to see if anyone knows where I can get a used copy of the Oracle 8i to 10g training materials. Thanks, Oracle DBA ... 3 Jul 2008 21:45
Yellowfin Business Intelligence Release 4.0 Announced to Industry (CDT) Tue Jul 1, 2008 10:45am -- Announced today, the next release of Yellowfin Business Intelligence, 4.0 is scheduled for the end of July. Whilst most of the activity in the BI space has been busy with merger and acquisitions, Yellowfin has continued focussing its efforts to develop web Business Intelligence soft... 2 Jul 2008 07:47
pl/sql forcing RHS of = in where clause to be variable? This code will compare a column to a variable: declare myx number; begin select * from foo where x=myx; end; but suppose I have a variable with the same name as a column: declare x number; begin select * from foo where x=x; end; This will compare column x with column x, and not with the variable ... 1 Jul 2008 19:32
A little help with a query please Hi Guys, I need a little help putting a query together as I'm pulling my hair out. I'm getting two values, one from each table. Table 1 has a value and is in a 1 to many relationship with table 2 so what I'm getting back is something like this: Table1.Col1 Table2.Col1 A 1 A ... 26 Jun 2008 03:18
Exists a aggregate function (Oracle9) for varchar that generate a comma separated lsit Hello, The Firebird-Database 2.1 contains a LIST function http://www.firebirdsql.org/rlsnotes/Firebird-2.1-ReleaseNotes.pdf ____________________________ The LIST Function Oleg Loa Dmitry Yemanov (v.2.1) This function returns a string result with the concatenated non-NULL values from a group. It returns NU... 25 Jun 2008 15:00 |