Oracle Help
in [SQL]
|
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
index Hi all, I read the following in a book 1) we can have several non clustered indexes on a table , but we can have only one clustered index per table 2) index on the primary key can be clustered or non clustered now my question is 1) by default what sort of indexing is used in oracle ? ... 28 Jul 2008 16:10
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
create table error with constraint... Hi! I've got a simple problem with a create table statement: CREATE TABLE HB_ATTRIBUTE ( STRINGVALUE VARCHAR2(4000 CHAR), DATEVALUE DATE, CONSTRAINT TCC_HB_ATTRIBUTE_1 CHECK ((STRINGVALUE is null)<>(DATEVALUE is null)) DEFERRABLE INITIALLY DEFERRED); This gives me an "ORA-00907: missing right paranthesis" ... 26 Jul 2008 09:56
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
Microsoft acquires DatAllegro http://www.computerworld.com/action/article.do?command=viewArticleBasic&articleId=9110624 -- David Portas ... 28 Jul 2008 15:08
The 20% rule Hi all, I recently read the following in a book(oracle 9i for dummies by Carol McCullough Dieter) The fastest way to retrieve rows from a table is to access the row with exact row id. An index is the second fastest way, but it decreases in performance as the proportion of the rows retrieved increases. if you... 26 Jul 2008 18:08
Case statement in Order by section? I am usint 10g. I know that you can put a decode in the order by section. But I tried to see if it is possible to put a case statement in the order by section. My little experiment did not work. Has anyone in this forum successfully put a case statement in the order by section? If so, how did you do it. Belo... 24 Jul 2008 10:49 |