OT: looking for 9i on solaris for test

2002-04-16 Thread Danisment Gazi Unal
Hello all, I'm looking for Oracle9i on Solaris for some tests. do you know a site offers these types of services. As I know Compaq offers, bu I need Solaris ? thanks in advance... -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ:

Re: Developer access in test database

2002-04-14 Thread Yechiel Adar
clarify... developers only get access to dev, and for test prod they get nothing. I've encountered very few with a need/desire for select_catalog_role, and they have to ask first :) John Hallas wrote: Suzy, You are much too generous. I always have found that asking for a change control

Re: Developer access in test database

2002-04-14 Thread Steven Lembark
To answer your question: We define schema owner for each application and only the DBA knows the password. the user gets i, u, d, s grants on the objects but have NO grants to do DLL's. All DDL is done by the DBA. This role was implemented after tables began to disappear from the schema

RE: Developer access in test database

2002-04-13 Thread DENNIS WILLIAMS
development projects, so this issue is very relevant. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, April 12, 2002 2:28 PM To: Multiple recipients of list ORACLE-L Guess I should clarify... developers only get access to dev, and for test prod they get

RE: Developer access in test database

2002-04-13 Thread Whittle Jerome Contr NCI
Dennis, I love this one! Happens to us all the time. When I go to put it in production, I ask what roles get to use the tables, code, etc. Most developers get the 'deer in the headlights' look and say It worked for me. Why shouldn't it work for everyone? Jerry Whittle ACIFICS DBA NCI

test - Ignore pl

2002-04-13 Thread Praful Thakkar
__ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Praful Thakkar INET: [EMAIL PROTECTED] Fat City Network Services--

RE: Developer access in test database

2002-04-12 Thread Jamadagni, Rajendra
Jeff, We have dba privileges granted to schema owners in devl databases, test database mimics the prod, so they just have appropriate roles. In prod, no schema level access, everyone goes in with their own id, and no one has those ANY privileges. In next couple of months, we are cutting off

RE: Developer access in test database

2002-04-12 Thread Mercadante, Thomas F
: Multiple recipients of list ORACLE-LSubject: Developer access in test database In our test databases, I have always granted select,insert,update,delete any table to the developers. While yesterday, one updated a "sys" table. Be non-production, I always felt if it is destroyed

RE: Developer access in test database

2002-04-12 Thread Jeffrey Beckstrom
Like I said this is test. In prod, they only have select access. However, since in test have "any" rights, were able to get a sys object. [EMAIL PROTECTED] 4/12/02 9:13:19 AM Jeff,We have dba privileges granted to schema owners in devl databases, testdatabase mimics the prod, so

RE: Developer access in test database

2002-04-12 Thread Mercadante, Thomas F
Jeff, I agree with Raj. Further to what I said before, I have four database - dev, user test, training and production. Training and Prod are always at the same application release level. Developers have total access in dev; and query-only access in the rest. Tom Mercadante Oracle Certified

RE: Developer access in test database

2002-04-12 Thread Kimberly Smith
As little as they need. I, as a general rule, only grant to the objects they are actually using. One way to look at it is you will always know which grants to move over to test and prod. Now, the group I work with grant select on any table which I have mixed feelings about. With the amount

Re:RE: Developer access in test database

2002-04-12 Thread dgoulet
In our test databases, I have always granted select,insert,update,delete any table to the developers. While yesterday, one updated a sys table. Be non-production, I always felt if it is destroyed can always be recreated. What table privileges do you grant in test. Jeffrey Beckstrom Database

RE: Developer access in test database

2002-04-12 Thread Deshpande, Kirti
work is done in your particular environment. In my previous job, no one bothered to change sys and system passwords and it was a true 'open systems' environment when it came to TEST/DEV work !! - Kirti -Original Message-From: Kimberly Smith [mailto:[EMAIL PROTECTED]]Sent: Friday

RE: Developer access in test database

2002-04-12 Thread John Hallas
Suzy, You are much too generous. I always have found that asking for a change control form delays things by a few days!! John -Original Message- Sent: 12 April 2002 18:43 To: Multiple recipients of list ORACLE-L I generally give developers access only to the schema's they are

