TEST

2002-05-21 Thread RAJESH DAYAL
Title: TEST TESTING .. PLS IGNORE .

RE: TEST

2002-05-20 Thread Schilling, Ben
Your shift key is not working correctly -Original Message- Sent: Monday, May 20, 2002 1:18 AM To: Multiple recipients of list ORACLE-L TESTING ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schilling, Ben INET: [EMAIL PROTECTED] Fat Cit

RE: TEST

2002-05-19 Thread Abdul Aleem
Title: TEST What are you testing? -Original Message-From: RAJESH DAYAL [mailto:[EMAIL PROTECTED]]Sent: Monday, May 20, 2002 11:18 AMTo: Multiple recipients of list ORACLE-LSubject: TEST TESTING ...

TEST

2002-05-19 Thread RAJESH DAYAL
Title: TEST TESTING ...

Test - Please Ignore

2002-05-14 Thread Madhavan Amruthur
Test Mail --- Madhavan Amruthur Outgrown your current e-mail service? Get a 25MB Inbox, POP3 Access, No Ads and No Taglines with LYCOS MAIL PLUS. http://login.mail.lycos.com/brandPage.shtml?pageId=plus -- Please see the official ORACLE

RE: pl/sql is INTERPRETED?- java test

2002-05-06 Thread G . Plivna
riod of time. This means that development and maintenance costs are > > > relatively low. If an IT shop is stronger in Java, then they should > > > probably program in Java, or Cobol, or Ada, or whatever the flavor of the > > > decade happens to be (lets bring

test - text file attachment / Re: ORACLE-L Digest -- Volume 2002, Number 123

2002-05-03 Thread Eric D. Pierce
what - you changing careers - trying out for Denis Miller's show? > TEST TEXT FILE ATTACHMENT FOR ORACLE-L ANTI-VIRUS SPAMMERS

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: http://www.orafaq.co

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 schem

Re: Developer access in test database

2002-04-14 Thread Yechiel Adar
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 nothing. I've encountered very few with a > need/desire for select_catalog_role, and they have to ask first

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-- (858)

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 Informa

RE: Developer access in test database

2002-04-13 Thread DENNIS WILLIAMS
k of some large 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 t

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 h

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) 538-50

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 develo

RE: RE: Developer access in test database

2002-04-12 Thread Mercadante, Thomas F
the user to that they can create stored procs if need be. I then migrate stored procs to the dev schema as need be. Hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, April 12, 2002 8:38 AM To: Multiple recipients of list ORACLE-L In our

RE: Developer access in test database

2002-04-12 Thread Deshpande, Kirti
I grant them full access to their own schema. The production schema owner in TEST databases is still controlled by DBAs. I do grant them selected '... any ...' privileges as needed, in the TEST databases excluding 'select any table'. No one gets it. Instead I grant them

Re:RE: Developer access in test database

2002-04-12 Thread dgoulet
12, 2002 8:38 AM To: Multiple recipients of list ORACLE-L 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.

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

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 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, test

RE: Developer access in test database

2002-04-12 Thread Mercadante, Thomas F
8:38 AMTo: 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

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

Developer access in test database

2002-04-12 Thread Jeffrey Beckstrom
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 "t

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

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

Test

2002-04-09 Thread Denny Koovakattu
Testing new email address. Testing new email address. Testing new email address. Testing new email address. Testing new email address. Testing new email address. Testing new email address. Testing new email address. Testing new email address. -- Please see the official ORACLE-L FAQ: http://www.or

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 N

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 in

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

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 and

Re: How to test BCV and backups

2002-03-25 Thread Brian_P_MacLean
acle DBA, OCP8i "Seppo Kaasalainen" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject:

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 Ora

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 the

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

2002-03-13 Thread Robertson Lee - lerobe
ive > a > little over 84 on the score. All of the knowledge needed was > presented > some more detailed than others. Now that I look back on the > experience > and start moving forward towards my 8i OCP and eventually 9i OCP, I > will > study and practice more with the concepts

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

2002-03-12 Thread Rachel Carmichael
learned and understood the concepts presented. I was able to acheive > a > little over 84 on the score. All of the knowledge needed was > presented > some more detailed than others. Now that I look back on the > experience > and start moving forward towards my 8i OCP and eventually

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

