RE: Connections with WebLogic (5.1) and Oracle 8.1.7 on Solaris[Scanned]

any reason for the different behaviour... Any ideas... Rgds, Joshua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karthikeyan S INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing li

RE: BUFFER OVERFLOW, LIMIT OF 2000 BYTES.[Scanned]

Try, set serveroutput on size 100  I faced this problem sometime back and it worked when I set the size to 100.   -Original Message-From: Meomeo Nguyen [mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 24, 2002 10:23 PMTo: Multiple recipients of list ORACLE-LSubject:

RE: Group By - Without using aggregate functions[Scanned]

BREAK ON and it works. But I want use this query in a java program. Is there any solution for this? TIA regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karthikeyan S INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Group By - Without using aggregate functions

it works. But I want use this query in a java program. Is there any solution for this? TIA regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karthikeyan S INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: Moving data between tablespaces[Scanned]

Is there any way to move the records and the table to some other tablespace? regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karthikeyan S INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Californ

RE: Moving data between tablespaces[Scanned]

Amar / Thomas, Thanks a lot for your help. As you said, "ALTER TABLE {table_name} MOVE {tablespace}", solved the problem. regards, Karthik -Original Message- Sent: Tuesday, September 17, 2002 5:10 PM To: [EMAIL PROTECTED] Cc: Karthikeyan S Karthik, Look at the A

Moving data between tablespaces

Hi All, Some of my tables are accidentally created in the SYSTEM tablespace. Is there any way to move the records and the table to some other tablespace? regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karthikeyan S INET: [EMAIL PROTECTED] Fat

RE: Oracle Installer not launching in NT[Scanned]

#x27;) and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K

Spooling data containing Umlaut character (DB characterset UTF8)

get this problem. Any info on this would be of great help. regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karthikeyan S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Publi

RE: Changing sysdate - Problem resolved

Title: RE: Constraints problem Hi Gurus,   Thanks a lot for your help. The problem is resolved now.    regards, Karthik -Original Message-From: Karthikeyan S [mailto:[EMAIL PROTECTED]]Sent: Wednesday, September 04, 2002 2:48 AMTo: Multiple recipients of list

RE: Changing sysdate[Scanned]

lto:[EMAIL PROTECTED]]Sent: Wednesday, September 04, 2002 12:53 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Changing sysdate[Scanned] Change the System date, and restart the database. -Original Message-----From: Karthikeyan S [mailto:[EMAIL PROTECTED]]Sent: Wednesday, Sep

Changing sysdate

Title: RE: Constraints problem Hi,   Is it possible to change the sysdate?  (Solaris 5.8, Oracle 8.1.7) TIA.   K.    

Cognos-unix???

Hi, Is it possible to install Cognos (Version 7) in an UNIX environment (HP, SCO or whatever) ? Thanks in advance... regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: karthikeyan S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

To_Char Problem

ated_date,'dd/mm/ hh:mi:ss')) from amend_default_value c where c.effective_from <= sysdate and c.effective_to>= sysdate and c.group_id = '942' and c.default_type_id = b.default_type_id); Thanks in advance. regards, Karthik -- Please see t

Error while invoking Email from PL/SQL

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

CLOB columns

editor? I tried DBMS_LOB.READ(locator_var,amount_var,offset_var,output_var) and DBMS_LOB.OPEN(locator_var,1); K. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: karthikeyan S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Unable to conenct from Java front end

-- Author: karthikeyan S 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

Problem while importing a dmp file

help regarding this is appreciated. Thanks in advance, regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: karthikeyan S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Pu

Select Query - Help required

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

Unable to connect to an Oracle Instance

cular ora instance is not connectable from any workstation) " Thanks in Advance K. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: karthikeyan S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

RE: Oracle Performance Tuning steps[Scanned]

Gavin,   I too faced a similar kind of problem in the past. Probably there are some uncommited data in your database (that are related to this package) or somebody might have closed a sql session manually while executing this package. This will create a lock on some of the tables accessed b