Oracle9i Installation Error

Hello All, We are trying to install Oracle9i on HP-UX and getting following message: Error in invoking target install of makefile: /oracle/product/9.0.1/ctx/lib/ins_ctx.mk I have looked through metalink but could not find anything satisfying. I would like to hear from someone who has an idea

Comparison between Oracle 8 and Oracle 9

Hi everybody, Currently we are using Oracle 8.1.7 in our company and for a new datawarehouse project, a consultant company has suggested us to use Oracle 9. The have claimed that applications run much faster and it's more reliable etc... Of course I was not convinced. Could you please tell me,

Re: Currently log-in users

Hi, You may use the view V$SESSION. Regards M.Emre HANCIOGLU Masterfoods Services GmbH Nguyen, David M [EMAIL PROTECTED] xo.com Sent by: [EMAIL PROTECTED] 11.04.02 17:53 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:

Re:Import excelfile into Oracle table

Hi, You'd better do the following: * Convert the excel file to .csv file. * Use utl_file package to read the data and insert to Oracle Tables. M.Emre HANCIOGLU Masterfoods GmbH

Re:Re:Import excelfile into Oracle table

Here is an example. As far as I know, utl_file package reads data from unix box. So the file path below should be on Unix and be careful about your rights writing or reading from this path. DECLARE outfile_handle UTL_FILE.FILE_TYPE; v_test VARCHAR2(1000) ; BEGIN outfile_handle :=

Renaming files on Unix via PL/SQL

Hi all, Is it possible to rename files (e.g .txt files) on Unix by using PL/SQL? Is there a function to do that? Regards M.Emre HANCIOGLU Masterfoods Services GmbH ISI Application Support Tel : +49 2162 500-576 Fax: +49 2162 41497 E-Mail: [EMAIL PROTECTED]

Re: TOAD schema browser

Hello, You should change the schema name from the list box, which is just under the toolbar. Regards M.Emre HANCIOGLU Masterfoods Services GmbH ISI Application Support Tel : +49 2162 500-576 Fax: +49 2162 41497 E-Mail: [EMAIL PROTECTED] Sergey V Dolgov [EMAIL PROTECTED] pptus.oilnet.ru

ORA-02074: cannot Rollback in a distributed transaction

Hello, I have this error 'ORA-02074: cannot Rollback in a distributed transaction' in a stored procedure of PL/SQL. In a FOR LOOP, when I have an error, I make a Rollback in the EXCEPTION and I get this error. I had looed up in the Server Messages but was not helpful. I would like to add that I

Re: good pl/sql coding/debugging tool?

I would suggest you to use TOAD because the DBA Module of this product is quiet good. Database Monitor and Unix Monitor could also be used. Another option is SQL Station from CA. Regards M.Emre HANCIOGLU Masterfoods Services GmbH ISI Application Support Tel : +49 2162 500-576 Fax: +49 2162

Re: toad question

Only 'Execute' right should be enough. Regards M.Emre HANCIOGLU Masterfoods Services GmbH ISI Application Support Tel : +49 2162 500-2576 Fax: +49 2162 41497 E-Mail: [EMAIL PROTECTED] Jeffrey Beckstrom [EMAIL PROTECTED] gcrta.org Sent by: [EMAIL PROTECTED] 29.01.2003 15:48 Please

Error in Rownum Select

Hello, Can anyone tell me the reason, why I get an error because of the Order By in Oracle 8.1.5. It works fine in 8.1.7 and 9.2. declare v_t number(8); begin SELECT tagesdatum into v_t FROM (SELECT rownum n, tagesdatum FROM (SELECT tagesdatum FROM kalender

RE: Error in Rownum Select

It seems so.. Thanks. Regards M.Emre HANCIOGLU Masterfoods Services GmbH ISI Application Support Tel : +49 2162 500-2576 Fax: +49 2162 41497 E-Mail: [EMAIL PROTECTED] - Forwarded by Emre M. Hancioglu/VSN/Effem on 11.02.2003 16:10 - Stephane Faroult [EMAIL PROTECTED]

AW: Error in Rownum Select

In this statement, I'm trying to get (last working day - 6 days) from a specific table. If I remove the ORDER BY, I can never retrieve the correct rownum and of course the date. Regards M.Emre HANCIOGLU Masterfoods Services GmbH ISI Application Support Tel : +49 2162 500-2576 Fax: +49 2162