I am getting the following error message on my oracle database. This is a database that was created in 1999 and houses our MRP system for my work. ...

Brian

11-08-2007 02:30 AM
Lodewicus Maas

Hello, I would like to install Oracle 10g in my Ubuntu Linux. I have read in a book that Oracle needs access to /u01.../u0X. What does this mean? I...

R.A.M.

09-18-2007 09:23 AM
R.A.M.

http://www.tompall.us/TomPall.doc

TP

07-11-2007 03:16 PM
TP

Hi, I try install http://plpdf.com/index.html on Application Express 2.1.0.00.39. I can't compile plpdf package. I have error RA-06502: PL/SQL:...

Tomek

06-25-2007 08:03 AM
Tomek

How to get type of input parameter into the PL/SQL? -- Thank you, De Cool, EPE, Ukraine

Dmitry Kulinich

05-31-2007 07:06 AM
Dmitry Kulinich

I have worked a lot with dBase (version III upto version 7). Is there a lot of difference between Oracle and dBase? Programming in dBase and visual...

nospam

05-22-2007 09:52 PM
EricF

Hi guys I seem to have a problem with my DB ORACLE 8.1. Since I'm having problem with tables hanging I've made a test procedure that INSERTS A...

daniele

04-21-2007 06:55 PM
daniele

Please what's the best tool i can use to transfer data from one Oracle DB to another

Jubri

04-15-2007 12:41 AM
JP

Sorry to bother you all with whith what is a possibly simple question. I had XE-Universal installed on a CentOS server at home to do stuff outside...

Rob Bradford

03-15-2007 07:45 AM
Rob Bradford

Hello All, Does anyone know how to translate this mysql statement into oracle statement. It's about calculate binairy numbers. Where the pipe is...

Rob

03-07-2007 03:39 AM
Rob

How I can execute base synchronisation between oracle and OID?

posty

01-26-2007 04:33 AM
Johan Louwers

Hello! I would be grateful if somebody clearify me the issue described below. I don't know how is is posibble that the size of tablespace is smaller...

Marcin Hirszberg

01-23-2007 05:13 AM
Marcin Hirszberg

Hi, I am new to Oracle and wonder someone may help for the question. In Oracle Database Concepts 10g Release, it said one can close a database;...

Hong Hsu

12-09-2006 01:04 PM
Peter Jamieson

Hi, I am new to Oracle and wonder someone may help me the question. From Oracle Database Concepts 10g Release, it said one can close a database;...

Hong Hsu

12-09-2006 01:02 PM
Peter Jamieson

spare brain wrote: You are also dealing with an inability to follow usenet rules and only place your message into a group one time and...

Daniel Morgan

11-18-2006 12:12 PM
TGGA

How is this done in Oracle? Do I have to fetch all records and get the count from that or is there a better way?

Lorenzo Thurman

11-02-2006 04:38 AM
Thijs

Hi, I'm trying to produce a stored procedure or function which would allow me to fetch tree data stored in a table. Records of this table looks...

wish

10-15-2006 09:00 AM
KM

I have been searching for answers to this question ... but all I have found is other people asking the same question..but I have not found an...

riggor

10-12-2006 04:23 PM
riggor

Hi How I can do upgrade database for Oracle 8.1.7. to Oracle 9. Please help me. Thanks Slawek

slawek

09-26-2006 09:44 AM
Daniel Stragowski

I have some very large tables divided into yearly archives. I want to run a report where the user enters the date range of the data desired. The...

MartyL

09-22-2006 01:45 PM
MartyL

http://datamining.eruditionhome.com/forum/

09-21-2006 12:44 AM

Is there a DB solution that will query a sizeable excel file with multiple worksheets. Can anyone recommend a DB program that will do this? Or is...

Felix Becerra

09-16-2006 12:38 PM
Master Blaster

Hopefully the subject said it all. I have a sales table with a row per sale and each row has a sale_date column. I want to calculate average sales...

Matthew Wilson

09-13-2006 10:32 AM
Matthew Wilson

Hi everyone I would like to know if using several views for a complicated query is slower than placing all the code in one large query. I had heard...

Jeff User

09-12-2006 12:17 PM
Acme Acmeson

Hi I'd like to known the best (reccomended if any have experience) server hardware configuration and os for install oracle database 9i. Thank you.

libre

09-12-2006 10:40 AM
Jim K

Hi All, I am trying to load a tab delimited (text file) with the help of a procedure. To access these files I have to create an Oracle directory....

anand b

09-11-2006 08:17 AM
anand b

We have a tablespace including an Oracle sequence. One of our sites is required to reboot the server under certain circumstances, and sometimes when...

