How to find creation date for Rollback segment

Is there any way to find out created time stamp for a rollback segment apart from looking into alert.log. TIA Kranti This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the

how to find elapsed time for a query in oracle 8.1.7 Database

Hi Gurus, Is there any way to find out which queries are taking say more than 20 min in oracle 8.1.7 Database. Regards, Kranti Pushkarna This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received

RE: how to find elapsed time for a query in oracle 8.1.7 Database

Stephane, LAST_CALL_ET lets u know that user is idle for so long (correct me id i am wrong) and I want to know which queries are taking long time. Unfortunately I cannot use Oracle trace for it. Regards, Kranti Pushkarna

Re: Urgent - Help ....

u need to increase the length of the field USERNO and make corresponding changes in the application where you are accessing this field. Syntax will be something like this Alter table table_name modify column_name; HTH Kranti

Migration from 8.1.7 to 9.0.2

Hi all, Can anyone give me estimate time required for migrating a DB on 8.1.7 to 9.0.2. Size of the DB is 10GB. RAM is 1 GB. It is a dual CPU system on windows NT. Thanx Kranti Pushkarna This message is for the designated recipient only and may contain privileged, proprietary, or otherwise

passing parameters to a stored procedure from command prompt

Hi all, I am running a batch file through which I am opening SQLPLUS session and calling a stored procedure. I want to pass parameters to this procedure from the command prompt. Is it possible? Can anyone on this list will help me. Environment is Oracle 8.1.7 and OS Win2k. Thanx, Kranti

Re: passing parameters to a stored procedure from command prompt

, I am running a batch file through which I am opening SQLPLUS session and calling a stored procedure. I want to pass parameters to this procedure from the command prompt. Is it possible? Can anyone on this list will help me. Environment is Oracle 8.1.7 and OS Win2k. Thanx, Kranti Pushkarna

RE: change a database connection in a stored procedure?

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

RE: Re[2]: change a database connection in a stored procedure?

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

RE: IN() question

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

change a database connection in a stored procedure?

Hi List, Can someone tell me is it possible to change a database connection in a stored procedure? if so how? TIA Kranti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kranti pushkarna INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: Sql Question

Thanx Stephane . I did the same STAARSHIP TECHNOLOGIES www.staarship.com Kranti Pushkarna Project Leader Tel: +91-22-6931557 __ Failure to prepare is preparing

stored procedure status

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

RE: stored procedure status

Kranti Pushkarna Project Leader Tel: +91-22-6931557 __ Failure to prepare is preparing to fail __ -Original Message- Sent: Wednesday, May 01, 2002 2:28 PM To: Multiple recipients of list

Sql Question

Hi List, Can someone give a SQL query to retuen all values in paricular column in comma separed format. e.g. suppose I fire "select deptno from dept" the output would be like Deptno 10 20 30 40 I want the output like 10,20,30,40. I am just wondering can it be done in a single query.

RE:

F1 -Original Message-From: Ravindra B [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 30, 2002 3:09 AMTo: Multiple recipients of list ORACLE-LSubject: HELP

RE: Constraints

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

RE: One sql statement

, 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: kranti pushkarna INET: [EMAIL PROTECTED

error 997:overlapped I/O process is in progress

Hi all, I am getting error 997:overlapped I/O process is in progress when I am starting oracle management server service. My system is using DHCP. Can anyone give me idea what to do in this case. Thanx in advance Kranti Pushkarna -- Please see the official ORACLE-L FAQ: http

how to grant selct on all the ables in schema

Hi all, Is there anyway of granting select on all the tables in a schema in one shot. Regards STAARSHIP TECHNOLOGIES www.staarship.com _ Kranti Pushkarna Project Leader Tel: +91-22-6931557

RE: Weid exp/imp problem

Title: Weid exp/imp problem This error is coming because at the time of adding foreign key constraint , referencing primary key is not available. You can avoid this error by creating a similar schema in the user in which you are taking the import and then import data with parameter

RE: which view for hidden objects

Title: RE: which view for hidden objects If u mean X$ tables it is V$fixed_table. -Original Message- From: Seema Singh [SMTP:[EMAIL PROTECTED]] Sent: 28 ÑãÖÇä, 1422 12:11 AM To: Multiple recipients of list ORACLE-L Subject: which view for hidden objects Which

RE: OCP

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

RE: Change sysdate in database to a future date

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: kranti pushkarna INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: ORA - 12560: TNS: protocol adapter error

Title: How to read trace file just start the oracle service in the control panel Kranti -Original Message-From: Saurabh Sharma [mailto:[EMAIL PROTECTED]]Sent: Tuesday, November 27, 2001 3:35 PMTo: Multiple recipients of list ORACLE-LSubject: Re: ORA - 12560: TNS: protocol

RE: NT SCheduler !!

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

RE: Move table to another tablespace

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

RE: schema documentation

of 'ListGuru') 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: kranti