Re: Developer access in test database

2002-04-12 Thread Suzy Vordos
I generally give developers access only to the schema's they are developing for. In some cases, they might also get select_catalog_role. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

Re: Developer access in test database

2002-04-12 Thread Suzy Vordos
Guess I should clarify... developers only get access to dev, and for test prod they get nothing. I've encountered very few with a need/desire for select_catalog_role, and they have to ask first :) John Hallas wrote: Suzy, You are much too generous. I always have found that asking

test

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

RE: test

2002-04-11 Thread Reddy, Madhusudana
SUCCESS !! And Congrats -Original Message- Sent: Thursday, April 11, 2002 6:19 PM To: Multiple recipients of list ORACLE-L test -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ivan Llamoca INET: [EMAIL PROTECTED] Fat City Network Services

Test Message - Please ignore

2002-04-08 Thread Madhavan Amruthur
--- Madhavan Amruthur See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Madhavan Amruthur INET: [EMAIL PROTECTED] Fat City

TEST PLEASE DELETE

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

RE: Generate Data for TEST

2002-03-30 Thread John Hallas
Don't know exactly what you want but if you just create table Hamid_table as select * from dba_tables and do likewise with some of the other data dictionary tables (objects,triggers,segments etc) then you have a set of tables which are all related to each other. Another quick way of populating

Generate Data for TEST

2002-03-29 Thread Hamid Alavi
Hi List, I am looking for some scripts to generate some dummy data and insert it in alot of tables which related to each other, any site or url or scripts? Appreciate Thanks Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is

RE: How to test BCV and backups

2002-03-26 Thread Koivu, Lisa
May be late in responding... but here's how I did it I designated one disk associated BCV as a test group - had a sysadmin do it. I modified a copy of all the shell scripts to only affect that BCV with all the operations (sync, split, etc.) Then I created a little test db on that disk only

How to test BCV and backups

2002-03-25 Thread Seppo Kaasalainen
Hello, we are implementing EMC Time Finder with our Sun boxes. Now I wonder how I can test backup and recovery scenarios with BCV. Do you have any ideas or good documents concerning that. Thank you in advance, Sepi _ Join

Re:How to test BCV and backups

2002-03-25 Thread dgoulet
Sepi, You'll need an additional server, and the EMC manuals, to mount the BCV's onto. After that it's just a matter of having the Oracle software in place bingo you can test to your hearts content or else use it as a reporting DB. BTW, don't forget to pay the Oracle piper for the second

Re: How to test BCV and backups

