SQL*PLUS buffer width and buffer length stored where ??

2003-11-04 Thread Bob Metelsky
through the gui. I'm sure someone here knows that, or has a complete login.sql file to have the ability to enable the horizontal scroll by default Thanks Bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services

RE: SQL*PLUS buffer width and buffer length stored where ??

2003-11-04 Thread Bob Metelsky
Bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: What happened to Howard Rogers ?

2003-10-23 Thread Bob Metelsky
command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

question on comments -sanity check

2003-10-22 Thread Bob Metelsky
just burnt out... or am I missing something? A sanity check please. Also, is there a relatively easy way to maintain comments? Thanks! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: question on comments -sanity check

2003-10-22 Thread Bob Metelsky
? Thanks! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Can I concatenate several rows without a procedure?

2003-10-21 Thread Bob Metelsky
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.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: Can I concatenate several rows without a procedure?

2003-10-21 Thread Bob Metelsky
, 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.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED

passwords case sensitive

2003-10-17 Thread Bob Metelsky
Is it possible to force a password case sensitive? Command? Thanks! TGIF bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: passwords case sensitive

2003-10-17 Thread Bob Metelsky
ORACLE-L Subject: Re: passwords case sensitive see $ORACLE_HOME/rdbms/admin/utlpwdmg.sql Bob Metelsky [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/17/2003 01:54 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE

RE: Opinions sought on possible TOAD replacement

2003-10-16 Thread Bob Metelsky
TORA, OraC, sqlplus, vi, perl and a linux box to run it on, though the database servers are mostly Win2k. Software $0.00 OS $0.0 HW $12k A procedure return with no errors Priceless g FWIW for a nice sql editor golden is nice. Others on this list sold me on that bob

RE: How to add ' (comma) at the begining and end of each line? Either Unix or Windows

2003-10-16 Thread Bob Metelsky
ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

RE: Passed Net8 OCP Exam

2003-10-16 Thread Bob Metelsky
see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

question about less than values in a range partition

2003-10-10 Thread Bob Metelsky
include what is in partition 1 And partition 2 would have 1 and 0 Between would make more sence to me How does the less than N work? Thanks! bob Bob Metelsky Oracle Certified Professional Phone 203-245-5089 ext113 Office 203-245-5000 Continuum Performance Systems Inc http://www.cps92.com PGP

RE: how to keep statistics up to date for CBO

2003-10-09 Thread Bob Metelsky
of list ORACLE-L How does one keep CBO statistics for an applications base tables up to date? We are about to implement the CBO any must read documents. Many thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City

RE: where can I find sample db creation script (9.2.0.1.0 installation)?

2003-10-09 Thread Bob Metelsky
the file you menetioned. Looks like your box is Microsoft one. essex$ pwd /oracle/product/9.2.0.1.0/rdbms/admin essex$ ls -l b* b*: No such file or directory Guang -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network

how to keep statistics up to date for CBO

2003-10-08 Thread Bob Metelsky
How does one keep CBO statistics for an applications base tables up to date? We are about to implement the CBO any must read documents. Many thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services

RE: How to copy recursive files in Windows? like UNIX cp -r

2003-10-08 Thread Bob Metelsky
information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: where can I find sample db creation script (9.2.0.1.0 installation)?

2003-10-08 Thread Bob Metelsky
, 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.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat

RE: RE: Desupport of RBO[Scanned]

2003-10-07 Thread Bob Metelsky
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.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: how to send mail from windows command prompt?[Scanned]

2003-10-03 Thread Bob Metelsky
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Cary's book[Scanned]

2003-10-03 Thread Bob Metelsky
FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

RE: Oracle and nfs mounted devices.[Scanned]

2003-10-02 Thread Bob Metelsky
: 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.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services

RE: Hiding passwords

2003-10-02 Thread Bob Metelsky
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.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: createing test sessions

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

FW: createing test sessions

2003-10-01 Thread Bob Metelsky
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: how to generate unique file names on Windows.

2003-09-30 Thread Bob Metelsky
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.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: RE: Google's architecture -- was Re: paging and google.com

2003-09-30 Thread Bob Metelsky
Title: Message An brief overview of Googles architecture http://www.computer.org/micro/mi2003/m2022.pdf Google does use Oracle, but afaik only in-house for internal applications. The clustered search engine is entirely custom code and engine. 10,000 servers would be a pretty

RE: 8i OCP Net8 Exam

2003-09-29 Thread Bob Metelsky
). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: Off Topic: PC Firewall Recommendation

