Re: ORA - 12560: TNS: protocol adapter error

Title: How to read trace file check to see whether listener settings are done on the system. check for tnsnames.ora and listener.ora files on home\network\admin folder cheers. saurabh - Original Message - From: S.Jyotinarayan To: Multiple recipients of list ORACLE-L

Re: Oracle 9i Problem

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: Saurabh

Problem - V$BUFFER_POOL_STATISTICS

in adv Saurabh Sharma Mail to : [EMAIL PROTECTED] : [EMAIL PROTECTED]Contact : saurabh00pc @ MSN / Yahoo

Re: orapwd utility

://www.orafaq.com -- Author: Saurabh Sharma 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

Re: Hot Backup Issue

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

Re: Shutdown and archivelog mode

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: Saurabh Sharma INET: [EMAIL PROTECTED] Fat City

constraints in create table..

at the same time. i can't have null in aprimary key. what's the significance of this DDL. thanks in advance.. Saurabh Sharma

different stats in sga..

is this so, i'm getting diff values.. can anyone explain. thanks Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html

Re: IMP 8.1.6 to 8.1.7 DB

wanna get my lunch first , then i must say u ..YES. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 08, 2001 1:25 PM

mts parameters

. but all the connections made to server are dedicated. what does this means. what is then i'm using.. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html BEGIN:VCARD VERSION:2.1 N:Sharma;Saurabh FN:Saurabh Sharma EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV

Re: cleaning up oracle homes on NT

u can also remove specific or all oracle home from ur system. go to registry editor.. local machine/software/oracle and remove what u want.. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L

using ora dbf as datafile extensions..

in conversion or upgradation. any views. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html BEGIN:VCARD VERSION:2.1 N:Sharma;Saurabh FN:Saurabh Sharma EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20010731T071402Z END:VCARD

Re: Urgent..DB creation problem..

there are two parameters infact that need to be removed(commented) from init file. mts_dispatcher mts_server thanks for all replies. problem goes away. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list

Re: Urgent..DB creation problem..

thanks a lot Jon, that was really a big help. thanks again. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html - Original Message - From: Jon Walthour To: Multiple recipients of list ORACLE-L Sent: Saturday, July 28, 2001 5:55 PM

Re: Help need

