Oracle Help
in [SQL]
|
KTSMG_UPDATE_MQL() MMNL absent for 4294967293 secs; Foregrounds taking over On Wed, 8 Oct 2008 20:30:42 -0700 (PDT), choubou <netwatching(a)gmail.com> wrote: Our company use rac 10g (10.1.0.4),we have two nodes,recently node one always reboot,I guest maybe dead lock ,can anyone help me how to solve this problem,thank you~ Please submit a service request. You really shouldn't run RAC... 9 Oct 2008 01:15
stuck on Clone database creation step I'm try installing Oracle 10g on a pSeries RHEL 4. I'm on the "Database Configuration Assistant" screen and the "Clone database creation in progress" bar shows 2% complete and is stuck there. I've waited a few hours and it hasn't moved. There no disk activity and no errors so I don' know what is going on. A t... 8 Oct 2008 18:06
Complex crosstab query I am wondering if I can create a complex query in oracle that simulates an Access crosstab. The data is comprised of measurments created from fish scales. The output is based on the water type 'F' - Fresh and 'S' - Salt and the Age of the fish, 5th and 6th characters of the FISH_ID. The 5th charactrer is the F... 27 Sep 2008 15:05
Can this be done with a trigger? Hi, We have a table like this: CUSTOMER_ID PRODUCT_ID FORMAT STATUS DATE_ADDED DATE_MODIFIED We also have a history table like this: CUSTOMER_ID PRODUCT_ID FORMAT STATUS SOURCE DATE_ADDED We want to put a trigger on the first table such that when a record is inserted or updated it will m... 7 Aug 2008 15:31
AD4J Installation with JBoss Hi, Does anybody know Oracle AD4J? I´ve got the AD4J-Console running on Suse Linux and the agent-file upon JBoss (Suse Linux, too). The console works fine but when i try to deploy the "jamagent.war" file on the JBoss-Server, i always see the following error-message: ########################################... 5 Aug 2008 11:08
Restore Am trying to do restore of control file on Linux Machine 64Bit CenTOS5.2, i get the following RMAN> restore controlfile; Starting restore at 29-07-2008 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: restoring control file channel ORA_DISK_1: reading fro... 30 Jul 2008 15:50
Oracle 10g 10.0.2 client, to connect oracle 8 server Dear Group members, I am using Oracle 10 g 10.0.2 client software to connect 9i,10g and 8i it is working very good with the 9i and 10g.. when i trying to connect 8i server ./. it giving error <b> "ORA-03134: Connections to this server version are no longer supported." </b> Can i install, 2 or more v... 28 Jul 2008 15:08
java.sql.SQLException: Data size bigger than max size for this type: 3991 uday <uday1067(a)gmail.com> wrote: i have been using setString() of prepared statement. but it is giving me java.sql.SQLException: Data size bigger than max size for this type: 3991 exception. where as as per my understanding, the size of varchar2 is 4000. can someone suggest the s... 25 Jul 2008 10:25
java.sql.SQLException: Data size bigger than max size for this type: 3991 On Jul 25, 11:49 am, Laurenz Albe <inv...(a)spam.to.invalid> wrote: uday <uday1...(a)gmail.com> wrote: i have been using setString() of prepared statement. but it is giving me java.sql.SQLException: Data size bigger than max size for this type: 3991 exception. where as as per my understanding, the si... 25 Jul 2008 09:23
java.sql.SQLException: Data size bigger than max size for this type: 3991 uday <uday1067(a)gmail.com> wrote: i have been using setString() of prepared statement. but it is giving me java.sql.SQLException: Data size bigger than max size for this type: 3991 exception. where as as per my understanding, the size of varchar2 is 4000. can someone suggest the solution Well, h... 25 Jul 2008 03:16 |