2003-09-29 Thread Bob Metelsky
for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: 10g: SQL Plus

2003-09-24 Thread Bob Metelsky
to like sqlplus (opposed to sqlplusw). One good feature is you have your command history using the up arrow like regular shell bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: download metalink articles - save target as

2003-09-24 Thread Bob Metelsky
://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

RE: Onames and various connections scenarios

2003-09-03 Thread Bob Metelsky
this method as its much more elegant ... and indeed I saw it on the list last Friday. Sure it's supposed to work that way. It is a documented feature. Otherwise there would be little point in having a 'set server' command. Jared "Bob Metelsky" [EMAIL PROTEC

RE: DBI in activestate perl

2003-09-03 Thread Bob Metelsky
Title: Message do you know about ppm type ppm at the command line perl package manager http://aspn.activestate.com/ASPN/Downloads/ActivePerl/PPM/ http://perl.about.com/library/weekly/aa030500a.htm hth bob Does anybody know how and where to get DBI/DBD::Oracle for ActivePerl

RE: DBI in activestate perl

2003-09-03 Thread Bob Metelsky
Title: Message sorry that shoud have been type atthe command prompt perl -MCPAN -e shell then one you walk through the setup you use ppm to install new packages -Original Message-From: Bob Metelsky Sent: Wednesday, September 03, 2003 11:09 AMTo: Multiple recipients

Some posts not showing up

2003-09-02 Thread Bob Metelsky
FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

RE: Onames and various connections scenarios

2003-09-02 Thread Bob Metelsky
dump_tnsnames c:\temp\tnsnames.txt worked fine for me. The default server is ns_ns1 Had I wanted to do this from another server, say ns2, I would have gone directly into namesctl, then issued the command 'set server ns_ns2' Jared Bob Metelsky [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED

RE: Congratulations Arup (DBA of the Year)

2003-08-29 Thread Bob Metelsky
://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

RE: Onames and various connections scenarios

2003-08-29 Thread Bob Metelsky
server is ns_ns1 Had I wanted to do this from another server, say ns2, I would have gone directly into namesctl, then issued the command 'set server ns_ns2' Jared "Bob Metelsky" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED]

RE: Onames and various connections scenarios

2003-08-27 Thread Bob Metelsky
gone directly into namesctl, then issued the command 'set server ns_ns2' Jared "Bob Metelsky" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/26/2003 03:04 PM Please respond to ORACLE-L To: Multiple recipients of

Onames and various connections scenarios

2003-08-26 Thread Bob Metelsky
means they will need to maintain a tnsnames file as well. I'm managing about 70+ connect discriptors And I was hoping onames could be a centralised answer Is this common? Or is there a workaround? Thanks! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob

RE: Onames and various connections scenarios

2003-08-26 Thread Bob Metelsky
://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself

Standby database ORA-16016

2003-08-14 Thread Bob Metelsky
. How can I be sure the primary sends all logs? Ive performed a log switch and the missing logs do not get sent. Does anyone have any suggestions to correct this? I would be very thankful. have a good weekend all! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob

Correct method of auto starting standby db

2003-07-31 Thread Bob Metelsky
seem to mention the starting up on the db http://www.oracle-base.com/Articles/8i/StandbyDatabase.asp Thanks! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: Imort Parameter File Question

2003-07-31 Thread Bob Metelsky
# your comment goes here # another comment # Bla bla -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: Correct method of auto starting standby db

2003-07-31 Thread Bob Metelsky
ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Correct method of auto starting standby db

2003-07-31 Thread Bob Metelsky
-- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

RE: Anyone using onames on win2k server + 8.1.7 ?

2003-07-28 Thread Bob Metelsky
+ 8.1.7 ? I used onames on 8.1.7 without a problem. It's the secondary server, but it always works. Jared On Friday 25 July 2003 12:54, Bob Metelsky wrote: All Ive gone round and round with a new install of 8.17 and getting names to work. Initially when

Anyone using onames on win2k server + 8.1.7 ?

2003-07-25 Thread Bob Metelsky
-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

NNC-00425: meta-data violation -- need sanity check!

2003-07-17 Thread Bob Metelsky
grin!! This has to be a bug. I was counting on pulling in the one 9.2 tns entry and then entering the other 60 by hand yecch!! Thanks! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

