Oracle

THE TRUTH is stranger than fiction
http://ronaldgreglewis.blogspot.com ... 28 Dec 2005 06:28

Oracle 9i ebook or online tutorial
Hi group I am new to Oracle. Does anyone have an ebook on learning Oracle 9i, or knows any good tutorials online. Thanx ... 5 Jan 2006 08:19

ORA-01654 Fix?
I am being told to create another tablespace for an error that I have been getting (ORA-01654: unable to extend index SYSADM.OPS_TRANS_IDX1 by 138254 in tablespace SYSTEM ORA-27039: create file failed, file size limit reached OSD-02067: illegal option specified ORA-27039: create fil). I am trying to understand... 22 Dec 2005 19:19

ORA-00937 when CURSOR_SHARING=FORCE
Hello, I have read about the use of bind variables and how dramatically it can inprove the performance on the Database servers. Unafortunatelly I have several applications running against my Oracle servers that doesn't make good use of this feature. In most of the cases they simply don't work with bind variabl... 22 Dec 2005 08:54

NULLs
Hello, I have an application whose database was recently upgraded from 7 to 9i. In a bit of code, columns are compared that may both be null. In Oracle 7, will two columns compare equal if they are both NULL? In 9i it seems that they do not and I have to change it to NVL(column1) = NVL(column2). Thanks, An... 22 Dec 2005 06:45

Timezone Problem
Hello, I'm a bit confused about the result of tz_offset in oracle. I don't understand the result of this query SELECT tz.*, tz_offset(tz.tzname) DIFF FROM V$TIMEZONE_NAMES tz WHERE TZNAME IN ('US/Eastern','GMT','Europe/Berlin','Atlantic/Azores','Etc/GMT+1')) I think the result of tz_offset is the offse... 20 Dec 2005 12:05

ORA-12842
OS : Solaris 8 Oracle Version: 9.2.0.7 Oracle Error: ORA-12842 Hi, I am getting this error on a Database that is running on UAT. We are running a long running query and we are not doing any DDL in parallel. The error message text says that Cursor Invalidated during parallel execution. This message according ... 21 Dec 2005 09:56

Error
I am getting this error in our Oracle 8i database server running on Netware 5.1. It is generated from our MRP system that is the front end to the database. For a quick band-aid, can I archive some stuff and delete some records? ORA-01654: unable to extend index SYSADM.OPS_TRANS_IDX1 by 138254 in tablespace... 19 Dec 2005 18:25

10.2 Upgrade Information Utility
Oracle Database 10.2 Upgrade Information Utility 'utlu102i.sql' displayed Database: ********************************************************************** --> version: 9.2.0.4.0 --> compatible: 9.2.0.0.0 Tablespaces: [make adjustments in the current environment] *********************************... 21 Dec 2005 10:59

rman restore procedure
Hi all, I tried to reproduce a "case study" founded in a rman tutorial. at a certain point, after that command: alter database mount; restore database; recover database noredo; alter database open resetlogs; the tutorial say : "NOTE: Tempfiles are automatically excluded from RMAN backups. This requires... 15 Dec 2005 16:54