INFORMIX 7.3 to ORACLE 8.1.7 (New info)
Since I said I'll tell you how it went here it is. We used Oracle Migration Workbench, and it really works but...(there is always at least one but). In our case, it was amount of tables (more than 800) and data which we had to put into Oracle. Time effect was also very important. After extensive testing, we discovered that our scripts are the fastest way. HTH, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= 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).
INFORMIX 7.3 to ORACLE 8.1.7
Thanks to all who helped. I'll inform you how it works, maybe someone will need it too. Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= 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).
INFORMIX 7.3 to ORACLE 8.1.7
Hi! We inherited one Informix database, which we must put into our production Oracle database (new schema). Both databases are on AIX UNIX machines. We can do this by writing a scripts, but I'm wondering does any of you have some experiance in this, and could you suggest me some other (simpler) way? Perhaps some Conversion tools? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= 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).
Reporting database with Time Finder
Hi! Oracle 8.1.7 on AIX, on EMC discs boxes which are synchronized with SRDF. At the target site, we have BCV volumes. We want to open reporting database on a daily basis. Now we can open target database with the same AIX volume group as the primary database. My question is do you have experience in renaming AIX volume group, so we can have two databases on the same machine (SRDF target and BCV)? We have some experience in doing that manually, but we're interested in having some scripts. Please help. TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= 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).
Oracle on AIX performance issue
Oracle 8.1.7 on AIX. Our database is rapidly expanding. Now it's approximately 80GB and for few months it's going to be at least double of that size. We are planning some reorganizations, so I'm wondering could you give me some advice. Is it better to have several big file systems or lot of smaller? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= 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).
Oracle8i on WinNT - renaming disc drives
List hi! Oracle 8.1.7 on WinNT. Our Windows guys want to rename disc drives for some administration reasons. I'm really in UNIX so I'm wondering could you give me some advices on this matter. As far as I know, I have to recreate control files, with new drives. Is there anything else I should do? Some Windows stuff? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= 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).
encryption of password (how to do it)?
Hi! Oracle 8.1.7 on AIX and Panther 'Application Server' on another AIX server (2 tier architecture). When starting application, first user connects to UNIX server with private login name. After that he is connected to 'Application Server' which connects to the database. For starting 'Application Server' user has database connect string and password (plain text) in .profile (as env variables). Do you have suggestions (experience) how to make a secure connection? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?= 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).
Pl/SQL question
List hi! Oracle 8.1.7 EE on AIX. One of our developers wrote a procedure. Inside that procedure he wants to know instance and schema, while executing that procedure. Do you have any suggestions? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?= 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).
Problem with RMAN
List hi! Oracle 8.1.7 EE on WinNT. During instalation of database, package DBMS_RCVCAT was not installed but I have packages DBMS_RCVMAN, DBMS_BACKUP_RESTORE. What should I do? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?windows-1250?Q?Sonja_=8Aehovi=E6?= 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).
Strange report from 'vmstat'
Hi all! Oracle 8.1.7 on AIX (8GB RAM (+ swap space 9GB)). It concerns AIX memory 'problem'. When I issue vmstat command, we got following result: /u01/app/oracle/product/8.1.7.vmstat 2 4 kthr memory page faultscpu - --- --- r b avm fre re pi po fr sr cy in sy cs us sy id wa 0 0 580556 554 0 0 0 14 34 0 126 137 63 11 5 82 1 0 2 580556 549 0 0 0 00 0 708 527 206 0 0 99 0 0 2 580557 548 0 0 0 00 0 829 99854 421 2 10 88 0 0 2 580557 548 0 0 0 00 0 637 111 35 0 0 99 0 Analysing this output, it seams that we have cca 2GB RAM (example: (580557 + 548)* 4096 = 2,2 GB), while we expected min 8GB. This gap between 8GB and output from vmstat report, increases in time. The question is if our calculation was right, is this the right way to analyse this at all? Maybe it is important to say, that our Oracle is installed on OFA using data files, max size 2GB, in same volume group(not on raw devices). Do you know of any AIX memory problems which can manifests as mentioned above? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?= 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).
MTS
Hi all! Oracle 8.1.7 EE on AIX. We have several hundred user which connect to the database in OLTP mode. I'm wondering is it good idea to configure MTS in such conditions? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?= 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: how to install Oracle Developer2000 on Windows98 ?
Well, I remember that I had such installation problems. To begin with, you must have CD for Win98 . It really annoyed me when I realized that you can't install Developer from CD for Win95/NT. HTH, Sonja -Original Message- Sent: Saturday, April 21, 2001 11:16 AM To: Multiple recipients of list ORACLE-L dear listers, any body knows how to install Oracle Developer2000 on Windows98 ? I installed it on my machine but I can't even connect to my database thanks in advance , regards, bambang Bambang Setiawan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bambang Setiawan 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?windows-1250?Q?Sonja_=8Aehovi=E6?= 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).
ORA-01458
Hi all! Oracle 8.1.7 on WinNT. When I try to copy one table from one schema to another I get this error message. ORA-01458: invalid length inside variable character string Description is "very informative" 01458, 0, "invalid length inside variable character string" // *Cause: // *Action: This is what I did: copy from [EMAIL PROTECTED] to [EMAIL PROTECTED] create abc using select * from abc; Do you have any suggestions? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?= 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).
authentication externally on WinNT
It's working now! Thanks to all that helped. In addition, I discovered that you must put one parameter in sqlnet.ora file: SQLNET.AUTENTICATION_SERVICES=(NTS) Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?= 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: EMC TimeFinder, and EMC TimeFinder vs Hot Standby
List hi! I have a "few" questions on thet subject: What we need: Primary site - 24x7 OLTP database access Backup site - a. Failover site b. Disaster Recovery site c. Reporting database - In case of loosing funcionality one of the site takes the production on itself - The Hardware and Software at the Bakup site should be used for production a. Aplication servers on all sites work in load balancing (end users should not be aware that they are working at the other site). b. Database server on backup site should be used for reporting - REPORTS are created through our applications (possibilly writing records in some temporary tables) - Stopping of production because of all types of changes (upgrade of RDBMS, changes in structure of the tables, ...) must be minimal, preferable none! Idea: Through the combination of Symmetrix EMC2 disks, SRDF (Symmetrix Remote Data Facilities) and Time Finder (EMC2 software) make up-to-date reporting Oracle instance on target (backup) site. What do we want to know? 1. Are we on the write way, (do you have any other idea)? 2. Does that concept have some misses? 3. What is your opinion and experience on that subject? 4. What is your experience with implementing and administering of such configuration? 5. Could you explain us basic concept of starting up of target database through SRDF and Time Finder. Sales people from EMC2 told us that some APIs are used for this purpose. Do we have to customize it, or write some programs or scripts? 6. Do you use some special monitoring tools? 7. Could you describe us your step-by-step scenario for starting up target system in case of primary sitefailure, and specially if your target site at the time of the failure is open for reporting. 8. What if: - primary site server fails (loosig data in cache)? - EMC storrage system fails ? - Network fails? - Corrupted blocks (Oracle side)? 9. Have you ever experienced failure and downtime? 10. After all, do you recommend us such configuration? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: =?windows-1250?Q?Sonja_=8Aehovi=E6?= 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: Locking
Try with this query: select xidusn, object_id, session_id, locked_mode from v$locked_object; If developer created table with bitmap index it can be reason for locking (we had such problem). HTH, Sonja -Original Message- Sent: Tuesday, March 20, 2001 11:27 PM To: Multiple recipients of list ORACLE-L Recently, one of my users nor I could update a table. As I dug around, I couldn't find any of the 'lock' tables such as dba_locks. Eventually, I managed to start data gatherer and get OEM's lock manager to kill the hung session. What do you guys do to find and terminate this deadlock or hung sessions? Are the 'lock' system tables built with specific options during db build? TIA. ...R [EMAIL PROTECTED] _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Lau 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?windows-1250?Q?Sonja_=8Aehovi=E6?= 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).
BUG in installing Designer6 Repository on 8.1.7 database
List hi! Here is description of the Bug we found. It is quite unpleasent. For a while everything looks just nice, then installation freeze. There are no errors of any kind; system just hangs (and it can lasts for hours)! It cost me 3 hours, before I realized something is very wrong (you think it's almost done)! Just to let you know. Sonja Title: ALERT: Some Repository versions will not install on Oracle 8.1.7.0.0 ALERT: Some Repository versions will not install on Oracle 8.1.7.0.0 Versions Affected ~ Oracle Designer/Repository 6i Release 1 and all Oracle Designer 6.0 versions prior to Designer 6.0.3.11 (patchset 7) Platforms Affected ~~ ALL Description ~~~ During the installation phase of Designer Repository when the script CIUEET.OPB is fired the 8.1.7.0.0 database server will show 100% CPU usage and hang indefinitely. The script CIUEET.OPB installs the component that is responsible for managing UE elements Type Extensions to the repository. This problem can also occur if you attempt a full repository import. Note: This is an Oracle 8.1.7 PLSQL Server bug and not a Designer bug. See Oracle 8.1.7 Server PLSQL bug Bug:1396675. Likelihood of Occurrence HIGH: This problem will occur everytime you attempt to install or import(full repository) a Designer Repository against 8.1.7.0.0 of the Oracle Server. The exception to this is Designer 6i release 2 which has a workaround to the bug applied to its code. This workaround will be introduced to a future Designer 6.0 patchset. Possible Symptoms ~ When the script CIUEET.OPB is fired by the Repository Adminstration Utility (RAU), the database server will show 100% CPU usage and the database will hang indefinitely. The database will also hang if a full repository import is attempted, as the package cioue_element_type(orginal created by the CIUUET.OPB script) will be executed. Workaround ~~ Use 8.1.6 of the Oracle Server. Patches ~~~ However, a workaround has been introduced in the Designer 6i Release 2 code to get past the plsql problem. This release has been certified. For Designer 6.0 the code change has been introduced in Designer 6.0.3.11.0 (patchset 7). References ~~ Bug:1396675 Bug:1528667 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?= 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).
problem with UTL_FILE.FILE OPEN
List hi! Oracle817 on AIX. (64 bit) We have defined in initora file UTL_FILE_DIR=* When we start function UTL_FILE.FOPEN it raises exception INVALID_PATH. Everything is set and available (permissions are 777). Do you have any idea what's wrong? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= 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).
Inteligent Agent on Oracle817 for OS/390 OSDI
List hi! My colleuge have problem with this configuration Does anyone have a cook book for configuring this product? If anyone have it, would you be so kind to send it directly to: [EMAIL PROTECTED] TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= 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).
OEM - Tunning Pack, Diagnostic Pack....
List Hi! Oracle gave as these tolls on evaluation and testing and IT managerment wants our opinion. As you know, these products are licenced acording to the number of users (which we have several hundreds). Since we didn' have enough time to test this properly, I was wondering can you give me some info on this? Is this really worth the cost? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= 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).
Script for INDEX creation
List hi! From one schema in production database I want to create same indexes on the other (same schema on different instance). I know that I can do it with imp in indexfile, but it is not good enough. Does anyone have script with which I could dinamicaly create indexes on all tables within schema? Something like this: select ('drop index'||' '||index_name||';' ) from user_indexes TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= 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).