Oracle

Reload message
Sometimes, when reading newsgroups, Thunderbird fails to fetch the body of an article when I click on its subject in the message list panel. Is there a way to instruct Thunderbird to download the message body again? -- -- http://alvaro.es - �lvaro G. Vicario - Burgos, Spain -- Mi sitio sobre programaci�n ... 2 Feb 2010 14:39

dbstart with wrong shell / wrong systax
hi all After installing Oracle database 11.2 on Solaris 10 x86 the dbstart script doesn't work because of the interpreter is set to /bin/sh but the script uses syntax of ksh/bash . dbstart: line 1:#!/bin/sh .... line 89:export ORACLE_HOME=$ORACLE_HOME_LISTNER This export statement is illegal for bourne... 3 Feb 2010 03:57

Download oracle 9iR2
Hello all, for studying, where can I download oracle 9.2 for linux 64bit? I don't find anymore on the oracle website...and also on metalink Any hints? Thanks Stefano ... 2 Feb 2010 14:39

adding a constraint to child table that references a column of theparent table that is not part of the primary key
Hello, Oracle 10.2.0.3 on Linux here. I have two tables, P (parent table) and D (data table): hr@> create table p ( pid integer primary key, ptype varchar2(1) not null, pname varchar2(80) not null ) ; Table created. hr@> create table d ( pid integer not null, ddate date not null, dstuff varchar2(80), pri... 2 Feb 2010 14:38

find position of row in set of rows
I have a table ordered by date. When I find a specific record in this set, I want to know what its position is in this ordered list. I could get the date from the record found and count dates above or below, but is there a better way? Thank you. ... 2 Feb 2010 14:39

performance comparision
All, at Oracle 9.2.0.8 we are aiming to delete huge rows( old data ) from a table T1 Since we can not afford outage hence CTAS and other options are ruled out. Method being opted are ( in Test env first ) : a) Mark the rows to be deleted. i.e. Update one column, which is made exclusivley for arch... 2 Feb 2010 14:39

Bequeath connections
I have been given access to a certain database at Oracle level, but no UNIX access. Is it possible to determine whether a connection (Oracle session) is Bequeath connection or connection through listener by looking at V$ views? Thanks ... 2 Feb 2010 14:39

Oracle 11.2 for iPad
Here is the announcement: http://news.zdnet.com/2422-19178_22-387489.html When will there be Oracle 11.2 EE for iPad? Will there be RAC? What if have 2 of them, may I somehow cluster them over a USB drive or a NFS4- mounted remote file system? -- http://mgogala.byethost5.com ... 27 Jan 2010 16:01

Dumb Character Column
Hi, Ok, whomever wrote this dumbass application should be put on trial. Anyhow, we have a column in our table which is defined as VARCHAR2, but contains both numbers AND character data. Problem is that we need to do some < & > in a query on the numeric content. But, because of the character data we get an... 27 Jan 2010 14:52

lag lag lag
I picked up lag from this group a few weeks ago and ... nice stuff. Now I'm trying to create a query that contains a future date. That means all the values in a row are LAG values except for the future date. I can lag a field. How can I lag all the fields? Do you have to write lag(), lag(), lag()... or is the... 2 Feb 2010 14:38