9iRAC on AIX
Hi, We're attempting to configure a system using 9iRAC on AIX. Our local IBM folks don't seem to know whether or not they have H/W that will do this. Has anyone on this list implemented an AIX solution and would you be willing to share the H/W specs with me? TIA, Ron Morton DB Architect / Admin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Morton, Ronald D 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: Ticket tracking system
Solution 4 is not dumb. We use it frequently - it allows retrieval of tickets "marked as closed" as well as providing a bit of history for the ticket. If you use this technique, David, you must keep in mind that sooner or later you must actually "delete" the old closed tickets. We generally set up a purge schedule that removes any closed items after they reach a certain age limit. We also have an archive schedule that places a copy of any changed item on CD-ROM on a daily interval. This allows us to retrieve any ticket, if necessary - though it requires operator intervention to reload the ticket. - Ron > -Original Message- > From: Post, Ethan [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, April 02, 2002 4:08 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Ticket tracking system > > Manager to David... > > "David, this is your manager speaking. Larry says he opened 10 tickets > last > month to get the Brady report fixed. Is that true?" > > ok enough of that let's ponder some possible solutions... > > 1. Have everyone print out a copy of their ticket and then submit it back > to > you to re-enter if they want to re-open it. > 2. Use log miner to log your archive logs. Find the SQL to recreate the > ticket then run it again against the database. > 3. This one is really just a better idea for #1...have everyone do a print > screen of each ticket then create a database that allows people to upload > the picture of the ticket. Save those and you can refer to them if you > need > to re-create a ticket. > 4. This last solution is really dumb but also might work...instead of > deleting the record perhaps you could just add a status column to the > table > and then mark it as closed. Then you could re-open it using an update > statement. > > - Ethan > > -Original Message- > Sent: Tuesday, April 02, 2002 1:38 PM > To: Multiple recipients of list ORACLE-L > > > I develope a ticket database for people to open, close, re-open ticket to > update using oracle database. My question is how do I use SQL command to > let people re-open a close ticket for updates? When someone close a > ticket, > delete command is executed and data is gone. Please advise. > > Thanks, > David > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Nguyen, David M > 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: Post, Ethan > 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: Morton, Ronald D 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).
Application task refuses to reconnect
Fellow listers, I have an application task that is designed to connect to the database and remain connected until the task is shut down. This task also has logic to detect when it loses the database connection and then attempt to reconnect. All of my testing in our lab has worked perfectly. With the task running, I can shut down the database, forcing the task to generate the following two error messages. Upon restarting the database the task reconnects just as it did when first started. ORA-01092: ORACLE instance terminated. Disconnection forced. ORA-01034: ORACLE not available. This development occurred about four years ago and the task has been in service at the customer site all this time. Just recently, the customer informed me that this task has never reconnected to their database whenever there has been an outage. They claimed that they always had to shutdown and restart the task to get it to connect again. So, I took a look at their operation and sure enough - no reconnection. Here are the error messages from their database. ORA-01092: ORACLE instance terminated. Disconnection forced. ORA-12154: TNS: could not resolve service name. The two databases are the same version (7.3.2.2.0 - I know, I know, UPGRADE! - not an option for at least a year). This task communicates with the DB through OCI calls. The task does not run on the same machine as the DB. The OS in question here is Solaris 2.5 (SunOS 5.5). I've checked the permissions on the TNSNAMES.ORA file and even placed copies of this file in the other expected locations with no luck. I have tried numerous changes to the SQLNET.ORA file as suggested by a MetaLink document on 12154 errors - all to no avail. I was able to force my lab task to fail by removing the TNSNAMES.ORA file altogether. Once the task received the 12154 error, it then refused to reconnect, even when the TNSNAMES file had been replaced. I've run out of ideas on what to look at here. Anybody out there ever seen anything similar? Any ideas? Thanks in advance for any ideas you may have. -Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Morton, Ronald D 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: Oracle Presentation for Beginners!
Yes, I got that one too. I suspect that the current courses are locked to all but current students? Ron > -Original Message- > From: Steven Joshua [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, May 09, 2002 3:00 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle Presentation for Beginners! > > Any one got this message? > > Forbidden > You don't have permission to access > /~melody/courses/Spring2002Backup/BackupPPTS/les on > this server. > > > > --- "Sherman, Edward" <[EMAIL PROTECTED]> wrote: > > > > > > > > Here's the slides! > > > > > > SQL/PL-SQL > > > http://www.ecst.csuchico.edu/~melody/courses/Spg2001OraclePLSQL/PLSQL8iPPT > S/ > > Default.htm > > > > Architecture and Admin > > > http://www.ecst.csuchico.edu/~melody/courses/Fall2001CSCI379/TOC.html > > > > Performance Tuning > > > http://www.ecst.csuchico.edu/~melody/courses/Spring2002PerfTune/TOC.html > > > > Backup and Recovery > > > http://www.ecst.csuchico.edu/~melody/courses/Spring2002Backup/BackupPPTS/l > es > > 01_files/v3_document.htm > > > > > http://www.ecst.csuchico.edu/~melody/courses/Spring2002Backup/BackupPPTS/l > es > > 02_files/v3_document.htm > > > > > http://www.ecst.csuchico.edu/~melody/courses/Spring2002Backup/BackupPPTS/l > es > > 03_files/v3_document.htm > > > > And here's a gal after my own heart! > > http://www.ecst.csuchico.edu/~melody/ > > > > Thanks Melody!!! > > > > Ed > > > > > > > > > > > > > > > > > > > -Original Message- > > Sent: Monday, May 06, 2002 5:09 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Hello all, > > > > because I am an human being I am also looking for > > the easiest solution :-) > > > > So, I need to have a training session concerning > > basic oracle features. > > > > I wonder if anyone of you know place/site where I > > could download some > > powerpoint slides. Or if you have your own, pls. > > send me a copy ... > > > > Any help will be highly appreciated. > > > > Thanks > > > > km > > the lazy dba > > -- > > > > __ > > Ota itsellesi luotettava kotimainen email > > http://www.jippii.fi/ > > Tutustu samalla netin parhaaseen pelipaikkaan > > JIPPIIGAMESIIN. > > > > -- > > 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). > > > > > > * * * * * Freedom of Information Act Notice * * * * > > * > > The information in this email is subject to the > > record protection mandated > > by 5 United States Code 552 (b) (4) and relevant > > judicial opinions. > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Sherman, Edward > > 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!? > Yahoo! Shopping - Mother's Day is May 12th! >
RE: Electronic Laser Forms - Any recommendations?
My Oracle rep tells me that Oracle Reports is being phased out as a stand-alone product and will be bundled into 9iAS in the near future, thus increasing the cost to implement a simple reporting solution. We're looking for a simple reporting solution and are now a bit reluctant to go with the current Oracle Reports. Anybody know of any reporting tools that run on Linux? Ron Morton Database Architect / Administrator > -Original Message- > From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]] > Sent: Monday, March 18, 2002 6:43 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Electronic Laser Forms - Any recommendations? > > Oracle reports? > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > > -Original Message- > > Sent: Monday, March 18, 2002 4:18 PM > To: Multiple recipients of list ORACLE-L > Subject: Electronic Laser Forms - Any recommendations? > > > Can anybody recommend a printing package for Oracle? We have a number of > forms that need to be populated with Oracle data. Examples are Report > Cards, Progress Reports, Immunization Letters. The format of these > changes, so we need to have the ability to modify the ELF in-house. The > platform is UNIX (HP-UX), and the printers are HPs(9000). > > David A. Barbour > Oracle DBA, OCP > AISD > 512-414-1002 > > -- > 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: Boivin, Patrice J > 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: Morton, Ronald D 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: Electronic Laser Forms - Any recommendations?
Stephen, I think they are fishing for money too. However, they did tell me that they plan to phase out the IDS as a separate product. David, Sorry for taking over your thread here - I hope you still get the information you are looking for. Ron Morton > -Original Message- > From: Karniotis, Stephen [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, March 19, 2002 12:28 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Electronic Laser Forms - Any recommendations? > > Ron: > >I think they are fishing for money. Oracle9iAS does have Oracle > reports > bundled in as part of the Internet Development Suite. However, IDS is a > separate product. I can't believe Oracle will cut their own throats by > removing this tool. > > Thank You > > Stephen P. Karniotis > Technical Alliance Manager > Compuware Corporation > Direct: (248) 865-4350 > Mobile: (248) 408-2918 > Email:[EMAIL PROTECTED] > Web: www.compuware.com > > -Original Message- > Sent: Tuesday, March 19, 2002 8:43 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Electronic Laser Forms - Any recommendations? > > My Oracle rep tells me that Oracle Reports is being phased out as a > stand-alone product and will be bundled into 9iAS in the near future, thus > increasing the cost to implement a simple reporting solution. > > We're looking for a simple reporting solution and are now a bit reluctant > to > go with the current Oracle Reports. > > Anybody know of any reporting tools that run on Linux? > > Ron Morton > Database Architect / Administrator > > > > -Original Message- > > From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]] > > Sent: Monday, March 18, 2002 6:43 PM > > To: Multiple recipients of list ORACLE-L > > Subject:RE: Electronic Laser Forms - Any recommendations? > > > > Oracle reports? > > > > Regards, > > Patrice Boivin > > Systems Analyst (Oracle Certified DBA) > > > > > > -Original Message- > > > > Sent: Monday, March 18, 2002 4:18 PM > > To: Multiple recipients of list ORACLE-L > > Subject:Electronic Laser Forms - Any recommendations? > > > > > > Can anybody recommend a printing package for Oracle? We have a number > of > > forms that need to be populated with Oracle data. Examples are Report > > Cards, Progress Reports, Immunization Letters. The format of these > > changes, so we need to have the ability to modify the ELF in-house. The > > platform is UNIX (HP-UX), and the printers are HPs(9000). > > > > David A. Barbour > > Oracle DBA, OCP > > AISD > > 512-414-1002 > > > > -- > > 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: Boivin, Patrice J > > 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: Morton, Ronald D > 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 > t
RE: file output of a SP
Look up UTL_FILE in your documentation set - it should handle this nicely. Ron Morton > -Original Message- > From: Bunyamin K. Karadeniz [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, May 15, 2001 7:35 AM > To: Multiple recipients of list ORACLE-L > Subject: file output of a SP > > Hi Gurus, > I have a problem, > I am trying to output a txt file of my query results. But all these will > be in a stored procedure, And in the procedure , how will I open a file > and write to it and then close it ? > Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Morton, Ronald D 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: Duplicate keys message two
-Original Message- Sent: Tuesday, May 15, 2001 5:16 PM To: Multiple recipients of list ORACLE-L "borrowed" from Ari Kaplan of this list: delete from &table_name a where rowid > (select min(rowid) from &&table_name b where a.&column_name=b.&&column_name) / Original message rejected due to Binaries this seems to be the message used to warn us that we are not allowed to have attachments in our messages * ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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: Morton, Ronald D 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: set term off
I don't have my manual nearby but how about: set feedback off? -Original Message- Sent: Tuesday, May 15, 2001 6:40 PM To: Multiple recipients of list ORACLE-L Anyone had any problems with setting term off? I'm running 8.1.7 and I go to do this sqlplus -s /nolog set term off conn username/passwd Connected. Any idea how I can get rid of the "Connected." message? I will be putting this in a script so I can tail it to get rid of the string "Connected." but this is basic stuff. Thanks, Dave Turner -- And you thought James Bond's watch was cool... http://www.tellme.com Call 1-800-555-TELL for stocks, sports, news...& much more! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner 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: Morton, Ronald D 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: From SID to connected machine
Title: From SID to connected machine Linda, Have you checked the v$session view? I believe that it shows the OS user and machine associated with the session id. Hope this helps. Ron -Original Message-From: Hagedorn, Linda [mailto:[EMAIL PROTECTED]]Sent: Tuesday, May 15, 2001 9:56 PMTo: Multiple recipients of list ORACLE-LSubject: From SID to connected machine Hello, I'm looking to trace a sid from oracle to a pid on unix to a connection/socket/port to another machine. Server is Sun Solaris 2.8. I'm trying to deimplement a userid and there is a connect string to it buried somewhere on one or more of eight different application machines. The engineers have looked for the connection, but are unable to find it. I need to tell them which machine it's coming from. If anyone has the steps to do this, I'd appreciate a note back. I've tried to match the pid to the lots of logs, but cannot find a match. Thank you very much. Any information or referral to documentation is appreciated. Linda The userid connection on topsessions: PALMAPP SID 149 PALMAPP SID 58 PALMAPP SID 129 PALMAPP SID 204 PALMAPP SID 158 The netstat output. I believe the connection is coming from either va8 or va11. kong.epocrates.com.1521 va8.epocrates.com.4501 32120 0 10136 0 ESTABLISHED kong.epocrates.com.1521 va8.epocrates.com.4502 32120 0 10136 0 ESTABLISHED kong.epocrates.com.1521 va8.epocrates.com.4503 32120 0 10136 0 ESTABLISHED kong.epocrates.com.1521 va8.epocrates.com.4504 32120 0 10136 0 ESTABLISHED kong.epocrates.com.1521 va8.epocrates.com.4505 32120 0 10136 0 ESTABLISHED kong.epocrates.com.1521 va11.epocrates.com.4117 32120 0 10136 0 ESTABLISHED kong.epocrates.com.1521 va11.epocrates.com.4118 32120 0 10136 0 ESTABLISHED kong.epocrates.com.1521 va11.epocrates.com.4119 32120 0 10136 0 ESTABLISHED kong.epocrates.com.1521 va11.epocrates.com.4121 32120 0 10136 0 ESTABLISHED kong.epocrates.com.1521 va11.epocrates.com.4122 32120 0 10136 0 ESTABLISHED
RE: Upgrade question
Lee, I don't know of any white papers but we had to upgrade Tru64 to v5.1 in order to install Oracle 8.1.6. I don't recall any other drawbacks to making this conversion. Ron -Original Message-From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 16, 2001 7:16 AMTo: Multiple recipients of list ORACLE-LSubject: Upgrade question All, Are there any white papers out there (or personal experiences) that you know of specifiying gains/losses in upgrading from Oracle8 to 8i. We are on Compaq Tru64 4.0f and Oracle Version 8.0.5.0.0 TIA Lee The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computersystem.
RE: data migration
If the remaining 90% of data is not going to change while you test-run the first 10%, then how about something like this: run this against the original data just before moving the 10%: SELECT 'CREATE SEQUENCE '||sequence_name||' START WITH '||last_number + 1||';' FROM user_sequences; This gives you a set of numbers that are above your most recent data and will not interfere with your PK constraint. After moving the 10% to the new DB, drop all sequences in the new DB and run the generated script from above. Just my .02 worth. Ron -Original Message- Sent: Thursday, May 17, 2001 5:46 PM To: Multiple recipients of list ORACLE-L Hi, We are planning to do two-phase data migration - split by data. In first phase, about 10% of the data will be moved as is - without changing the primary keys (generated from sequences). Once we start using the database with phase 1 data, sequences will generate new primary keys and add to this data - which could be same as primary key for the remaining data, which is not yet migrated. In phase 2, to avoid unique constraint problems, we'll add 1,000,000 to primary keys before we migrate remaining data. This will lead to imbalance of primary keys. After complete migration, we'll have about 10% of the keys with low values and remaining with very high values. What is the impact of this huge gap in primary keys? How will be the performance affected? Is there a way in which we can avoid this huge gap in primary keys (We do not have an option of going for single migration. Business needs force us to test the application with partial data. ) One option I thought of is to use high value keys in first migration itself - but when sequences reach these high values, we'll have same problems of unique constraint being violated. Thanks. - Praful __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Praful Thakkar 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: Morton, Ronald D 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: sum of file size ????
Andrea, You could try: wc * Ron -Original Message- Sent: Tuesday, May 22, 2001 2:39 PM To: Multiple recipients of list ORACLE-L Hi, OK, as you know, I don't know too much about Unix: When you do a ls -l and see the individual file size, is there a command to show the sum of all the file size? Thank you! Andrea __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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: Morton, Ronald D 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 find out internal's password???
Janet, The default password for SYS is CHANGE_ON_INSTALL. Maybe you will be lucky and find that nobody changed it. If you are running 8.1.x, then try logging in through sqlplus as follows: sqlplus internal If you get in, then change the SYS password to something you want: ALTER USER SYS IDENTIFIED BY new_password; Hope this helps. Ron > -Original Message- > From: Janet Linsy [SMTP:[EMAIL PROTECTED]] > Sent: Friday, May 25, 2001 2:07 PM > To: Multiple recipients of list ORACLE-L > Subject: how to find out internal's password??? > > This is in additional to my previous question about > how to turn off passowrd for internal: > > To try to turn off pwd for internal, I commented out > remote_login_passwordfile = exclusive in the init > file, now I need to shutdown and restart the database. > I tried to login as internal to shutdown the db, when > it askes for password, I tried a bunch things > including sys, manager, and they all failed. So I > used sqlplus system/pwd to login and do shutdown, the > database is down, but now I cannot login to svrmgrl to > startup the database, since I don't know internal's > password. So my question is how to find out > internal's password? Thanks a lot. > > Janet > > > __ > Do You Yahoo!? > Yahoo! Auctions - buy the things you want at great prices > http://auctions.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Janet Linsy > 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: Morton, Ronald D 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: A Basic PL/SQL Question
Bill, The version 8 PL/SQL manual states: Messages sent using the DBMS_OUTPUT are not actually sent until the sending subprogram or trigger completes. There is no mechanism to flush output during the execution of a procedure. You may want to try using the file i/o facility provided by the UTL_FILE package - not as convenient, but should handle all of your table. Maybe use DBMS_OUTPUT to indicate when file has been written? Ron Morton Union Switch & Signal Inc [EMAIL PROTECTED] > -Original Message- > From: Carle, William T (Bill), NLCIO [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, March 27, 2001 4:09 PM > To: Multiple recipients of list ORACLE-L > Subject: A Basic PL/SQL Question > > Hi, > > This is my first attempt at writing a PL/SQL procedure. Everything > works > fine, except I have a firly large table I am running against. I am trying > to > display my output with DBMS_OUTPUT.PUT_LINE. I have set the buffer size to > 100, apparently the maximum value, but it still isn't enough to print > output for my entire table. Is there another way to display data? Or is > there some way to increase the maximum? > > > Bill Carle > AT&T > Database Administrator > 816-995-3922 > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Carle, William T (Bill), NLCIO > 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: Morton, Ronald D 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: Import comma-delimited text file into Oracle
Helmut, I believe that SQL*Loader is the quickest way to load your data. You could write a procedure that uses UTL_FILE also. And there is another choice, but truly brute force - you could edit your file into INSERT statements and load it through SQL*PLUS. :-( Ron Morton Union Switch & Signal Inc [EMAIL PROTECTED] -Original Message- Sent: Tuesday, March 27, 2001 10:36 PM To: Multiple recipients of list ORACLE-L Hi! Is SQL*Loader the only way to move the contents of a comma-delimited ASCII file into Oracle? UTL_FILE would be another option, right? Or are there any other ways to do this? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger 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: Morton, Ronald D 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: Oracles TBT's
Eman, I have the DBA set of TBT's. So far I have managed to almost complete the SQL, PL/SQL portion. I have found the information provided to be fairly thorough thus far. My only complaint is with the progress tests that accompany each set of lessons. The answers that you provide must exactly match what the program expects to see or it counts it as an error. If you enter column names in the wrong order for a SELECT statement, it's an error - even though your answer will work in the real world. I find that you have to read the instructions VERY CAREFULLY. There are several other anomalies that I have encountered but cannot remember at the moment. There is at least one question that CANNOT be answered correctly, no matter what you do and there are a couple of places where the first question in the test does not allow you to enter an answer - won't allow you to type but if you click on the window, it becomes an error. So far, I consider these to be a minor inconvenience, though a bit frustrating at times. I've learned quite a bit from the lessons so will continue to press on. Oh, one other thing. The OCP test certificates that come with the set are only good for one year - not sure if there is a way to get the deadline extended or not. My schedule is not going to allow me to complete everything on one year's time, so I guess I'll be looking into that in the future. Hope this helps. Ron Morton Database Architect / Administrator Union Switch & Signal Inc [EMAIL PROTECTED] > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, March 29, 2001 9:45 PM > To: Multiple recipients of list ORACLE-L > Subject: Oracles TBT's > > Has anyone used oracle's TBT's (Technical Based Training)? I am > considering > purchasing some but was wondering just how good the are. > These TBT's are supposedly like CBT's (Computer Based Training). > Any feed back would be greatly appreciated, before I spend $3000.00 on a > set. > > I'm interested in the DBA set. > > Thanks, > > Eman > > - > This message was sent using Burgoyne Internet Services WebMail. > http://webmail.burgoyne.com/ > > > -- > 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: Morton, Ronald D 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: Sql question
Surjit, You could set up your PL/SQL procedure to order your query on a unique column such as PK, then return just 20 rows of data plus the last PK value to the application. The application could then supply this PK value in its next request such that your procedure now returns 20 more rows > PK. Ron Morton Database Architect / Administrator Union Switch & Signal Inc [EMAIL PROTECTED] > -Original Message- > From: Surjit Sharma [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, April 03, 2001 8:46 AM > To: Multiple recipients of list ORACLE-L > Subject: Sql question > > All > > I am sure this question has come up here before. I need to get the limited > number > of rows from a table at a time (say 20 rows ) using sql . I know this can > be > achieved using PL/SQL. > This is typically required in web based applications where you can only > show a few > records at a time. > > Your comments are highly appreciated. > > Regards. > > Surjit > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Surjit Sharma > 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: Morton, Ronald D 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: OCI
Lee, Our implementation of OCI makes use of the .h files in $ORACLE_HOME/rdbms/public and also the shared library libclntsh.so in $ORACLE_HOME/lib. These have to exist as part of the client installation. If I'm not mistaken, I had to select the programmer option from the list of installable pieces during the 8.0.5 client install. Hope this helps. Ron Morton Database Architect / Administrator Union Switch & Signal Inc [EMAIL PROTECTED] > -Original Message- > From: lerobe - Lee Robertson [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, April 03, 2001 10:45 AM > To: Multiple recipients of list ORACLE-L > Subject: OCI > > All, > > Using Oracle 8.0.5.0.0 Compaq Tru64 v4.f > > One of the duhvelopers here wants to use OCI. I am sure it is installed as > part of the server installation but where do all the relevant files live > for him to use. I can only find oci files in $ORACLE_HOME/rdbms/demo. Is > this normal. ?? > > Regards > > Lee Robertson > Acxiom > Tel:0191 525 7344 > Fax:0191 525 7007 > Email: [EMAIL PROTECTED] > > > > > The information contained in this communication is > confidential, is intended only for the use of the recipient > named above, and may be legally privileged. If the reader > of this message is not the intended recipient, you are > hereby notified that any dissemination, distribution or > copying of this communication is strictly prohibited. > If you have received this communication in error, please > re-send this communication to the sender and delete the > original message or any copy of it from your computer > system. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Morton, Ronald D 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).
PLS-00225
Hi, I just ran into a problem with v8.1.6 on Linux whereby my stored procedure won't compile because it claims that a table reference is out of scope. It complains about the definition of the arguments to the stored procedure which are as follows: CREATE OR REPLACE PROCEDURE rollup_insert ( vv_rollup_idOUT rollup.rollup_id%TYPE, vv_warrant_id IN rollup.warrant_id%TYPE, vv_rollup_limit_id IN limit.limit_id%TYPE, vv_rollup_time IN VARCHAR2, vv_rollup_emp_badge IN rollup.rollup_emp_badge%TYPE, vv_exec_id OUT INT, vv_rc OUT INT ) AS ... The specific error message complains that "rollup" is out of scope. If I substitute base level types for these, the procedure will compile. I have included the "rollup" table definition and ownership below for reference. It is the TWS user trying to execute this procedure. desc rollup - ROLLUP_ID NOT NULLNUMBER WARRANT_ID NOT NULLNUMBER ROLLUP_TIME NOT NULLDATE ROLLUP_TIME_TZ NOT NULLVARCHAR2(3) ROLLUP_EMP_BADGENOT NULLVARCHAR2(4) ROLLUP_LIMIT_ID NOT NULLNUMBER DATESTAMP DATE select owner, object_name, object_type from dba_objects where object_name like '%ROLLUP%'; OWNER OBJECT_NAME OBJECT_TYPE TWS ROLLUP TABLE TWS ROLLUP_INSERT PROCEDURE As you can see, the table and the procedure are owned by the same user. The table exists and the columns referenced in the arguments to the procedure also exist. What am I missing here? Is there a new keyword called ROLLUP somewhere? Any help would be very much appreciated. TIA Ron Morton Database Architect / Administrator Union Switch & Signal Inc [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Morton, Ronald D 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: PLS-00225
Thanks to all who replied. I knew it had to be something simple - should have checked my docs on CD first. Thanks again. Ron Morton > -Original Message- > From: Haskins, Ed [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, April 24, 2001 5:29 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: PLS-00225 > > Ron, > > Yes, there is a KEYWORD called ROLLUP which is used in Dimensions > typically > found in a DW environment. I'm surprised that Oracle has not added this > to > there list of "Oracle Reserved Words". Hopefully the following will help: > > Ed Haskins > Oracle DBA > Verizon Wireless > > > ROLLUP > ROLLUP enables a SELECT statement to calculate multiple levels of > subtotals > across a specified group of dimensions. It also calculates a grand total. > ROLLUP is a simple extension to the GROUP BY clause, so its syntax is > extremely easy to use. The ROLLUP extension is highly efficient, adding > minimal overhead to a query. > > Syntax > ROLLUP appears in the GROUP BY clause in a SELECT statement. Its form is: > > SELECT ... GROUP BY ROLLUP(grouping_column_reference_list) > > Details > ROLLUP's action is straightforward: it creates subtotals which roll up > from > the most detailed level to a grand total, following a grouping list > specified in the ROLLUP clause. ROLLUP takes as its argument an ordered > list > of grouping columns. First, it calculates the standard aggregate values > specified in the GROUP BY clause. Then, it creates progressively > higher-level subtotals, moving from right to left through the list of > grouping columns. Finally, it creates a grand total. > > ROLLUP creates subtotals at n+1 levels, where n is the number of grouping > columns. For instance, if a query specifies ROLLUP on grouping columns of > Time, Region, and Department (n=3), the result set will include rows at > four > aggregation levels. > > > > > -Original Message- > Sent: Tuesday, April 24, 2001 4:47 PM > To: Multiple recipients of list ORACLE-L > > > Hi, > > I just ran into a problem with v8.1.6 on Linux whereby my stored procedure > won't compile because it claims that a table reference is out of scope. > It > complains about the definition of the arguments to the stored procedure > which are as follows: > > CREATE OR REPLACE PROCEDURE rollup_insert > ( > vv_rollup_id OUT rollup.rollup_id%TYPE, > vv_warrant_id IN rollup.warrant_id%TYPE, > vv_rollup_limit_idIN limit.limit_id%TYPE, > vv_rollup_timeIN VARCHAR2, > vv_rollup_emp_badge IN rollup.rollup_emp_badge%TYPE, > vv_exec_idOUT INT, > vv_rc OUT INT > ) > AS > ... > > The specific error message complains that "rollup" is out of scope. If I > substitute base level types for these, the procedure will compile. I have > included the "rollup" table definition and ownership below for reference. > It is the TWS user trying to execute this procedure. > > desc rollup > -- > -- > - > ROLLUP_ID NOT NULLNUMBER > WARRANT_IDNOT NULLNUMBER > ROLLUP_TIME NOT NULLDATE > ROLLUP_TIME_TZNOT NULLVARCHAR2(3) > ROLLUP_EMP_BADGE NOT NULLVARCHAR2(4) > ROLLUP_LIMIT_ID NOT NULLNUMBER > DATESTAMP DATE > > select owner, object_name, object_type from dba_objects where object_name > like '%ROLLUP%'; > > OWNER OBJECT_NAME OBJECT_TYPE > -- > -- > > TWS ROLLUP TABLE > TWS ROLLUP_INSERT PROCEDURE > > As you can see, the table and the procedure are owned by the same user. > The > table exists and the columns referenced in the arguments to the procedure > also exist. > > What am I missing here? Is there a new keyword called ROLLUP somewhere? > > Any help would be very much appreciated. > > TIA > > Ron Morton > Database Architect / Administrator > Union Switch & Signal Inc > [EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Morton, Ronald D > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San
RE: OCI drivers
The OCI stuff used to be part of the "programmer" option in the client installation. I don't recall which of the client installation choices include this, though I know that the full installation does. Ron Morton Database Architect / Administrator Union Switch & Signal Inc [EMAIL PROTECTED] > -Original Message- > From: Ravindra Basavaraja [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, May 02, 2001 5:26 PM > To: Multiple recipients of list ORACLE-L > Subject: OCI drivers > > Where can I download the OCI drivers from ?I need the drivers > for Unix and NT. > > Should I install the Oracle client to install the oci drivers.? > > I was told that OCI drivers with JDBC connection pooling helps > to improve the performance. > > Can pls anyone comment or contirubute their experience on this > topic. > > thanks > > Ravindra > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ravindra Basavaraja > 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: Morton, Ronald D 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: date+time in milliseconds
You can store the whole thing as a string in one column or store as two columns: date + milliseconds. The Oracle DATE type does not support time granularity below one second. We have used both methods here - just depends on how you want to use the data later. Ron Morton Database Architect / Administrator Union Switch & Signal Inc [EMAIL PROTECTED] > -Original Message- > From: Sinardy Xing [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, May 08, 2001 2:50 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: date+time in milliseconds > > Hi Raj, > > I never heard such time > Date can handle > century + year + month + day + hour + minute + second > but not milliseconds > > > Sinardy > > > -Original Message- > Sent: Tuesday, 8 May 2001 1:14 PM > To: LazyDBA mailing list > > > can anyone help me with date + time in milliseconds. > i want to inpurt the data from a user in this format. > rgds > raj > > _ > Chat with your friends as soon as they come online. Get Rediff Bol at > http://bol.rediff.com > > > > > > > Think you know someone who can answer the above question? Forward it to > them! > To unsubscribe: send a blank email to [EMAIL PROTECTED] > To subscribe: send a blank email to [EMAIL PROTECTED] > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > Tell yer mates about http://www.farAwayJobs.com > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sinardy Xing > 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: Morton, Ronald D 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: RE[2]: Re-claiming the space from Table after deletion
s]. > > > > > > > > > > Kind Regards and thanks to all there, > > > > > > > > > > > > > > > Rafi Ahmad > > > > > > > > > > > > > > > > > > > > -- > > > > > 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: Alex Hillman > > > > 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). > > > > > > > >_ > > > Get Your Private, Free E-mail from MSN Hotmail at > >http://www.hotmail.com. > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Raghu Kota > > > 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: Alex Hillman > > 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: > > 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). > > _ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Raghu Kota > 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: Morton, Ronald D 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: oracle and America
GRAANN! > -Original Message- > From: Eric D. Pierce [SMTP:[EMAIL PROTECTED]] > Sent: Monday, March 12, 2001 2:39 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: oracle and America > > yes, but perhaps if they were within a polar circle, it would be > ok for them to have control of a few Icy B.M.s? > > On 12 Mar 2001, at 11:07, Gogala, Mladen scribbled with alacrity and > cogency: > > Date sent:Mon, 12 Mar 2001 11:07:02 -0800 > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > > > ... Having Microsoft controlling the ICBMs would definitely be too close > > to disaster for my > > taste. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Eric D. Pierce > 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: Morton, Ronald D 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).