2002-03-25 Thread Brian_P_MacLean
: il.com Subject: How to test BCV and backups Sent by: [EMAIL PROTECTED

RE: How to test BCV and backups

2002-03-25 Thread Aponte, Tony
Title: RE: How to test BCV and backups Are you going to use RMAN or only OS utilities? Tony Aponte -Original Message- From: Seppo Kaasalainen [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 12:40 PM To: Multiple recipients of list ORACLE-L Subject: How to test BCV

RE: OCP Test on Oracle 8i New features Upgrade : study

2002-03-13 Thread Robertson Lee - lerobe
for the OCP 7 exam the answers were testing your knowledge needed for each test and the tests were comfortable and pleasent to take. With the 8 OCP upgrade I found myself having to dig into the deep trenches of my mind to understand what they wanted and pick the multiple answers needed

OCP Test on Oracle 8i New features Upgrade : study Materials, URLs, Sample questions

2002-03-12 Thread Mandal, Ashoke
Greetings All, Could you please send me the name author of the books, or any sample questions for Oracle 8i new features upgrade test. For 7.3 and 8 upgrade tests, I used DBA Certification Exam guide by Couchman and it was helpful. Thanks, Ashoke -- Please see the official ORACLE-L FAQ

RE: OCP Test on Oracle 8i New features Upgrade : study Materials,

2002-03-12 Thread Freeman, Robert
features upgrade test. For 7.3 and 8 upgrade tests, I used DBA Certification Exam guide by Couchman and it was helpful. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Re: OCP Test on Oracle 8i New features Upgrade : study Materials, URLs, Sample questions

2002-03-12 Thread Joe Raube
] wrote: Greetings All, Could you please send me the name author of the books, or any sample questions for Oracle 8i new features upgrade test. For 7.3 and 8 upgrade tests, I used DBA Certification Exam guide by Couchman and it was helpful. Thanks, Ashoke -- Please see the official

RE: OCP Test on Oracle 8i New features Upgrade : study

2002-03-12 Thread Ron Rogers
to 8i is in the book and on other documentation. Read and understand the source information and practice on a database. When you are confident with your knowledge review the information and schedule the exam. Remember, the exam is not A, or B, or C, or D the answers will test your conceptual knowledge

RE: OCP Test on Oracle 8i New features Upgrade : study

2002-03-12 Thread Freeman, Robert
. Remember, the exam is not A, or B, or C, or D the answers will test your conceptual knowledge and the answers will most likely be A,B, and D. ROR mª¿ªm [EMAIL PROTECTED] 03/12/02 01:00PM I just happen to have a book published by Coriolis called the Oracle 8 to 8i Exam Cram Guide... You can find

RE: OCP Test on Oracle 8i New features Upgrade : study

2002-03-12 Thread Ron Rogers
testing your knowledge needed for each test and the tests were comfortable and pleasent to take. With the 8 OCP upgrade I found myself having to dig into the deep trenches of my mind to understand what they wanted and pick the multiple answers needed. A real test of your understanding of Oracle concepts

RE: OCP Test on Oracle 8i New features Upgrade : study

2002-03-12 Thread Freeman, Robert
needed for each test and the tests were comfortable and pleasent to take. With the 8 OCP upgrade I found myself having to dig into the deep trenches of my mind to understand what they wanted and pick the multiple answers needed. A real test of your understanding of Oracle concepts. I know the test has

RE: OCP Test on Oracle 8i New features Upgrade : study

2002-03-12 Thread Rachel Carmichael
will study and practice more with the concepts that Oracle uses. Initially for the OCP 7 exam the answers were testing your knowledge needed for each test and the tests were comfortable and pleasent to take. With the 8 OCP upgrade I found myself having to dig into the deep trenches of my mind

Study Materials, URLs, Sample questions for Oracle 8i New features Upgrade OCP Test

2002-03-11 Thread Mandal, Ashoke
Greetings All, Could you please send me the name author of the books, or any sample questions for Oracle 8i new features upgrade test. For 7.3 and 8 upgrade tests, I used DBA Certification Exam guide by Couchman and it was helpful. Thanks, Ashoke -- Please see the official ORACLE-L FAQ

Planning Test Backup/Recovery

2002-03-04 Thread Eca Eca
Hi all : Does anyone have a planning for test backup and recovery ? I have the scripts and i am doing the backup and now we need to test it in production environment. I have tested it at another environment and got sucess. but at production ... it need to be very very careful ... Any

RE: Planning Test Backup/Recovery

2002-03-04 Thread
There should not be any problem to test the backup. However we are testing the restores to another machine, not on the production machine. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Eca Eca [SMTP:[EMAIL PROTECTED]] Sent: Mon, March 04, 2002 1:18

RE: Planning Test Backup/Recovery

2002-03-04 Thread Mercadante, Thomas F
Eriovaldo, If I were you, I would create a small test database on the production machine, and perform backup/restore of that test database to be sure that everything is working before I would try it on a production database. Once you are convinced that everything works, schedule a down time

RE: Planning Test Backup/Recovery - Tom

2002-03-04 Thread Eca Eca
Tom : I am thinking something like that .. I have already did the test at another machine ... It worked right... but the instance was diferente ... So, in your opinion i need to create a instance, in the production machine, with the same parameters of production and apply the test

RE: Planning Test Backup/Recovery - Tom

2002-03-04 Thread Mercadante, Thomas F
Eriovaldo, If you already have a backup script, then you need to test it on the production machine. The test db you create does not necessarily have to be the same size as the production db (init.ora params can be smaller). But what you are testing is that your backup scripts run as expected

Test - pl ignore

2002-03-02 Thread Praful Thakkar
__ Do You Yahoo!? Yahoo! Sports - sign up for Fantasy Baseball http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Praful Thakkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

DISREGARD, JUST A TEST

2002-02-26 Thread Babich , Sergey
TEST ONLY

FYI: *ALWAYS* test your recovery plan!

2002-02-05 Thread Jesse, Rich
to effectively restore 46GB. Now if this were 150GB... Long story short: TEST YOUR DATABASE RECOVERY! We've tested before, so this must've cropped up in an Omniback upgrade. BTW, our production DB is fine, except for the 3M row table a developer truncated... ;) Hope this helps someone! Rich

