RE: Crontab ,HELP!!!

2001-02-06 Thread Rajesh Dayal
T 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 -- Author: Ra

RE: ORA 1113

2001-02-21 Thread Rajesh Dayal
'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: Rajesh Dayal IN

RE: (F) Any way to tell if a DB is OPS?

2001-02-21 Thread Rajesh Dayal
://www.orafaq.com -- Author: Rajesh Dayal 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: How rename a database?

2001-03-11 Thread Rajesh Dayal
de 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: Rajesh Dayal INET: [EMAIL PROTECTED] Fat C

RE: Limit

2001-03-19 Thread Rajesh Dayal
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: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE:

2001-03-21 Thread Rajesh Dayal
, 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: Rajesh Dayal INET: [EMAIL PROTECTED] Fat

RE: how to store orace errors in database

2001-03-22 Thread Rajesh Dayal
:Lookup Oracle error messages. Similar to unix "oerr" command. rem This script is handy on platforms like NT with no OERR support rem Author: Frank Naude ([EMAIL PROTECTED]) rem rem modified by Rajesh Dayal to avoid entering negat

RE: Parallel Queries and CPU usage high

2001-03-31 Thread Rajesh Dayal
://www.orafaq.com -- Author: Rajesh Dayal 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

crontab fpr NT

2001-04-08 Thread Rajesh Dayal
Hi all, Some days back I remember someone mentioning about crontab on NT. Please pass that utility directly to me. Appreciate your help. TIA, Rajesh [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL

RE: crontab for NT

2001-04-10 Thread Rajesh Dayal
Dear Patrice, Thanks a Lot !!! Regards, Rajesh -Original Message- Sent: Monday, April 09, 2001 3:20 PM To: Rajesh Dayal Place the crontab file in Windows\system32 folder. crons.zip cron.zip cron1.htm cron2.htm cron3.htm cron4.htm Regards

crontab script problem

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

RE: crontab script problem

2001-04-17 Thread Rajesh Dayal
command. The commands written in /oracle/test1.sh is as follows, . /oracle/product/723/.profile sqlplus -s system/manager @/oracle/test2.sql Any help/suggestion would be greatly appreciated. TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal

RE: Datafile needs media recovery

2001-04-20 Thread Rajesh Dayal
ning: 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: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services

RE: Database Connection Log!!!

2001-04-23 Thread Rajesh Dayal
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: Rajesh Dayal INET: [EMAIL PROTECTED] Fat

ORA-12500

2001-04-25 Thread Rajesh Dayal
experience on this issue? Please suggest some solution. TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: ORA-12500

2001-04-26 Thread Rajesh Dayal
error in alert.log ? Rajesh Dayal wrote: Hi All, I have seen the error-manual for above Error message, but it really doesn't state anything clearly. Env is Oracle 8.0.5 on NT 4.0. This problem is not persistent and it comes intermittently. And it has come when

RE: Could not Connect to 8.1.6

2001-04-27 Thread Rajesh Dayal
Possibly it has something to do with Connect Data string in tnsnames.ora For 8i databases, SID has to be replaced with SERVICE_NAME.As can be seen in following example(OHIL is Oracle 8.0.5 database, and OHIR1 is 8.1.6 database) OHIL.OHIT.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =

RE: Re:Please Advice on Performance Tuning

2001-04-28 Thread Rajesh Dayal
') 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: Rajesh Dayal INET: [EMAIL

RE: question: create schema ?

2001-05-03 Thread Rajesh Dayal
the same objects, data, grants, etc)? Thank you. Leslie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: ??? Again: run unix script on NT

2001-05-09 Thread Rajesh Dayal
-- Author: Rajesh Dayal 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

RE: Urgent: Why is system tablespace growing?

2001-05-12 Thread Rajesh Dayal
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: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Urgent: Why is system tablespace growing?

2001-05-13 Thread Rajesh Dayal
-Original Message- Sent: Sunday, May 13, 2001 12:10 AM To: Multiple recipients of list ORACLE-L Rajesh, touser's temporary tablespace is temp, do have any other idea's as to why system tablespace is suddenly running out of space? Thanks abdul latif --- Rajesh Dayal [EMAIL PROTECTED] wrote

