Oracle

newbie question..droping BIN tables
happy wrote on 24.04.2010 18:21: How can I delete tables like this ? BIN$d1hIUXKfQN+8Twh/4gKg/Q==$0 http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_9018.htm#i2152611 What make them created ? Is rollback command create them ? http://download-uk.oracle.com/docs/cd/B1930... 24 Apr 2010 12:46

DBMS_REPAIR.CHECK_OBJECT
I am using Oracle 11.1.0.7.1 on HP UNIX 11.23. To my surprise, I find that a block has been corrupted. My export dump backups fail when reading corrupt blocks. I cannot repair from a backup, this system is not a production system, no rman backups were taken. I have read about DBMS_REAPIR and trying it. When I run... 25 Apr 2010 17:48

how to do a ldapsearch from a telnet session
Hi, I'm trying to check the status of our OID (10.1.0.4) server running OEL 4 from another OEL server by passing a string (cn=mytestdb) and I'm hoping to receive an expected string back but I'm getting connection closed by foreign host. Is there a configuration change that has to be made to open up the access? ... 27 Apr 2010 19:03

V$DIAG_ALERT_EXT table
I must confess that this table has become slightly more useful in 11.2.0.1. with the April 2010 PSU applied. It is still not documented and the MOS search of V$DIAG_ALERT_EXT will not retrieve anything. It still has it's quirks: SQL> select count(*) from v$diag_alert_ext where component_id='rdbms'; selec... 23 Apr 2010 20:39

Sample clause with multiple conditions workaround?
I am trying to do the equivalent of this Teradata query in Oracle, and I can't figure it out select * from tab sample when prod_code = 'AS' then 10 when prod_code = 'CM' then 10 when prod_code = 'DQ' then 10 end I got this example from http://forums.teradata.com/forum/database/sample-function and was a... 23 Apr 2010 20:39

Interesting SR response
So we have had a severity 1 SR open with Oracle since midnight Sunday morning. The bug has a note that has been on MOS since March 2009 for 10.2.0.4 (the version we are running), yet there was no patch. The only workaround without a patch is to move the table to a different tablespace. We have had almost zero fe... 26 Apr 2010 12:35

Oracle 11.2 for Windows
Only for your information: When testing the new 32bit release I got problems when trying to import a datapump import. Metalink support identified an open bug and gave the advice to wait for the first patch set which should be delivered at the begin of May for 32 bit and 64 bit. Oracle recommends using Oracle 11.... 23 Apr 2010 20:39

Apex sample
I am testin Apex in 11r2 (win). http://www.oracle.com/technology/obe/apex/apex31nf/apex31rpt.htm When installing OEHR sample, it gives errors when inserting seed customers. ORA- 01843 obviously wrong date language. How to fix it? Changed this: Home>Application Builder>Manage Application Builder Defaults but... 26 Apr 2010 02:36

Sample clause with multiple conditions workaround?
On Apr 23, 5:44 am, Sub-Z Pulao <subzpu...(a)gmail.com> wrote: I am trying to do the equivalent of this Teradata query in Oracle, and I can't figure it out select * from tab sample when prod_code = 'AS' then 10 when prod_code = 'CM' then 10 when prod_code = 'DQ' then 10 end I got this ... 23 Apr 2010 20:39

dummy value?
I have large list I use in an 'IN' clause select * from mytable where x in { HUGE LIST } What I want to do is find all the entries in that huge list that do not match. Some how I have to get the list value into a variable. Can that be done? select var from mytable where var putinvar { HUGE LIST } and var... 23 Apr 2010 20:39