UNIX performance

2003-01-21 Thread Andrey Bronfin

UNIX performance analyzing/tuning

2003-01-21 Thread Andrey Bronfin

RE: bitmapped indexes

2003-01-14 Thread Andrey Bronfin
Hi ! I don't remember where I got the paper, but I am attaching it. Cheers. -Original Message- Sent: ? 13 ? 2003 19:40 To: [EMAIL PROTECTED]; Andrey Bronfin Andrey, Perhaps you could tell us what paper, and where to obtain it. >From the context, it sounds like a refe

bitmapped indexes

2003-01-13 Thread Andrey Bronfin

RE: Recommendation for SQL Tuning Book

2003-01-13 Thread Andrey Bronfin
Q: http://www.orafaq.net -- Author: Andrey Bronfin 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 yoursel

RE: Some of you may find this useful

2003-01-12 Thread Andrey Bronfin
THANKS ;-) -Original Message- Sent: ? 12 ? 2003 13:59 To: Multiple recipients of list ORACLE-L Andrey Bronfin wrote: > > And what does KGL stand for ? > Thanks ! [K]ernel layer [G]eneric layer [L]ibrary cache manager. Feeling better :-) ? > -Original Message

RE: Some of you may find this useful

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

RE: encrypted user/passwd connection

2003-01-07 Thread Andrey Bronfin
Thanks a lot to all who replied! -Original Message- Sent: ? 07 ? 2003 6:01 To: [EMAIL PROTECTED]; Andrey Bronfin Andre, Oracle does not send passwords across the network in clear text, they are encrypted by default. Jared On Monday 06 January 2003 05:43, Andrey Bronfin wrote

RE: audit user activities

2003-01-07 Thread Andrey Bronfin
>against the DB . >I need to trace a user's login/logout as well as >DML operations on certain >tables. >I understand that there are more than one way to >achieve these. >Could you please share your experiences / tricks on >the matter. >Thanks a lot ! >Andrey. An

encrypted user/passwd connection

2003-01-06 Thread Andrey Bronfin

audit user activities

2003-01-06 Thread Andrey Bronfin

Script to recreate schema

2002-12-25 Thread Andrey Bronfin

RE: a PL/SQL design question.

2002-12-01 Thread Andrey Bronfin
recipients of list ORACLE-L Andrey Please forgive me if this sounds like a theoretical solution, since I don't have the time to try it out relevant to your situation. But what about using the trigger to call a procedure which is an autonomous transaction ? You do this by placing the foll

RE: a PL/SQL design question.

2002-12-01 Thread Andrey Bronfin
Thanks a lot ! -Original Message- Sent: Thursday, November 28, 2002 8:04 PM To: Multiple recipients of list ORACLE-L Andrey Bronfin wrote: > Dear gurus! > I'm looking for a solution to the following problem: > I need a way to run a certain stored procedure as soon

a PL/SQL design question.

2002-11-28 Thread Andrey Bronfin

A way to restore a DB

2002-11-24 Thread Andrey Bronfin
d I don't care if THIS step will take 2 weeks. What do you say? Any reviews of my steps and the idea in general? And, do you have a script that can re-engineer a DB (as in my step 1)? Thanks a lot in advance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey

A way to restore a DB

2002-11-24 Thread Andrey Bronfin

A way to restore a DB

2002-11-24 Thread Andrey Bronfin

RE: analyze table takes forever

2002-10-31 Thread Andrey Bronfin

analyze table takes forever

2002-10-29 Thread Andrey Bronfin
vance. DBAndrey * 03-9254520 * 058-548133 * mailto:andreyb@;elrontelesoft.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Calif

Scripts to reengineer a DB / recovery speed-up

2002-09-22 Thread Andrey Bronfin
ed. The actual question is : what do you think of this scheme ? DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://

OT - for you , UNIX lovers

2002-09-17 Thread Andrey Bronfin
-- Author: Andrey Bronfin 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 list

OT - LDAP

2002-09-12 Thread Andrey Bronfin
* 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Function-Based Index not working

2002-09-01 Thread Andrey Bronfin

RE: Reasons to upgrade from Oracle 7.3.4 to 8i - DONE

