Rollback after truncate?? + 2 more questions :-)

Thank you for your help Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: Rollback after truncate?? + 2 more questions :-)

Mercadante Oracle Certified Professional Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Order by question - newbie

Hi, I have a table with 3 colums : PersonalCode, Name and SpecialOrder. The PersonalCode is the primary index and I have also an index on SpecialOrder,Name columns. However the following select: Select PersonalCode From MyTable Order By SpecialOrder,Name doesn't use the SpecialOrder,Name

RE: ORACLE 9i doesn't start on Linux Solved

the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Re: Dba studio under 9i for Linux?

Csillag Zsolt wrote: Hi, Can you tell me where can I find Dba Studio under Oracle 9i for Linux. I've tried the different files in the Bin directory with no result. T.I.A. Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

Morpheus killed my Oracle! Help!

. Thank you in advance Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Morpheus killed my Oracle! Help!

-- Facsimile: +61 (0)7 3303 3048 Csillag Zsolt [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 26/11/2001 09:00 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject: Morpheus killed my Oracle! Help! Hi, I've installed

RE: Morpheus killed my Oracle! Help!

it will tell you what ports are used. When you try to start the listener service what gets written into the listener log file? HTH, Bruce Reardon - Csillag Zsolt [EMAIL PROTECTED] 26/11/2001 09:00 AM Subject:Morpheus killed my Oracle! Help! Hi, I've installed Morpheus. Right

1 1 ??? Strange problem

FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

The code doesn't work in the package

Hi, The following code work as you can see below, but if I put this code in a package ( a procedure in a package) then I got ORA-01031 insufficient privileges error. This is absurd for me because it's the same user (an administrator) that owns the package, tablespace, table and everything. From

Re: The code doesn't work in the package

Hi, Thank you for your help. Now it works. At 11:00 2001.12.16. -0800, you wrote: You need to read on up on permissions. privileges that you get thru a role does not work for stored objects, like proces/pkgs. joe Csillag Zsolt wrote: Hi, The following code work as you can see below

How to prevent Oracle 9i for Windows from starting?

: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E

Utl_Smtp trouble

versions. Both customers have internet through ethernet(intranet) connection. Thank you in advance. Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

Data transfer between 2 databases

see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Function slows the select

Hi, In the following select statement I have a function GetSid that slows the update for hours even if the Link_keszit updatable table consists of a few rows. Update UpdateTable--Varosokat updatel Set UpdateTable_Column1= -- ( Select distinct 'Some string

Linux profile - a little offtopic

-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

ORA-03113 end of file comm. error - Why???

with the same data, maybe all 100 will be good, but there is a chance that e.g. the 97-th will give this error. Thank you Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

I still can't install Oracle on Linux - help

Hi, I have the following environment: Suse 7.1, Oracle 8.1.6, 256 Mb Ram, KDE, Java runtime (I hope I installed it correctly). When I run the Installer from Kde, it makes nothing, but if I run from terminal window I get a very long list ended by an OK. I'm going to paste below the whole

Update question - a little newbie

in SELECT list of cursor to avoid duplicate column names. That's correct since the two tables has the same structure. Thank you for your help Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City

Re: I still can't install Oracle on Linux - help

: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E

RE: Update ALL colums without knowing their name??-correction

] -Original Message- From: Csillag Zsolt [mailto:[EMAIL PROTECTED]] Sent: Monday, July 23, 2001 5:33 PM To: Multiple recipients of list ORACLE-L Subject: Update ALL colums without knowing their name?? Hi, I need an universal update procedure in which I don' t know the colums name. How

Surprising event

? If an index is bad how come Oracle doesn' t see it? It is important for me to know that for I don' t want to run in this problem again. Thank you Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City

Bulk collect error

,Vissza.FoFejezetKod,Vissza.Darab From Fofejezet F ; Can somebody help me? Thank you Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: Bulk collect error

2001.09.20. -0800, you wrote: Can you provide simplified resource details -Original Message- From: Csillag Zsolt [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 11:40 PM To: Multiple recipients of list ORACLE-L Subject: Bulk collect error can you provide

RE: Bulk collect error

Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

For i (Select..)

you Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: For i (Select..)

Hi, If this code is a cursor then why doesn't everybody use it this way? For me it seems a lot simplier and easier than declaring a cursor in a normal way. At 14:50 2001.10.01. -0800, you wrote: the code IS a cursor --- Csillag Zsolt [EMAIL PROTECTED] wrote: Hi, I've read in Tom

Re[2]: For i (Select..)

FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

Group by problem

, or 1 because it hadn't got any relation. Can you help me work around this problem? Thank you Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

Linux client error

that the Oracle client library ($ORACLE_HOME/lib/libclntsh.so) contained an undefined symbol __cmpdi2. Can somebody help me? Thank you in advance Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network

Dba studio under 9i for Linux?

Hi, Can you tell me where can I find Dba Studio under Oracle 9i for Linux. I've tried the different files in the Bin directory with no result. T.I.A. Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED

lsnrctl error

: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E