Hi Guys : Scenario : Database A is on one server (tables A, B, C) Database B is on another server ( tables X Y Z) I would like to establish a...

Mudasir Ahmed

06-16-2004 02:30 PM
Mudasir Ahmed

the situation : A few days ago I inserted a lot of records (400.000) into my database, since then I sometimes experience low cpu-power (those moments...

Oeleboele

06-16-2004 01:59 AM
Oeleboele

Greetings group, Windows Server 2003 Oracle 9i (Release2). Ok I new to Oracle so pease don't shout ;-) Can anyone tell me how to add databases to...

David Gray

06-14-2004 11:54 AM
David Gray

Hi I have problem with debugging Java Stored Procedure. I use JDeveloper and if procedure is a part of package I can run it and I see results but if...

Piotr

06-12-2004 11:11 AM
Piotr

If I alter an index alter index <indexname> storage (MAXEXTENTS nnn); Do I need to drop and rebuild the index before it can be used? Do I need to do...

Mike Coldewey

06-11-2004 01:41 PM
Mike Coldewey

Hi, I‘m using Oracle 8.0.5.2.1 Enterprise Edition with PL/SQL 8.0.5.2.0. There's an importtable, which is continuously filled with data from several...

MarcO

06-11-2004 04:41 AM
MarcO

I am looking for an easy method by which I can determine the tables referenced in a form. These pre-existing forms were created by...

Margaret

06-10-2004 11:09 AM
Margaret

Hi There. I'm getting this error when running a dot net application. We get through the (all custom) login screen fine and dandy. When we click on...

NavEEd

06-10-2004 07:05 AM
NavEEd

Hello all, I have a question regarding Oracle9i security. I have a database owned by 'admin' all tables in the database are owned and originally...

David Pylatuk

06-09-2004 08:43 AM
David Pylatuk

Hi, Does anybody know if SAP systems are based on Oracle, and if so, is it exlcusively Oracle ? Also, can anybody give any details of SAP's...

Graham

06-09-2004 02:41 AM
Olivier Guyot

Hi, I have recently installed ORACLE 9.2 Database on a UNIX server (2.8) which already has ORACLE 8.1.7. They have both a different SID...

Jonathan Johnston

06-09-2004 02:33 AM
Olivier Guyot

Hi, We are considering implementing the following solution and would appreciate any feedback comments you have. Does anybody have experience...

Darren

06-08-2004 12:36 PM
Darren

Hi. I'm new to ORACLE, so my question is very elementary... Our 9I ORACLE DB run under WINDOWS NT. The problem is, the DB is brought down nightly...

LG

06-08-2004 11:24 AM
LG

Hi. I've got a problem. Let's look at this: CREATE TYPE xxxT AS OBJECT( d DATE, something REFERENCES Something(ID) ); where Something is a table.

Dziadek

06-08-2004 04:02 AM
Dziadek

I have tablespace that keeps getting space eaten up for no clear reason. I have some tables set up that keep 5 of months of data. Every night a...

wireless

06-08-2004 12:53 AM
Chris Leonard

Hi all, Can anyone tell me is there any enhancement in PL/SQL with the release of Oracle9i? Thanks.

HL

06-08-2004 12:47 AM
Chris Leonard

I want to schedule a job to run on 24th on each month (Jan 24,Feb 24,Mar 24,...).But I noticed that by setting Interval to 'sysdate+30',the 'next...

col

06-08-2004 12:36 AM
Chris Leonard

How can I declare a local cursor within a recursive function? What this function does is it clean up a hierarchy. I know in SQL Server it is DECLARE...

Alexander Pino

06-04-2004 11:39 PM
Richard Xu

I am trying to write a simple stored procedure for oracle. My first in oracle :-( This procedure will take one parameter from an asp page. That...

Mike D

06-04-2004 05:35 PM
Michael Austin

I have tried to migrate from oracle 7.3 to oracle 10g by using export dump in oracle 7 and import into oracle 10g. It works !! But accordingly to...

ausora

06-03-2004 09:14 PM
Michael J. Moore

Hello, I need to add a single value such as 2004 for a newly added column in a production data table. I got several ascii data files...

David

06-03-2004 04:06 PM
David

Hi, all How can I enter an ASCII character (£, ALT-156) into a varchar column in a table? Whe I enter it (either through an application or throught...

Perico de los Palotes

06-03-2004 09:38 AM
Perico de los Palotes

Hi, does anyone know if, and how, I can return a record (set) from a stored procedure/function? What does the function have to do? well at this...

Alexander Pino

06-03-2004 06:03 AM
Alexander Pino

I'm trying to link tables in MS Access. The ODBC driver is 8.0.5. The database is 9i. I'm timing out. If the issues is that I need a new ODBC driver,...

Chris Oakleaf

06-02-2004 10:18 PM
Chris Oakleaf

In various places I have seen mentioned the importance of indexing foreign keys to avoid table locks on the child table on parent update/delete and...

Carlos Ibarra

06-02-2004 03:17 PM
Carlos Ibarra

I've seen some other posts of people trying to reset System passwords. Now, User logs on to Oracle( 9i ) on an NT4.0 through web Browser. When the...

S Hall

06-02-2004 11:11 AM
S Hall

Hi, We are using ADO with the Otacle Provider for OLEDB in our COM+ MTS C++ client (Oracle 8.1. It seems there is no way to timeout our ORACLE SQL...

Tzanko

06-02-2004 08:50 AM
Tzanko

Hello, I have a silly situation that I can't figure out. I have the following query: select * from table1 join table2@mssql on table1.field1 =...

lev

06-01-2004 05:04 PM
lev

I am very new to Oracle. We need to get the flow of table information from Oracle, or at least be able to look at the table structure. Can anyone...

cmoore

06-01-2004 06:11 AM
cmoore

The new brand new version 0.9.2 of Mogwai ERDesigner is available for download at http://mogwai.sourceforge.net. Mogwai ERDesigner is a visual data...

Mirko Sertic

05-31-2004 09:39 AM
Mirko Sertic

Can anyone help me to run oracle9i SQL on the internet instead of installing oracle9i database on the hard drive? I am asking this question because...

Francis Pho

05-29-2004 12:25 AM
Francis Pho

Hello everyone, We are looking for beta-testers for our new product - Scribe Report Generator. At the moment, Scribe supports 5 relational...

Alex Molochnikov

05-28-2004 02:06 PM
Yosua

Deptno Dname ------ ----- 10 ACCOUNTS 20 SALES 30 MARKETING 40 RESEARCH i want a query which will select lets say first 5 employees...

Mir

05-28-2004 02:01 PM
Yosua

Please send resume to skuntz (AT) bcbs-ga (DOT) com. Must have experience with installing, maintaining 9i Application Server and 9i Forms and...

ap

05-27-2004 04:42 PM
ap

Please send resume to skuntz (AT) bcbsga (DOT) com. Must have experience with installing, maintaining 9i Application Server and 9i Forms and Reports.

ap

05-27-2004 04:40 PM
ap

Hi! I have this problem.. How can i pass an IN parameters into a select statement? It continue to gimme the error: "invalid number".. (oggetto in...

kintaro

05-27-2004 03:06 AM
kintaro

Hi, my name is John Tytler, I'm the author of a stand-alone Windows application that does spell checking amongst other things. It's called...

John Tytler

05-26-2004 03:05 PM
John Tytler

Hi, I am using oracle 9.2 with windows2000 server. When I commit a transaction, it takes a long time even for a single record. Selects are very...

mark collings

05-26-2004 02:51 PM
mark collings

I'm not sure if this is the correct forum to go to for this, so if there is another, let me know. My problem is that I'm trying to install Oracle...

Shawn Zumwalt

05-26-2004 06:00 AM
Olivier Guyot

Hello Has anyone got some url's or information on how oracle 8i works under windowsw20003. I can't seems to find any answers and my reseller is...

Wim van Kregten

05-26-2004 05:43 AM
Olivier Guyot

Hi again! I tryed as u told me but i still gave some difficulties.. ^^ So i thought to post the code of my stored procedure... and the error oracle...

kintaro

05-26-2004 04:19 AM
kintaro

Hi, I am evaluating the usage of ORACLE MTS options for our CORBA services. I understand that MTS reduces the memory usage for a database connection...

Sreenivas

05-25-2004 07:41 PM
Jim Kennedy

Hi! I'm a newbie in pl/sql programming.. my problem is how to return multiple values from a stored procedures.. I tryed with cursor but there's prob...

kintaro

05-25-2004 12:33 PM
kintaro

Altova (http://www.altova.com) producers of Altova XMLSPY, the world's leading XML (eXtensible Mark-up Language) development environment,...

Altova Announcements

05-25-2004 12:31 PM
Altova Announcements

Hi all. I'm fighting with a strange problem for several days already. Maybe someone can help... My problem: I have a Win2K PC with Oracle 10 and...

Mike

05-21-2004 08:40 AM
Mike

I am working on Oracle reports . One of the parameters that a User inputs is 'report_type'. Now, is there a way to do the following within a...

Rohit Dhawan

05-20-2004 12:41 PM
R Gorden

I am attempting to create a database manually with oracle 9i. I have started the instance through the command prompt and opened it. I did a startup...

d.j.

05-20-2004 12:32 PM
R Gorden

Hi, I am having Multiple oarcle database server with same schema. sometimes i have to access other database server to get some information for that i...

Brij

05-18-2004 05:19 PM
Mir

Thanks Hans, I'll try Metalink. Vern "Hans Forbrich" <forbrich (AT) yahoo (DOT) net> wrote

Vern

05-17-2004 03:17 PM
Vern

Hi all, I've only ever used SQL Server and DB2 except for my university days, and I'm about to do a couple of days work on an Oracle site to do...

Josh White

05-13-2004 05:38 AM
Screaming_In_Digital