RE: *ALWAYS* test your recovery plan!

2002-02-05 Thread Grabowy, Chris
if this were 150GB... Long story short: TEST YOUR DATABASE RECOVERY! We've tested before, so this must've cropped up in an Omniback upgrade. BTW, our production DB is fine, except for the 3M row table a developer truncated... ;) Hope this helps someone! Rich Jesse System

Re: FYI: *ALWAYS* test your recovery plan!

2002-02-05 Thread Jared . Still
* test your recovery plan! So, here we are, restoring production from tape. Our recovery methods are sound (we have two or three ways back, depending on circumstances) as we will have ZERO loss of data with minimal downtime in off-hours, but we hit a bit of a snag today. We need to recover all

RE: *ALWAYS* test your recovery plan!

2002-02-05 Thread Mercadante, Thomas F
Rich, I've always said to test your recovery plan frequently. The standard joke here (when we were starting to test Rman with Edm) was that: We can back-up anything. It's the restore part that is giving us trouble. Glad at least you can get your db back. Tom Mercadante Oracle Certified

RE: FYI: *ALWAYS* test your recovery plan!

2002-02-05 Thread Jesse, Rich
to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:FYI: *ALWAYS* test your recovery plan! So, here we are, restoring production from tape. Our recovery methods are sound (we have two or three ways back, depending

RE: *ALWAYS* test your recovery plan!

2002-02-05 Thread Kimberly Smith
of them from the incremental. This has the effect of almost doubling our recovery time. Since our DB files are only about 23GB, we need to effectively restore 46GB. Now if this were 150GB... Long story short: TEST YOUR DATABASE RECOVERY! We've tested before, so this must've cropped up in an Omniback

Test

2002-01-19 Thread Scott . Shafer
Knock-knock. Scott Shafer San Antonio, TX 210-581-6217 Common sense will not accomplish great things. Simply become insane and desperate. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

RE: Test

2002-01-19 Thread Larry Elkins
Boo -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Saturday, January 19, 2002 6:20 AM To: Multiple recipients of list ORACLE-L Subject: Test Knock-knock. Scott Shafer San Antonio, TX 210-581-6217 Common sense

Oracle dev/test schema generation tool.

2002-01-16 Thread Mark Leith
Hi List, I'd like to take the opportunity to ask if any of you would be interested in testing a copy of a new tool that is available through Cool-Tools (from a company called Net2000 Ltd. run by another of our list members Dale Edgar) *free of charge*. We are looking for people to test it out

test

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

Test - Ignore

2001-10-01 Thread Viraj Luthra
Please delete Make a difference, help support the relief efforts in the U.S. http://clubs.lycos.com/live/events/september11.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: test

2001-09-24 Thread Nirmal Kumar Muthu Kumaran
Please don't test here. -Original Message- From: Rajesh Dayal [SMTP:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 9:10 AM To: Multiple recipients of list ORACLE-L Subject: test test -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

test

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

AW: test schema from prod

2001-09-18 Thread Schoen Volker
. [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 17. September 2001 19:10 An: Multiple recipients of list ORACLE-L Betreff: RE: test schema from prod import fromuser touser? -Original Message- Sent: Monday, September 17, 2001 10:35 AM To: Multiple recipients of list ORACLE-L Hi Friends, I

test schema from prod

2001-09-17 Thread Raghu Kota
Hi Friends, I want to create test schema from my production database, What is best way to do that!! Any ideas or ways to create test schema fast!! I appreciate your time. TIA Raghu. _ Get your FREE download of MSN Explorer

RE: test schema from prod

2001-09-17 Thread Smith, Ron L.
import fromuser touser? -Original Message- Sent: Monday, September 17, 2001 10:35 AM To: Multiple recipients of list ORACLE-L Hi Friends, I want to create test schema from my production database, What is best way to do that!! Any ideas or ways to create test schema fast!! I

Test - Please Delete

2001-09-17 Thread Speaks, Chuck W.
Title: RE: Visio for ERD's ? Test. Not receiving email from list. 10:53am Chuck Speaks Database Administrator Lithonia Lighting 770-860-3450 http://www.lithonia.com -Original Message-From: Jon Baker [mailto:[EMAIL PROTECTED]]Sent: Friday, September 14, 2001 16:18To: Multiple

RE: test schema from prod

2001-09-17 Thread Kevin Lange
The big question here is .. is it a full copy of production Test Schema or do you want to cut your data down by X percent. Also, is it on the same instance or a different instance ? If its a full copy an export/import would work . If its different boxes just export it from one

AW: test schema from prod

2001-09-17 Thread Schoen Volker
Betreff: test schema from prod Hi Friends, I want to create test schema from my production database, What is best way to do that!! Any ideas or ways to create test schema fast!! I appreciate your time. TIA Raghu. _ Get your

Re: test schema from prod

2001-09-17 Thread DBarbour
] mail.comcc: Sent by: Subject: test schema from prod [EMAIL PROTECTED

Re: test schema from prod

2001-09-17 Thread Steve Smith
fromuser touser? -Original Message- Sent: Monday, September 17, 2001 10:35 AM To: Multiple recipients of list ORACLE-L Hi Friends, I want to create test schema from my production database, What is best way to do that!! Any ideas or ways to create test schema fast!! I appreciate

test schema from prod

2001-09-17 Thread Raghu Kota
Hi Friends, Great input and wonderful info guys!! Thanks to all. Its always nice to see different view points. Thanks again Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the

just a test

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

Re: Test for compatibility with Standard Engine

2001-09-06 Thread Jeram
8.1.7 Enterprise Edition on AIX, but a customer has only 8.1.7 Standard Engine. Is there anyway I can test that my development code(PL/SQL mostly) is compatible with Standard Engine?. From the list of functions missing from Standard I think I am Ok...but would like to be sure! John -- Please see

RE: Test for compatibility with Standard Engine

2001-09-06 Thread Mark Leith
can test that my development code(PL/SQL mostly) is compatible with Standard Engine?. From the list of functions missing from Standard I think I am Ok...but would like to be sure! John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED

RE: Test for compatibility with Standard Engine

2001-09-06 Thread Vadim Gorbounov
problems. Rgds/Jeram -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thursday, September 06, 2001 3:02 PM We develop using 8.1.7 Enterprise Edition on AIX, but a customer has only 8.1.7 Standard Engine. Is there anyway I can test that my development

Test Message

2001-09-05 Thread Walthour, Jon (GEAE, Compaq)
Title: Message This is a test message. Please ignore. Jon Walthour Oracle Database Administrator COMPAQ DBA Team Cincinnati, Ohio

Re: Test Message

2001-09-05 Thread tday6
recipients of list ORACLE-L Compaq) [EMAIL PROTECTED] Jon.walthour@cc: ae.ge.comSubject: Test Message

OCP Test timeframe

2001-08-22 Thread Traci Rebman
Hello, does anyone know if there is a time limit on exams taken for the OCP DBA 8i track? More specifically, from when the first test is taken, do you have to complete the others in a specified amount of time, say within 1 year? Thanks Traci -- Please see the official ORACLE-L FAQ: http

RE: OCP Test timeframe

2001-08-22 Thread Cale, Rick T (Richard)
on exams taken for the OCP DBA 8i track? More specifically, from when the first test is taken, do you have to complete the others in a specified amount of time, say within 1 year? Thanks Traci -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Traci Rebman INET: [EMAIL

Re: OCP Test timeframe

2001-08-22 Thread kjanusz
if there is a time limit on exams taken for the OCP DBA 8i track? More specifically, from when the first test is taken, do you have to complete the others in a specified amount of time, say within 1 year? Thanks Traci -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

RE: TNSPING Test Script for NT

2001-08-22 Thread Haskins, Ed
it to *** file name pingtest.bat tnsping %1 1000 ping.lis Can be executed as pingtest {sid} Another way to do this using a loop within the .bat file follows. This would execute the tnsping command 1000 times: *** file name pingtest1.bat echo TnsPing Test ping.lis echo date /T ping.lis for /L %I

RE: OCP Test timeframe

2001-08-22 Thread Tirumala, Surendra
the first test is taken, do you have to complete the others in a specified amount of time, say within 1 year? Thanks Traci -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Traci Rebman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

RE: TNSPING Test Script for NT

2001-08-21 Thread Mercadante, Thomas F
the .bat file follows. This would execute the tnsping command 1000 times: *** file name pingtest1.bat echo TnsPing Test ping.lis echo date /T ping.lis for /L %I in (1,1,1000) do tnsping r816 ping.lis And a third way, using goto looping: *** file name pingtest2.bat @rem @rem Loop

TNSPING Test Script for NT

2001-08-21 Thread Ed . Haskins
Can anyone help me with a simple .bat script for NT that will run a TNSPING against a certain connect descriptor and write the results to a file. I need to have the TNSPING run for say 1000 loops. Once complete, I can search through the file for errors. Thanks, Ed -- Please see the official

ignore this test

2001-08-16 Thread Don Dealy II

Test Message - receiving no mail..

2001-08-13 Thread Mark Leith
Too often, we lose sight of life's simple pleasures. Remember, when someone annoys you it takes 42 muscles in your face to frown, BUT, it only takes 4 muscles to extend your arm and bitch-slap that mother@#?!! upside the head! Thanks for listening to my test message

Re: Explain Plan different on TEST and PRODUCTION instance

2001-08-13 Thread Mohammad Rafiq
of parallelism, etc...). In this case TEST is getting a better plan because the CBO is being used. You can tell this from several features in the explain plan: 1. Cost = 169 Only the CBO calculates costs. 2. Only the CBO uses hash joins. The first thing I'd check is the degree

TEST

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

RE: Explain Plan different on TEST and PRODUCTION instance

2001-08-06 Thread Gupta, Brijesh
Title: RE: Explain Plan different on TEST and PRODUCTION instance Thanks Anita, It was the degree of parallelism that was creating the problem. I was just checking the degree column of the dba_indexes to set the parallelism , which was 1 but the INSTANCES column was set to DEFAULT. Brijesh

Re: Explain Plan different on TEST and PRODUCTION instance

2001-08-04 Thread Sukumar Kurup
--- 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 plan because the CBO is being used. You can tell

Re: Explain Plan different on TEST and PRODUCTION instance

2001-08-04 Thread Sukumar Kurup
Brijesh, Another thing to check is if the tables involved have been analyzed on prod database. Sukumar Kurup __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the

Test message

2001-08-02 Thread Arich Henneman
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

RE: Test message

2001-08-02 Thread Mohan, Ross
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--

RE: Test message

2001-08-02 Thread Jamadagni, Rajendra
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

RE: Test message

2001-08-02 Thread JOE TESTA
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 PROTECTED]Fat

[Q] populate production DB to test DB?

2001-07-17 Thread ef 8454
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

2001-07-16 Thread viraj
please ignore

test message - please ignore

2001-07-16 Thread Viraj Luthra
-- 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 - please ignore

2001-07-11 Thread Eric . Desai
-- 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

test

2001-07-05 Thread Sinardy
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

2001-07-03 Thread Pablo ksksksk
___ 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:

Looking for a test Database

2001-07-02 Thread Peter McLarty
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

Re: Looking for a test Database

2001-07-02 Thread Jared Still
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 some tests with. perhaps something

RE: Looking for a test Database

2001-07-02 Thread Mark Leith
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 some tests with. perhaps something

Re: Looking for a test Database

2001-07-02 Thread Greg Moore
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 demo database

<    1   2   3   4   >