RE: export/import

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

RE: FK Constraints

2001-03-21 Thread Rao, Maheswara
Title: Building FK constraints depends on the application characteristic.  We have an application in which we do not have any FK constraints.  The primary purpose of this application is monitoring the trade messages that flow from stock exchanges and match them with the stock purchase/buy o

RE: How to remove the Ora & Lstn services from the WinNT

2001-03-27 Thread Rao, Maheswara
t 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: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-

What is best practice - differenet schema/different dbs

2001-03-27 Thread Rao, Maheswara
. Raid 10. Memory 4 GB (memory can be increased if required). Oracle 816. Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Solaris security ?

2001-03-27 Thread Rao, Maheswara
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://w

RE: multiple schema in a database ???

2001-05-07 Thread Rao, Maheswara
; And is there an easy way to create a schema which is identical to another one? > > Thank you. > > Andrea > > __________ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROT

RE: Rename Datafile

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

Usage of Number type for table columns

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

RE: is C compiler a must for oracle UNIX installations ?

2001-08-16 Thread Rao, Maheswara
oralce requires to relink the executables after the installation. Regards -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Usage of Number type for table columns - Thanks to all

2001-08-16 Thread Rao, Maheswara
n to get it correct. -- Author: Galen Boyer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: OT : kernel using 75% of CPU

2001-08-28 Thread Rao, Maheswara
Title: Message Jerry,   On solaris you could run the same command.  Here is the path: /usr/ucb/ps -aux   Rao Maheswara.Rao @ Sungardp3 . com   -Original Message-From: Jerry C [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 28, 2001 4:17 PMTo: Multiple recipients of list ORACLE

RE: OT : kernel using 75% of CPU

2001-08-30 Thread Rao, Maheswara
Jerry, Be aware that the system performance degardes drastically while truss is running. Rao Maheswara Rao -Original Message- Sent: Thursday, August 30, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Hi, Jerry, Next time you see top output like shown below, please provide

RE: !! Keeping the list alive

2001-08-30 Thread Rao, Maheswara
Title: RE: !! Keeping the list alive I support. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 30, 2001 11:22 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !! Keeping the list alive AMEN! -Original Message- Fro

RE: RE: financial problems with fatcity.com

2001-08-30 Thread Rao, Maheswara
Title: OT: RE: financial problems with fatcity.com Ross,   We need to give free ride to you also.  Without your wit, the list some times becomes drag with too much of a heavy techie stuff. (just pulling :) )   Rao -Original Message-From: Mohan, Ross [mailto:[EMAIL PROTECTED]]Sen

RE: HELP : doubts regarding --- Tablespace ,Roll Segment , dif

2001-11-27 Thread Rao, Maheswara
ll or any of the above doubts. awaiting for all u're replies eagerly. regards sangeetha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

RE: For You Telnet Experts

2001-11-28 Thread Rao, Maheswara
Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Califor

Urgent - error ORA-24327

2001-11-28 Thread Rao, Maheswara
List   The environment : Oracle 817 : Solaris 7 : Memory - 4 GB. WebLogic Vesrion: 6.1   In the WebLogic Connection pool, when we try to open the connections beyond 246, we are getting this error - ORA 24327.   We are not getting this error when the connection pool in the WebLogic is below 2

RE: Urgent - error ORA-24327

2001-11-28 Thread Rao, Maheswara
Deepak, Processes parameter is set to 1000. Rao -Original Message- Sent: Wednesday, November 28, 2001 5:05 PM To: Multiple recipients of list ORACLE-L what is your processes parameter set to? --- "Rao, Maheswara" <[EMAIL PROTECTED]> wrote: > List > > The

RE: RE: ORA-03113

2001-11-29 Thread Rao, Maheswara
Title: RE: RE: ORA-03113 Lisa,   ps -fu oracleSID - command would not work.  The reason is when you -u option with ps, it looks for the user by name mentioned. In this case, there would not be any user by name oracleSID (most likely).  All the oracle processes would be owned by the user

RE: Crontabs and Oracle

2001-11-30 Thread Rao, Maheswara
... commands for an interactive shell here ... ;; *) ;; esac Tim. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Californi

RE: Crontabs and Oracle

2001-11-30 Thread Rao, Maheswara
... commands for an interactive shell here ... ;; *) ;; esac Tim. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Californi

RE: Resume issues - (Not posting my resume)

2001-12-03 Thread Rao, Maheswara
t to how small you can make the type and how short you can make the paragraphs. You still need your resume to be your representative, and if you've been in the field for a long time, you sometimes just can't be represented by one page. Hope this helps... Bambi. -- Please see the

RE: Possibly moving to Sun Equipment

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

RE: Oracle for Sun/64 Bit Question

