Re: Explain Plan different on TEST and PRODUCTION instance

--- "A. Bardeen" <[EMAIL PROTECTED]> wrote: > Brijesh, > > Even though OPTIMIZER_MODE=RULE, the CBO will be > used > in the presence of other features (e.g. > partitioning, > degree of parallelism, etc...). > > In this case TEST is getting a better p

RE: Test message

doh.>>> [EMAIL PROTECTED] 08/02/01 02:28PM >>>Too late. -Original Message-Sent: Thursday, August 02, 2001 12:47 PMTo: Multiple recipients of list ORACLE-LIgnore this message.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Arich Henneman  INET: [EMAIL PROTECTE

RE: Test message

I tried ... but couldn't .. __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinio

RE: Test message

Too late. -Original Message- Sent: Thursday, August 02, 2001 12:47 PM To: Multiple recipients of list ORACLE-L Ignore this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arich Henneman INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Test message

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

[Q] populate production DB to test DB?

We have ORACLE 8.1.6 on SUN servers.  We just finished phase I developmentand will starting phase II development soon.  We will copy our productionDB to development server for phase II.  Our contractor request every weekwe need populate new/update information on production DB to developmentserver,

test message - please ignore

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

test message

please ignore

test - please ignore

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

SUMMARY-Test Databases

In response to my own continuing research for such a thing I have found a couple of Oracle Test databases. There is some available on CD to be purchased with related books, Not much good if just wanting some data to play with. I found a couple at Prentice Hall http://www.phptr.com

test

test Best Regards Sinardy *** CONFIDENTIALITY CAUTION This message and its attachments (“Message”) are intended only for the use of the individual or entity to whom it is addressed

test -- please ignore

___ Do You Yahoo!? Yahoo! Messenger: Comunicación instantánea gratis con tu gente - http://messenger.yahoo.es -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Pablo=20ksksksk?= INET: [EMAIL

Re[2]: Looking for a test Database

oks include a test database. guy harrison's book has a web site and GM> you can download a large test database from the web site for that book. i GM> believe gennick's book also has a test database, either on cd-rom or from a GM> web site. best of all, why not just use the

Re: Looking for a test Database

some books include a test database. guy harrison's book has a web site and you can download a large test database from the web site for that book. i believe gennick's book also has a test database, either on cd-rom or from a web site. best of all, why not just use the scott/tiger dem

RE: Looking for a test Database

somewhere that I can get a small test database. I know some of the products have databases to be installed, I have done some stuff with one of the JDeveloper databases, I have Oracle PE 8.1.7 installed I was hoping to find something a little meatier in size to run some tests with. perhaps something that

Re: Looking for a test Database

ere is somewhere that I can get a small test database. > I know some of the products have databases to be installed, I have done > some stuff with one of the JDeveloper databases, I have Oracle PE 8.1.7 > installed I was hoping to find something a little meatier in size to run > some t

Looking for a test Database

Hi I was wondering if there is somewhere that I can get a small test database. I know some of the products have databases to be installed, I have done some stuff with one of the JDeveloper databases, I have Oracle PE 8.1.7 installed I was hoping to find something a little meatier in size to run

test - pl. delete

test Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

test

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

Re: test

what are you trying to test?? coz I am a novice Oracle Certifiable DBBS - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, June 29, 2001 9:16 AM > > test > -- > Please see the official ORACLE-L FAQ: http://

Test

[EMAIL PROTECTED] Best Regards Sinardy *** CONFIDENTIALITY CAUTION This message and its attachments (“Message”) are intended only for the use of the individual or entity to whom it i

test

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

test

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

This is Test

List this is only test mail. I had posted several queries, but my mail is not in the list. but I get all mails from the list. Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

test

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

Test Database Schema.

Hi Guys and Girls, I was just wondering if anybody has a script that will create a schema - much like the Scott or SQLServer North wind - in a test database, but with a little more depth.. I'm looking for something that will create the tables, indexes, constraints, maybe some users thoug

Re: Stress Test Apps

this will test your web server. http://support.microsoft.com/support/kb/articles/Q231/2/82.ASP >>> [EMAIL PROTECTED] 06/20/01 05:35PM >>> Greetings to all. Does anyone out there know of any free, shareware, open source applications for stress testing a system/database? Or

Stress Test Apps

Title: Stress Test Apps Greetings to all. Does anyone out there know of any free, shareware, open source applications for stress testing a system/database?  Or has anyone created their own or have a set of procedures/methodologies which they use to stress test they'd like to share

test

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

Test

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

Test

_ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SRIVIDYA ARUN INET: [EMAIL PROTECTED] Fat City Network Services--

RE: Test Model

Testing what? Load performance? Data Integrity? Bank balance? Brain capacity? User stupidity? -Original Message- Sent: Tuesday, May 29, 2001 10:02 To: Multiple recipients of list ORACLE-L Hi List, Anybody knows any model or tools for testing. Thanks in advance = Hamid Alavi 4268

Test Model

Hi List, Anybody knows any model or tools for testing. Thanks in advance = Hamid Alavi 4268 Flintlock LN Westlake Village 91631 PH: 818-8790966 __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.

New Subscriber / Test Message - Please Ignore

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

test, please ignore

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

#test#

ignore my test!

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

RE: DB Link Between Prod and Test?

William: Check my old post. "I agree with that Matthew. But if you still have to use the link make sure you give the user the appropiate provileges and assign him a "profile" to limit the ammount of resources he can consume with his queries. This way he can't slow down the prod instance

RE: OT RE: /TEST/IDIOT/Re: ADMIN: 2nd Beta of web-based ODTUG arc

, May 15, 2001 6:25 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: /TEST/IDIOT/Re: ADMIN: 2nd Beta of web-based || ODTUG archives || now available || || || a search on "IDIOT" turned up nothing. || || || Date sent: Tue, 15 May 2001 12:10:53 -

Re: DB Link Between Prod and Test?

On Tue, 15 May 2001,Rocky Welch scribbled on the wall in glitter crayon: ->How about creating a user that only has read-only rights? But that still allows the "query from hell" syndrome that can bring a prod box to it's knees. -- Bill Thater Certifiable ORACLE DBA Telergy, Inc.

Re: DB Link Between Prod and Test?

> Sent: Tuesday, May 15, 2001 2:26 PM > To: Multiple recipients of list ORACLE-L > > > One of our development DBAs suggested today to build a private database > link between production and test database so that he can run some > queries against both at the same time

Re: /TEST/IDIOT/

Since the web interface is to the *archives*, you won't be able to search currrent messages until something goes into the archives. That will likely occur around 1am in the morning after each daily digest is created. Nice try though. :-) thanks, bruce -- Please see the official ORACLE-L FAQ: h

OT RE: /TEST/IDIOT/Re: ADMIN: 2nd Beta of web-based ODTUG archive

How about SAVANT? or moron imbecile vegetable || -Original Message- || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, May 15, 2001 6:25 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: /TEST/IDIOT/Re: ADMIN: 2nd Beta of web-based || ODTUG archives

RE: DB Link Between Prod and Test?

--Original Message- Sent: Tuesday, May 15, 2001 2:26 PM To: Multiple recipients of list ORACLE-L One of our development DBAs suggested today to build a private database link between production and test database so that he can run some queries against both at the same time. I am a little concerned bec

RE: DB Link Between Prod and Test?

ts of list ORACLE-L One of our development DBAs suggested today to build a private database link between production and test database so that he can run some queries against both at the same time. I am a little concerned because he might make a mistake and accidentally corrupt the prod database. A

Re: DB Link Between Prod and Test?

How about creating a user that only has read-only rights? --- [EMAIL PROTECTED] wrote: > One of our development DBAs suggested today to build a private database > link between production and test database so that he can run some > queries against both at the same time. I am a little

Re: /TEST/IDIOT/Re: ADMIN: 2nd Beta of web-based ODTUG archives now available

a search on "IDIOT" turned up nothing. Date sent: Tue, 15 May 2001 12:10:53 -0800 To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > /TEST/IDIOT/ ... > > ... (http://www.fatcity.com/ListGuru) > > Please underst

Re: DB Link Between Prod and Test?

hater, William" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: DB Link Betwee

RE: DB Link Between Prod and Test?

Title: RE: DB Link Between Prod and Test? I agree with that Matthew.   But if you still have to use the link make sure you give the user the appropiate provileges and assign him a "profile" to limit the ammount of resources he can consume with his queries. This way he can'

/TEST/IDIOT/Re: ADMIN: 2nd Beta of web-based ODTUG archives now available

/TEST/IDIOT/ On 15 May 2001, at 11:16, Bruce Bergman wrote: Date sent: Tue, 15 May 2001 11:16:15 -0800 To: Multiple recipients of list ODTUG-DEV2K-L <[EMAIL PROTECTED]> > I have just finished making some changes to the ListGuru web-based archive &

RE: DB Link Between Prod and Test?

Title: RE: DB Link Between Prod and Test? Is he an idiot? (I couldn't resist) We go to extreme lengths to ensure that nobody can link our devlopement and production databases together in any shape or form.  It's just a bad idea. R. Matt Adams  - GE Appliances - [EMAIL

RE: DB Link Between Prod and Test?

Title: RE: DB Link Between Prod and Test? I created a 'READER' id on production for our datawarehouse guys.  The dblink connects from dw to production as user READER, and READER has select authority on the specific prod tables that they are supposed to be looking at.  DW has mu

Re: DB Link Between Prod and Test?

On Tue, 15 May 2001,[EMAIL PROTECTED] scribbled on the wall in glitter crayon: ->One of our development DBAs suggested today to build a private database ->link between production and test database so that he can run some ->queries against both at the same time. I am a little concerned b

RE: DB Link Between Prod and Test?

abase Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 15, 2001 13:26 > To: Multiple recipients of list ORACLE-L > Subject: DB Link Between Prod a

DB Link Between Prod and Test?

One of our development DBAs suggested today to build a private database link between production and test database so that he can run some queries against both at the same time. I am a little concerned because he might make a mistake and accidentally corrupt the prod database. Anybody out there

RE: DB Link Between Prod and Test?

--Original Message- Sent: Tuesday, May 15, 2001 2:26 PM To: Multiple recipients of list ORACLE-L One of our development DBAs suggested today to build a private database link between production and test database so that he can run some queries against both at the same time. I am a little concerned bec

RE: DB Link Between Prod and Test?

build a private database link between production and test database so that he can run some queries against both at the same time. I am a little concerned because he might make a mistake and accidentally corrupt the prod database. Anybody out there who is doing the same thing? Are there any other

OEM 2.2: Test email message works but real email doesn't

Hi there, when I do test mails ... working fine. But When I schedule jobs does not seems to be working ... there are no email blockouts. Any hints or ideas? Best regards Henrik Henrik Bachmannmailto:[EMAIL PROTECTED] B.I.M.-Consulting Magdeburghttp://www.bim

test

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

Re: How to test for all digits in string

Here are three slightly different versions of what you might be looking for. CREATE OR REPLACE FUNCTION isnum (thestring IN VARCHAR2) RETURN BOOLEAN IS holder NUMBER; BEGIN holder := TO_NUMBER(thestring); RETURN TRUE; EXCEPTION WHEN OTHERS THEN RETURN FALSE; END; / That i

How to test for all digits in string

Hello gurus, Could someone tell me the best way to check a string to ensure that it contains all numeric digits before converting it to a number with to_number? I don't see a function like ISNUM. TIA, Woody -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Woody Mckay

Test only

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

Re [30k]: /test - dumb & dumber/ Re: error when creating a BIG FREAKING ATTACHMENT TO THE LIST

L PROTECTED]> > Sender: [EMAIL PROTECTED] > Reply-To: [EMAIL PROTECTED] > Errors-To: [EMAIL PROTECTED] > From: "Eric D. Pierce" <[EMAIL PROTECTED]> > Subject: /test - dumb & dumber/ Re: error when creating a BIG FREAKING ATTACHMENT TO >THE LIST > Organization

/test - dumb & dumber/ Re: error when creating a BIG FREAKING ATTACHMENT TO THE LIST

trying again, missing attachment 1st time??? word2000 doc renmaed w/ ".sql" extension > /TEST/ > > BINARY ATTACHMENTS NOT TESTED IF NAMED WITH ".sql" FILE EXTENSION? > > Date sent:Tue, 10 Apr 2001 06:27:28 -0800 > To:

test-plz ignore

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

please ignore: test message

test message Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

test please ignore

 

RE: test

Ha, we have one here and they give him a hard time anyway. I guess they figure he can take it. -Original Message- Sent: Friday, March 16, 2001 4:55 AM To: Multiple recipients of list ORACLE-L Wow, you were a SEAL Bill? I bet your duhvelopers don't bother you on a regular basis huh? :)

Re: test

Mark Leith wrote: > > Wow, you were a SEAL Bill? I bet your duhvelopers don't bother you on a > regular basis huh? :) just once.;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED] You gotta program lik

RE: test

Wow, you were a SEAL Bill? I bet your duhvelopers don't bother you on a regular basis huh? :) -Original Message- William Sent: Friday, March 16, 2001 12:10 To: Multiple recipients of list ORACLE-L Ron Rogers wrote: > > Bill, > Are you sure that you didn't stand in front of a microwave h

Re: test

Ron Rogers wrote: > > Bill, > Are you sure that you didn't stand in front of a microwave horn to keep warm while >you were in the service? > ROR mª¿ªm nope, where i was when in the service was a bit too warm for that, besides they wouldn't let us SEALS near the microwaves, they were afraid we'd

Re: test

Bill, Are you sure that you didn't stand in front of a microwave horn to keep warm while you were in the service? ROR mª¿ªm >>> [EMAIL PROTECTED] 03/15/01 03:10PM >>> sorry for the waste of bandwidth, but i don't think my stuff is getting through. but then if it doesn't get through i won't wast

test

sorry for the waste of bandwidth, but i don't think my stuff is getting through. but then if it doesn't get through i won't waste the bandwidth, will i? -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED]

test, ignore

sorry. -- Oliver Artelt Oracle certified DBA cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

RE: test

I should think so!!! :) -Original Message- Sent: Friday, March 02, 2001 07:20 To: Multiple recipients of list ORACLE-L test, sorry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Belov Igor INET: [EMAIL PROTECTED] Fat City Network Services-- (858

test

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

QDBA has been banished from my test server (was RE: 8.1.6 upgrade )

of this user's objects. Then I logged in as SYSTEM and I quite enjoyed deleting this beast from my test machine. Obviously when you issue a DROP USER command, Oracle doesn't do anything to clean up that user's jobs - it just hangs. Live and learn, now I know what to do if this

RE: ignore this test !!!!

GOOD BUT I DID NOT UNDERSTAND WHAT IT MEANT CAN YOU ELOBORATE THOUGH IT IS TEST MAIL. CAN YOU? -Original Message- Sent: Tuesday, February 27, 2001 11:16 AM To: Multiple recipients of list ORACLE-L test PS: Hampir lupa

ignore this test !!!!

test PS: Hampir lupa, kamu sudah punya pacar belum? Mau temenin aku Cari Cinta ngga di www.naver.co.id? Get your free E-mail account at http://www.detik.com -- Please see

Test - please ignore if received.

Testing at the request of the list administrator. Regards, Gary _ Remember: Amateurs built the Ark. Professionals built the Titanic. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Servi

onaly a test, delete

Volker E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

test - please ignore

test _ Global Virtual Desktop http://www.magicaldesk.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

test

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

<    1   2   3   4