RDBMS - key strength
Suppose you were allowed only ONE sentence to describe the greatest strength of RDBMS's over say (object databases, legacy, etc.)... what would that be? Keith __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson 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 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 command for other information (like subscribing).
RE: foreign key what???? help!!
you might want to disable the FK's before loading. This will speed up the loading, and it will not upset you with ugly error messages. After loading... enable keys. Keith Date: Mon, 03 Jun 2002 15:28:22 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Reply-to: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California It is probably a question of timing when Child records are loaded before Parents. It can be a question of table order or even record order (self referencing relationship). Once the data is loaded, enforcement of the constraint is easy because all of the data exists. Daniel W. Fink Sr. Oracle DBA MICROMEDEX 303.486.6456 -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 4:13 PM To: Multiple recipients of list ORACLE-L Okay guys, Have foreign keys defined on large dw tables. When loading get foreign key errors. However, after load (w/o change in data and supposedly data it was barking on) could create fk's just fine on the same data elements involving the same data - I SWEAR. This does not make sense to me. Any ideas? __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson 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 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 command for other information (like subscribing).
Re: Database backup question.Thank You
lets not forget the classic exp. 1. Production database (where you can't lose a single transaction) - ARCHIVEMODE absolutely 2. Development database (few hrs of transactions ok to lose) - cold backups 3. Development database (no schema changes, say an application is being developed with a tool such as using Oracle designer) - a simple 'exp un/pwd' of the user, is the simplest, quickest, lightest, least headache,... may also be considered. Keith Date: Fri, 24 May 2002 09:12:02 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Reply-to: [EMAIL PROTECTED] Address | Add to Address Book Organization: Fat City Network Services, San Diego, California Hi Tim and Connor, Thanks you all for your very helpful feedback. I do appreciate it very much. In fact, we are in development at this point, so the database is small and transaction volume is very low. Therefore, my choice for primary backup method is the cold backups. However, to safeguard against unsual things, which might happen to the database, I will take your advice to run my database in ARCHIVELOG mode. The hot backup will be used. Again, thanks for your very quick responses. Regards, Trang Tim Gorman [EMAIL PROTECTED] wrote: Trang, Theoretically, the online redo log files are be necessary, but the world has a habit of making a shambles of the theoretical. Let's say, in the event that you automate your Friday script, you'll probably come to realize that SHUTDOWN IMMEDIATE is far from perfect (as well as far from immediate!). Over time, you'll probably construct some kind of fail-safe mechanism to SHUTDOWN ABORT if the initial SHUTDOWN IMMEDIATE doesn't shut down after a period of time. Pretty standard thing that DBAs have been writing for years. Hopefully, after the SHUTDOWN ABORT they also STARTUP RESTRICT and then SHUTDOWN NORMAL, but you can't count on it... So, here's the point: what if you take a cold backup in NOARCHIVELOG mode after a SHUTDOWN ABORT (that should have been a SHUTDOWN IMMEDIATE and wasn't) and you have *not* backed up those online redo log files? Answer: unusable backup. So, back up everything: all datafiles, controlfiles, and online redo logfiles. The latter are not too big anyway -- what's the point of excluding them? It is wise to take a cold backup after a clean shutdown, but you can even get a valid backup after a SHUTDOWN ABORT or a crash if you've backed up the online redo archive log files. When you restart Oracle, an instance recovery will occur automatically, and you might not even know it. Just be certain that the instance is truly dead when you take your cold backup... With regards to switching between ARCHIVELOG and NOARCHIVELOG, it's a waste of effort from a recoverability standpoint. At most it may be interesting, but as soon as you switch out of ARCHIVELOG mode, nothing you've done while in ARCHIVELOG mode is valid anymore. Leave it one way or the other, and then leave it... ...just my $0.02... Another $0.02: use RMAN for your cold backups. Then you won't forget anything, because RMAN will remember for you... Hope this helps... -Tim - Original Message - To: Multiple recipients of list ORACLE-L Sent: Thursday, May 23, 2002 5:33 PM Hi All, I need to perform a consistent backup for my whole database every Friday by using operating system utilities. My database has been currently operating in NOARCHIVELOG mode, so the only files need to be backed up are datafiles, control files, the initialization parameter file and other oracle product initialization files (Based on Oracle8.1.6 Backup and Recovery Guide). Since the files in this type of backup are all consistent and do not need recovery, so the online logs are not needed. Since online redo logs is very crucial for recovery, so my question is do I need to back up the online redo log files as I choose to perform cold backup type for my entire database weekly? Here is step by step what I did to back up the whole database: after the database was closed cleanly and all the above mentioned files had been backed up into the tape. I had to restart the database and mount but not open, then switched between NOARCHIVELOG mode to ARCHIVELOG mode in order to archive the online redo log files. Finally, I copied all archived redo log files into the tape while the database was open and operated in ARCHIVELOG mode. when it was all done, I then switched the database back to NOARCHIVELOG mode. Just wondered whether my procedure to perform a whole consistent database backup is correct? Am I safe to this point? Your help is greatly appreciated it. Your help is greatly appreciated. Thanks in advance, Trang __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson INET: [EMAIL PROTECTED] Fat City Network Services
Re: Rename Column in 9iR2
wish this had come about 20 years ago, as it would have saved us approx. 2 man years of dev. time (conservative estimate). Considering all 9i enhancements... this feature should weigh in at well over 25% Keith Date: Wed, 22 May 2002 06:38:37 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Reply-to: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California Summary: it works! SQL SELECT * FROM v$version; BANNER Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production PL/SQL Release 9.2.0.1.0 - Production CORE9.2.0.1.0 Production TNS for Solaris: Version 9.2.0.1.0 - Production NLSRTL Version 9.2.0.1.0 - Production SQL create table test_table (wrong_name VARCHAR2(40)); Table created. SQL alter table test_table rename column wrong_name to right_name; Table altered. SQL desc test_table; Name Null? Type - RIGHT_NAME VARCHAR2(40) SQL Kevin Toepke [EMAIL PROTECTED] __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson 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 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 command for other information (like subscribing).
RE: Rename Column in 9iR2
If those times are right... its a functionality you should not live without, its a direct money saver. Upgrade to 9i today! hats off to Oracle marketing... if and when the database sales lose traction... we will release RENAME COLUMN... and 20 years later... here it is. Keith Date: Wed, 22 May 2002 10:41:32 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Reply-to: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California Kevin, I appreciate your testing efforts. Now to convince the bean-counters to upgrate to 9i. Ron ROR mª¿ªm [EMAIL PROTECTED] 05/22/02 02:08PM I reran my test. with 250,000 rows in the table. It took a whopping 0.25 seconds to complete. -Original Message- Sent: Wednesday, May 22, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Kevin, Yes but does it work with data in the column?, I do not have 9i set up yet. If it works as you describe with data in the column it will really help with the multi million row tables that they want to rename a column after a release of a new lotto game. thanks, for the test and update. Ron ROR mª¿ªm [EMAIL PROTECTED] 05/22/02 10:38AM Summary: it works! SQL SELECT * FROM v$version; BANNER Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production PL/SQL Release 9.2.0.1.0 - Production CORE9.2.0.1.0 Production TNS for Solaris: Version 9.2.0.1.0 - Production NLSRTL Version 9.2.0.1.0 - Production SQL create table test_table (wrong_name VARCHAR2(40)); Table created. SQL alter table test_table rename column wrong_name to right_name; Table altered. SQL desc test_table; Name Null? Type - RIGHT_NAME VARCHAR2(40) SQL Kevin Toepke [EMAIL PROTECTED] __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson 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 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 command for other information (like subscribing).
complementary Conference passes
we have received information on complementary registrations to odtug 2002. If you are interested, let me know and I will forward the email. Keith __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson 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 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 command for other information (like subscribing).
Free ODTUG2002 registrations
Chris, the info. is at: https://www.odtug.com/ssl/2002_reg_iraje.asp Keith Date: Tue, 21 May 2002 10:29:45 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] I am interested. Thanks. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 21, 2002 2:01 PM To: Multiple recipients of list ORACLE-L we have received information on complementary registrations to odtug 2002. If you are interested, let me know and I will forward the email. Keith __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson 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 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 command for other information (like subscribing).
Complementary ODTUG 2002 Registrations
as customers, we just received this. Should be open to all: https://www.odtug.com/ssl/2002_reg_iraje.asp Keith __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson 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 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 command for other information (like subscribing).
Connecting to Oracle without using Listener
if your real question is can I circumvent the listener, the answer is no. Keith Date: Thu, 16 May 2002 19:33:46 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Reply-to: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California Is it possible to connect to Oracle DB server using DBI/ODBC through TCP/IP with or without using Listener at port 1521? Thanks. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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 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 command for other information (like subscribing). __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson 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 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 command for other information (like subscribing).
SQLPlus was Oracle - can you imagine ;-)
ever wonder why SQLPlus is so damn robost? It can do just about anything... in a messy and time consuming way sometimes, but it is rock solid. About 15 years ago, Sqlplus WAS Oracle. Nothing else. Hard to imagine. An Oracle engine with nothing inside (just tables and indexes): no procedures, no packages, package body, functions no triggers no sequences (can you imagine... this came with V6) no ref constraints no 2-phase commit no snapshots, no snapshot logs no parallel server ... can you imagine! and it was already the most powerful database server growing at 100% year over year (100% growth for 13 years in a row) I mean can you imagine SQLPLUS was ORACLEcan you in your wildest dreams imagine what this group would be like?... just SQLPLUS related issues can you imagine;-) Keith __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson 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 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 command for other information (like subscribing).
RE: SQLPlus was Oracle - can you imagine ;-)
You mean that 40% A/V - 80%proof was not ketchup...? and the most complex question for the group in those days would have been: I am new to Oracle and I have this problem SQL desc emp NameNull?Type --- EMPLOYEE_ID NUMBER(4) LAST_NAMEVARCHAR2(15) FIRST_NAME VARCHAR2(15) MIDDLE_INITIAL VARCHAR2(1) JOB_ID NUMBER(3) MANAGER_ID NUMBER(4) HIRE_DATEDATE SALARY NUMBER(7,2) COMMISSION NUMBER(7,2) DEPARTMENT_IDNUMBER(2) FAT/TITLEVARCHAR2(40) SQL select fat/title 2 from emp; select fat/title * ERROR at line 1: ORA-00904: invalid column name SQL c/fat\/\title/FAT/TITLE String not found. SQL drop the employees fat/title; drop the employees fat/title * ERROR at line 1: ORA-00950: invalid DROP option SQL huh? unknown command huh? - rest of line ignored. SQL Keith Date: Fri, 17 May 2002 07:18:21 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Reply-to: [EMAIL PROTECTED] ;-) Organization: Fat City Network Services, San Diego, California Have you been on the sauce ??? -Original Message- Sent: 17 May 2002 15:54 To: Multiple recipients of list ORACLE-L ever wonder why SQLPlus is so damn robost? It can do just about anything... in a messy and time consuming way sometimes, but it is rock solid. About 15 years ago, Sqlplus WAS Oracle. Nothing else. Hard to imagine. An Oracle engine with nothing inside (just tables and indexes): no procedures, no packages, package body, functions no triggers no sequences (can you imagine... this came with V6) no ref constraints no 2-phase commit no snapshots, no snapshot logs no parallel server ... can you imagine! and it was already the most powerful database server growing at 100% year over year (100% growth for 13 years in a row) I mean can you imagine SQLPLUS was ORACLEcan you in your wildest dreams imagine what this group would be like?... just SQLPLUS related issues can you imagine;-) Keith __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson 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 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 command for other information (like subscribing).
RE: ERD generation tool - Active SCM
], '[EMAIL PROTECTED]' [EMAIL PROTECTED] Date: Wed, 1 May 2002 16:06:00 -0500 Well, for one thing, if your developer, Dom Phoc, starts changing crap in your database (as has happened to me in the past) a compare to the dev model would be great because my development changes would be in the model, not in the test or production databases. In that specific case I had to TRUST him (what? trust him after what he just did?) to change everything back, or restore from a backup, which would have been very time consuming. I was one large ball of raging hormones that day and I took it all out on him. We don't work on the same projects anymore. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Keith Peterson [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 5:50 PM To: Multiple recipients of list ORACLE-L Subject: RE: ERD generation tool - Active Comparisons Am I speaking to the wind For Compares, why would you compare the MODEL with the DATABASE...like going from US to London via Tokyo... ... and you get to pay more, like... you pay not for distance, but for time in the air... If a tool takes longer to do something, makes more mistakes, is bumpy and complex... you get to pay more. For compares, someone tell me what beats ActiveCompare: http://www.iraje.com/compare-diff.htm http://www.iraje.com/ActiveCompare_viewlet.html ...and I will switch my tool. Keith __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson 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 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 command for other information (like subscribing).
Re: ERD generation tool - Active SCM
Yechiel, here is additional information: white paper: http://www.iraje.com/docs/ActiveSecureDesigner.htm WEBCAMS (4-6 mins) and screenshots: ActiveChangeManager: http://www.iraje.com/ActiveChangeManager_viewlet.html http://www.iraje.com/acommanbig.htm ActiveCompare: http://www.iraje.com/ActiveCompare_viewlet.html http://www.iraje.com/acomparebig.htm ActiveDesigner: http://www.iraje.com/ActiveDesigner_viewlet.html http://www.iraje.com/adbig.htm Active+: http://www.iraje.com/active_main.htm Keith Date: Sun, 05 May 2002 03:48:18 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Reply-to: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California Well , just to keep things jumping. Last week I deviated from our rule and gave a responsible user that needed truncate on tables the password for the owner of the schema. Guess what? Today he comes to me to recreate 2 tables that he dropped. Go figure. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 03, 2002 5:53 PM Yechiel, Yes, I have been there, done that, over and over... But then, there is a Toyota Corolla solution and maybe a Ferrari Testarosa solution. If we can control Dom Phoc without tieing his hands behind the back, wouldn't that would be the best: white paper: http://www.iraje.com/docs/ActiveSecureDesigner.htm Keith __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson 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 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 command for other information (like subscribing).
Re: ERD generation tool - Active SCM
have been very time consuming. I was one large ball of raging hormones that day and I took it all out on him. We don't work on the same projects anymore. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Keith Peterson [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 5:50 PM To: Multiple recipients of list ORACLE-L Subject: RE: ERD generation tool - Active Comparisons Am I speaking to the wind For Compares, why would you compare the MODEL with the DATABASE...like going from US to London via Tokyo... ... and you get to pay more, like... you pay not for distance, but for time in the air... If a tool takes longer to do something, makes more mistakes, is bumpy and complex... you get to pay more. For compares, someone tell me what beats ActiveCompare: http://www.iraje.com/compare-diff.htm http://www.iraje.com/ActiveCompare_viewlet.html ...and I will switch my tool. Keith __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson 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 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 command for other information (like subscribing).
Re: ERD generation tool - Active SCM
Yechiel, Yes, I have been there, done that, over and over... But then, there is a Toyota Corolla solution and maybe a Ferrari Testarosa solution. If we can control Dom Phoc without tieing his hands behind the back, wouldn't that would be the best: white paper: http://www.iraje.com/docs/ActiveSecureDesigner.htm Keith Date: Thu, 02 May 2002 11:48:38 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Reply-to: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California Well Keith Our solution to the Doom Phoc (and their siblings) is: Do not grant they rights to do any DDL either in test nor in prod. The dab stuff does all the DDL work. Sure it is an added chore, but after tracking down, a few times, tables that were dropped inadvertently by users (their tool did it by itself) we now use the following policy: Every application has two user id's: Owner, with password known only to the DBA group. User with rights for select, insert, update, delete ONLY. It works. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 02, 2002 7:54 PM Lisa, There is only so much you can control via a model, since it remains a process away from the DB, and cannot be enforced via privileges, etc. So, we are always in the hands of Dom Phoc (and their siblings), who can do stuff even in the production database with SQLPLus/TOAD/... Under this schenario, do you sleep well at night? So, we said lets work with our Dom Phoc's. On production databases, we will STRIP them off of the Oracle database passwords. No password, no change. ENFORCED! Now, I can sleep well at night. How? Not via models. Via a solution involving the following, and it seems to be working for us well: ActiveDesigner/ActiveChangeManager/ActiveCompare/A+ White Paper: http://www.iraje.com/docs/ActiveSecureDesigner.htm Take charge of the Dom Phocs in your org! Keith To: '[EMAIL PROTECTED]' [EMAIL PROTECTED], '[EMAIL PROTECTED]' [EMAIL PROTECTED] Date: Wed, 1 May 2002 16:06:00 -0500 Well, for one thing, if your developer, Dom Phoc, starts changing crap in your database (as has happened to me in the past) a compare to the dev model would be great because my development changes would be in the model, not in the test or production databases. In that specific case I had to TRUST him (what? trust him after what he just did?) to change everything back, or restore from a backup, which would have been very time consuming. I was one large ball of raging hormones that day and I took it all out on him. We don't work on the same projects anymore. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Keith Peterson [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 5:50 PM To: Multiple recipients of list ORACLE-L Subject: RE: ERD generation tool - Active Comparisons Am I speaking to the wind For Compares, why would you compare the MODEL with the DATABASE...like going from US to London via Tokyo... ... and you get to pay more, like... you pay not for distance, but for time in the air... If a tool takes longer to do something, makes more mistakes, is bumpy and complex... you get to pay more. For compares, someone tell me what beats ActiveCompare: http://www.iraje.com/compare-diff.htm http://www.iraje.com/ActiveCompare_viewlet.html ...and I will switch my tool. Keith __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson 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 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 command for other information (like subscribing).
RE: ERD generation tool - Active SCM
Lisa, There is only so much you can control via a model, since it remains a process away from the DB, and cannot be enforced via privileges, etc. So, we are always in the hands of Dom Phoc (and their siblings), who can do stuff even in the production database with SQLPLus/TOAD/... Under this schenario, do you sleep well at night? So, we said lets work with our Dom Phoc's. On production databases, we will STRIP them off of the Oracle database passwords. No password, no change. ENFORCED! Now, I can sleep well at night. How? Not via models. Via a solution involving the following, and it seems to be working for us well: ActiveDesigner/ActiveChangeManager/ActiveCompare/A+ White Paper: http://www.iraje.com/docs/ActiveSecureDesigner.htm Take charge of the Dom Phocs in your org! Keith To: '[EMAIL PROTECTED]' [EMAIL PROTECTED], '[EMAIL PROTECTED]' [EMAIL PROTECTED] Date: Wed, 1 May 2002 16:06:00 -0500 Well, for one thing, if your developer, Dom Phoc, starts changing crap in your database (as has happened to me in the past) a compare to the dev model would be great because my development changes would be in the model, not in the test or production databases. In that specific case I had to TRUST him (what? trust him after what he just did?) to change everything back, or restore from a backup, which would have been very time consuming. I was one large ball of raging hormones that day and I took it all out on him. We don't work on the same projects anymore. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Keith Peterson [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 5:50 PM To: Multiple recipients of list ORACLE-L Subject: RE: ERD generation tool - Active Comparisons Am I speaking to the wind For Compares, why would you compare the MODEL with the DATABASE...like going from US to London via Tokyo... ... and you get to pay more, like... you pay not for distance, but for time in the air... If a tool takes longer to do something, makes more mistakes, is bumpy and complex... you get to pay more. For compares, someone tell me what beats ActiveCompare: http://www.iraje.com/compare-diff.htm http://www.iraje.com/ActiveCompare_viewlet.html ...and I will switch my tool. Keith __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson 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 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 command for other information (like subscribing).
RE: ERD generation tool - Active Comparisons
Am I speaking to the wind For Compares, why would you compare the MODEL with the DATABASE...like going from US to London via Tokyo... ... and you get to pay more, like... you pay not for distance, but for time in the air... If a tool takes longer to do something, makes more mistakes, is bumpy and complex... you get to pay more. For compares, someone tell me what beats ActiveCompare: http://www.iraje.com/compare-diff.htm http://www.iraje.com/ActiveCompare_viewlet.html ...and I will switch my tool. Keith Date: Wed, 01 May 2002 13:00:31 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Reply-to: [EMAIL PROTECTED] to Address Book Organization: Fat City Network Services, San Diego, California ERWin's not much better. Has some better modeling capability as you might guess, but has some VERY annoying quirks too. You also need to drill down endlessly when doing a compare and I have seen it see two exact tables (even case being the same) and see them as different. The DO have a MATCH button that I would SUPPOSE allows you to re-align them, but I would not know for sure as I get Dr. Watson's whenever I press it and the whole thing crashes! I had a nice BUG last week only. Generated scripts for the model, ran them on the db, then ran a compare from the model to the db. Darn thing came up with differences Furthermore, I find that if you work from the Logical Model (like I do), the changes are not equally presented to the physical model (ie name change./datatype change) and its NOT consistent with this behavior either! It has a report builder, but it doesn't report on datatypes entered on the Logical side (even though the datatype on the physical MAY be different) = therefore you can't run any consistency reports between the Logical and Physical models. I have been using ERWin both as a modeling tool and a change repository for the model.I like to run several reports against a model (I call them the Sanity Checks Reports) you know, make sure that all columns named the same (ie DESCRIPTION) are of the same datatype, length, etc. Anyhow, I can rant and rant. ERWin's BIGGEST Annoyance is my book is that there is no UNDO feature and it is rather easy to accidentally drop and drag either a relationship or field when re-aligning the model.. ugh I wish we could get together a group and benchmark some relatively unknown but stable modeling tool who's maker will listen to the DBA community and put their name in the market (IE. give them market share) in exchange for giving our community a tool that would actually work for us and work well! Rant over now. Please continue... * It cannot handle obejcts (CLOBs, BLOBs, ...) that are not stored inline. If you place CLOBs in a different tablesapce form the rest of the row, you will have to manually manipulate the DDL. * It has no schema-schema comparision capabilities, only schema-model. * Examining the results of schema-model comparision is extremely awkward, time consuming, and aggravating. One has to continually drill down in a miniscule window using the Windows Explorer type interface to see anything meaningful. There are some other significant deficiencies also. I talked to them about all these and more. What I got was the same answer that I got two years ago also. We'll put it on the enhancement request list. or We've been intending to do that. Personally, I think that packages have been around long enough that a multi-thousand dollar per seat tool should be able to handle them by now! Unfortunately, I don't know of any great modeling tool right now. Designer does everything, but definitely has some quirks. If you use another RDBS, it probably won't handle it well. In addition, it wants to do things its own way, not your way. Some also say it has the world's most obtuse interface. Simply sit someone that is familiar with modeling, but unfamiliar with Designer, down in front of the GUI and see how long it takes them to generate a readable ER diagram! (To make this fair, compared to other tools, don't give them any documentation other than the online help, but start it up and connect it to a database before you turn it over). It could be days, perhaps weeks! Don Granaman [OraSaurus] __ 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: Keith Peterson 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY
Re: Iraje. - Active tools - for comparing
Mark, we have been using the Active tools for some time and are kind of entrenched, particularly for comparing, designing and auditing: Active Compare http://www.iraje.com/compare-diff.htm Choices: TOAD, DBDiff, and Scripts? Why do we use ActiveCompare?: - we like the diff presentation as above - the Diff window is Active/Live - you can refresh the diff again after changing options, eg: ignore initial, ignore grants, ignore indexes etc. (TOAD has a live window, identifies the diffs but DOES NOT DISPLAY the diffs, and there are no options other than ignore Storage) - between ORACLE and SQLServer (DBDiff has this, but the window is a dead report. TOAD does not support SQLServer) - also, the direct execution of SQL to Consolidate/SYNCH UP is convenient (TOAD - scripts, DBDIFF-none) - Logs the changes. Now this is good for moving the changes across to another instance - tied to change management (TOAD - none, DBDIFF - none) Keith Hi All, I was wondering if any of you out there are using the tools that are provided by Iraje (i.e the Active tools)? If so, what are you thoughts, and comments on these tools (good or bad)? Thanks Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance __ 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: Keith Peterson 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 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 command for other information (like subscribing).
Re: Iraje. - ActiveWarehouse - fraud detection
Mark, The other tool we use is the ActiveAuditor/Warehouse solution as described below: ActiveAuditor/ActiveDataWarehouse http://www.iraje.com/accbig.htm Choices: informatica? DB Triggers? Why use it? - records DATA changes, just by a few clicks. - Lets say you have an OLTP app. This lets you split it up into OLTP(pure) and OLAP(pure) - allows you to rid your OLTP applications of all your HISTORY tables. Including, in ERPs like SAP, ORACLE APPS, PEOPLESOFT, ...very quickly, few hrs. - implementation time is only a few hours, we liked this, and turning the audit on/off is a switch, i.e. seconds. So, we turn on the monitoring at random, during times of fraud... night?, or on certain portions, financials, logins, etc. as required. Keith Date: Tue, 30 Apr 2002 08:41:19 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Reply-to: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California Hi All, I was wondering if any of you out there are using the tools that are provided by Iraje (i.e the Active tools)? If so, what are you thoughts, and comments on these tools (good or bad)? Thanks Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] __ 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: Keith Peterson 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 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 command for other information (like subscribing).
Re: ERD generation tool - ActiveDesigner pricing
and, pricing for ActiveDesigner (2001 dec. prices) Active D'lite approx: 995/- to the ActiveDesigner enterprise approx: 6,995/- (there are some intermediate points, dont have that info.) Keith Date: Tue, 30 Apr 2002 12:13:56 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Reply-to: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California ERWin is about $3,500 for a single user license. Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 30, 2002 2:38 PM any idea on the pricing for these tools? I dont see a price on any of these sites. Ray Mark Leith [EMAIL PROTECTED] Reply-To : [EMAIL PROTECTED] To : Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject : RE: ERD generation tool Date : Tue, 30 Apr 2002 06:03:36 -0800 ERWin www.ca.com ERStudio www.embarcadero.com Active Designer http://www.iraje.com/ad_fsmain.htm HTH Mark -Original Message- Sean Sent: 30 April 2002 13:24 To: Multiple recipients of list ORACLE-L Can anyone please recommend/advise on NT/W2K compliant solutions which can generate ERD's by interogating the DB. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] __ 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: Keith Peterson 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 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 command for other information (like subscribing).
Re: Active Compare - Oracle/Sqlserver - COMPARE WIZ
You might want to look at this: http://www.iraje.com/acc_comparemain.htm In addition to identifying the diffs, generating the diff reports alter scripts, it also: - executes the consolidation SQL realtime- Active - supports compares across ORACLE and SQLSERVER - allows rules: for conditional compares - Keeps a LOG of all executions - change management Keith Peterson Date: Fri, 26 Apr 2002 16:53:19 -0800 To: Multiple recipients of list ORACLE-L Reply-to: [EMAIL PROTECTED] DB Organization: Fat City Network Services, San Diego, California Thanks Charlie, this was a good suggestion. I downloaded and tried it out, and it works across Oracle and SQLServer. This is good. Ray From: Charlie Mengler To: Ray Gordon Subject: Re: Compare (diff) Oracle DB and MS-SQLServer DB - DBArtisanDate: Fri, 26 Apr 2002 13:14:43 -0700 __ 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: Keith Peterson 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 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 command for other information (like subscribing).
Re: Compare Schemas
Ron, For compares within Oracle, Oracle--SQLServer--DB2, etc., we think this is the best: http://www.iraje.com/compare-diff.htm links: http://www.iraje.com/acc_comparemain.htm http://www.iraje.com/ActiveCompare_viewlet.html DOWNLOAD: http://www.iraje.com/downloadmain.htm Keith Date: Mon, 29 Apr 2002 12:23:42 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Reply-to: [EMAIL PROTECTED] Address | Add to Address Book Organization: Fat City Network Services, San Diego, California I need to compare the schemas for two databases. I tried Toad, which will tell me there are differences but it won't say what the differences are. Does anyone have a script that will show the differences in detail? Ron Smith DBA Kerr-McGee Corp __ 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: Keith Peterson 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 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 command for other information (like subscribing).