2002-08-21 Thread Andrey Bronfin
by Oracle consultants on site. DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Monday, August 19, 2002 3:42 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Andrey, Playing Devil's advocate, the only valid reason I can think of is due to

RE: Reasons to upgrade from Oracle 7.3.4 to 8i

2002-08-21 Thread Andrey Bronfin
d 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 information (like subscribing). --

Reasons to upgrade from Oracle 7.3.4 to 8i

2002-08-19 Thread Andrey Bronfin
0 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-

RE: how to force a log switch - SOLVED !

2002-08-19 Thread Andrey Bronfin
Thanks a lot to all who replied ! DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Sunday, August 18, 2002 6:36 PM To: LazyDBA.com Discussion; Andrey Bronfin After researching lot of issues with having smaller size redo logs , we opted for

RE: OPS 7.3.4 - DONE. THANKS !

2002-08-19 Thread Andrey Bronfin
hen to import. Is it OK ? TIA. DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Califor

RE: how to force a log switch

2002-08-18 Thread Andrey Bronfin
ution. Thanks again ! DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Sunday, August 18, 2002 3:14 PM To: 'Andrey Bronfin'; 'LazyDBA.com Discussion' The answer pretty simple - change the size of your logs. Log switching is

how to force a log switch

2002-08-18 Thread Andrey Bronfin
PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public I

RE: OPS 7.3.4 - how to ?

2002-08-13 Thread Andrey Bronfin
nal ones) and then to import. > Is it OK ? > > TIA. > > DBAndrey > > * 03-9254520 > * 058-548133 > * mailto:[EMAIL PROTECTED] > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Andrey Bronfin > INET: [EMAIL

RE: OPS 7.3.4 - how to ?

2002-08-13 Thread Andrey Bronfin
nces as the original ones) and then to import. Is it OK ? TIA. DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

OPS 7.3.4 - how to ?

2002-08-12 Thread Andrey Bronfin
) and then to import. Is it OK ? TIA. DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

a quick SQL performance question - rethinked

2002-07-18 Thread Andrey Bronfin
esponce. Thanks a lot ~ DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

a quick SQL performance question.

2002-07-18 Thread Andrey Bronfin
peration is executed every couple of seconds, so i want to maximally optimize it . Cheers. I'd very much appreciate a prompt responce. Thanks a lot ~ DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andr

System Administrator Appreciation Day - Friday - July 26th, 2002

2002-07-16 Thread Andrey Bronfin

RE: OT - unix vs linux vs windows - the future

2002-07-15 Thread Andrey Bronfin
elieve that all mainstream vendor implementations of unix have AT&T base. Jared On Sunday 14 July 2002 11:58, Andrey Bronfin wrote: > hi ! > i might start another war , but i can't resist a part of me which wants to > ask : > what do you , seasoned gurus, think of everybody

RE: OT - a good list for UNIX (Solaris) system administration top

2002-07-15 Thread Andrey Bronfin
/bigadmin/ http://solarisguide.com/ http://www.samag.com/ http://www.stokely.com/unix.sysadm.resources/index.html Andrey Bronfin wrote: > > Dear friends ! > Are you aware of a good mailing list for UNIX (Solaris/HP) system > administration - similar to this one ? > I'm also interes

partitioned tables and the optimizer's behaviour

2002-07-15 Thread Andrey Bronfin
lease ? TIA DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

OT - unix vs linux vs windows - the future

2002-07-14 Thread Andrey Bronfin
s ? DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Inter

RE: DBMS_JOB does not run on NT - SOLVED !

2002-07-14 Thread Andrey Bronfin
No , it was not ;-) Sorry , i knew it , but overlooked it ;-) It's working now ! Thanks a lot to all who replied ! DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Sun, July 14, 2002 5:51 PM To: Andrey Bronfin; LazyDBA.com Discussion

DBMS_JOB does not run on NT

2002-07-14 Thread Andrey Bronfin
s ? Thanks a lot ! DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: OT - a good list for UNIX (Solaris) system administration top

2002-07-14 Thread Andrey Bronfin
d 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: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Pu

OT - a good list for UNIX (Solaris) system administration topics

2002-07-10 Thread Andrey Bronfin
54520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: OFF_TOPIC - apache - SOLVED !