Running remote scripts

2001-05-13 Thread Rajesh Dayal
: Rajesh Dayal 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: Oracle 8i R3, and 9i R2 on Same NT Box

2002-10-01 Thread Rajesh Dayal
ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: doubt in INDEX

2002-09-01 Thread Rajesh Dayal
for your own FREE Personalized E-mail at Mail.com http://www.mail.com/?sr=signup -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

test

2002-05-22 Thread RAJESH DAYAL
Title: test Testing .

TEST

2002-05-23 Thread RAJESH DAYAL
Title: TEST TEST

RE: Is Oracle8.1.7 certified for NT4.0 ?

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

RE: Is Oracle8.1.7 certified for NT4.0 ?

2001-08-08 Thread Rajesh Dayal
-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: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: PERL PROGRAMMING

2001-08-09 Thread Rajesh Dayal
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: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: sqlldr80- error

2001-09-02 Thread Rajesh Dayal
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: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services

RE: Datawarehouse suggestions?

2001-09-02 Thread Rajesh Dayal
(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: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: Create Database ORA-907 need help

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

RE: export user definitions

2001-09-10 Thread Rajesh Dayal
(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: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: export user definitions

2001-09-10 Thread Rajesh Dayal
Thanks a lot for correcting me,I just remembered the basic idea and missed the real stuff ( SHOW=Y AND LOG=filename) Too Busy with some bugsNpatches of 8.1.7 ;-)) Rajesh -Original Message- Sent: Monday, September 10, 2001 4:10 PM To: [EMAIL PROTECTED]; Rajesh Dayal Rajesh, I am

RE: Downloading from Oracle

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

RE: stop sharon

2002-03-27 Thread RAJESH DAYAL
Title: RE: stop sharon Why not current one ? ;-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mark Leith Sent: Wednesday, March 27, 2002 2:33 PM To: Multiple recipients of list ORACLE-L Subject: RE: stop sharon EH? Virus? Joke? Wrong

TEST

2002-05-19 Thread RAJESH DAYAL
Title: TEST TESTING ...

Installing Oracle on W2k

2001-12-08 Thread RAJESH DAYAL
Hi All, I am trying to install oracle 8.1.7 on W2k Server. OUI doesn't start at all. What could be wrong? Any-body had any similar experience? TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: RAJESH DAYAL INET: [EMAIL PROTECTED] Fat City

RE: Installing Oracle on W2k

2001-12-09 Thread RAJESH DAYAL
8.1.7 on W2k Server. OUI doesn't start at all. What could be wrong? Any-body had any similar experience? TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: RAJESH DAYAL INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: Oracle 9i Real Application Cluster Concepts manual.

2002-01-08 Thread Rajesh Dayal
It's http://technet.oracle.com/docs/products/oracle9i/content.html HTH, Rajesh -Original Message- Tatikonda Sent: Wednesday, January 09, 2002 10:25 AM To: Multiple recipients of list ORACLE-L hi all, if any of you has Oracle 9i Real Application Cluster Concepts manual softcopy could

RE: Maximum number of redo log members

2002-01-15 Thread Rajesh Dayal
FAQ: http://www.orafaq.com -- Author: Rajesh Dayal 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: sqlplus question

2002-01-29 Thread Rajesh Dayal
://www.orafaq.com -- Author: Rajesh Dayal 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: sqlplus question

2002-01-29 Thread Rajesh Dayal
; dbms_sql.parse(c, 'alter system switch logfile', 1); d := dbms_sql.execute(c); dbms_sql.close_cursor(c); commit ; END; -Original Message- Faroult Sent: Tuesday, January 29, 2002 1:36 PM To: Multiple recipients of list ORACLE-L Rajesh Dayal wrote: I was also trying to put some script on Oracle

RE: OT : howto RTFM

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

ORA-600 and iOraBugFinder available

2001-05-20 Thread Rajesh Dayal
: Rajesh Dayal 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

RE: Problem with DBMS_UTILITY.ANALYZE_DATABASE

2001-05-21 Thread Rajesh Dayal
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: Rajesh

NT Scheduled Restart