Multiple addreses in tns

2003-07-10 Thread Bob Metelsky
://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself

RE: Multiple addreses in tns

2003-07-10 Thread Bob Metelsky
a means of failover or allowing for continuity of connections while doing maintenance on a listener or server --- Bob Metelsky [EMAIL PROTECTED] wrote: Is having multiple addresses valid for a tns entry? A client provided this to me and initailly looked invalid alias

RE: Multiple addreses in tns

2003-07-10 Thread Bob Metelsky
? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Re[2]: Online tech books

2003-07-03 Thread Bob Metelsky
://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

RE: nt script

2003-07-01 Thread Bob Metelsky
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.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services

RE: nt script

2003-07-01 Thread Bob Metelsky
finished D:\oracle\adminrem if errorlevel 1 @d:\psfm\start_proc_sched.bat Bob Metelsky wrote: echo off @cls find ORA-124 C:\yourlog.txt NUL IF ERRORLEVEL 1 GOTO no IF NOT ERRORLEVEL 1 GOTO yes :no ECHO NOT FOUND goto end :yes ECHO String IS found pause

RE: Online tech books

2003-06-30 Thread Bob Metelsky
list will be contacting their respective publishers? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Bob Metelsky [mailto:[EMAIL PROTECTED] Sent: Wednesday, June

RE: Online tech books

2003-06-30 Thread Bob Metelsky
that message) But, Ive taken some pictures of my collection.. Ive actually purchaced all the books you see! http://162.42.213.232/books/index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services

RE: [Q] Script to generate grant privilege on a table?

2003-06-20 Thread Bob Metelsky
\insertperm.sql -- exit ; Does anyone has script which can check grant privilege on a table and generate output for future usage? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Online tech books

2003-06-18 Thread Bob Metelsky
This was just passed on to me and I'd like to share it wit the list... http://www.palaydium.net/tech/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: MySQL in the future?

2003-06-18 Thread Bob Metelsky
. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Re[2]: Online tech books

2003-06-18 Thread Bob Metelsky
purchaced 80% of the O'Reillys Oracles books and have here at my desk close to 2K$ of books that I personally purchaced. Again my humble apologies bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858

RE: recreating a create database file

2003-06-17 Thread Bob Metelsky
to continue, this will take you to the batch job check the logs... pause Exit Hth bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

OT Googles cluster architecture

2003-05-31 Thread Bob Metelsky
servers. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

SQL Loader Concatenate date and time

2003-05-30 Thread Bob Metelsky
row data 283700 05/28/2003 00:00:00 16:28:12fff eth-s4fp1c0 fff Log Accept nbdatagram 10.54.4.1 10.54.255.255 udp 23 nbdatagram -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL

RE: SQL Loader Concatenate date and time

2003-05-30 Thread Bob Metelsky
for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Need help with a dynamic query

2003-03-10 Thread Bob Metelsky
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Where is the sql stored for a stored procedure?

2003-02-20 Thread Bob Metelsky
to find the sql Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Service startup on Windows 2000 fails