2002-07-07 Thread Andrey Bronfin
Thanks a lot , Mark , and all who replied ! DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Thu, July 04, 2002 4:29 PM To: Multiple recipients of list ORACLE-L Andrey, This is usually done with re-direction scripts written in something

OFF_TOPIC - apache

2002-07-04 Thread Andrey Bronfin
redirected to a specific URL (such as www.abcd.com/xxx/yyy/qqq.html) . Thanks a lot ! DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services

OT : informix and/or sybase

2002-06-26 Thread Andrey Bronfin
ermely glad to have any inputs . Please send them either directly to me or to the list , and i promise to summarize everything i get and post the summary. Thanks a lot ! DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

RE: off topic: anyone form Amsterdam, Holland / other major europ

2002-06-12 Thread Andrey Bronfin
kes up for it. > > Be warned: If you're american, you might get a culture shock regarding > unfriendly and pushy people. > > I guess Amsterdam is comparable (just guessing). > > Regards, > Stefan > > -Urspr?ngliche Nachricht- > Von: Andrey Bronfin

RE: AW: off topic: anyone form Amsterdam, Holland / other major e

2002-06-12 Thread Andrey Bronfin
> > the salary > > here to be about 30% higher then in Germany, so that makes up for it. > > > > Be warned: If you're american, you might get a culture shock > > regarding > > unfriendly and pushy people. > > > > I guess Amsterdam is comparable (ju

RE: off topic: anyone form Amsterdam, Holland / other major europ

2002-06-11 Thread Andrey Bronfin
he salary here to be about 30% higher then in Germany, so that makes up for it. Be warned: If you're american, you might get a culture shock regarding unfriendly and pushy people. I guess Amsterdam is comparable (just guessing). Regards, Stefan -Urspr?ngliche Nachricht- Von: Andr

off topic: anyone form Amsterdam, Holland / other major european

2002-06-11 Thread Andrey Bronfin
c question bothers you ;-) DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

RE: "snapshot too old" error - strange

2002-05-28 Thread Andrey Bronfin
no , i do not . Thanks DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Tue, May 28, 2002 4:53 AM To: Multiple recipients of list ORACLE-L Hello Andrey, Do you use autonomous transaction? Monday, May 27, 2002, 7:53:19 PM, you wrote: AB

RE: "snapshot too old" error - strange

2002-05-27 Thread Andrey Bronfin
no , no lobs. thanks ! DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Mon, May 27, 2002 4:03 PM To: Multiple recipients of list ORACLE-L Hi Andrey, Are there any LOB columns in the tables ? I read something on Metalink about bugs on ORA

"snapshot too old" error - strange

2002-05-27 Thread Andrey Bronfin
i get the Ora-1555 - "snapshot too old" error during the run of the aforementioned program. Any ideas , please ? TIA DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL

USE_SHARED_SOCKET with Oracle 8.1.7 on NT.

2002-05-23 Thread Andrey Bronfin
://www.orafaq.com -- Author: Andrey Bronfin 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

RE: Performance issue , OCI related ? - urgent , please

2002-05-22 Thread Andrey Bronfin
r 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: Andrey Bronfin INET: [EMAIL PROTECTED] Fat Ci

RE: Performance issue , OCI related ? - urgent , please

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

Performance issue , OCI related ? - urgent , please

2002-05-22 Thread Andrey Bronfin
: http://www.orafaq.com -- Author: Andrey Bronfin 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: Connecting to DB from behind a firewall - solved !

2002-05-20 Thread Andrey Bronfin
le as well. --- Jason Heinrich, OCP Oracle Database Administrator Pensacola Christian College (850) 478-8496 x2509 [EMAIL PROTECTED] > From: Andrey Bronfin <[EMAIL PROTECTED]> > Date: Sunday, May 19, 2002 10:36 AM > Subject: Connecting to DB from behind a firewall. >

Connecting to DB from behind a firewall.

2002-05-19 Thread Andrey Bronfin
nection manager" etc.. thanks a lot ! DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5

RE: Alternatives to Directly Attached Disk - NAS or SAN ?