2001-05-23 Thread Rajesh Dayal
Title: Database Down Hi all, I am looking for a utility (preferably freeware), which can perform a scheduled shutdown of NT 4.0 server. This I need because of inconsistent behavior of NT for Oracle Services. I want to do a scheduled restart after every night

RE: NT Scheduled Restart

2001-05-23 Thread Rajesh Dayal
Title: Database Down That's the best thing I like about this list... You ask for something and you get it, with no delay at all Thanks list and Thanks Suhen... Rajesh -Original Message-From: Suhen Pather [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 23, 2001

RE: Steve Adam's Removal

2001-05-25 Thread Rajesh Dayal
to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: Steve Adams's Removal

2001-05-28 Thread Rajesh Dayal
://www.orafaq.com -- Author: Rajesh Dayal 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: More views

2001-05-29 Thread Rajesh Dayal
(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: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

Row Chaining table fetch continued row

2001-06-05 Thread Rajesh Dayal
-- Author: Rajesh Dayal 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

RE: Where can I find openworld 2000 white papers?

2001-06-06 Thread Rajesh Dayal
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: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

RE: Which SQL is executing

2001-06-06 Thread Rajesh Dayal
Hi Chuan, Still your question is not clear to me. But I am sending you some scripts, may be these would help you: This gives SQL-TEXT, Oracle-User-name, machine-name and program-name for the user executing the SQLs. set pagesize 50 set head on set linesize 70 select

RE: How to remove corrupted blocks from datafile.

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

RE: urgent !!

2001-06-07 Thread Rajesh Dayal
Just check if this file inituybs.ora is present in the specified directory D:\oracle\ora816\admin\uybs. Alternatively you copy this file (inituybs.ora) to ORACLE_HOME\database directory, which is default place for this. In this case you can directly use startup nomount. HTH, Rajesh

decoding rowids

2001-06-07 Thread Rajesh Dayal
Hi all, I was just wondering if there is any alternative method of getting the numeric values of rowid other than dbms_rowid. Other way, what is the algorithm for calculating numeric value of rowid's values. e.g. SQL SELECT DISTINCT SUBSTR(ROWID,10,6) BLOCK# FROM PRASANTA.TPSV ;

RE: find allocated and used space for a table

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

RE: find allocated and used space for a table

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

test

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

RE: Removing Older version of Oracle on NT Machine

2001-06-12 Thread Rajesh Dayal
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: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: rowcount and rowsize..

2001-06-13 Thread Rajesh Dayal
but from where can i get the rowcount after analyzing table. USER_TABLES.NUM_ROWS It seems you are in hurry ;-)... Take a deeper look of manuals hth, Rajesh -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Saurabh SharmaSent:

RE: **Help Reqd Immdly** - Database Recovery problem...

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

Redo latch contention

2001-06-16 Thread Rajesh Dayal
of these parameters(which are made obsolete)... Appreciate your inputs ;-) Cheers, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: Oracle 8i installation problem

2001-06-16 Thread Rajesh Dayal
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: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: Oracle 8i installation problem

2001-06-17 Thread Rajesh Dayal
system to system.org) and tried. But it fails there too. Thanks, gopi --- Rajesh Dayal [EMAIL PROTECTED] wrote: Hi Pankaj, With 256 MB RAM, you may not be able to set set shmsys:shminfo_shmmax=4294967295 Try setting it to lower values 1-2 GB, It should resolve the issue

RE: How to size db_block_size?

2001-06-19 Thread Rajesh Dayal
Title: RE: How to size db_block_size? Just one thought. You check the block size of redolog files using following script ( -- Author:Steve Adams) select max(l.lebsz) log_block_sizefrom sys.x$kccle lwhere l.inst_id = userenv('Instance')/ This would give the OS Block Size. I am

RE: Yahoo!

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

RE: RE: How to find out what caused job to fail?

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

RE: Tkprof.

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

RE: Download a database

2002-02-10 Thread Rajesh Dayal
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: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City

RE: Changing dump destinations in init.ora

2002-02-13 Thread Rajesh Dayal
-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: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: View for Procedure/Function SQL Code

2002-02-14 Thread Rajesh Dayal
: http://www.orafaq.com -- Author: Rajesh Dayal 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: problem in creating control file?

