Can anyone help to understand why re-parsing occurs on a remote database (using database links), even though we are using a prepared statement on the...

Pentti

10-14-2005 03:11 PM
Pentti

Pls, post in cdo.server; this ng is not carried by many ISP's -- Regards, Frank van Bortel Top-posting is one way to shut me up...

Frank van Bortel

10-05-2005 02:29 PM
Frank van Bortel

Can all "joins" be mimicked via nested selects?

DG

09-22-2005 01:03 AM
DG

when i create a new database , assistant does not ask to me the database internal password..I don't understand why ??? thanks reply on...

dave

09-09-2005 12:25 PM
dave

Suppose that you are connected to an Oracle database with the user SYS or SYSTEM. I know that there is a way to inpersonate another Oracle user...

Martin

09-07-2005 10:27 AM
Martin

RDBMS Version:: 10.1.0.3.0 Operating System and Version:: MAC OS X 10.4.2 Product Version:: ORACLE Db10g Version 10.1.0.3.0 OEM Console Operating...

max

09-06-2005 07:25 AM
max

Hello all: I have a very basic question about oracle database structures. I am coming from MS SQLServer where I have three "databases", each...

FC

09-04-2005 12:32 AM
FC

Hi, I want to bind an array to the following sql statement using oci SELECT UUID FROM TEST WHERE TYPE=:VAL UUID is INTEGER TYPE is CHAR(1) If i...

Bruce Collie

09-03-2005 06:34 PM
HansF

Hi all! Sorry guys but I am totally ignorant on oracle matters. I need some guidance in how and what is needed to connect directly to an oracle...

Andrew

08-21-2005 03:40 AM
Andrew

Anybody knows a way to produce output from a SELECT statement on a single line, instead of each hit on a separate line? Here is what I mean: let's...

R. P.

08-16-2005 02:52 PM


Hi everyone! We've just installed a two node 10G RAC environment under Linux AS 3.0 for EM64T (Intel's new chip) with shared storage on an EMC box...

stheby

08-10-2005 10:22 PM
stheby

Announcing complete and extensive PowerPoint slides for both an introductory and an advanced database course, along with supporting manuals,...

Ellis Cohen

07-22-2005 10:13 AM
Ellis Cohen

Hello, SLES9 SP1 is on PIII with two 800MHz procesors and 2GB RAM, on four SATA 156GBhard disks are created two RAID1 arays, on one RAID is OS with...

Martin Solveig

07-11-2005 06:41 PM
Mater

