RE: Data Purging Strategy
A poor man's solution might be to load the offline database with appropriate data, then do a tablespace export and store the results on CD labelled by date. Restoring needed data would entail a tablespace import of stuff from the appropriate CD into the offline DB. I'm sure here's some gotchas involved but some variation on that theme might work. Jim -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 06, 2002 8:49 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Data Purging Strategy This is a data-archival requirement, not a data-purge requirement. It only resembles a purge requirement based on the multiple-database-migration strategy you outlined. There are alternatives... Depending on the volume of data in your database and your availability requirements, implementing table- and index-partitioning will likely be crucial. One strategy is to have the most-active tables partitioned by a date column and have different sets of these partitions reside in time-variant tablespaces. With this arrangement, you can archive data to tape by simply setting the archived tablespaces to READ ONLY and then migrating them to tape-based (instead of disk-based) file-systems and bringing them back online. Legato has this file-system technology (recently purchased) and there is a share-ware product called SAMFS which is an HSM (hierarchical storage mgmt) filesystem used by some vendors (i.e. StorageTek, etc). By setting tablespaces to READ ONLY it becomes very easy to move them from disk to tape while retaining them within the same original database, simplifying the task of later retrieval (which is really important). Of course, Oracle's partitioning option is enormously expensive, but in this case it is a matter of the upfront license costs (with reduced downstream implementation costs due to simplicity) versus a large downstream application-development cost. In this situation, I think roughly offsets everything. Since I'm not spending the money, I can afford such a calculation... :-) With the various storage technologies available, a single database can straddle several simultaneously, optimizing performance or cost as needed. Some files might reside on solid-state NVRAM "disk", some on SAN-based disk, some on NAS-based storage, and then finally reside in archive media file-systems such as tape or magneto-optical based HSM file-systems. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, November 06, 2002 2:13 AM Subject: Data Purging Strategy Dear List, I need some inputs from you all regarding purging data from the database. This is the requirement We define a retention period for all the data in the system. When the retention period is reached, the data should be deleted, but then at a later time, some user might request for this purged data. So it must be possible to retrieve this data. This is the strategy we have designed for this. When the retention period is reached, move the data from the main database to an offline database. Then delete the data from the main database. In the offline database, we cannot again keep it from long, so it has to moved to tapes. Now my question, how can we move this data to tapes and at the same time retrieve data from the tapes based on dates. i.e, the user will ask for the data on a particular date, so it must be possible to retrieve data from the tapes based on a date and load it to the database tables. Regards Prem
RE: ORA-01031: insufficient privileges
Wow. That is a perfectly logical and amazingly simple explanation I would never have thought of. I am in awe. Jim Chris, The answer may be in what occurs below the water. Remember that RESOURCE is a bit special (here for Oracle 5 compatibility reasons), that it is one of the two (I think) 'roles' which cannot be granted to a role and that the reason I suspect it cannot be is that it grants 'unlimited tablespace' underhand. An hypothesis might be that RESOURCE was granted and then UNLIMITED TABLESPACE revoked by a DBA unwilling to see the user pollute any tablespace. It behaves like what you witnessed : SQL> create user demo identified by demo; User created. SQL> grant create session to demo; Grant succeeded. SQL> grant resource to demo with admin option; Grant succeeded. SQL> create user demo2 identified by demo2; User created. SQL> revoke unlimited tablespace from demo; Revoke succeeded. SQL> connect demo/demo Connected. SQL> grant resource to demo2; grant resource to demo2 * ERROR at line 1: ORA-01031: insufficient privileges -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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.com -- Author: Conboy, Jim 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: DBA work load - BDBAFH #1
The phone rings. Another user. Still pissed off, I pick it up... "Database Administration, can I help you?" I answer professionally. Troubled silence on the phone. Politeness is a very bad signal from me and they know it. He was rattled. "Uh, hi, this is Joe, technical lead on that super-critical project for Benefits? Is this a good time? I have some stuff I need moved to production?" The last was a statement, but it came out like a question. With a slight quaver in the voice, too. Excellent. Technical lead my arse. "Could you be more specific so I can schedule you appropriately?" He hesitated. Gosh, I sounded for real. I almost convinced myself. The victim approached warily. "I've got a bunch of PL/SQL packages and some outlines to speed up the queries with special hints. The scripts are all ready for your review, they include the create statements, the grants, everything. I'm forwarding the email package to you with signoffs from IT, the user department, and your own from reviewing our design and test results". This last was delivered with almost pathetic eagerness. Good boy. Good, simple, foolish boy. If he could see me he'd be terrified by my grin. "Joe, I need you to help me out. You've just given me 10 minutes of work, but I'm due for lunch in 5 minutes. What do you suggest I do?" Joe knew better, he really did. But his team had been up all night finishing and the prize was so close... "Look, I really hate to impose. But we've missed several major deadlines, and department head has made it clear if we screw up again he'll outsource the whole project and have us laid off. I need it now so we can make sure everything's perfect for the big production run at COB today". "Consider it done," I promised cheerfully and hung up. I surprised him, and maybe myself, with my good spirits. Especially since I was more than 5 minutes late, closer to fifteen, and my buddies were already into their second beer when I joined them for lunch. But the extra 10 minutes had been well worth it considering what I managed to do to those hints with the outline editor. Just the same, though, I turned off my cell phone in case the twit called to find out why his 5-second queries took almost an hour. Can't have him taking me for granted, can I? Later that evening, after quaffing several (all right, numerous) more ales with the boys, I dialed in from home to check how things were going. Mr. Tech Lead was still logged in, no doubt desperately trying to determine why things were taking forever. Poor Mr. Tech Lead, another sleepless night. I logged off, turned out the light, and slept like a baby. Next morning, hangover. The phone rings. I snatch it up angrily... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim 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: Followup: Apache core dumps after IP address change (solution)
Bruce- Glad you worked it out. Actually, this problem can be worse than you saw. Apparently 9iAS V2 contains some sort of hardware dependency (somewhere in the JDK encryption algorithms). The net result is that you can have a full, good backup of your Apache server but if that physical hardware dies it can't be successfully restored to a new, even identical, box. The startup command for Apache needs to login to OID but somehow the encrypted OID password fails if the hardware is different. I've even heard (completely unconfirmed) rumors that certain types of hardware changes on a server can trigger the problem. Not a reassuring scenario for disaster recovery, eh? Jim -Original Message- Sent: Tuesday, September 17, 2002 6:13 PM To: Multiple recipients of list ORACLE-L Thanks to everyone who suggested ideas for my "emergency" yesterday. The problem only became obvious after a complete reinstall of Oracle on my server. I took this approach after finding a thread on the ODTUG-JAVA-L mailing list that talked about how 9iAS Rel 2 has hardcoded values for the IP address. The thread indicated that there was no way of changing the IP address of a server short of a complete Oracle reinstall. After literally exhausting all other ideas of my own (and needing to get the server back up asap), I reinstalled Oracle 8.1.7 last night on a new partition. Once the default installation finished, everything worked fine. After restoring my schemas and other configurations, things still continued to work fine. Apache continued to start without core dumping and life was good. The moment I moved my old httpd.conf file back into place, Apache core dumped. Clearly, it was no longer an issue of hardcoded IP addresses, so I started taking the httpd.conf file apart into small pieces. The culprit was an upgrade RedHat Network passed along to PHP4 and glibc about a month ago. I allowed the PHP4 upgrade and glibc library upgrades to be installed. Apache continued to run using the old libphp4.so module without problem, but the moment I would have had to either reboot the server or restart Apache, it would have died because the libraries had changed. Adding PHP4, BTW, is a custom enhancement I made to the stock 8.1.7 Apache config as I need it on several parts of my server. I found the latest libphp4.so file, moved it into the /u01/.../libexec directory, restarted Apache and all was well with the world again. 17 hours of work later, I believe I have things as they should be once again. Lesson learned: if Apache core dumps (something I haven't seen it do in years) when restarting after a long period of uptime, then suspect a module/library problem. Side note: if anyone wants to know every nook and cranny where Oracle stores your IP address and domain names, I can tell you that now. :-) Thanks again! bruce -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bruce A. Bergman 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.com -- Author: Conboy, Jim 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: Oracle Arm Twisting?
"I've called Oracle for a TAR once in the past 18 months." Ah, my friend, but you're not using Portal 9.0.2, are you? I've opened more TARs in the last few months than the rest of my Oracle career. Bleeding edge, I guess, so maybe its our own fault. But third-party support for this would have stopped the project before it got started. I agree that its not accurate to generalize all tech support as nimrods. There are some very good ones out there, and even the rest at least have acccess to all the internal notes we can't get to (Gr...why the hell do they show in metalink searches if we can't see them?). And the developers, if you can ever get to them, know their stuff and are a pretty decent bunch. Jim -Original Message- Sent: Wednesday, August 14, 2002 5:18 PM To: Multiple recipients of list ORACLE-L Well, that's not really fair. There are a number of good people that work for Oracle Support. True, there are also some that are subpar, but how often is it necessary to open a TAR anymore? MetaLink has vastly improved over the past couple of years. I've called Oracle for a TAR once in the past 18 months. Some excellent in depth posts that you may have seen on this list were put there buy Oracle support personnel. No, I'm not saying who they are. Jared Rodd Holman <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/14/2002 09:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Oracle Arm Twisting? Yes, Oracle support sucks, and is staffed with morons. However one thing you get with Oracle support that you cannot get with third party support is bug fixes and product upgrades. If you want this without a support contract, you need to buy new licenses each time you upgrade. Rodd On Wed, 2002-08-14 at 11:13, Steven Lembark wrote: -- Naveen Nahata <[EMAIL PROTECTED]> > Now they say, that this can't be done and the product license will be > terminated if we want this. The thing is that Oracle support is useless(I > get more help from this forum :) ), but we still want it, just in case. Ever heard of "FUD"? That's what Oracle is selling you if you think their support is that bad: fear of not having support that you don't want because you think it's bad. Q: Does anyone know of any reliable 3rd party support for Oracle? -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim 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: OEM changes
Now please, please tell me you don't REALLY talk about this geeky stuff at parties! Jim -Original Message- Sent: Monday, July 22, 2002 9:53 PM To: Multiple recipients of list ORACLE-L Wish I could. This was at a party, and the person speaking was an Oracle employee. We were talking/ranting about how often Oracle changes things and he mentioned that OEM was changing AGAIN. That's all he said Rachel --- "Boivin, Patrice J" <[EMAIL PROTECTED]> wrote: > Rachel, > > Could you shed any light on the changes they are proposing? > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim 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: Where is Oracle 9.2 init.ora?
Dennis-
With 9i you have the option of using init.ora or the spfile. DBs created with the
assistant I think use spfile by default. To make the change you want, issue the ALTER
SYSTEM blah blah SCOPE BOTH to make the change both immediate and permanent. SCOPE
MEMORY changes it immediately but only until reboot, SCOPE SPFILE changes the
initialization file but won't take effect until reboot.
Jim
-Original Message-
Sent: Thursday, July 11, 2002 11:43 AM
To: Multiple recipients of list ORACLE-L
For Oracle 9.2 (Solaris), can anyone tell me where Oracle is expecting the
init.ora file?
I created the database using dbca. It created an init.ora in
admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed the
original init.ora file. Then I discovered that Oracle is not reading the new
init.ora. The database starts fine, with no errors. I tried moving the
init.ora file back to the original pfile location, but it is still not
reading it. Specifically, I am trying to set LOG_ARCHIVE_START = true, but I
have made other changes and they are not taking effect either.
I have searched the documentation, and while there is the new SPFILE, there
is no indication how this might affect my problem.
Any insights from someone that has turned archiving on with 9.2 would be
appreciated.
Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
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: Conboy, Jim
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: runInstaller
But how ridiculous is it that you need a "really hot machine" to get good performance just INSTALLING the darn thing? As an aside, the 9iAS v.2 installer does an outstanding job with the database install. Unfortunately it falls apart when you have to install all the patches, but its a definite step in the right direction. -Original Message- Sent: Tuesday, July 09, 2002 5:48 PM To: Multiple recipients of list ORACLE-L You might look at silent mode install, Note:73510.1 I have found that on really hot machines oui is a screamer. It could be your system needs a facelift. On Tue, Jul 09, 2002 at 12:47:19PM -0800, [EMAIL PROTECTED] wrote: > What I wouldn't give for "./orainst /c" right now. > > > > Where is the productivity and ease of use of the #$%^#@ OUI when it takes > hours and hours just to load up all the java crap! Piece of garbage is > enough to make me want to go back to 7.3.4 - and shoot the idiot who thought > up java... > > > > Thankyou. I feel better about hating 9iAS now. > > > Scott Shafer > San Antonio, TX > 210-581-6217 > > > -- > 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). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: Conboy, Jim 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 Financials Sys Admin. Needed in South Carolina
Michael- 'Taint no "tax free" states, sometimes they just hide it better how they get you (sales tax, property tax, personal property tax, gasoline tax, etc.) Except for maybe Alaska, as long as the oil keeps flowing. But I know what you mean. Anybody who moves based solely on these calculators needs their head examined. But they can in fact provide useful information. $75K in Spartanburg doesn't look to be below-market. Jim -Original Message- Sent: Monday, April 29, 2002 3:28 PM To: Multiple recipients of list ORACLE-L The only problem with this line of thinking is the federal government. They seem to take out the same amount for federal taxes as well as social security no matter where I live. If this is truly reflective of the cost of living there then I better automatically receive a check just for being a resident (which is actually the case in Alaska). Doubtful at best. Does anybody know if SC is a tax-free state like Texas and Tennessee? I can see using a salary calculator to convince your spouse that it is a good idea to move. Otherwise I don't they relect real life. Just my 2 cents. -Original Message- Sent: Monday, April 29, 2002 2:48 PM To: Multiple recipients of list ORACLE-L As evidence of this, HomeFair.com's salary calculator says a salary of $100,000 in Manhattan is equivalent to $32,000 in Spartanburg. Doubt this is accurate to the penny, but if even close it sounds like $75K has you living like a king (or queen) in Spartanburg. Jim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim 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 Financials Sys Admin. Needed in South Carolina
e. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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: Freeman, Robert 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim 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: Dbms_job not running
Are there any jobs running? There's a couple of init.ora parameters that must be set first. Jim -Original Message- Sent: Friday, April 19, 2002 2:04 PM To: Multiple recipients of list ORACLE-L If the parameters suggested are already set up right , I have one more thing to ask... 1. is this something do with the DB Link ??? 2. if so , the user running the job is having any private DBLINK ??? --Madhu PS: If the DB LINK is used to run this job , you need to have a private dblink created for the user running the job. -Original Message- Sent: Friday, April 19, 2002 11:14 AM To: Multiple recipients of list ORACLE-L Hi, We have a job own by user MTSSYS which we scheduled to run every 1 minute but it is not running itself. If we run the job manully from sqlplus it runs fine. What can be the reason that job is not running itself??? Interval is set to SYSDATE+1/1440 Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh 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: Reddy, Madhusudana 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: Conboy, Jim 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: initjvm and rmjvm failing
Note 159801.1 (Full JVM Removal on 8.1.7) on Metalink may help. Haven't tried it myself but I fear I'm about to. Jim -Original Message- Sent: Wednesday, April 17, 2002 12:08 AM To: Multiple recipients of list ORACLE-L Hi All I am trying to add Java support to one of the databases and it keeps failing. It seems that after the first run it didn't get it right and rmjvm doesn't seem to run properly after. there still appears to be a large bunch of objects in the database. Any ideas as to how to clean it up I can rebuild it if i need to, this is more of a learning task, I normally create them with Java in the first place. Any ideas 8.1.7 on Solaris 8 Thanks -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom "The People, The Experience, The Vision" = -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim 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: Calling SQL statement
There was just the ticket in an Oracle mag online piece by Ian Craig a while back. http://www.oracle.com/oramag/webcolumns/2001/index.html?op_unixway.html A trivial example from the article: print "select * from dual;" | sqlplus -s scott/tiger produces the following output: D - X Jim -Original Message- Sent: Thursday, March 14, 2002 8:33 AM To: Multiple recipients of list ORACLE-L !/bin/ksh sqlplus / <>> [EMAIL PROTECTED] 03/14/02 06:26AM >>> Hi all, How do I issue SQL staments to the Oracle server from shell scripts -preferably korn shell. Example scripts highly welcome. Thanx 'n Ciao +---+ CSW, MTN-Uganda, 8th Floor UDB Building Cell: 077-212655,http://mtn.co.ug +---+ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale 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: Gene Sais 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: Conboy, Jim 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 Hungry for Money
"For some reason there has been a great confusion..." I believe that's exactly the point. Oracle installed this extra-cost option by default, for no other defensible reason then to encourage its unwitting use. There's a reason there has been confusion. They're like a drug pusher, first one's easy but once you're hooked you PAY. And unless you know where to look its not so easy to find info on Metalink for what are the options for each DB version. I don't know what the original meaning was behind 'feeling tricked', but I guarantee you there are some on this list who've just realized they've been tricked into using an expensive add-on product they may not be able to back out of at this point. Jim -Original Message- Sent: Wednesday, March 13, 2002 3:29 PM To: Multiple recipients of list ORACLE-L While I agree Oracle is avaricious and sales reps are a smarmy lot, I don't see any entrapment here. If you believe you are licensed for an option and you are not, it is perfectly legitimate for Oracle to ask for you to pay for that license and any maintenance costs. $23,800 is cheap, must be a 20 named user license. They are not asking for payment for all the years it had been illegally installed? Consider yourself very lucky and Oracle anything but greedy. "Feeling tricked" implies that had you known that you were not licensed, you would not have divulged it to Oracle. If so, you are lower than a smoldering heap of parrot droppings. However, as it was indeed an innocent mistake and no such characterization is necessary. For some reason there has been a great confusion over whether the partitioning option costs extra. Even some of the most knowledgeable DBA's in the world were mistaken on this. The height of this misunderstanding was a two to three years ago. I expect there were hundreds perhaps thousands of sites who have installed partitioning without a license because they believed it to be free. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim 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: Rollback Segments
Holy cow Mladen, what a memory! Does anybody else remember (or admit to) using UFI? Jim ** ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim 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: SCOTT/TIGER
I was once told with certainty from an Oracle instructor that Scott was an early developer, and Tiger was his cat. But without actually meeting Scott I take this with a grain of salt. I expect there are many urban legends surrounding this. Jim -Original Message- Sent: Wednesday, January 23, 2002 11:45 AM To: Multiple recipients of list ORACLE-L Anyone out there know the history of this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: Conboy, Jim 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: HP vs SUN for a UNIX box
OTECTED] 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: Babich , Sergey 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard 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: Kimberly Smith 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: Conboy, Jim 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).
