| Thread | Last Post | Replies |
|
| oracle installation on Windows Home edition | 27 Mar 2006 15:11 GMT | 9 |
This might be a stange question. I would like to install oracle on my Windows Xp home edition. is it possible to install? I'm planning to buy Orcale Software.
|
| What does "koh-kghu call " mean? | 27 Mar 2006 14:41 GMT | 7 |
I am getting a lot of ORA-4030 errors while UGA touches 1.8GB and freezes. The heapdump contains information like - line#52,033 Chunk bfef3bb4 sz= 16416 freeable "koh-kghu
|
| 8.1.7 on Fedora | 27 Mar 2006 14:24 GMT | 3 |
I'd like to announce the it's possible to install 8.1.7 on fedora. It takes lots of time but is possible even on FC4 I've just succesfully installed oracle 8.1.7 server no Fedora FC3. Marek Pedziwiatr
|
| performance problems with hierarchical query and outer join | 27 Mar 2006 10:00 GMT | 2 |
Good morning, Oracle 9.0.1.3 on SUSE SLES7 here. The following hierarchical query based only upon the MOV0 table executes in less than a second: select
|
| Seconds | 27 Mar 2006 08:02 GMT | 4 |
I have a test table. 1 of the columns hav time in second as follows : Seconds 10720 31
|
| Unit Testing Software for PL/SQL | 27 Mar 2006 04:09 GMT | 5 |
Can anyone offer opinions/recommendations concerning Unit Testing Software products for PL/SQL? Thanks, Bill West
|
| Calling a stored procedure from an insert statement | 27 Mar 2006 00:20 GMT | 2 |
Can someone provide guidance on how I can call a stored procedure from a sql statement. We have a procedure which generates sequence numbers. I want to call this procedure to generate a value for an insert statement.
|
| XMLQuery select gives "PLS-00801: internal error" | 26 Mar 2006 20:14 GMT | 1 |
I take it this means Oracle does not do implicit casting between xmltype and varchar2? I don't see why this is not possible... an implicit cast could just copy the xmltype stuctured data into a varchar2 (or clob). The version is Oracle 10gR2 Standard running on RHAS4.
|
| RMAN Error on Linux - | 26 Mar 2006 02:14 GMT | 4 |
Good morning. I would appreciate any help or direction on the problem I am having (listed below). An error is occurring on one of my servers when I use RMAN to backup or Export data. The OS is Linux AS 2.1 & the DB is Oracle 9.2.0.4. I
|
| Populating 10G XE table with time AND date through VB.Net | 26 Mar 2006 02:08 GMT | 5 |
I am writing a VB.Net (2005 on Win XP) application that will put Date & Time data into a Date formatted field of an Oracle 10G XE table. This SQL statement delivered through VB.Net works fine: Insert into Vessel_Data (GPS_Date) Values ('19-Mar-2006')
|
| WOW! 200% SGA Usage!! | 25 Mar 2006 22:25 GMT | 3 |
I'm running 8i under AIX 5.2. We had an ORA-600 last Friday. Started with some 'unable to allocate 300 bytes in shared pool' messages, and then the 600 was thrown and the whole thing fell over. Not a pretty sight.
|
| Same old question about row consolidation | 25 Mar 2006 21:00 GMT | 2 |
I need help with a SQL statement or function that will consolidate two or more rows. I need to join the row on lot_id and conc. The conc values are always 0,10 or 100. The following is how the rows are configured.
|
| Delete trigger order of execution with on_delete_cascade | 25 Mar 2006 08:33 GMT | 1 |
I am trying to establish the order of execution of delete triggers when on-delete-cascade is set on my foreign key. If I have three tables T1, T2 and T3, all of which have before and after delete triggers defined, how will the be executed when I delete a
|
| sql dummies | 25 Mar 2006 05:28 GMT | 6 |
I'm switching from sybase to oracle. With sybase, I was used to start with sql-dummies like select 'test' so I could build the whole application on top of the sql-statement and
|
| I'm leaving oracle and IT | 24 Mar 2006 23:56 GMT | 1 |
So i'm selling my oracle-dba.com domain. its on the auction block on ebay, item: 9703428195 Joe Testa
|