Oracle

there is an error in comments
Hi List, I use Oracle 10 XE. I'm a student. When I wrote my lab then I had found that Oracle alerts about an error for the line: call echo('dddddd'); -- comment But it processes normally this line without the comment: call echo('dddddd'); The PL script is entirely: set serveroutput on; cr... 21 Dec 2009 07:59

Checking for Oracle Home incompatibilities
I've been trying to install Oracle on Solaris 10 (sparc) for the past week without progress. Below is what I get. What baffles me is that, I did not choose to install the oracle companion cd. I just want to install the database. "Checking for Oracle Home incompatibilities ... Check complete. The overall result o... 21 Dec 2009 05:51

Hey 11.2 is now out on solaris ( both flavors )
No hpux no windows so far ... Linux 32 bit and 64 bit ... solaris 64 bit both sparc and x86-64 ... Maybe they even got the 10.2.0.4 patchset out for solaris x86-64 by now? ... 20 Dec 2009 19:05

Oracle 11g on Windows 7
I got "operating system" error while I was trying to install Oracle 11g on Windows 7. Please shed a light. Thanks in advance. ... 18 Dec 2009 18:19

ADMIN_RESTRICTIONS default value for ORACLE listener.
Hi, I have a query about the parameter ADMIN_RESTRICTIONS, what is the value of the parameter if not set explicitly. And apart from listener.ora where can we see that value?? ... 18 Dec 2009 02:54

problem install Enterprise Manager
Hi, i installed a oracle database 10 instance with scrips CreateDB.sql CreateDBFiles.sql xdb_protocol.sql labelSecurity.sql spatial.sql context.sql CreateDBCatalog.sql JServer.sql odm.sql ordinst.sql interMedia.sql postDBCreation.sql emRepository.sql cwmlite.sql and all the log files from this scrip... 16 Dec 2009 13:28

looking out for Rbac with Financial
Hello , I am looking out for some one with Valid UK Visa and exp. with RBAC with Financial skills set. Interested , Pl. do send your resume ASAP. ... 16 Dec 2009 12:20

Compression
The word "compression" is very fashionable these days. I find that strange because everybody keeps telling me how cheap disks are these days and yet, there is a slew of compression algorithms all around: MP3, MPEG-2,OGG, ZIP, BZIP2, GZIP, everything is compressed to save the inexpensive and cheap disk space. Or... 15 Dec 2009 12:14

update multiple rows continue past exceptions
Hello all, I need to update as many rows as possible. The issue is that one row that fails causes the entire transaction to fail. How do I get around this? I'd like to complete all UPDATE rows that don't have the exception. The below doesn't seem to work. I'm using Oracle 10g Thanks a bunch! BEGIN UPD... 15 Dec 2009 05:40

Optimizer 10053 trace file, strange choises made by Oracle??
Hi all, I had a 10053 trace file generated of a Siebel query and I do not understand the SINGLE TABLE ACCESS PATH part. Below is a snippet of the tracefile. It seems to calculate the costs of a full tablescan as 1988.76. Then the different index access paths are calculated which are calculated as 215.78 and 2... 11 Dec 2009 03:42