| Thread | Last Post | Replies |
|
| Alias for a CASE WHEN expression in a SELECT cannot be used in GROUP BY? | 05 Mar 2006 21:53 GMT | 4 |
I need some help explaining the following situation. I have tested the case both in 9i and 10gR2. Table: EMPLOYEE
|
| Database link from 9i to 10g | 05 Mar 2006 20:41 GMT | 1 |
I have a 9i database on which I am trying to make a database connection to a 10g database. Whenever I try to connect, I get an error saying: ORA-12645: Parameter does not exist. I get the same error when trying to connect to the 10g database using
|
| ORA-01460: unimplemented or unreasonable conversion requested | 05 Mar 2006 18:59 GMT | 5 |
We are currently getting the following error ORA-01460: unimplemented or unreasonable conversion requested When we try to insert a double-byte character from our ASP.Net application through ODP.Net version 9.
|
| problem with stored procedure | 05 Mar 2006 17:45 GMT | 6 |
I have a weird problem. I am using an Oracle 9i DB and I wrote a stored procedure. The procedure works like a charm when I use SQL+: execute insert_stats('gggg',1,2,3,4,5,6,7,8);
|
| DEFERRABLE check constraint on IOT not working? | 05 Mar 2006 06:13 GMT | 4 |
I have managed to make really small test case. So, lets's test it on a heap table first: SQL*Plus: Release 10.2.0.1.0 - Production on Sat Mar 4 01:23:08 2006 Copyright (c) 1982, 2005, Oracle. All rights reserved.
|
| Query Runs faster in 10G | 05 Mar 2006 04:22 GMT | 7 |
I have a query which takes 0.2 seconds in 10G but takes 18 seconds in 8i. the query is SELECT n.story_id, n.date_of_story AS sdate, n.headline,
|
| create/using type dynamically | 04 Mar 2006 22:18 GMT | 6 |
Hi frnds, I am caught up in a very crazy yet obvious situation using pl/sql. I wil try to explain the issue here in hope of gettin some pointers/help
|
| One OS user for two installations | 04 Mar 2006 19:01 GMT | 1 |
I have oracle 10.1 on linux Red Hat 4 I have to install 10.2 ( other oracle_home ) Can I use the same oracle unix user to install and admin the new database ?
|
| creating/using type dynamically | 04 Mar 2006 18:44 GMT | 8 |
Hi frnds, I am caught up in a very crazy yet obvious situation using pl/sql. I wil try to explain the issue here in hope of gettin some pointers/help
|
| Using external table to load files with fixed pattern | 04 Mar 2006 17:15 GMT | 8 |
I have a log file with following pattern: [<log ID>] <log message> < several lines of detail messages .......
|
| 900 distinct values, yet density yields 0.5?? | 04 Mar 2006 16:43 GMT | 4 |
Ora 9.2.06 AIX In a Peoplesoft environment a ran a dbms_stats.gather_table_stats on the PS_JRNL_LN table. In that table, there is a column called process_instance, which holds some kind of batch number.
|
| Interview Questions(Oracle9i DBA), help me | 04 Mar 2006 14:18 GMT | 5 |
1) Does windows NT support direct I/O? Answer: Choose one of the answers that apply A: No, only AIO B: Yes, depending on hardware.
|
| Password protect DBA role | 04 Mar 2006 14:13 GMT | 4 |
I'm getting beat up by the Sar/Oxy auditors because the DBA role is not password protected. The only schemas that are granted this role are SYS and SYSTEM. I've tried to explain that the DBA is a default role for SYS and SYSTEM and setting a password is useless, but to no avail.
|
| How do I trace hanging "connect / as sysdba"? | 04 Mar 2006 09:17 GMT | 47 |
I am having problems with Oracle 9.2 on a newly-built pc running w2k server. The software alone installed OK but I can't create a database. To cut a long story short it hangs on this: sqlplus /nolog
|
| Oracle benchmark | 04 Mar 2006 08:26 GMT | 6 |
I have to execute some benchmarks with a 100MB database. Cause I have to test the ram, I need to put all database in SGA. I try but I'm not able to stop disk access. Every query accesses the disks. Have you any hint to do this?
|