Hi everyone, I wondered if anyone has have experiences with using JDeveloper with Oracle 7.3.4. (Yeah, I know you are probably wondering why we are...

The Doctor

06-18-2005 04:07 PM
The Doctor

A customer has 11i Purchasing and is unsure how to configure it for sending a fax. After they reserve the funds, there are 2 radio buttons; Print...

Slider

06-16-2005 04:21 PM
Slider

Hi there Am just about to deploy a new application - one of those 'generic' database types with very little Oracle specific functionality built...

simoncole

06-15-2005 04:39 PM
Paul

How can I create a link setup with oracle and DB2

tonik

05-31-2005 03:05 AM
tonik

DA Morgan wrote: To be really fair, this is just nitpicking on the semantics. To most people, "licensing" really means "total cost payable to the...

Rhino

05-28-2005 04:31 PM
Jasper Scholten

Hello everyone! Has anyone every seen the following behavior? Oracle 9.? running on AIX, no problems here Windows NT machine, Oracle client...

DG

05-27-2005 05:10 PM
DG

Hi, A few years ago (2000 ?) I installed an oracle client on a linux server (oracle8iR2 on Debian Woody) and everything went beautifully. ...

carex

05-24-2005 03:52 PM
carex

Hi, I already included in GROUP BY clause all SELECT expressions that are not group function arguments. And it runs OK in Oracle 8, but when I change...

MM

05-24-2005 01:59 AM
Primo¾ Govekar

i have had to install 8.1.7 on Redhat Enteprise 3. That was a feat by itself but i finally got it to run the listener and the instance, i have a...

Bob Marley

05-20-2005 08:37 AM
Paul

Hello I am trying to build a system where I can full-text index documents with UTF8 or UTF16 data using Oracle Text. I am doing the filtering in...

Server Applications

05-19-2005 04:00 AM
Frank van Bortel

Hi All, I tried evething: but no help, I'm connecting from my home trough 1.5 MB ADSL Line to Oracle Server and getting ORA-12170 Oracle...

Zahi Savion

05-17-2005 05:38 AM
Zahi Savion

Hello users! I have to prepare a paper about ERDish programming language. Unfortunately I can't find any useful info about it. All I know it is...

Slawek Z

05-15-2005 04:11 PM
Slawek Z

We have some performance Problems due to heavy load in an oracle database 10g. Our Server is Hewlett Packard Proliant ML380 OS: SuSE Linux...

max

05-12-2005 11:14 AM
IANAL_VISTA

This is probably easy and I'm missing it because I'm a little sleep-deprived this month, but: given the following table 'test': name group ...

jared

05-10-2005 05:21 AM
Tomislav Kokoska

What is the best way to speed up query looks like: SELECT DISTINCT COLUMN1, COLUMN2, COLUMN3, COLUMN4 FROM TABLE WHERE COLUMN5 = 5 cardinality of...

Tomislav Kokoska

05-10-2005 05:13 AM
Tomislav Kokoska

Søren Alexandersen wrote: That's basically what export/import does for you. It moves all the data, including tables, triggers, views, constraints,...

Walt

05-09-2005 05:41 PM
Walt

Hello guys, I would like my app to generate and execute cross platform (sybase and oracle) multi-statement SQL in the form: (situation A) SQL +=...

SerGioGio

05-08-2005 08:22 AM
SerGioGio

hello.. with oracle 7.3.4.4 and with remote_login_passwordfile=NONE, can a user be granted the SYSDBA system privilege? Or does granting the SYSDBA...

Luis Correia

05-06-2005 04:44 PM
Luis Correia

To all, How do you stop the debugger when you encounter an error ? I have tried using STEP OUT (CTRL T) and BREAK (SHIFT+ESC) and...

Rick Silvers

05-04-2005 02:57 PM
Rick Silvers

We have a network with 4 computers on it. One of them is running the database and the other 3 are clients. I can ping the server, but not...

berj

04-26-2005 06:06 AM
Frank van Bortel

Hello! I have Oracle 10g using AL32UTF8 as internal charset. I have a documents table where uploaded files (I'm using modplsql web-gateway (release...

Michael Postmann

04-25-2005 10:28 AM
Michael Postmann

You can't ... What you might try is: desc tabe1 This will list the columns in that table. You can select what you want to pull from that way.

Steve Kirby

04-21-2005 09:20 PM
Steve Kirby

Hi all, We are doing an exercise of migrating an application (developed in Informix 4gl) from Informix to Oracle database. Before doing actual...

Girish

04-19-2005 02:49 AM
Joe Yong

Hello All, I am new to PL/SQL, come from a COBOL/DB2/iSeries world. I have a question about Packages, Procedures. I want to create a Package, that...

Rick Silvers

04-17-2005 09:56 PM
GreyBeard

Hello all, I have a question about the Oracle 10g thin JDBC driver. I was wondering if anyone knows what the default prefetch size is (in number of...

nospam

04-16-2005 02:59 PM
nospam

Hi - I've created the following SuperType object in Oracle : CREATE OR REPLACE TYPE CT_CALC_UT as object ( ct_plant_nm varchar2(50), ct_value...

daviscomp20

04-16-2005 10:22 AM
Frank van Bortel

Can anyone help with a mysterious problem that has arisen since 'upgrading' from 8 to 9.2.0.4? The situation is this: Queries that worked fine...

SteveS

04-16-2005 08:08 AM
SteveS

Hello together, I'am a oracle databse administrator and i want to write a short procedure in PL/SQL. My programming experience is ohther programming...

T.Kindermann

04-14-2005 02:26 AM
T.Kindermann

Hi all. I have a need to connect to an Oracle 7.3.3.5 database. I have a user who successfully connects to it with her Oracle 7.3 client. I have...

Tig

04-12-2005 05:54 PM
KMART

Hi all. I have a need to connect to an Oracle 7.3.3.5 database. I have a user who successfully connects to it with her Oracle 7.3 client. I have...

Tig

04-11-2005 03:03 AM
Tig

I'm using Oracle database. It is true that I can't use update when I have group by ? For example I tried with: update (select t1.ID,...

MM

04-08-2005 08:59 AM
MM

Hi - I'm updating an Oracle table with an empty string and getting the error: An unhandled exception of type 'System.Exception' occurred...

arvee

04-08-2005 07:46 AM
Frank van Bortel

Dear all, We use TCP/IP for our Oracle networking to the database server but I see 2 formats for specifying the definition of a connection string of...

Miori

04-08-2005 06:49 AM
Artur Karazniewicz

Hi, The following does not return result: with free_space_by_tablespace as ( select sum(bytes)/1024 Kbytes_free, max(bytes)/1024...

web_poster03@yahoo.com

04-06-2005 10:11 AM
web_poster03@yahoo.com

Hi All, I am currently handling a J2EE application with the Application server as Weblogic 7.0 SP2 and Database on Oracle 9.2.1.0. The client wants...

Anshul Seth

04-06-2005 06:50 AM
dinko

Hi All Nice to be in this Forum. I have questions to ask on UTL_FILE :roll: Let me explain the concept 1.When the net is down the user will take the...

Prasanna

04-03-2005 12:53 PM
Mark C. Stock

Hi, I'm using dreamweaver to do some asp development with an oracle database. I'm having trouble seeing tables that are in my own schema. I can see...

samuelgreene@gmail.com

03-30-2005 07:44 PM
samuelgreene@gmail.com