2003-02-19 Thread Bob Metelsky
Title: Message Can you start the service via oradim? CMD oradim C:\oradim -STARTUP -SID -USRPWD -STARTTYPE srvc,inst -PFILE C:\your_path\ can you start the db via svrmgrl? CMDset oracle_sid=mysid svrmgrl connect internal/* startup pfile=. have you tried rebooting

RE: Service startup on Windows 2000 fails

2003-02-19 Thread Bob Metelsky
Title: Message Lisa Sorry, I misread your message, I had theimpression the db would notstart... not that the listener would not start. Is it possible you/someone installed oracle that was not an administrator, at the time of install. Sounds like a permissions problem. possible solution

Where is the sql stored for a stored procedure?

2003-02-19 Thread Bob Metelsky
Im mucking about in the user_ views... Im seeing dba_objects type = 'procedure'; but need to find the sql Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Schema specific grants

2003-02-12 Thread Bob Metelsky
; Anyone have the syntax for that? Many thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Schema specific grants

2003-02-12 Thread Bob Metelsky
- just easier to manage. good luck! Tom Mercadante Oracle Certified Professional -Original Message- From: Bob Metelsky [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 12, 2003 10:30 AM To: Multiple recipients of list ORACLE-L Subject: Schema specific grants Good

Looking for simple monitor script dbup.bat

2003-02-06 Thread Bob Metelsky
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Examples of dbms_job.submit intervals and arguments

2003-01-30 Thread Bob Metelsky
although all parameters would not hurt. Ive searched online and at tahiti but I couldn't really find good examples of usage Can someone point me in the right direction? Or provide examples..? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET

Creating a simple stored procedure

2003-01-30 Thread Bob Metelsky
to go insane} bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Creating a simple stored procedure

2003-01-30 Thread Bob Metelsky
present my delimma to my knowledgable friends @fatcity! {about to go insane} bob -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Examples of dbms_job.submit intervals and arguments

2003-01-29 Thread Bob Metelsky
examples..? Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Statspack recomendations.

2003-01-23 Thread Bob Metelsky
bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Dictionary location or initSID.ora and PWDsid.ora

2003-01-23 Thread Bob Metelsky
hardcoding the values Thanks!! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Statspack recomendations.

2003-01-23 Thread Bob Metelsky
deals there Ive always been reasonably pleased with the service as well. Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Global names

2003-01-22 Thread Bob Metelsky
command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: Auto start failing AGAIN... shared realm does not exist....

2003-01-21 Thread Bob Metelsky
are auto starting! Many thanks bob Also take a look at Doc # 136214.1 on MetaLink. Jared On Monday 20 January 2003 13:46, Bob Metelsky wrote: My scenario Fresh install of w2k server, sp 3 high end machine, twin 2G processers 4G ram ... Installed Oracle 8.17 release 3, Install went

Auto start failing AGAIN... shared realm does not exist....

2003-01-20 Thread Bob Metelsky
This is a new machine and I can reboot at will or make any changes (no one is using this server yet) so I really need to get this working. I am at a loss... any suggestions would be appreciated thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL

XML functonality in Oracle XML Developer Kit

2003-01-14 Thread Bob Metelsky
://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing

OT Recommended reading...

2003-01-08 Thread Bob Metelsky
I recall that people were looking for UNIX/DBA admin books, I did a search and came across some interesting reading Have a look, This is a riot! http://carcino.gen.nz/images/index.php/54de433e/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET

Cant install statspack !

2003-01-07 Thread Bob Metelsky
Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Cant install statspack !

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

RE: email out of oracle

2003-01-07 Thread Bob Metelsky
(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.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: PMON seems to not close sessions in a timely manner eg Max

2002-12-27 Thread Bob Metelsky
-- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing

RE: PMON seems to not close sessions in a timely manner eg Max

2002-12-26 Thread Bob Metelsky
= mydb) ) This is on win2k server, Oracle 8.1.7 Thanks! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: PMON seems to not close sessions in a timely manner eg Max

2002-12-26 Thread Bob Metelsky
Title: Message From: Bob Metelsky [mailto:[EMAIL PROTECTED]] I have a developers stored procedure making repeaded calls (logons/request for data and logoff) Each call takes only seconds but it seems like PMON dosnt close the process in a timely manner, leaving what look to be ghost

RE: PMON seems to not close sessions in a timely manner eg Max

2002-12-26 Thread Bob Metelsky
server, Oracle 8.1.7 Thanks! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

PMON seems to not close sessions in a timely manner eg Max processes(50) reached

2002-12-24 Thread Bob Metelsky
bring my delimma to the list I think I'd like to tell PMON how frequently to check for completed requests. thanks and happy holidays bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: PMON seems to not close sessions in a timely manner eg Max

2002-12-24 Thread Bob Metelsky
for a setting that I can assign to have the processes clean up earlier. Ive read a article on Metalink saying processes should not be set to More than v$license More than 200 And is os dependant ? Thanks Bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET

RE: PMON seems to not close sessions in a timely manner eg Max

2002-12-24 Thread Bob Metelsky
and happy holidays bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Mailing lists for MS Windows NT/2000/XP Administration

2002-12-23 Thread Bob Metelsky
Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Robert INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat

RE: Happy Holidays!!

2002-12-20 Thread Bob Metelsky
Where and when is this going to be? A url maybe?? Or is it a womans only convention ;-) bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: Methods to get DDL

2002-12-19 Thread Bob Metelsky
-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

Footprint of 9i

2002-12-19 Thread Bob Metelsky
FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

Bizzare behaviour of set oracle_sid=mysid

2002-12-19 Thread Bob Metelsky
://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

  1   2   >