2002-03-12 Thread RAJESH DAYAL
USE COMMAND LIKE . CREATE CONTROLFILE SET DATABASE TEST2 RESETLOGS ARCHIVELOG .. HTH, Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bunyamin K. Karadeniz Sent: Tuesday, March 12, 2002 3:48 PM To: Multiple recipients of list

RE: Upgrade 8.0.4 to 8.1.6

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

RE: OT RE: 24 x 7 on NT?

2001-06-27 Thread Rajesh Dayal
(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: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

test

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

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

2001-07-05 Thread Rajesh Dayal
://www.orafaq.com -- Author: Rajesh Dayal 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

RE: RULE versus CHOOSE - sorry it's long

2001-07-07 Thread Rajesh Dayal
') 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: Rajesh Dayal INET

9i New Features

2001-07-07 Thread Rajesh Dayal
I thought this would help all in becoming familiar with 9i DB ... http://technet.oracle.com/products/oracle9i/daily/content.html Here you can see one new feature of Oracle 9i on daily basis.. HTH, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal

RE: Backup script giving error when run by cron

2001-07-20 Thread Rajesh Dayal
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: Rajesh

Listener Security !!

2001-07-23 Thread Rajesh Dayal
doesn't have any cross OS check in it Is this a known issue/bug. Any-ideas, any patches? Oracle Corp guys, what you say? Waiting for you views.. Rajesh OC DBA 88i -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED

OT: Micsoft Technically Correct

2001-07-25 Thread Rajesh Dayal
://www.orafaq.com -- Author: Rajesh Dayal 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: Help ! ORA-00600 : internal error code

2001-07-26 Thread Rajesh Dayal
') 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: Rajesh Dayal INET

RE: Securing passwords in scripts

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

RE: how do i explain this ?

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

RE: Unix date ??

2001-07-30 Thread Rajesh Dayal
: http://www.orafaq.com -- Author: Rajesh Dayal 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: upgrade

2001-08-01 Thread Rajesh Dayal
. I have tried to recompile them to no avail. I did the upgrade manually running the script :u0800050. Is there anything else I needed to run??? Rgds Fawzia -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services

RE: Required Help on Analyzing dmp File

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

DB Restore

2001-09-23 Thread Rajesh Dayal
session password for backup sessions. Many TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

test

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

RE: DB Restore

2001-09-24 Thread Rajesh Dayal
]; Rajesh Dayal Rajesh, I haven't used this combination. I'm assuming that you're attempting to perform the restore now out of necessity, not out of testing. Restore the files to some other directory and manually copy them to local storage of the Oracle Server. Recover the effected files manually

RE: Block Dump Interpretation

2001-09-25 Thread Rajesh Dayal
: 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: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services

RE: cached tables

2001-09-30 Thread Rajesh Dayal
Just by executing the command alter table xxx cache ; Table won't come in cache. You have to select rows from the table to get itinto cache. Another point is that kept field is meant for pl/sql packages and functionsand not for objects like tables/indexes etc. Below is

Hot Backup Issue

2001-10-01 Thread Rajesh Dayal
://www.orafaq.com -- Author: Rajesh Dayal 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

2001-10-01 Thread Rajesh Dayal
the last logfile has been applied and open the database resetlogs and you will be fine --- Rajesh Dayal [EMAIL PROTECTED] wrote: Hi All, I am trying for hot backup restore/recovery. Oracle 8.1.7.0.0 on WIN 2K Server. I am performing the operations in following order: 1. Put all

RE: Hot Backup Issue

2001-10-02 Thread Rajesh Dayal
') 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: Rajesh Dayal INET

site-down www.unal-bilisim.com

2001-10-02 Thread Rajesh Dayal
Hi All, I have been noticing this site down for quite some time. Any idea when this would be up?? TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: Problem - V$BUFFER_POOL_STATISTICS

2001-10-20 Thread Rajesh Dayal
Wasnt statspack started with 8.1.6? Check the docs.. Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Saurabh Sharma Sent: Saturday, October 20, 2001 3:05 PM To: Multiple recipients of list ORACLE-L Subject: Problem -

  1   2   >