David Shochat

09-10-2006 03:40 PM
Acme Acmeson

Hi, I'm teacher and i want to show my students ORACLE XE. Could someone tell me is there any good free, open source, shareware, trial software for...

kiel44

09-08-2006 02:54 PM
Matthias Hoys

Hello, help me please. I have stored procedure in Oracle server. This is simple fragment: procedure ABCD() IS ora_table_name VARCHAR2(20); BEGIN

artur

09-07-2006 04:09 AM
artur

Hello Doers anyone of you know how to parametrize SQL script ? I have one in *.sql file and want to have one or more parameters in it, wich user has...

Czujnik

09-07-2006 03:54 AM
Ariel

Hi, I have a problem and would invite any assistance available. I am working on a database table, with approx 2.5 m rows, the structure of the...

gjeff@chariot.net.au

09-07-2006 03:47 AM
Ariel

I'm reversing the normal order of LIKE, with the column on the right side: SELECT domain FROM tbl_domain WHERE 'com.hotmail.subdomain' LIKE domain...

Ariel

09-07-2006 03:27 AM
Ariel

Hi how in Oracle build cross query like in MS Access in MS Access I have: TRANSFORM Sum(t1.war) AS SumaOfwar SELECT t1.id, t1.name FROM t1 GROUP BY...

t

08-29-2006 02:47 AM
t

Does anyone has sql tuning tools for oracle recommendation? thanks

abby

08-15-2006 04:12 PM
Matthias Hoys

Hello, I have installed Oracle 10g. How can I check whether everythink passed. Should I create simple database or something else? Please help Thank...

RAM

08-04-2006 09:09 AM
carlos.escobar

Hi all, I'm new to oracle programming, in fact i'm in training to become a dba where i work, my problem is, i have made a function in PHP using ADODB...

carlos.escobar

08-03-2006 05:51 PM
carlos.escobar

Hello! I am opening a form name "Martin", then I open a form "Ann" and then report "John". How to close a form Martin and Ann form while closing a...

Kamyk

07-25-2006 01:11 PM
Kamyk

hello it is possible in oracle 10g to implement history which remember which row in a table was read by a user? thanks in advance Peter

Piotr Kozak

07-18-2006 08:53 AM
Piotr Kozak

Hello, I have a little problem with configuration outpost firewall ~ oracle 10g. When I try to install database outpost do some kind of reset and...

colin

07-12-2006 03:36 AM
colin

Hi, I work with Oracle HRMS and I want to link some custom workflow to the business events. I have tried to find some documentation that explains...

PAUL MADDSION

07-02-2006 04:27 AM
PAUL MADDSION

Has anyone been able to install Workflow over Oracle 10 Express on a Windows XP pc? If so could you please give me a few pointers. Thanks, Gary

Gary

06-29-2006 02:55 AM
Robbert van der Hoorn

Hi, i have a little proble with Oracle 10g XE. In our company we have full oracle 10. Now we have to do backup server so we choose XE edition. But...

kiel44

06-28-2006 03:31 AM
kiel44

Hi, We just migrate some pc from windows 2000 to Windows XP Some of our SELECT are now very slow, even if we don"t change any parameters. When I...

tsc1

06-27-2006 08:42 AM
tsc1

Hi all, Due to disk error we had to restore an entire db. We have recovered all of data, but some system user has disappeared. I've manually created...

DzU

06-26-2006 08:38 AM
DzU

We are looking for an economical ad-hoc query tool as a replacement for Oracle's Discoverer. Does anyone have any suggestions? It should...

Cherie Jo Patenaude

06-21-2006 06:16 PM
Cherie Jo Patenaude

Does anyone know if there is any way to generate table, index DDL from an installed instance? Thanks! C.

Corey Wirun - Telus

06-10-2006 10:36 AM
Aslan

Hi, We just migrate some pc from windows 2000 to Windows XP Some of our SELECT are now very slow, even if we don"t change any parameters. has...

tsc1

06-07-2006 10:20 AM
tsc1

Hi all, I've got a set of scripts that I run in Sql*Plus, running in the Classic environment on Mac OSX. The scripts use the spool feature to...

Jim Pistrang

05-30-2006 05:41 AM
Jim Pistrang

Hi, I am an XML newbie. I am trying to retrieve data , in the form of XML from a table that has a nested table. My table structure is as follows...

iota1234

05-11-2006 09:26 AM
iota1234

I create an Oracle directory object on Windoze with the following syntax: CREATE DIRECTORY MY_DATA AS 'C:\Oracle\data\mydata'; Is there any way in...

John Jones

05-06-2006 03:53 PM
bdj