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

2002-10-16 Thread Karthikeyan S
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 list and web

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

2002-09-24 Thread Karthikeyan S
Try, set serveroutput on size 100 I faced this problem sometime back and it workedwhen 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:

Group By - Without using aggregate functions

2002-09-23 Thread Karthikeyan S
name 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

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

2002-09-23 Thread Karthikeyan S
BREAK ON column name 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

Moving data between tablespaces

2002-09-17 Thread Karthikeyan S
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: Moving data between tablespaces[Scanned]

2002-09-17 Thread Karthikeyan S
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 ALTER TABLE

RE: Moving data between tablespaces[Scanned]

2002-09-17 Thread Karthikeyan S
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, California-- Mailing

RE: Oracle Installer not launching in NT[Scanned]

2002-09-16 Thread Karthikeyan S
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: Karthikeyan S INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Spooling data containing Umlaut character (DB characterset UTF8)

2002-09-13 Thread Karthikeyan S
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-- Public Internet

RE: Changing sysdate - Problem resolved

2002-09-11 Thread Karthikeyan S
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 ORACLE

RE: Changing sysdate[Scanned]

2002-09-04 Thread Karthikeyan S
CTED]]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, September 04,

Changing sysdate

2002-09-03 Thread Karthikeyan S
Title: RE: Constraints problem Hi, Is it possible to change the sysdate? (Solaris 5.8, Oracle 8.1.7) TIA. K.

Cognos-unix???

2002-08-16 Thread karthikeyan S
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

CLOB columns

2002-08-12 Thread karthikeyan S
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

Error while invoking Email from PL/SQL

2002-08-12 Thread karthikeyan S
. -- 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 conenct from Java front end

2002-08-09 Thread karthikeyan S
-- 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

2002-07-30 Thread karthikeyan S
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-- Public Internet access

Select Query - Help required

2002-07-29 Thread karthikeyan S
. 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-- Public Internet access / Mailing Lists

Unable to connect to an Oracle Instance

2002-07-03 Thread karthikeyan S
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, California-- Public

RE: Oracle Performance Tuning steps[Scanned]

2002-07-01 Thread karthikeyan S
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 whileexecuting this package. This will create a lock on some of the tables accessed by