2002-03-12 Thread Freeman, Robert
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. A real test of you

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

2002-03-12 Thread Ron Rogers
swers 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. A real test of your understandin

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

2002-03-12 Thread Freeman, Robert
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 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 Cor

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

2002-03-12 Thread Ron Rogers
r OCP from 8 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 conce

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

2002-03-12 Thread Joe Raube
t; <[EMAIL PROTECTED]> 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 hel

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

2002-03-12 Thread Freeman, Robert
le 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: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services--

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

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

Re: Planning Test Backup/Recovery

2002-03-05 Thread Eriovaldo Andrietta
ok. Thanks for answers. Regards Eriovaldo - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, March 04, 2002 11:18 AM > Eriovaldo, > > If I were you, I would create a small test database on the production >

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

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 there

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

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 0

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

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) 53

DISREGARD, JUST A TEST

2002-02-26 Thread Babich , Sergey
TEST ONLY

test - pl delete

2002-02-18 Thread Praful Thakkar
__ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games 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-- (8

[Q] install ORACLE ODBC patch 8.1.7.5 and "ODBC test" gone?

2002-02-06 Thread dist cash
I installed ORACLE client 8.1.7 on NT. after finished, I can configure ODBC through "MS ODBC Administrator" and test it from "ODBC test". I installed ODBC patch 8.1.7.5 and "ODBC test" is gone from "Network Admin" ent

RE: *ALWAYS* test your recovery plan!

2002-02-05 Thread Kimberly Smith
ll 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

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

2002-02-05 Thread Jesse, Rich
PROTECTED] 02/05/02 12:31 PM Please respond 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

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 Mercada

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

2002-02-05 Thread Jared . Still
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 on circumstances) as we will have ZERO loss of data with minimal downtime in off-hours, but we hit a bit of a snag

RE: *ALWAYS* test your recovery plan!

2002-02-05 Thread Grabowy, Chris
B. 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 Jesse

FYI: *ALWAYS* test your recovery plan!

2002-02-05 Thread Jesse, Rich
t 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 upgrade. BTW, our production DB is fine, except for the 3M row table a developer truncated... ;) Hope

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

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

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 i

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 FAX:

RE: test

2001-09-23 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

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, 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 of

Re: test schema from prod

2001-09-17 Thread Ron Rogers
Raghu, That depends on what you call fast and how big your database is. I created a test environment on a Linux box Oracle 8.1.7 and I decided to use LMT for the tablespace. The data consists of 8 years worth of data (72 GIG). The data tables were small 4K to large 8 GIG. Some of them are

Re: test schema from prod

2001-09-17 Thread Steve Smith
7, 2001 11:10 AM > 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

Re: test schema from prod

2001-09-17 Thread DBarbour
>cc: Sent by: Subject: test schema from prod [EMAIL PROTECTED]

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 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

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

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 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

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 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

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 Jeram
lop 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 code(PL/SQL mostly) is >compatible with Standard Engine?. From the list of functions missing from >Standard I think I am Ok...but would

Test for compatibility with Standard Engine

2001-09-06 Thread John Dunn
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 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

Re: Test Message

2001-09-05 Thread tday6
To: Multiple recipients of list ORACLE-L Compaq)" <[EMAIL PROTECTED]> Subject: Test Message

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: OCP Test timeframe

2001-08-22 Thread Tirumala, Surendra
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-22 Thread Haskins, Ed
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 >&g

Re: OCP Test timeframe

2001-08-22 Thread kjanusz
s 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 ORACL

RE: OCP Test timeframe

2001-08-22 Thread Cale, Rick T (Richard)
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

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

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 OR

RE: TNSPING Test Script for NT

2001-08-21 Thread Mercadante, Thomas F
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 in (1,1,1000) do tnsping r816 >> ping.lis And a third way, using goto looping: *** file name pi

ignore this test

2001-08-16 Thread Don Dealy II

Re: Explain Plan different on TEST and PRODUCTION instance

2001-08-13 Thread Mohammad Rafiq
degree 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 th

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 tes

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

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

<    1   2   3   4   >