2001-12-03 Thread Rao, Maheswara
e any other 817 release for Sun. I do see, however, 64 bit for Oracle for 9i. Thanks! Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: Quick Question on hotbackup

2001-12-03 Thread Rao, Maheswara
tablespace end backup ) -All parameter like init.ora,listener.ora,tnsnames.ora and passwd file -All archive log files Is any things missing in this list? Thanks -Seema -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network

RE: Oracle for Sun/64 Bit Question

2001-12-03 Thread Rao, Maheswara
William, Thanks for the update. Rao -Original Message- Sent: Monday, December 03, 2001 3:15 PM To: Multiple recipients of list ORACLE-L Rao, Maheswara wrote: >Tom, > >Yes. Oracle 817 comes in two disks. Installation is little tricky. The >best way, I found is, copy b

RE: doubts reg : Tablespace

2001-12-03 Thread Rao, Maheswara
t the time of creation of tablespace. can objects of two diff users be stored in the same tablespace and datafile. can two tablespaces contain the same datafile . thanx in advance sangeetha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL

RE: Error opening the database

2001-12-04 Thread Rao, Maheswara
ema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat Cit

RE: Changes to db after renaming mount points

2001-12-04 Thread Rao, Maheswara
r your help Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ---

RE: Init.ora Compabible Setting

2001-12-10 Thread Rao, Maheswara
e official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -

RE: tablespace in backup mode

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

RE: Becoming a DBA questions

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

RE: Unix question

2002-01-11 Thread Rao, Maheswara
ectory. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Pu

RE: OEM question

2002-01-30 Thread Rao, Maheswara
Y, 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: Rao, Maheswara INET: [EMAIL PROTECT

RE: Installed Product Info

2001-06-18 Thread Rao, Maheswara
p this info. Does anyone know what is necessary to get this info without the full install? TIA Terry -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: Common Oracle RDBMS Misconceptions

2001-06-26 Thread Rao, Maheswara
r papers :) Rachel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet ac

RE: Pentium 4 (gotta love wintel) install (attempt)

2001-07-03 Thread Rao, Maheswara
the secret of how this actually works? -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

Why this SQL does not work?