Title: Help need Hi deewakar, hope this will help.. SELECT TABLESPACE_NAME,TABLE_NAME,INDEX_NAME FROM DBA_INDEXESORDER BY 1,2,3/ Saurabh Sharma Oracle DBA [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html - Original Message - From: Deewaker G.V

Urgent..DB creation problem..

e is no DB on the server, how is it reading the init.ora file. i've not specified any new mts_dispatcher parameter value. why it is showing me the error msg. how to counter this. other errors are oracle not available. error code ORA-00101 invalid specification for system parameter MTS_DISPATCHER

Re: Help ! ORA-00600 : internal error code

this is an error code that must be reported to Oracle support along with full description of error, procedure performed that caused this error and also details about your database environment settings. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html

Re: Solaris.. help.!!

thanks.. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 1:15 PM Start at Oracle Technet there is documents on installing and administering

Solaris.. help.!!

Hi all, please help me in finding the right doc about starting from scratch on Solaris. I'm looking for Solaris for Oracle. can anyone suggest me some good starting documentation or links on this. like introduction, architectue, installtion and configuration etc.. thanks. Saurabh Sharma

retrieving BLOB column..

hi all, do any one tell me how can i retrieve from a blob column. these will be displayed in browser through asp page. r there any functions used to retrieved records(jpg files, gif) from a blob. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html

OUTPUT WIDTH..

hi all, how do i increase the width of output of a querry concatenated with some strings through '||'. the output is truncated in the end. output is ok in sql prompt with set line option. but whatabput svrmgrl.. any idea.. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com

Re: Re: Jobs

a common effort of the have's for the have not's. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 23, 2001 7:10 PM Listers: Is it appropriate to be sending

Re: How to deal with special character like in ' '

choose use some other character for define. set define $ or so.. will let u insert string containing Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html - Original Message - From: Kevin Lange To: Multiple recipients of list ORACLE-L Sent

pls help..

on my system. this is surprising me a lot.. the TS is shown created on yesterday and is of 20 mb in size. how do i figure out, why is it so. how do it came here with such file location. i've 815 on NT pls suggest. thanks. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc

Re: Locally managed tablespaces

consider this also.. if u make a tablespace as LMT, the SMON process is not going to coalesce it automatically.. as it in the case of dictionary managed TS. if i'm wrong.. pls correct. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message

urgent pls...PL/SQL problem..

. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html

how to get back value stored through get_hash_value function..

hi list, dbms_utility.get_hash_value converts a string into its hash value.. how do we get back the original value while selecting the entire record. TIA Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html

strange datafile name..

system. this is surprising me a lot.. the TS is shown created on yesterday and is of 20 mb in size. how do i figure out, why is it so. how do it came here with such file location. i've 815 on NT pls suggest. thanks. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc

Re: Oracle db missing

i think u need to check whether the oracle agent is started on the node running that database. check it from control panel/services. a service named oracleAgent must be started. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message

Re:

u can always have multiple oracle homes on NT. create new home for installing new version. if u want to install higher version it will ask u for migrating the DB. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple

Re: db links...

thanks a lot. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 05, 2001 1:20 PM Hi, Create {public} database link LINK connect

Re: urgent..! how to combining 2 querries...

ya i checked this too.. it's not working. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 03, 2001 7:00 PM sorry. I checked it and turned out

urgent..! how to combining 2 querries...

querry as.. tablespace_name bytes1 bytes2 -- -- -- -- -- -- -- -- -- where bytes1 is sum(bytes) group by tablespace_name in table a. and bytes2 is sum(bytes) group by tablespace_name in table b. Saurabh Sharma [EMAIL PROTECTED]http

sysstat table..

log space requests 16redo log space wait time 1438redo log switch interrupts 0redo ordering marks 0 Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html

Re: EXECUTING DOS COMMAND IN A STORED PROC?

hi, i think u should make use of ocopy utility instead of simple copy command. this is provided in oracle_home\bin jsu replace copy with ocopy. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html - Original Message - From: Bunyamin K

need urgent reply..

not running saying unable toaccess the initialisation file. thanks in advance.. Saurabh Sharma Oracle 8i DBA

Re: which initSID?

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

Re: Auditing

(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: Saurabh Sharma INET: [EMAIL PROTECTED] Fat City Network

Re: Auditing

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

Re: Database in archivelog mode

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: Saurabh Sharma INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Re: Oracle Passwords

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

Re: GRANTS FOR SESSION

(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: Saurabh Sharma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

rowcount and rowsize..

hi all, i've a c program which calculates the estimated no of blocks required to store a table after reading the table name, row size and row count. i feel to gather these stats i need to analyze tables. the row size can be found at user_tables.ang_row_len. but from where can i get the

public objects..

hi, do the syntax 'public' in DDL means any new user with connect , resource (default) privileges would entitles himto accesssuch objects without any special privileges. ishould say whether its synonym, view, etc.. or we need to grant specific privileges on the object for any operation.

Re: Oracle 8i database ER diagram

://www.orafaq.com -- Author: Saurabh Sharma 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

regarding indexes..

hi all, how can we find whether we need to build more indexes other than primary keys. how can we know about what all indexes are being accessed, and creating on which columns will help improve performance. saurabh

Re: regarding isqlPlus

on Windows 2000 with 8.1.7.0.0. Works just fine, but .sql files are not able to read SQL*Plus commands (i.e. column xxx format a10). As I recall the install was fairly simple. Jon Baker Database Engineer (1/5) [EMAIL PROTECTED] www.netsec.net Saurabh Sharma wrote: hi all, has

Re: isqlPlus

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

Re: Oracle's Market share

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

Re: help for rollback segments..

? Because when they were created no tablespace was specified and they were created in the SYSTEM tablespace. From: Saurabh Sharma [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: help for rollback segments.. Date: Thu, 07 Jun 2001

regarding isqlPlus

hi all, has anybody using iSqlPlus tool, provided by oracle. what i know is , it's the internat enabled extension of sql * plus, utilising the 3-tier architecture. they say oracle 8.1.7 is required for the implementation. any suggestions. saurabh

help for rollback segments..

HI ALL, i've some confusion regarding rollback segments. could anyone explain this information from my database. select * from dba_rollback_segs revealed following stats.. SEGMENT_NAME OWNER TABLESPACE INITIAL_EX NEXT_EXTEN MIN_EXTENT MAX_EXTENT PCT_INCREA STATUS- --

Trouble.. Standby Database. Urgent!!

) The system cannot find the file specified. has anybody any idea of what's causing this problem. what i feel is there i may have wrongly configured the standby_archive_dest in init.ora at standby. any help is greatly appreciated. thanks. saurabh sharma

Re: Recording Destructive DDL

://www.orafaq.com -- Author: Saurabh Sharma 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

Re: How to send email from pl/sql in 806?

then raise_application_error(-2,'Unable to send e-mail message from pl/sql'); this msg is returned with ora 06512 any suggestions.. - Original Message - From: Jared Still [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Saurabh Sharma [EMAIL PROTECTED] Sent: Wednesday, May

Re: How to send email from pl/sql in 806?

.. - Original Message - From: Jared Still [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Saurabh Sharma [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 9:43 PM Subject: Re: How to send email from pl/sql in 806? On Wednesday 30 May 2001 03:10, Saurabh Sharma wrote: should i give it all

Re: Number Vs. Varchar2 Datatype

Title: Number Vs. Varchar2 Datatype this always a better decision to decide the datatypes of such columns keeping in mind the future requirements. u may come to a certain point where u think, number datatype to be better and somewhere to varchar2. u said number datatype which is not always

Re: 4 join methods?

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

Re: Table size

-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: Saurabh Sharma INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Re: How to send email from pl/sql in 806?

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

QUERRY DOUBT..

hi all, i've a querry that is to find out what all columns have constraints applied on them. giving the table_name,column_name,constraint name and constraint type. the querry goes like.. select a.table_name,b.constraint_name,b.constraint_type,c.column_namefrom user_tables

Re: Exporting and Importing table statistics

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: Saurabh

Re: How to send email from pl/sql in 806?

are available with oracle 8.1.5 onwards , thats the reason you were getting compilation errors. Ramana -- From: Saurabh Sharma[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Friday, May 25, 2001 12:40 PM To: Multiple recipients of list ORACLE-L Subject: Re: How

Re: QUERRY DOUBT..

THANKS A LOT, Seley the querry works absolutely fine. instead i've created a view. which can be easier to querry. and it also let me able to devise way for finding each individuals' report. thanks again. saurabh sharma - Original Message - From: Seley, Linda

Re: NT Scheduled Restart

Title: Database Down hi suhen, for some reasons i did'nt recieved the mail with the attachment as exe file. have u sent it. pls confirm. i'm also looking for such utilities. thanks. - Original Message - From: Rajesh Dayal To: Multiple recipients of list ORACLE-L

Re: Why I can not create temporary tablespace?

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

How to enable partitioning option now..

HI ALL, while querying the v$option view, i came to know thatPartitioning option is false. due to this i'm unable to create partitioned tables. how to enable such options. can i enable it now. i've oracle 8i version 8.1.5 on NT4.0 thanks in advance. saurabh.

Re: How to downgrade database from 8.1.5 to 8.0.6 - Urgent Help P

for downgrading from oracle 8 to 7, u need to take complete export and import the file in oracle 7 by running the catexp7.sql utility. look for more help on this utility. - Original Message - From: Djordje Jankovic To: Multiple recipients of list ORACLE-L Sent:

Re: SQL loader query

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

RE:..not importing previous export!!!!!!!!

hi winnie, it got me errors like..* IMP-00015: following statement failed because the object already exists:* IMP-00017: following statement failed with ORACLE error 1119:"CREATE TABLESPACE "ROLLBACK_DATA" DATAFILE'G:\ORANT\DATABASE\RBS1ORCL.ORA" ..* IMP-3: ORACLE error 1536

URGENT..not importing previous export!!!!!!!!

hi all, there is an urgent problem that cropped up while ihad some problems with oracle 8(version 8.0.4) database and after taking all the necessary backups, full database exports, physical copy of database and net8 folder.. deinstalled it. i then installed oracle 8i (version 8.1.5) and

Re: monitoring listener.log

Title: monitoring listener.log hey can u elaborate how do u scan each log file, and convert it in email msg. how do u do this.. saurabh sharma dba - Original Message - From: NGUYEN Philippe (Cetelem) To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 25

oraCore.log

hi everyone, can anyone help me in understanding the contents iof the above file... i.e. oraCore.log in orahome\rdbms##\trace\ what does this file contains and when it is created, which process controls it. thanks in advance. saurabh sharma

Re: Database Connection Log!!!

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

Re: Entity Relationship diagrams

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

Re: Default database blocksize

') 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: Saurabh Sharma INET

No Listner...!!!!

hi friends, I'm trying tough towards becoming a ful handed oracle 8 DBA. yesterday, i tried built new database on my test server, with successful creating req. set of files. i managed for successful running of both database. but got some problem while connecting toprevious one, it says

Re: Insert

, 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: Saurabh Sharma INET: [EMAIL PROTECTED] Fat

about analyse table..

hello, i'm not very familiar with the analyse table command. and not fully aware of it's advantage or limits to analyse the tables. could anyone pls help me with this cmd, how to see the analysed statistics, etc. any help is highly appreciated. thanks in advance. saurabh sharma

Re: Limit

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

Re: Re:date of last password change

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: Saurabh Sharma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-50

Re: Order of table_name resolution

(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: Saurabh Sharma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

Re: Last Fri. of the Month ?

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

Re: HOW TO SELECT LATEST INSERTED ROW..

- From: Saurabh Sharma To: Multiple recipients of list ORACLE-L Sent: Wednesday, February 21, 2001 3:45 PM Subject: HOW TO SELECT LATEST INSERTED ROW.. HI ALL, how can i select the latest inserted row from a table. i want

HOW TO SELECT LATEST INSERTED ROW..

HI ALL, how can i select the latest inserted row from a table. i want to select a col value, perform some operation on it and update the same to table via a trigger.. it says table is mutating. i'm inserting rows 1 at a time. any suggestions.. thanks in advance. saurabh

Re: could we please stop the political discussions?

I appreciate ur views..Jacques it's better if v discuss something meaningful..for which this list was created. saurabh - Original Message - From: Jacques Kilchoer To: Multiple recipients of list ORACLE-L Sent: Saturday, February 17, 2001 8:50 AM Subject: could we

Re: this drove me crazy!!!

ailing 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: Saurabh Sharma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

Re: Off Topic: Message for you

this was fabulous..how could u do it. pls explain.. - Original Message - From: magesh To: Multiple recipients of list ORACLE-L Sent: Thursday, February 15, 2001 7:40 AM Subject: Off Topic: Message for you Dear All Execute the statement on a

Re: Resouce Allocation

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

Re: top n or top n%

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

Re: Renaming a Column

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

Re: Off Topic: Row Locking - Row Id

te EXACT spelling 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 --

Re: How to insert data in LOBs

- A CLOB B BLOB SQL r 1 insert into kk 2* values ('PUMAS',utl_raw.cast_to_raw(' are the best rugby team')) 1 fila creada. Regards. -Mensaje original- De: Saurabh Sharma [SMTP:[EMAIL PROTECTED]] Enviado el: jueves 8 de febrero de 2001