Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Oracle / Oracle Server / March 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Alias for a CASE WHEN expression in a SELECT cannot be used in GROUP BY?05 Mar 2006 21:53 GMT4
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 10g05 Mar 2006 20:41 GMT1
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 requested05 Mar 2006 18:59 GMT5
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 procedure05 Mar 2006 17:45 GMT6
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 GMT4
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 10G05 Mar 2006 04:22 GMT7
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 dynamically04 Mar 2006 22:18 GMT6
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 installations04 Mar 2006 19:01 GMT1
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 dynamically04 Mar 2006 18:44 GMT8
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 pattern04 Mar 2006 17:15 GMT8
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 GMT4
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 me04 Mar 2006 14:18 GMT5
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 role04 Mar 2006 14:13 GMT4
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 GMT47
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 benchmark04 Mar 2006 08:26 GMT6
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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.