Oracle
in [SQL]
|
Oracle specialist trainers/consultants in Australia? Hi all, Apologies for cross-posting, but I expect my search to be difficult, and any responses to comp.databases.oracle.marketplace *ONLY* please, or to me by email - geoff dot muldoon at gmail dot com. I'm currently involved in a project prototyping (successfully so far) the use of Oracle Change Data Captu... 24 Jul 2008 13:56
Comments? The below is a portion of an email describing how the plan for disaster recovery has been explained to us. This is an Oracle 10g database running on Windows 2003 server. The way we did the disaster recovery backup is: Step1: 1.. Export the entire db (with no rows option) - This will get a copy of ... 28 Jul 2008 15:08
question on 10g analytic functions This is a question on 10g analytic functions I have Table T1 with four number columns: Table T1: id X Y Z 1 0 0 0 1 0 1 0 2 0 1 1 2 1 1 1 3 0 0 1 3 0 1 1 3 1 0 1 After group by "id:, I get: For X=0: id Count1 1 0 2 1 3 1 For Y=0: id Count2 1 1 2 2 3 1 For Z=0: id Count3 1 0 2 2 3 3... 22 Jul 2008 22:57
procedure submitted to dbms_job - implicit commit? Hi group, I'm just wondering - and I tried to look it up in the documentation: When I submit a dbms_job calling a pl/sql-procedure and this procedure does some data-changes - is it for sure that this changes are commited? (There is no commit in the procedure.) I've tried with a little test-case and the job's... 23 Jul 2008 19:29
Glamour models & Fasion designing New look watch my profile http://www.geocities.com/cathrina39 Glamour models & Fasion designing New look watch my profile http://www.geocities.com/cathrina39 ... 22 Jul 2008 09:34
Oracle Financials Install Guys, I need help with a Oracle E-Business install on a test system (Windows Vista) on my PC at home.. This is basically a test system for learning purposes only..... I hope that someone out there in Cyberspace is willing to help and guide me through this process.... Thanks in Advance..... ... 24 Jul 2008 05:42
CDynamicParameterAccessor fail when use OraOleDB provider Platform - Window Server 2003, VC++ (visual studio 2005) Database - Oracle Express 10g Hi, Below code works fine for SQL Server provider. When i run same code with OraOleDB provider program fails. Can you please let me know what can be problem. Command use for Oracle provider -----------------------------... 22 Jul 2008 01:24
V$session_wait.seconds_in_wait SELECT sid ,event,state, seconds_in_wait siw,wait_time,p1text p1txt,p1,p2text p2txt,p2,p3text p3txt,p3 FROM v$session_wait WHERE sid = &sid SID Wait Event Wait State SIW wait_time P1TXT P1 P2TXT P2 P3TXT ... 22 Jul 2008 10:36
Network Issue We are replatforming our datawarehouse from Oracle 9i in Sun Solaris to 10g in IBM AIX 5.3. There is a direct connect network link (Gigabit) setup between the two servers. The plan is to transfer the data over a dblink. When we tested the network link, we got 50G per hour using binary mode whereas ascii mode gav... 22 Jul 2008 03:27
what is a "module" in the context of DBMS_APPLICATION_INFO.SET_MODULE? hi group, first off, thanks to Steve Howard and DA Morgan for helping me out on my last post. much appreciated. my question today refers to these statements in the oracle documentation for DBMS_APPLICATION_INFO: http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28419/d_appinf.htm [emphasis mine]: ... 21 Jul 2008 09:57 |