2002-05-14 Thread Andrey Bronfin
Hi John ! Unfortunately , i can't add to the discussion yet, i juts know much less than you do. Therefore , i'd be interested in some URLs / papers on the matter. Thanks a lot ! -Original Message- Sent: Tue, May 14, 2002 3:18 PM To: DBA Forum (E-mail); '[EMAIL PROTE

Who is eating up all the memory ?

2002-05-14 Thread Andrey Bronfin
within the instance. And how would i see this on UNIX ? Cheers. DBAndrey -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Publi

OT - Teradata - THANX !

2002-05-14 Thread Andrey Bronfin
Thanks a lot to all who replied ! DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Thu, May 09, 2002 6:19 PM To: Multiple recipients of list ORACLE-L Andrey - I would try the dwlist. Here is enough to get signed up. A number of Teradata

RE: Alternatives to Directly Attached Disk - NAS or SAN ?

2002-05-14 Thread Andrey Bronfin
http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell

A trigger vs. "default value" in a table - SOLVED

2002-05-14 Thread Andrey Bronfin
Thanks a lot to all who replied ! DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Mon, May 13, 2002 11:03 PM To: Multiple recipients of list ORACLE-L Hello Andrey The correct answer depends on what you want ! if you can live with null

A trigger vs. "default value" in a table

2002-05-13 Thread Andrey Bronfin
3 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

RE: pl/sql is INTERPRETED?

2002-05-06 Thread Andrey Bronfin
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: Mercadante, Thomas F > >

RE: where to find Oracle Installation guide for HP-UX ? - THANKS

2002-05-06 Thread Andrey Bronfin
ttp://otn.oracle.com/doc/hp/server.805/a64527.pdf http://otn.oracle.com/docs/products/oracle8i/content.html http://otn.oracle.com/docs/products/oracle9i/content.html Brian P. MacLean Oracle DBA, OCP8i Andrey Bronfin

where to find Oracle Installation guide for HP-UX ?

2002-05-05 Thread Andrey Bronfin
one ? I'm especially interested in a pre-/post-installation steps needed to be taken as root. Thanks a lot ! DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] F

RE: Column level grants - THANKS

2002-04-24 Thread Andrey Bronfin
FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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: column level grants

2002-04-24 Thread Andrey Bronfin
il.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

column level grants

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

Free Open source PL/SQL Editors / DB management tools - THANX !

2002-04-22 Thread Andrey Bronfin
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: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: ioug-a question

2002-04-21 Thread Andrey Bronfin
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 comm

Free Open source PL/SQL Editors / DB management tools

2002-04-21 Thread Andrey Bronfin
Dear list! are U aware of any free open source PL/SQL Editors or freeware/open source tools for database management ? If so , would u please post an URL of a such . Thanks a lot . Andre. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL

RE: db2/udb and new skillz

2002-04-18 Thread Andrey Bronfin
stGuru') 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: And

THANKS : Brainbench Oracle certifications

2002-04-14 Thread Andrey Bronfin
Thanks a lot , Dennis and all who responded ! Have a nice day ! DBAndrey -Original Message- Sent: Fri, April 12, 2002 1:19 AM To: Multiple recipients of list ORACLE-L Andrey - Value is in the eye of the hiring manager. OCP can be most useful for consultants because you are

Brainbench Oracle certifications

2002-04-11 Thread Andrey Bronfin
> Dear gurus ! > May i ask for your opinions regarding the value of the Brainbench Oracle > 8i Administration certifications. > I understand that it can not be compared t othe OCP, but is there any > value at all for it ? > Thanks a lot in advance. > Andrey. > >

Brainbench Oracle certifications

2002-04-11 Thread Andrey Bronfin
Dear gurus ! May i ask for your opinions regarding the value of the Brainbench Oracle 8i Administration certifications. I understand that it can not be compared t othe OCP, but is there any value at all for it ? Thanks a lot in advance. Andrey. -- Please see the official ORACLE-L FAQ: http

a theoretical question

2002-04-08 Thread Andrey Bronfin
an, will Oracle somehow detect that actually the update does not need to occur , or will it perform the update regardless of the current values of the columns . Thanks a lot, DBAndrey -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTE

THANKS - a PL/SQL question - how to catch errors without going i