2001-07-11 Thread Rao, Maheswara
UM = 5 --- Question: Why second SQL statement does not work? I would be thankful for the clarification. Thanks, Rao [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-505

RE: Why this SQL does not work? - Thank You All

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

RE: Oracle 32bit / 64bit

2001-07-17 Thread Rao, Maheswara
to run UTLIRP.SQL script which recompiles all PL/SQL modules and alters certain dictionary tables. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

RE: AutoExtend

2001-07-20 Thread Rao, Maheswara
20, 2001 11:51 AM To: Multiple recipients of list ORACLE-L How can I determine if tablespaces are set up in autoextend? -- Author: Michael E. Cupp, Jr. INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED

What privileges are required for Shareplex?

2001-07-24 Thread Rao, Maheswara
://www.orafaq.com -- Author: Rao, Maheswara 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: E-mail from Alert Logs

2001-05-08 Thread Rao, Maheswara
ailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note 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 informa

RE: Order of columns in a table

2001-05-10 Thread Rao, Maheswara
der of the columns within a table? Any ideas? Yhis is 8.1.6 on Win2k. Thanks, Helmut -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

RE: Oracle 8i installation problem on Pentium 4

2001-05-14 Thread Rao, Maheswara
. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet ac

RE: cdump, bdump, udump

2001-05-15 Thread Rao, Maheswara
To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note 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 comma

RE: cdump, bdump, udump

2001-05-15 Thread Rao, Maheswara
, 2001 12:36 PM To: Multiple recipients of list ORACLE-L On Solaris 2.5, 2.6 and 2.7, as well as AIX we have removed the alert.log and space has immediately become free. (Not true with the listener.log however). Terry "Rao, Maheswara" wrote: > Ron, > > You would not be able

RE: cdump, bdump, udump

2001-05-15 Thread Rao, Maheswara
try to remove will it is being written to, it will not release the space. We tend to remove our logs during periods of low acitivity, so the file is not likely to be being written to. So we have not seen the space not released. Terry "Rao, Maheswara" wrote: > Terry, > > I te

RE: cdump, bdump, udump

2001-05-16 Thread Rao, Maheswara
> 2. You may not see an immediate reclamation of free space. Try to do sync ( > In solaris) and notice the free space. Also, try more than one method of > free space checking - Using du, bdf, sam or sysadmin tools. > > > > -Original Message- > From: Rao, Maheswara [SMTP:[EMA

RE: job offer from SAUDI ARABIA

2001-05-16 Thread Rao, Maheswara
Bunyamin,   I worked in Saudi Arabia for 5 yrs. (approx.). I could help you and clarify your various other questions.  If interested, please contact me directly.   Rao   [EMAIL PROTECTED]   -Original Message- From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]] Sent: Wedn

RE: Vocabulary

2001-05-16 Thread Rao, Maheswara
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.orafa

RE: Ok two databases..two machines..one database name

2001-05-25 Thread Rao, Maheswara
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: Rao, Maheswara INET: [EMAIL PROTECTED] Fat Cit

RE: Full user export

2001-05-25 Thread Rao, Maheswara
CLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE you

Your views on Quest - Shareplex

2001-05-29 Thread Rao, Maheswara
Shareplex product. Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Your views on Quest - Shareplex - Thank you all

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

RE: Oracle price politics

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

RE: What next ?

2001-06-07 Thread Rao, Maheswara
AIL PROTECTED] (note 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 FA

RE: Autologout of idle users

2001-06-07 Thread Rao, Maheswara
ng: 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: Rao, Maheswara INET: [EMAIL PROTECTED

RE: What next ?

2001-06-08 Thread Rao, Maheswara
g: 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: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Ser

RE: How do IMP & EXP - SOS

2001-06-11 Thread Rao, Maheswara
Title: How do IMP & EXP - SOS Deewaker,   You did not mention what is the version of Oracle 8i.  I am assuming it is higher than Oracle 815.  In this case do the following steps.   1. Take export of the schema using exp from Oracle 815.  To do this , you can connect to your source database

RE: Oracle 8i database & ER diagram

2001-06-12 Thread Rao, Maheswara
-- Author: Rao, Maheswara 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,

RE: Shared server model

2001-06-12 Thread Rao, Maheswara
work. Any thoughts on this would be helpful to me.. Thanks Raj -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: Enforced Costraints ??

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

Inserting records into a table without creating indexes

2001-09-11 Thread Rao, Maheswara
g the transaction processing. Is the above requirement feasible? Or am I on a wrong path? Please advise. Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-505

RE: Sqlplus tunning

2001-09-19 Thread Rao, Maheswara
the manual for exact syntax. Off hand, could not tell you). Then try your query. If you observe significant time difference, then, set other PARALLEL parameters in init.ora to optimize your system. Rao, Maheswara Rao Oracle DBA -Original Message- Sent: Wednesday, September 19, 2001 2:25

Question on Gaja's Raid Document

2001-09-20 Thread Rao, Maheswara
ich in turn controls the number of volumes on your system. " Question: Why the degree of parallelism is less on a 16-way volume compared to 16 individual drives? Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED]

Design Issue - Quick response appreciated

2001-09-21 Thread Rao, Maheswara
ase, he want to see the record with Account ID = "HP" also. Also, he want to see the related records from the child tables.   I tried with the idea of sequence number generation but it was failing.   Any ideas or suggestions are much appreciated.   Thanks,   Rao Maheswara Rao, Oracle DBA SunGard Securities 

RE: Design Issue - Quick response appreciated

2001-09-21 Thread Rao, Maheswara
n you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:    (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863   -Original Message-----From: Rao, Maheswara [mai

RE: Design Issue - Quick response appreciated

2001-09-21 Thread Rao, Maheswara
Any ideas or suggestions are much appreciated. Thanks, Rao Maheswara Rao, Oracle DBA SunGard Securities -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: Design Issue - Quick response appreciated

2001-09-21 Thread Rao, Maheswara
nt to see the related records from the child tables. I tried with the idea of sequence number generation but it was failing. Any ideas or suggestions are much appreciated. Thanks, Rao Maheswara Rao, Oracle DBA SunGard Securities -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

RE: Design Issue - Quick response appreciated

2001-09-24 Thread Rao, Maheswara
case, he want to see the record with Account ID = "HP" also. Also, he want to see the related records from the child tables. I tried with the idea of sequence number generation but it was failing. Any ideas or suggestions are much appreciated. Thanks, Rao Maheswara Rao, Orac

RE: Design Issue - Quick response appreciated

2001-09-24 Thread Rao, Maheswara
count ID = "HP" also. Also, he want to see the related records from the child tables. I tried with the idea of sequence number generation but it was failing. Any ideas or suggestions are much appreciated. Thanks, Rao Maheswara Rao, Oracle DBA SunGard Securities -- Please see

Does start with/connect by uses full table scan?

2001-09-24 Thread Rao, Maheswara
List, Does Oracle go for full table scan or does it use indexes when we use start with/connect by clause? Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: Discovering same SIDs on 2 boxes in OEM

2001-09-24 Thread Rao, Maheswara
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: Rao, Maheswara INET: [EMAIL PROTECTED]

RE: Design Issue - Quick response appreciated

2001-09-24 Thread Rao, Maheswara
ee the record with Account ID = "HP" also. Also, he want to see the related records from the child tables. I tried with the idea of sequence number generation but it was failing. Any ideas or suggestions are much appreciated. Thanks, Rao Maheswara Rao, Oracle DBA SunGard Securities

RE: Does start with/connect by uses full table scan?

2001-09-25 Thread Rao, Maheswara
-- Author: Rao, Maheswara 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

Comparing data between two tables in two schema

2001-10-01 Thread Rao, Maheswara
List, I have two schema. The tables in both schema are having same name and structures. Is there any tool to compare the data between two schema tabels? Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City

RE: Location of PLAN_TABLE

2001-10-29 Thread Rao, Maheswara
Title: Location of PLAN_TABLE We keep plan table in each of the developers schema and thus there is no problem of deletions and maintenance of this table.  Also, this is not such an important table for DBA maintenance.   Rao -Original Message-From: Thomas Jeff [mailto:[EMAIL PRO

RE: Oracle the best

2001-11-09 Thread Rao, Maheswara
/www.orafaq.com -- Author: Rao, Maheswara 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 fr

RE: Another Oracle DBA gets "The Bullet" in the UK - Seeking an O

2001-11-09 Thread Rao, Maheswara
n the > system , then you don't have a chance to look at your > apartment in daylight...heck last week I was in same > clothes for 42 Hours straight recovering 150 GB > Monster from a 'rolling disaster'. Say anything else > but don't say my Job is not complex...T

RE: Oracle the best

2001-11-12 Thread Rao, Maheswara
n MTS mode. It is running in shared server mode. Prasad BAV. --- "Rao, Maheswara" <[EMAIL PROTECTED]> wrote: > Prasad, > > Is the database running on MTS mode? > > Rao > > -Original Message- > Sent: Friday, November 09, 2001 9:00 AM > To:

RE: Off Topic: Message for you

2001-02-15 Thread Rao, Maheswara
Great and Very nice!!!   Rao   [EMAIL PROTECTED]   -Original Message- From: magesh [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 9:10 PM To: Multiple recipients of list ORACLE-L Subject: Off Topic: Message for you     Dear All   Execute the statement on a

RE: OFFTOPIC: Spam.

2001-02-15 Thread Rao, Maheswara
I tried to contact Edward Hoskins.  But he is unavailable as per the operator.   Rao   [EMAIL PROTECTED]   -Original Message- From: Grabowy, Chris [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 15, 2001 1:32 PM To: Multiple recipients of list ORACLE-L Subject: OFFTOPIC:

RE: this drove me crazy!!!

2001-02-17 Thread Rao, Maheswara
; Function created. > > Try a few of these: > > SQL> select empno > 2 from emp > 3 where dumb=0 and > 4 empno < 20; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services

Sun/Oracle Best Practices URL

2001-02-20 Thread Rao, Maheswara
/Oracle Best Practices paper. TIA Zabair Ahmed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: metalink

2001-02-20 Thread Rao, Maheswara
? Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

How to find a listener service without running lsnrctl services

2001-02-20 Thread Rao, Maheswara
TED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Li

RE: How to find a listener service without running lsnrctl servic

2001-02-21 Thread Rao, Maheswara
, Ross [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 20, 2001 6:41 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to find a listener service without running lsnrctl servic     ps -ef | grep tns   -Original Message- From: Rao, Maheswara [mailto:[EMAIL PROTECTED

RE: How to find a listener service without running lsnrctl servic

2001-02-21 Thread Rao, Maheswara
> > Thanks for your help, > > Rao > > [EMAIL PROTECTED] > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: How to find a listener service without running lsnrctl servic

2001-02-22 Thread Rao, Maheswara
ronment : Solaris 2.7 : Oracle 8.0.4 Thanks for your help, Rao [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Controllers

2001-02-26 Thread Rao, Maheswara
Title: RE: 24*7 Operation using Compaq TRU64 List,   I am interested in learning the details about various disk controllers available in the market and their pros and cons and on how to select a good combination of disk and controllers.     Could any of you point me a website/book wh

RE: MetaSlop -- More Screeching and Droning.

2001-02-27 Thread Rao, Maheswara
Title: MetaSlop -- More Screeching and Droning. Mohan,   You brought laughter to the entire team here!!! Great. Keep it up.   Rao   [EMAIL PROTECTED]   -Original Message- From: Mohan, Ross [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 4:26 PM To: Multiple reci

RE: OEM 2.2. installation blues

2001-03-02 Thread Rao, Maheswara
Title: RE: OEM 2.2. installation blues Hi,   We installed oem2.2 on NT with 256 MB RAM.  Installation went through well and did not face any problems.  The packs installed – Tuning, Change Management, Diagnostics.   Rao   [EMAIL PROTECTED]   -Original Message- From: Vincent