RE: Rman and database shutdowns UPDATE
Ron, the analogy I always use is "who has to recover the database when it crashes?" When they say, well, YOU, then I say Fine. We are going to back it up the way I see fit. End of story. Have fun testing~!! Good Luck. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax:954-935-3639 Cell:954-683-4459 -Original Message- Sent: Wednesday, February 12, 2003 1:59 PM To: Multiple recipients of list ORACLE-L Ron - Yes they can back it up and recover it from their perspective. You've brightened my day. Let us know if you want some more explanations to discuss this with them again. ;-) Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 12, 2003 10:24 AM To: Multiple recipients of list ORACLE-L Just got out of a meeting with the systems group. The Incremental backup was not working because the command was written wrong. There has been a decision to do cold backups each night. The system people swear that the OpenVms can successfully backup an open file (datafile) and have it recovered properly. They can backup it up with an Ignore flag that backups up open files? I will go with a cold backup methodology. Ron >>> [EMAIL PROTECTED] 02/12/03 10:18AM >>> List, OS OpenVms 7.3-1 Oracle 8.1.7 rel 3 Archivelog mode. We are trying to work through backup issues here and I have a question. The system nightly backup procedures backup up the disks used by Oracle (software and data). A full backup works but an incremental does not backup any files. Inorder to get the changed files to be backed up as an incremental the sysadmin shutdown the database to flag the files as changed. Questions: How will the shutdown effect the RMAN backup if it does not know that it was shutdown for a cold backup? Are there any possible problems doing a restore from the cold backup and then using the RMAN backup/restore? I am still trying to figure out the OpenVms OS. Perserverience required...! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, 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: Rman and database shutdowns UPDATE
Ron - Thought of a simple way to explain the situation to your VMS administrators. I've simplified a few things, but it should suffice. If I've missed anything critical, someone will correct me ;-) Each Oracle datafile has a transaction number recorded. The Oracle control file has a transaction number for each datafile. Before Oracle will open the database, the transaction number on the control file must match the transaction on each data file. When you shut Oracle down normal, all these numbers match, so a cold backup after a normal shutdown is valid. This is also why a cold backup after a shutdown abort or database crash can't be guaranteed. Now, if you back the database files up while Oracle is open, the backup will take some time, and if transactions occur in Oracle, the transaction numbers will change during the backup, so the control file may not match some file transaction numbers. Someone mentioned that you should test it. Be careful. If the database is quiet, it is possible to get a valid backup while the database is open. You wouldn't want to bet on this as a backup method, but in a test situation it could lead you to the wrong conclusion. Okay I'll shut up and let you get back to your nap ;-) Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 12, 2003 10:24 AM To: Multiple recipients of list ORACLE-L Just got out of a meeting with the systems group. The Incremental backup was not working because the command was written wrong. There has been a decision to do cold backups each night. The system people swear that the OpenVms can successfully backup an open file (datafile) and have it recovered properly. They can backup it up with an Ignore flag that backups up open files? I will go with a cold backup methodology. Ron >>> [EMAIL PROTECTED] 02/12/03 10:18AM >>> List, OS OpenVms 7.3-1 Oracle 8.1.7 rel 3 Archivelog mode. We are trying to work through backup issues here and I have a question. The system nightly backup procedures backup up the disks used by Oracle (software and data). A full backup works but an incremental does not backup any files. Inorder to get the changed files to be backed up as an incremental the sysadmin shutdown the database to flag the files as changed. Questions: How will the shutdown effect the RMAN backup if it does not know that it was shutdown for a cold backup? Are there any possible problems doing a restore from the cold backup and then using the RMAN backup/restore? I am still trying to figure out the OpenVms OS. Perserverience required...! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, 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: Rman and database shutdowns UPDATE
Ron, Back when we had Oracle on VMS (Oracle 7.1 - pre RMAN), we used this backup command for each datafile: backup/log/ignore=(interlock,nobackup)/new This will backup open files. But if your tablespace isn't in hot backup mode, it doesn't help you for database recovery. You might get lucky if there is little-to-no activity at the time of your backup, but this is a risk few DBAs would take. Jay >>> [EMAIL PROTECTED] 02/12/03 11:23AM >>> Just got out of a meeting with the systems group. The Incremental backup was not working because the command was written wrong. There has been a decision to do cold backups each night. The system people swear that the OpenVms can successfully backup an open file (datafile) and have it recovered properly. They can backup it up with an Ignore flag that backups up open files? I will go with a cold backup methodology. Ron >>> [EMAIL PROTECTED] 02/12/03 10:18AM >>> List, OS OpenVms 7.3-1 Oracle 8.1.7 rel 3 Archivelog mode. We are trying to work through backup issues here and I have a question. The system nightly backup procedures backup up the disks used by Oracle (software and data). A full backup works but an incremental does not backup any files. Inorder to get the changed files to be backed up as an incremental the sysadmin shutdown the database to flag the files as changed. Questions: How will the shutdown effect the RMAN backup if it does not know that it was shutdown for a cold backup? Are there any possible problems doing a restore from the cold backup and then using the RMAN backup/restore? I am still trying to figure out the OpenVms OS. Perserverience required...! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of D&E except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, 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: Rman and database shutdowns UPDATE
I'd tell them, great, then lets test it. Trust no one. Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 2/12/2003 10:23 AM Just got out of a meeting with the systems group. The Incremental backup was not working because the command was written wrong. There has been a decision to do cold backups each night. The system people swear that the OpenVms can successfully backup an open file (datafile) and have it recovered properly. They can backup it up with an Ignore flag that backups up open files? I will go with a cold backup methodology. Ron >>> [EMAIL PROTECTED] 02/12/03 10:18AM >>> List, OS OpenVms 7.3-1 Oracle 8.1.7 rel 3 Archivelog mode. We are trying to work through backup issues here and I have a question. The system nightly backup procedures backup up the disks used by Oracle (software and data). A full backup works but an incremental does not backup any files. Inorder to get the changed files to be backed up as an incremental the sysadmin shutdown the database to flag the files as changed. Questions: How will the shutdown effect the RMAN backup if it does not know that it was shutdown for a cold backup? Are there any possible problems doing a restore from the cold backup and then using the RMAN backup/restore? I am still trying to figure out the OpenVms OS. Perserverience required...! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, 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: Rman and database shutdowns UPDATE
Ron - the text below is from the fine VMS manual. I suspect your SAs are referring to the backup/ignore=interlock command. I certainly would not rely on it as part of my Oracle Disaster Recovery plan. The cold backup decision sounds to me like a wise one. BACKUP Invokes the Backup utility (BACKUP) to perform the following BACKUP operations: o Make copies of disk files. o Save disk files to a BACKUP save set. o Restore files from a BACKUP save set to disk. o Compare disk files with other disk files or files in a BACKUP save set. o List information about the files in a BACKUP save set. o Create and list BACKUP journal files. The two ways to back up your system disk are: o If you have access to the CD-ROM for the current version of OpenVMS Alpha or VAX, you can use the menu system supplied on the CD-ROM to back up your system disk. o If you do not have access to the CD-ROM for the current version of OpenVMS VAX, you must use standalone BACKUP to back up your system disk (VAX only). Standalone BACKUP is a form of the Backup utility (VAX only) that you boot into main memory (instead of executing under the control of the operating system). For more information about BACKUP and standalone BACKUP tasks refer to the OpenVMS System Manager's Manual. Format: BACKUP input-specifier output-specifier Additional information available: Parameters Qualifiers /ALIAS /ASSIST/BACKUP/BEFORE/BLOCK_SIZE /BRIEF /BUFFER_COUNT /BY_OWNER /COMMENT /COMPARE /CONFIRM /CONVERT /CRC /CREATED /DELETE/DENSITY Example /EXACT_ORDER /EXCLUDE /EXPIRED /FAST /FULL /GROUP_SIZE /IGNORE/IMAGE /INCREMENTAL /INITIALIZE /INTERCHANGE /JOURNAL /LABEL /LIST /LOG /MEDIA_FORMAT /MODIFIED /NEW_VERSION /NOINCREMENTAL/OVERLAY /OWNER_UIC /PHYSICAL /PROTECTION /RECORD/RELEASE_TAPE /REPLACE /REWIND/SAVE_SET /SELECT /SINCE /TAPE_EXPIRATION /TRUNCATE /UNSHELVE /VERIFY/VOLUME Examples BACKUP Subtopic? /ignore BACKUP /IGNORE /IGNORE=option Command Qualifier Specifies that a BACKUP save or copy operation will override restrictions placed on files or will not perform tape label processing checks. The /IGNORE=option qualifier has the following options: ACCESSIBILITYProcesses files on a tape that is protected by a volume accessibility character, or on a tape created by HSC Backup. The option applies only to tapes. It affects the first tape mounted and all subsequent tapes in the save set. INTERLOCKProcesses files that otherwise could not be processed due to file access conflicts. Use this option to save or copy files currently open for writing. You must have the user privilege SYSPRV, a system UIC, or ownership of the volume to use this option. LABEL_ Saves or copies the contents of files to the PROCESSING specified magnetic tape volume regardless of the information contained in the volume header record. BACKUP does not verify the volume label or expiration date before writing information to the tape volume. Note that you cannot use this option with the /EXACT_ORDER qualifier. NOBACKUP Saves or copies both the file header record and the contents of files marked with the NOBACKUP flag by the /NOBACKUP qualifier of the DCL command SET FILE. If you do not specify this option, BACKUP saves only the file header record of files marked with the NOBACKUP flag. -Original Message- Sent: Wednesday, February 12, 2003 10:24 AM To: Multiple recipients of list ORACLE-L Just got out of a meeting with the systems group. The Incremental backup was not working because the command was written wrong. There has been a decision to do cold backups each night. The system people swear that the OpenVms can successfully backup an open file (datafile) and have it recovered properly. They can backup it up with an Ignore flag that backups up open files? I will go with a cold backup methodology. Ron >>> [EMAIL PROTECTED] 02/12/03 10:18AM >>> List, OS OpenVms 7.3-1 Oracle 8.1.7 rel 3 Archivelog mode. We are trying to work through backup issues here and I have a question. The system nightly backup procedures backup up the disks used by Oracle (software and data). A full backup works but an incremental does no
RE: Rman and database shutdowns UPDATE
Ron - Yes they can back it up and recover it from their perspective. You've brightened my day. Let us know if you want some more explanations to discuss this with them again. ;-) Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 12, 2003 10:24 AM To: Multiple recipients of list ORACLE-L Just got out of a meeting with the systems group. The Incremental backup was not working because the command was written wrong. There has been a decision to do cold backups each night. The system people swear that the OpenVms can successfully backup an open file (datafile) and have it recovered properly. They can backup it up with an Ignore flag that backups up open files? I will go with a cold backup methodology. Ron >>> [EMAIL PROTECTED] 02/12/03 10:18AM >>> List, OS OpenVms 7.3-1 Oracle 8.1.7 rel 3 Archivelog mode. We are trying to work through backup issues here and I have a question. The system nightly backup procedures backup up the disks used by Oracle (software and data). A full backup works but an incremental does not backup any files. Inorder to get the changed files to be backed up as an incremental the sysadmin shutdown the database to flag the files as changed. Questions: How will the shutdown effect the RMAN backup if it does not know that it was shutdown for a cold backup? Are there any possible problems doing a restore from the cold backup and then using the RMAN backup/restore? I am still trying to figure out the OpenVms OS. Perserverience required...! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, 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: Rman and database shutdowns UPDATE
Ron, While Vms *can* backup the open datafile, it is worthless when you need to recover it. I know, I've been there. Worked on Open Vms for about 8 years, including Oracle for 3 years. The file would need recovery immediately upon an attempt to open it. And I would not bet my job that I could recover it properly. If you wish, you could put the tablespace in "Hot Backup" mode and let Vms back it up - that would work fine. Just be aware of the issues. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, February 12, 2003 11:24 AM To: Multiple recipients of list ORACLE-L Just got out of a meeting with the systems group. The Incremental backup was not working because the command was written wrong. There has been a decision to do cold backups each night. The system people swear that the OpenVms can successfully backup an open file (datafile) and have it recovered properly. They can backup it up with an Ignore flag that backups up open files? I will go with a cold backup methodology. Ron >>> [EMAIL PROTECTED] 02/12/03 10:18AM >>> List, OS OpenVms 7.3-1 Oracle 8.1.7 rel 3 Archivelog mode. We are trying to work through backup issues here and I have a question. The system nightly backup procedures backup up the disks used by Oracle (software and data). A full backup works but an incremental does not backup any files. Inorder to get the changed files to be backed up as an incremental the sysadmin shutdown the database to flag the files as changed. Questions: How will the shutdown effect the RMAN backup if it does not know that it was shutdown for a cold backup? Are there any possible problems doing a restore from the cold backup and then using the RMAN backup/restore? I am still trying to figure out the OpenVms OS. Perserverience required...! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, 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: Rman and database shutdowns UPDATE
Just got out of a meeting with the systems group. The Incremental backup was not working because the command was written wrong. There has been a decision to do cold backups each night. The system people swear that the OpenVms can successfully backup an open file (datafile) and have it recovered properly. They can backup it up with an Ignore flag that backups up open files? I will go with a cold backup methodology. Ron >>> [EMAIL PROTECTED] 02/12/03 10:18AM >>> List, OS OpenVms 7.3-1 Oracle 8.1.7 rel 3 Archivelog mode. We are trying to work through backup issues here and I have a question. The system nightly backup procedures backup up the disks used by Oracle (software and data). A full backup works but an incremental does not backup any files. Inorder to get the changed files to be backed up as an incremental the sysadmin shutdown the database to flag the files as changed. Questions: How will the shutdown effect the RMAN backup if it does not know that it was shutdown for a cold backup? Are there any possible problems doing a restore from the cold backup and then using the RMAN backup/restore? I am still trying to figure out the OpenVms OS. Perserverience required...! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, 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).