2002-04-08 Thread Andrey Bronfin
12:49 PM To: Multiple recipients of list ORACLE-L ex ps , i meant i := 1; while i < 10 loop select the_name from the_table into myvar where the_id = i ; end loop; DBAndre > -Original Message- > From: Andrey Bronfin > Sent: Thu, A

RE: a PL/SQL question - how to catch errors without going into ex

2002-04-04 Thread Andrey Bronfin
ps , i meant i := 1; while i < 10 loop select the_name from the_table into myvar where the_id = i ; end loop; DBAndre > -Original Message- > From: Andrey Bronfin > Sent: Thu, April 04, 2002 9:50 PM > To: [EMAIL PROTECTED] (

a PL/SQL question - how to catch errors without going into except

2002-04-04 Thread Andrey Bronfin
cial ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To RE

Microsoft, Unisys Prep 64-Bit SQL Server

2002-04-01 Thread Andrey Bronfin
http://www.crn.com/Sections/BreakingNews/BreakingNews.asp?ArticleID=30009 Dear gurus , what do U say about this ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

possible interview questions

2002-04-01 Thread Andrey Bronfin
l ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOV

RE: Production Oracle DBA Needed in Rochester, Minnesota

2002-03-31 Thread Andrey Bronfin
reath, and die (at) Mayo. As Dennis Miller says "that's just my opinion I could be wrong " I wish them well. Alter session set RANT_SWITCH = OFF; Brian P. MacLean Oracle DBA, OCP8i -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin IN

Multithreaded server question

2002-03-19 Thread Andrey Bronfin
t possible ? Also , what is the "price" of establishing a MTS connection compared to "price" of establishing a dedicated conenction , performance-wise ? Thanks a lot in advance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INE

RE: "Global" variable in Pl/SQL

2002-02-27 Thread Andrey Bronfin
thanks a lot to all who replied ! DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -Original Message- Sent: 26 February 2002 23:24 To: Multiple recipients of list ORACLE-L Andrey, You can't make a PL/SQL variable value visible to all sessions. You'll have

"Global" variable in Pl/SQL

2002-02-26 Thread Andrey Bronfin
the instance to be able to see this value of PPP.VVV . Thanks a lot in advance ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: moving from unix to NT

2002-02-26 Thread Andrey Bronfin
er information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet ac

RE: object-oriented vs semantic database model

2002-02-26 Thread Andrey Bronfin
#x27;) 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: Andrey Bron

Oracle "cheats" UNIX vendors ?

2002-02-06 Thread Andrey Bronfin
http://www.computerworld.com/storyba/0,4125,NAV47_STO67867,00.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

OT : ERP tool for evaluation

2002-02-04 Thread Andrey Bronfin
-- Author: Andrey Bronfin 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: HP vs SUN for a UNIX box

2002-01-22 Thread Andrey Bronfin
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: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-

pipes vs message queues

2002-01-21 Thread Andrey Bronfin
Dear list ! Sorry for an ignorent question : what's the difference (functional and technical) among Oracle pipes and Oracle message queues ? DBAndrey * 03-9254520 * 053-464562 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A

RE: dropped datafile problem

2002-01-21 Thread Andrey Bronfin
no , and i can not do so (it's a more than 1TB tablespace , i can't recreate it = no time frame). thanks ! -Original Message- Sent: 21 January 2002 18:01 To: Multiple recipients of list ORACLE-L did you drop the tablespace as well? --- Andrey Bronfin <[EMAIL PROT

RE: dropped datafile problem

2002-01-21 Thread Andrey Bronfin
nope. The file was physically deleted at the OS level after "offline drop". Thanks DBAndrey * 03-9254520 * 053-464562 * mailto:[EMAIL PROTECTED] -Original Message- Sent: 21 January 2002 17:51 To: Andrey Bronfin esoft.com>

dropped datafile problem

2002-01-21 Thread Andrey Bronfin
dba_extents show extents with FILE_ID of that file ! When a select statement tries to access a table with extents residing in that file , i get an error message , off course. So , the question is , how do i make the file's extents disappear from fet$ ? Thanks a lot. Andrey. -- Please

Databases on Solaris: Online Forum Jan. 22-28

2002-01-20 Thread Andrey Bronfin

  1   2   3   >