Has Anybody Used Domain-Prefixing on WinNT4/8.0.5 SE
Has anybody here done OS authentication using domain-prefixing (e.g. Domain Name\username) in creating users on a WinNT4/Oracle 8.0.5 Standard Edition environment? I'm curious to know how you've done it without using ANO (which is not available in SE anyway) and wonder whether you can share some of your hard-earned tips. Thanks, George -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Hofilena 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).
OS authenticated from Outside Domain/Firewall
We have a jsmith account that is OS authenticated in our TEST database. This account also exists in server X which is outside our domain and protected by a firewall. We've set up our firewall to allow Oracle connections to our TEST database to get through. This setup works fine. One day jsmith logs into server X, tries to connect to the TEST database using ODBC and the database let him in without asking for a password! We also did this on a local machine and it came through as well. Obviously, the database wasn't validating the DOMAIN NAME when it evaluated the user and since the username had an OPS$ account it let it through. Is there some setting that I needed to configure to force Oracle to validate both the Domain and User names? Thanks, George -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Hofilena 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: OS authenticated from Outside Domain/Firewall: PLS. IGNORE
Please ignore this for now. I think I've found something. George -Original Message- Sent: Wednesday, February 27, 2002 10:15 AM To: LazyDBA.com Discussion We have a jsmith account that is OS authenticated in our TEST database. This account also exists in server X which is outside our domain and protected by a firewall. We've set up our firewall to allow Oracle connections to our TEST database to get through. This setup works fine. One day jsmith logs into server X, tries to connect to the TEST database using ODBC and the database let him in without asking for a password! We also did this on a local machine and it came through as well. Obviously, the database wasn't validating the DOMAIN NAME when it evaluated the user and since the username had an OPS$ account it let it through. Is there some setting that I needed to configure to force Oracle to validate both the Domain and User names? Thanks, George Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage 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 By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Hofilena 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]: Linux taking over at Oracle
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: George Hofilena 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: Linux taking over at Oracle
-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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: Mercadante, Thomas F 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: George Hofilena INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Problem importing objects to different tablespace
Guys, I'd appreciate any help that I could get. I was trying to import to another tablespace, same user. I hadn't had a need to do this in a while but thought this shouldn't be too difficult. So I did what the manuals said: ran a user export set user's quota on old tablespace to 0 granted unlimited quota to user on new tablespace revoke resource, unlimited tablespace privs from user make new tablespace default for user Then when I ran the import with ignore=y I got the error space quota exceeded for tablespace old tablespace for all create table commands. Bottom line is, it didn't import the tables. Reading the manuals and Metalink docs, the process looked really straightforward. Does anybody know of anything that I've missed? Thanks, George -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Hofilena 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: Problem importing objects to different tablespace
All the objects are dropped beforehand. The import is done on a clean slate. I just put in the ignore=y because that's what the docs suggested and I was half hoping it'll drive the space quota exceeded... error away :) George -Original Message- Sent: Tuesday, November 27, 2001 12:30 PM To: Multiple recipients of list ORACLE-L George Hofilena wrote: Guys, I'd appreciate any help that I could get. I was trying to import to another tablespace, same user. I hadn't had a need to do this in a while but thought this shouldn't be too difficult. So I did what the manuals said: ran a user export set user's quota on old tablespace to 0 granted unlimited quota to user on new tablespace revoke resource, unlimited tablespace privs from user make new tablespace default for user Then when I ran the import with ignore=y I got the error space quota exceeded for tablespace old tablespace for all create table commands. Bottom line is, it didn't import the tables. Reading the manuals and Metalink docs, the process looked really straightforward. Does anybody know of anything that I've missed? Thanks, George Yes : a user cannot own two objects with the same name. The problem is with keeping everything in the same schema. You should have dropped all tables to be moved beforehand. Your message doesn't come from CREATE commands, but INSERT commands (you are aloso likely to have a number of duplicate rows if some of your tables had no unique index, PK or otherwise, defined). -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: George Hofilena 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: Problem importing objects to different tablespace
Funny because Oracle has explicitly stated that you can actually import a user's objects to it's new default tablespace as long as you make sure that the user doesn't have any quota or privs on the old tablespace. George -Original Message- Sent: Tuesday, November 27, 2001 1:00 PM To: Multiple recipients of list ORACLE-L The default tablespace is only used whenever there is no tablesapce parameter in the crate and alter table/index statements. Since the export always have tablespace parameter with the create table/index statement, your import method definitely will fail. You can change the tablespace for the segment by creating the segment in the desired tablesapce first, then import. Jun -Original Message- Sent: Tuesday, November 27, 2001 2:05 PM To: Multiple recipients of list ORACLE-L Guys, I'd appreciate any help that I could get. I was trying to import to another tablespace, same user. I hadn't had a need to do this in a while but thought this shouldn't be too difficult. So I did what the manuals said: ran a user export set user's quota on old tablespace to 0 granted unlimited quota to user on new tablespace revoke resource, unlimited tablespace privs from user make new tablespace default for user Then when I ran the import with ignore=y I got the error space quota exceeded for tablespace old tablespace for all create table commands. Bottom line is, it didn't import the tables. Reading the manuals and Metalink docs, the process looked really straightforward. Does anybody know of anything that I've missed? Thanks, George -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Hofilena 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: Feng, Jun 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: George Hofilena 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: Problem importing objects to different tablespace
I know this. But I just wanted to avoid the hassle of precreating the tables, creating the views and other objects. Note:1012307.6 in Metalink seems to encourage that approach. George -Original Message- Sent: Tuesday, November 27, 2001 3:26 PM To: Multiple recipients of list ORACLE-L George, If import sees the old tablespace (the tablespace where the table was exported from), it will try to import the table into it, even if the user has no quota (of course then you abend with a quota error). Our workaround is to pre-create the table in the new tablespace. Then you have to import with ignore=y. If you need DDL to create it, you can run import with indexfile= and then edit the file that it creates. hth Steve -Original Message- Sent: Tuesday, November 27, 2001 4:35 PM To: Multiple recipients of list ORACLE-L All the objects are dropped beforehand. The import is done on a clean slate. I just put in the ignore=y because that's what the docs suggested and I was half hoping it'll drive the space quota exceeded... error away :) George -Original Message- Sent: Tuesday, November 27, 2001 12:30 PM To: Multiple recipients of list ORACLE-L George Hofilena wrote: Guys, I'd appreciate any help that I could get. I was trying to import to another tablespace, same user. I hadn't had a need to do this in a while but thought this shouldn't be too difficult. So I did what the manuals said: ran a user export set user's quota on old tablespace to 0 granted unlimited quota to user on new tablespace revoke resource, unlimited tablespace privs from user make new tablespace default for user Then when I ran the import with ignore=y I got the error space quota exceeded for tablespace old tablespace for all create table commands. Bottom line is, it didn't import the tables. Reading the manuals and Metalink docs, the process looked really straightforward. Does anybody know of anything that I've missed? Thanks, George Yes : a user cannot own two objects with the same name. The problem is with keeping everything in the same schema. You should have dropped all tables to be moved beforehand. Your message doesn't come from CREATE commands, but INSERT commands (you are aloso likely to have a number of duplicate rows if some of your tables had no unique index, PK or otherwise, defined). -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: George Hofilena 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: Todd, Stephen 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: George Hofilena INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Oracle Licensing Scheme
I can't seem to find anything clear on licensing rates at Oracle's site anymore. Maybe it's my eyes, but I just couldn't find it. Only thing I saw was their claim that they have now changed their licensing scheme to user and cpu units but I wanted the the rates. I need to know, besides (or before) calling Oracle, what the licensing rates are now for 8.0.5 Standard and Enterprise Editions and whether there's additional costs for opening up our database to Internet users. Thanks, George -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Hofilena 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: NT SCheduler !!
Saroj, The only way that I can do this is using NT's GUI Task Scheduler. There is an advanced option there that lets you repeat tasks at every specified interval and the duration. Regards, George -Original Message- Sent: Tuesday, October 30, 2001 12:20 AM To: Multiple recipients of list ORACLE-L Hello Guru, I want to run one batch in Windowns NT using At scheduler. Thw question is : a) There will be a start time end time ...say 7PM 12 PM b) Want to run the batch say in every hour (Have a fixed Interval time ) c)want to repeat step a b everyday I am facing the problem in AT command how to specify the interval time i.e every 1 hr the batch will be run. Please help me. Regards, Saroj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) 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: George Hofilena 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: Replacing a Disk on WinNT
Thta's just what I did, skip #3. I realized it wasn't necessary as I had to do a full backup on a Disk C (backup disk) anyway. Everything worked out fine. Thanks, George -Original Message- Sent: Monday, October 29, 2001 6:05 AM To: Multiple recipients of list ORACLE-L I don't see any reason why George's approach shouldn't work. In fact, he can skip step 3 and just copy the files to A from their mirrors. If it doesn't work, you've always got the original disk A to put back in. Steven Lembark To: Multiple recipients of list ORACLE-L lembark [EMAIL PROTECTED] @wrkhors.comcc: Sent by: rootSubject: Re: Replacing a Disk on WinNT 10/27/2001 04:20 PM Please respond to ORACLE-L -- George Hofilena [EMAIL PROTECTED] Hi, We are replacing once of the disks where a mirrored control file and redo logs reside, nothing else, with a higher disk capacity. I can either use the recommended Oracle approach to moving/relocating control and redo log files but for my purpose it would seem laborious compared to what I am thinking is the quickest. But I need to know whether you agree to this. This is what I intend to do: 1. Shutdown the database 2. Make a full backup. 3. Copy the control and redo log files on Disk A to Disk B 4. Replace Disk A (Disk A wiil have the same drive letter/designation) 5. Copy control and redo log files back from Disk B 6. Startup the database. Is this safe? No. Only for the reason that you don't have a full backup of everything on stable, offline media. On the other hand, you do have a working backup of the media on the disk that is being removed. Why just just up the scsi address, write lock it and use the drive as its own backup? Basically you'd add the new drive in where the old one was in the chain, up the address of the old one -- total time 15 sec if you don't drop the jumpers too many times -- and copy the contents of the old drive to the new one. -- 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: George Hofilena 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: Win XP
From where I came from, probably about one in every 50 (optimistic estimate) computer users there have dial-up access to the internet. MS has practically cut itself off of about this percentage in terms of potential sales. George -Original Message- Sent: Monday, October 29, 2001 12:33 PM To: Multiple recipients of list ORACLE-L Remember XP can only be used on ONE machine. It takes a branding and authorization code from M$$$ to activate it. If by chance you get around the activation code it will be checked when you go to the internet and against a master table that M$$$ has. If it is an unauthorized copy then you are breaking the law and on your own. M$$$ can then prosecute if they desire. We have a 10 machine development license and each machine has to have a different authorization code from M. The machine branding is dependent upon the hardware making up the machine. ROR mª¿ªm [EMAIL PROTECTED] 10/29/01 02:20PM More realistic pricing (street value): http://www.bestbuy.com/software/promo.asp?m=1023Cat=1807p=1807 But for my money: http://www.linux.org :D Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, October 29, 2001 12:20 To: Multiple recipients of list ORACLE-L IS THIS REAL? They charge this much for XP? Lisa Koivu Oracle Database Monkey -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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: 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: George Hofilena 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).
Replacing a Disk on WinNT
Hi, We are replacing once of the disks where a mirrored control file and redo logs reside, nothing else, with a higher disk capacity. I can either use the recommended Oracle approach to moving/relocating control and redo log files but for my purpose it would seem laborious compared to what I am thinking is the quickest. But I need to know whether you agree to this. This is what I intend to do: 1. Shutdown the database 2. Make a full backup. 3. Copy the control and redo log files on Disk A to Disk B 4. Replace Disk A (Disk A wiil have the same drive letter/designation) 5. Copy control and redo log files back from Disk B 6. Startup the database. Is this safe? Thanks, George -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Hofilena 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: Uncle Larry in the news
Total non-sense from Uncle Larry. A pure marketing ploy. But that's what it's all about, 'MARKETING'. Larry knows it. He knows we know it. But knowing Larry he just doesn't give a damn as long as the money comes flowing in. George -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Hofilena 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: 2nd DBA or ?
I agree. Never heard of that word either. Is it a new feature in 9i? George -Original Message- Sent: Thursday, September 20, 2001 11:56 AM To: Multiple recipients of list ORACLE-L What is vacation? -Original Message- From: Miller, Jay [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 20, 2001 2:31 PM To: Multiple recipients of list ORACLE-L Subject: RE: 2nd DBA or ? Agreed. Do you want to ever be able to go on a 2 week vacation at some point in your life? Or even 1 week overseas? Then you need a 2nd DBA. It's also much better for the company. If you should ever decide to seek greener pastures elsewhere there will be someone familiar with all their systems and databases. -Original Message- Sent: Thursday, September 20, 2001 1:56 PM To: Multiple recipients of list ORACLE-L second person, you get to have a life -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Thursday, September 20, 2001 12:30 PM To: Multiple recipients of list ORACLE-L I've been presented with an opportunity to justify requirements for a 2nd DBA at our site. As I see it there are an number of paths this presents: 1 - Justify and get a 2nd DBA. Pro's: Gives me more time to get involved in other projects as a senior DBA. Holidays and attendance at courses and seminars etc. easier to take 2 - Outsource this role and activate it when required and justify putting money into investing in software and/or hardware to allow a single DBA function to required levels. Pros: New tools etc. to learn and broader experience gained. More bargaining power if required. I'd like to hear your feedback on which path you'd be inclined to take and why?. Also if going it alone what you'd look for software in hardware and other areas. Currently 6 NT servers, 10 databases and expanding... Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: O'Neill, Sean 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: Miller, Jay 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: Gogala, Mladen 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: George Hofilena 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
RE: Visio for ERD's ?
We use Visio2000 here. Sucks (hangs) if you try to re-engineer a schema composed of about a hundred tables. Wouldn't recommend it. George -Original Message- Sent: Friday, September 14, 2001 12:35 PM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! I would like to know if anyone is using Visio to re-engineer ERD's from an Oracle DB? Any problems, gotchas or recommendations are welcome I have Visio Prof. 5c and will be using Oracle DB 8.1.7. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz 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: George Hofilena 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).
WinNT / Oracle 8.0.5 / Problem with mapped drive
List, One of our web developers wants to extract a text file from Oracle and put it directly into a mapped drive that points to another NT server which acts as our web server. He's using a trigger to do this. I thought we could map one of the web server's drive on the database server, have Oracle see it through the UTIL_DIR parameter and the problem should be solved. Well, partly. This will only work if the OS account that was used to create the mapped drive is currrently logged into the database server. Onec the account/user is logged offOtherwise, it doesn't. We considered calling a NET USE command from within the PL/SQL program but it doesn't look as simple as we thought it should be. Is there a different solution to this problem or a better way than using the external procedure approach? Thanks, George -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Hofilena 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: WinNT / Oracle 8.0.5 / Problem with mapped drive
List, I've got it all figured out. I restarted all Oracle services under a domain account and added the UNC path to the UTL_FILE_DIR parameter. George -Original Message- Sent: Monday, September 17, 2001 4:15 PM To: Multiple recipients of list ORACLE-L List, One of our web developers wants to extract a text file from Oracle and put it directly into a mapped drive that points to another NT server which acts as our web server. He's using a trigger to do this. I thought we could map one of the web server's drive on the database server, have Oracle see it through the UTIL_DIR parameter and the problem should be solved. Well, partly. This will only work if the OS account that was used to create the mapped drive is currrently logged into the database server. Onec the account/user is logged offOtherwise, it doesn't. We considered calling a NET USE command from within the PL/SQL program but it doesn't look as simple as we thought it should be. Is there a different solution to this problem or a better way than using the external procedure approach? Thanks, George -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Hofilena 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: George Hofilena 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: WinNT / 8.0.5 / DECODE function affecting Century result in d
!! Please do not post Off Topic to this List !!
Thanks for all the responses. I just switched the operators like this.
Seems to work.
TO_DATE(DECODE(:bdate,NULL,NULL,'19'||:bdate),'MMDD')
This is legacy data so the '19' prefix is only temporary. RR was one of the
first that I tried. Didn't work.
Anyway, I guess I was just curious as to why Oracle changed the century in
such a manner when I introduce the DECODE the way I originally did.
This is no longer urgent in my case but I'd still be interested to know if
somebody has any input as to why Oracle behaves the way it does.
Thanks,
George
-Original Message-
Sent: Thursday, September 13, 2001 10:00 AM
To: Multiple recipients of list ORACLE-L
d
!! Please do not post Off Topic to this List !!
What about RRMMDD as the date format? Will that work?
-
Steven Monaghan
Oracle DBA
MSC Industrial Direct Co., Inc.
Melville, NY
[EMAIL PROTECTED]
http://www.mscdirect.com
-
-Original Message-
Sent: Thursday, September 13, 2001 5:45 AM
To: Multiple recipients of list ORACLE-L
date
!! Please do not post Off Topic to this List !!Hi George
Your code looks fine to me and I have no idea why it wouldn't work. But if
it turns into a pain in the neck, why not write a wee PL/SQL function to do
the century thing for you and also trap nulls ?
There's a reason you might want to do this anyway: presumably you will
sooner or later start receiving dates in the current century, e.g. if your
file contains 000101 don't you want a function that will turn it into
01-JAN-2000 rather than 01-JAN-1900 ?
Cheers
Greg
-Original Message-
Sent: Wednesday, 12 September 2001 01:12
To: Multiple recipients of list ORACLE-L
date
List,
I have a 6-position column, bdate, in a text file that I am trying to
SQL*Load formatted as yymmdd. When I use the following SQL operations I get
the following results:
1. SQL Operation: (bdate POSITION(001:006) CHAR
TO_DATE(:bdate,'YYMMDD'))
Result in the database: Next Century, e.g. '300223' becomes
'23-FEB-2030'
2. SQL Operation (bdate POSITION(001:006) CHAR
DECODE(:bdate,NULL,NULL,TO_DATE('19'||:bdate,'MMDD')))
Result in the database: Next Century, e.g. '300223' becomes
'23-FEB-2030'
but when I take out the DECODE in item 2, I get the correct century. I only
use decode because there are null values in this column. Can somebody
explain to me what I am missing here?
Thanks,
George
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: George Hofilena
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: Greg Solomon
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).
This e-mail is intended for the use of the addressee(s) only and may contain
privileged, confidential, or proprietary information that is exempt from
disclosure under law. If you are not the intended recipient, please do not
read, copy, use or disclose the contents of this communication to others.
Please notify the sender that you have received this e-mail in error by
replying to the e-mail. Please then delete the e-mail and destroy any
copies of it. Thank you.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steven Monaghan
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
RE: WinNT / 8.0.5 / DECODE function affecting Century result in d
!! Please do not post Off Topic to this List !!
Larry,
Just what I needed to know. Everything's clear now. Thanks for your
excellent response.
George
-Original Message-
Sent: Thursday, September 13, 2001 11:56 AM
To: Multiple recipients of list ORACLE-L
d
!! Please do not post Off Topic to this List !!
George,
The behavior is explained by the nature of the DECODE statement. The data
type of *all* the return arguments is defined by the datatype of the *first*
return argument. In your case, NULL is the first return argument, and, the
DECODE treats this as a VARCHAR2 datatype. As a result, the value being
returned by the second argument is defined as a VARCHAR2 datatype. Here is a
comment from the docs on the DECODE statement. Note the comment concerning
how nulls are treated:
Oracle automatically converts the return value to the same datatype as the
first result. If the first result has the datatype CHAR or if the first
result is null, then Oracle converts the return value to the datatype
VARCHAR2.
Here is the old one giving you problems:
DECODE(:bdate,NULL,NULL,TO_DATE('19'||:bdate,'MMDD')
Even though the last argument was a DATE due to your TO_DATE, it was
*implicitly* converted to a VARCHAR2 string to match the datatype, VARCHAR2,
of the first return argument, NULL. More than likely your NLS_DATE_FORMAT
was something like DD-MON-YY. So, something like 19620629 would get
converted to 62-JUN-29. This would then get converted back to a DATE when
inserted into the column in the table. And since the century significance
had been lost, the *current* century would be assumed.
Here is an example of how the first return type defines the return types of
all arguments:
SQL select decode(ename,null,0,ename) from emp;
select decode(ename,null,0,ename) from emp
*
ERROR at line 1:
ORA-01722: invalid number
Notice that my first return argument is 0, a number. As a result, it tries
to convert ENAME to a number when it returns it. Thus the error.
If I remember correctly, someone posted a response where they did a
TO_DATE(null) for the first return argument and the problem was fixed (since
the TO_DATE of the last argument would remain a DATE and wouldn't do an
implicit conversion to a VARCHAR2 string and back to a date when going into
the table). They mentioned that for whatever reason it appeared to be return
a STRING value and thus the use of the TO_DATE. Well, the above explains
why.
This gotcha was documented in one of their Y2K papers (had to watch out
for NLV functions also). I saw it bite a couple of people on the tail -- the
implicit conversion to a VARCHAR2 and back wasn't all that obvious unless
someone knew the details of the decode, or, ran into the problem.
Regards,
Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of George
Hofilena
Sent: Thursday, September 13, 2001 12:50 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: WinNT / 8.0.5 / DECODE function affecting Century result in
d
!! Please do not post Off Topic to this List !!
Thanks for all the responses. I just switched the operators like this.
Seems to work.
TO_DATE(DECODE(:bdate,NULL,NULL,'19'||:bdate),'MMDD')
This is legacy data so the '19' prefix is only temporary. RR was
one of the
first that I tried. Didn't work.
Anyway, I guess I was just curious as to why Oracle changed the century in
such a manner when I introduce the DECODE the way I originally did.
This is no longer urgent in my case but I'd still be interested to know if
somebody has any input as to why Oracle behaves the way it does.
Thanks,
George
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Larry Elkins
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: George Hofilena
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
RE: RE: STOP THE PRESS!!
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: George Hofilena 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: STOP THE PRESS!!
If you have lived in a country where innocent family members have been senselessly murdered because they happened to be in the wrong place and you know who were responsible and the world doesn't care I couldn't blame them if they react that way. While it has just started with Americans yesterday, war has been with these people for a long time now. George -Original Message- Sent: Tuesday, September 11, 2001 5:12 PM To: Multiple recipients of list ORACLE-L On Tuesday 11 September 2001 10:15, Cale, Rick T (Richard) wrote: Pretty sure it's BinLadin who is being kept in Afghanistan. It will be WAR for sure on Afghanistan if they continue to harbor him. Pictures of Palestinians CELEBRATING this on the West Bank. Yes, that is very disturbing. I can't comprehend how anyone can cheer the death of innocent people, regardless of their beliefs and disagreements. I haven't gone to work today, this is just all too upsetting. Tired of going to the tissue box. Jared -Original Message- Sent: Tuesday, September 11, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Its now 1. BOTH tower have fallen. 2. Pentagon hit by a plane. 3. All flights in US grounded And I am sure more to follow -Original Message- Sent: Tuesday, September 11, 2001 9:55 AM To: Multiple recipients of list ORACLE-L The BBC seems to have more info than the U.S. web sites. Tuesday, 11 September, 2001, 13:35 GMT 14:35 UK Planes 'attack' World Trade Center A huge explosion rocks one of towers Two planes have crashed into the World Trade Center in New York City while an explosion has rocked the Pentagon in Washington DC. The White House is reportedly being evacuated. One report says six people have been killed in the New York incident while hundreds have been injured. Smoke is pouring from the upper storeys of both towers of the World Trade Center. The building, one of the world's tallest, has been badly damaged in what President George W Bush has described as an apparent terrorist attack. He said: We will find those who committed this attack. New York police have been quoted as saying that both planes were hijacked from Boston. A few minutes after the first tower was hit by a passenger plane, a second, similar plane was seen flying into the second tower. A huge explosion was seen. Eyewitnesses say the first plane crashed into the West Tower after flying unusually low over Manhattan Island. A BBC correspondent says 10 to 15 floors have been affected by the crash. Briton James Winter, 30, living in an apartment close to the centre, said he was woken a huge bang at around 0800 local time. I was in bed and there was a huge explosion. The whole building rattled and shook, he said. I ran to the window and there was smoke billowing from the south side of one of the towers. Everyone in my building was panicking and running around. The World Trade Center consists of two 110-story skyscrapers, New York's tallest buildings. One of the towers is just six feet (two metres) taller than the other. About 40,000 people work inside the two-building centre, and more than 150,000 people enter the complex every day. On 26 February, 1993, a terrorist bomb exploded in building number one's lower level. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: George Hofilena INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: STOP THE PRESS!!
Boston. A few minutes after the first tower was hit by a passenger plane, a second, similar plane was seen flying into the second tower. A huge explosion was seen. Eyewitnesses say the first plane crashed into the West Tower after flying unusually low over Manhattan Island. A BBC correspondent says 10 to 15 floors have been affected by the crash. Briton James Winter, 30, living in an apartment close to the centre, said he was woken a huge bang at around 0800 local time. I was in bed and there was a huge explosion. The whole building rattled and shook, he said. I ran to the window and there was smoke billowing from the south side of one of the towers. Everyone in my building was panicking and running around. The World Trade Center consists of two 110-story skyscrapers, New York's tallest buildings. One of the towers is just six feet (two metres) taller than the other. About 40,000 people work inside the two-building centre, and more than 150,000 people enter the complex every day. On 26 February, 1993, a terrorist bomb exploded in building number one's lower level. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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: Christopher Spence 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: George Hofilena 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).
WinNT / 8.0.5 / DECODE function affecting Century result in date
List,
I have a 6-position column, bdate, in a text file that I am trying to
SQL*Load formatted as yymmdd. When I use the following SQL operations I get
the following results:
1. SQL Operation: (bdate POSITION(001:006) CHAR
TO_DATE(:bdate,'YYMMDD'))
Result in the database: Next Century, e.g. '300223' becomes
'23-FEB-2030'
2. SQL Operation (bdate POSITION(001:006) CHAR
DECODE(:bdate,NULL,NULL,TO_DATE('19'||:bdate,'MMDD')))
Result in the database: Next Century, e.g. '300223' becomes
'23-FEB-2030'
but when I take out the DECODE in item 2, I get the correct century. I only
use decode because there are null values in this column. Can somebody
explain to me what I am missing here?
Thanks,
George
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: George Hofilena
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: Comparison Statistics between Oracle and MS SQL
There had been some sites referred through this list before but I have not taken them down. If I were you, since this would probably continue until you can unquestioningly prove that Oracle is superior in many respects, I'd start using more time surfing for sites 'sympathetic' to Oracle. You would find lots. Either this or you can research more of SQL Server (especially it's weaknesses; concentrate on that until he retches). It is said that the best way to defeat your enemy is to know him well. Or if you don't have the time just create an Outlook rule to filter out possible Oracle attacks from him :) George -Original Message- Sent: Tuesday, September 04, 2001 2:31 AM To: Multiple recipients of list ORACLE-L Hi Folks, Need some backing up here! I have a MSSQL dba at my place of employment who enjoys emailing me with either Websites or reports that compare MSSQL and ORACLE, with MSSQL in a favouable light and Oracle usually in a very negative light. Anyone have anything similar, but from an Oracle point of view? Would love to shovel some down his throat. It would be funny if he did not insist on sending them to the Boss too. Regards, Denham -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denham Eva 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: George Hofilena 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: OT: any spam today?
I was just thinking here that if you ever succeeded in sending one to the spammer what's going to protect you from him doing the same to you in retaliation? George -Original Message- Sent: Tuesday, September 04, 2001 10:07 AM To: Multiple recipients of list ORACLE-L There are ways to send mail bombs, I am not going to go into them, but there are many ways to wreak havok through email, which are not totally considered virus. I get about 30 emails a day which are completely spam and completely garbage. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, September 04, 2001 12:33 PM To: Multiple recipients of list ORACLE-L ESPECIALLY with EXCITE. my kids sign up for stuff all the time, and I am NEVER able to remove their names from the mailing lists. wish there was a way to send a fire-bomb thru email Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, September 04, 2001 12:17 PM To: Multiple recipients of list ORACLE-L I haven't received those myself. Be forewarned that the option to remove often doesn't work and is actually a device to verify that your email address is valid. Jared On Tuesday 04 September 2001 08:31, Ron Rogers wrote: List, Has any one received un solicited emails from [EMAIL PROTECTED] or [EMAIL PROTECTED] about business opportunities. I can't get the email to respond to the remove option at [EMAIL PROTECTED] I keep getting invalid recipient. ROR ma?am -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Mercadante, Thomas F 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: Christopher Spence 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: George Hofilena 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: !! Keeping the list alive - part deux
Jared, Count me in for $20 (for now). George -Original Message- Sent: Wednesday, August 29, 2001 11:49 AM To: Multiple recipients of list ORACLE-L Forgot one question; Q. I would love to help, can I remain anonymous? A. Certainly. We have no intention of publishing contributors. -- 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: George Hofilena 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: !! *Very* important Oracle-L message !!
willing to waive all setup fees in order to bring new customers on board. If you become a customer here in the next couple of months, that would help tremendously. If you have an interest in hosting your website (personal or business) with us, -or- a want to start a new mailing list, please contact me for details. I know this is a lot to ask of you folks. You are entirely welcome to just tell me to jump in a lake, and that that's how business is right now. But I know many of you personally, either from ODTUG conferences or from other Oracle events, and I also know how staunchly you support this mailing list with useful information, humor, helpfulness and an eye toward quality. I would like to think that you find Fat City to be the best place to host your list, and that you will want to help me out so that I can continue to provide the list to you folks free of charge. I made a promise to Jared years ago to host this list for free because I think it is one of the best and most valuable resources out there. I intend to honor that promise to him by continuing to provide it for free. If it turns out that I must close shop and call it quits, at least I will have known I did my best to make it succeed, and I did so without having to reneg on committments I had made in the past. I am being open and honest with everyone because I believe that this is the best way to succeed. I believe you appreciate this kind of approach, and I want you to know that regardless of what happens, I certainly appreciate every consideration you give this request. Whether or not this succeeds, I know that you are a great group of people and I wish this list the best luck in this life, or the next. :-) Remember, time is of the essence. The sooner I hear from people who can help, the sooner I can nail down a line of approach. If you have any questions or concerns, please E-mail me. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: Orr, Steve 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: George Hofilena 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: net 8 / 8i ?
I'd go for option 1 George -Original Message- Sent: Monday, August 20, 2001 4:41 PM To: Multiple recipients of list ORACLE-L We are running 8.0.5 and due to upgrade fatigue on our applications, we are at least one year away before we upgrade to 8i and/or possibly 9i. But we are upgrading our desktops to windows 2000. The question I have, 1. Should I install the net 8.0 client on the base image and upgrade it to 8i later ? or 2. Should I go ahead and install the 8i client on the base image and be done with it. The larger question being will the 8i client work with the 8.0 databases ?? Any tips, suggestions, experiences would be greatly appreciated Thank you in advance Darren - Darren Browett P.EngThis message was transmitted Systems Admin/DBA using 100% recycled electrons Information and Communications Technology. City of Coquitlam P:(604) 927 - 3614 E:[EMAIL PROTECTED] - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren 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: George Hofilena 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: closing DB on NT with a scheduled BATCH FILE
All my batch files are in drive D and I haven't had any problems. Your problem could have been caused by something else but you can definitely put your batch files anywhere. I can also run AT from any drive. George -Original Message- Sent: Thursday, August 09, 2001 9:55 AM To: Multiple recipients of list ORACLE-L On Thursday 09 August 2001 01:30, Rajesh Dayal wrote: Jared, Just out of curiosity I am asking ( May be I am missing something) How does it matter whether the command file is on C drive or D/E (other) drives? I'm not an expert on NT, but experience and RTFM show that your AT jobs better be on the C: drive if you always expect them to work. I learned this just last week. AT job does not work when run from F: drive ( not a network drive, but attached as part of a cluster ). Move it to the C: drive and all is fine. NT security is kinda strange. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: George Hofilena 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: Using AT command in NT
Try, at 12:00pm /every:m,t,w,th,f c:\my_backups\backup.bat George -Original Message- Sent: Wednesday, August 01, 2001 11:28 AM To: LazyDBA.com Discussion I'm looking into setting up my backups and want to use the AT command in NT but I need some examples of the command line. I Know that I want it daily at midnight,but how do I do this in command line mode, What is the command? This is what I have tried and it does'nt work. AT /every:date M,T,W,TH,F 12:00pm c:\my_backups -- this does not work. Help please _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage 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 By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Hofilena 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).
NULL Foreign Key Value
Can somebody explain why Oracle would allow a foreign key to be null and still enforce the referential integrity constraint. Thanks, George Hofilena DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Hofilena 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: Metablink .... down again?
You can't. Nabila Mekkaoui (inf/mekkaoui) is using it right now :) George -Original Message- Sent: Monday, July 23, 2001 8:22 AM To: Multiple recipients of list ORACLE-L So slow I can't even get in... Chuck Speaks Database Administrator Lithonia Lighting 770-860-3450 http://www.lithonia.com -Original Message- Sent: Monday, July 23, 2001 10:21 AM To: Multiple recipients of list ORACLE-L Is it me or everyone? Is Metablink working for anyone this morning ? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra 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: Speaks, Chuck W. 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: George Hofilena 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).
WinNT / 8.0.5 / Import anomaly, or is it?
From out of nowhere, I started getting the 'ORA-01658: unable to create INITIAL extent for segment ...' error for only SOME indexes on my index tablespace when doing a simple import. Export was done without compression. I rechecked INITIAL extent sizes and true to my expectations they were small 665K. I didn't want to go through precreating the tables with appropriate sizes because I felt it was not the issue in the first place. As a last resort I restarted the database and everything went back to normal again. Can anybody have an explanation for this? Thanks, George -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Hofilena 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: WinNT / 8.0.5 / Import anomaly, or is it?
I actually did. That didn't help. George -Original Message- Sent: Friday, July 20, 2001 11:34 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] The tablespace was fragmented. Restarting the database caused it to coalesce your tablespaces. You could have issued 'alter tablespace mytbs coalesce;' for each tablespace before running the import. Jay [EMAIL PROTECTED] 07/20/01 02:55PM From out of nowhere, I started getting the 'ORA-01658: unable to create INITIAL extent for segment ...' error for only SOME indexes on my index tablespace when doing a simple import. Export was done without compression. I rechecked INITIAL extent sizes and true to my expectations they were small 665K. I didn't want to go through precreating the tables with appropriate sizes because I felt it was not the issue in the first place. As a last resort I restarted the database and everything went back to normal again. Can anybody have an explanation for this? Thanks, George -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Hofilena 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: George Hofilena 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: SUMMARY: BIG PROBLEM
Does that mean you won't be needing an Oracle DBA anymore? :) George -Original Message- Sent: Friday, June 29, 2001 2:12 PM To: Multiple recipients of list ORACLE-L This worked great!!! Thanks to all who replied! -Original Message- Applewhite Sent: Friday, June 29, 2001 2:21 PM To: Multiple recipients of list ORACLE-L Edward, Your database backup is OK. RMan just can't backup and delete the archived redo logs that you moved. If you want RMan to backup, then delete, those archived redo logs, you'll have to move them back to the drive from which they came. Then do another backup. If you've got lots of logs, it may take several batches to get them all. If you just want to go forward, with RMan backing up and deleting the logs from now on, issue the following command at the RMan prompt: allocate channel for maintenance type disk; change archivelog all crosscheck; release channel; That will cause RMan to forget about the archived redo logs you've moved, but it will pick up with the logs that have since been created and are still in the expected directory. Good luck. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Carr Sent: Friday, June 29, 2001 2:51 PM To: Multiple recipients of list ORACLE-L Hello all, I just joined this list today and am in need of desperate help!!! In its infinite wisdom HR decided to lay off our only oracle dba!!! I am trying to get some backups working on our database using rman. It seems to backup our datafiles ok, but I am getting the following error ... RMAN-03022: compiling command: backup RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure during compilation of command RMAN-03013: command type: backup RMAN-06089: archived log /oradata/bdw/disk01/archive/bdw_1_24445.arc not found or out of sync with catalog The problem here is twofold: 1) It is looking in the wrong directory for the archive logs 2) We have been moving old archive logs off of the server to another server to keep the disk from filling up while we were working on this backup problem, so I do not want it looking for the old logs. As I am not a DBA I have no clue how to fix this, but it needs to be done A.S.A.P. ... Thanks to anyone who can help me!!! -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite 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: Edward W. Carr 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: George Hofilena 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: BIG PROBLEM
One possible reason is that someone might have deleted some archived logs before doing a backup ... the ex-DBA? :) -Original Message- Sent: Friday, June 29, 2001 1:17 PM To: Multiple recipients of list ORACLE-L One possible reason is that someone might have deleted some archived logs before doing a backup ... solution: log into rman rman rcvcat rman/password target / change archivelog all crosscheck; allocate channel for maintenance type 'SBT_TAPE'; delete expired backup; exit the above is for a separate rman database running on a sun box using a netbackup tape system ... hth Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com mailto:[EMAIL PROTECTED] Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message- Sent: Friday, June 29, 2001 3:51 PM To: Multiple recipients of list ORACLE-L Hello all, I just joined this list today and am in need of desperate help!!! In its infinite wisdom HR decided to lay off our only oracle dba!!! I am trying to get some backups working on our database using rman. It seems to backup our datafiles ok, but I am getting the following error ... RMAN-03022: compiling command: backup RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure during compilation of command RMAN-03013: command type: backup RMAN-06089: archived log /oradata/bdw/disk01/archive/bdw_1_24445.arc not found or out of sync with catalog The problem here is twofold: 1) It is looking in the wrong directory for the archive logs 2) We have been moving old archive logs off of the server to another server to keep the disk from filling up while we were working on this backup problem, so I do not want it looking for the old logs. As I am not a DBA I have no clue how to fix this, but it needs to be done A.S.A.P. ... Thanks to anyone who can help me!!! -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. This transmission may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glasrot, Nechama 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: George Hofilena 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: SUMMARY: BIG PROBLEM
Does that mean you won't need an Oracle DBA anymore? :) -Original Message- Sent: Friday, June 29, 2001 2:12 PM To: Multiple recipients of list ORACLE-L This worked great!!! Thanks to all who replied! -Original Message- Applewhite Sent: Friday, June 29, 2001 2:21 PM To: Multiple recipients of list ORACLE-L Edward, Your database backup is OK. RMan just can't backup and delete the archived redo logs that you moved. If you want RMan to backup, then delete, those archived redo logs, you'll have to move them back to the drive from which they came. Then do another backup. If you've got lots of logs, it may take several batches to get them all. If you just want to go forward, with RMan backing up and deleting the logs from now on, issue the following command at the RMan prompt: allocate channel for maintenance type disk; change archivelog all crosscheck; release channel; That will cause RMan to forget about the archived redo logs you've moved, but it will pick up with the logs that have since been created and are still in the expected directory. Good luck. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Carr Sent: Friday, June 29, 2001 2:51 PM To: Multiple recipients of list ORACLE-L Hello all, I just joined this list today and am in need of desperate help!!! In its infinite wisdom HR decided to lay off our only oracle dba!!! I am trying to get some backups working on our database using rman. It seems to backup our datafiles ok, but I am getting the following error ... RMAN-03022: compiling command: backup RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure during compilation of command RMAN-03013: command type: backup RMAN-06089: archived log /oradata/bdw/disk01/archive/bdw_1_24445.arc not found or out of sync with catalog The problem here is twofold: 1) It is looking in the wrong directory for the archive logs 2) We have been moving old archive logs off of the server to another server to keep the disk from filling up while we were working on this backup problem, so I do not want it looking for the old logs. As I am not a DBA I have no clue how to fix this, but it needs to be done A.S.A.P. ... Thanks to anyone who can help me!!! -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite 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: Edward W. Carr 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: George Hofilena 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).
NT4 / 8.0.5 /Transactions Limit Reached
Hi, One of our prod databases sort of just suddenly went into restricted mode yesterday allowing only dba's to log in and stopping non-privileged user's. We first noticed this when os_authentication suddenly stopped working and users got the ODBC login. The alert log was clean (no errors reported) but further investigation showed that we had reached the transaction limit which was indicated in the Enterprise Manager. Not having more time to investigate, we rebooted NT and the problem was resolved. Now I can see that the transactions parameter is nearing the limit again and I would like to know where to look first to know what's happening. I looked into v$%transactions% views and they were all empty. BTW, we only had about 30 sessions at that time and the transactions had reached the limit of 247 Any ideas on where to begin looking or advice on what to watch out for? Thanks for your help, George Hofilena DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Hofilena 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).
NT4 / 8.0.5 /Transactions Limit Reached
Hi, One of our prod databases sort of just suddenly went into restricted mode yesterday allowing only dba's to log in and stopping non-privileged user's. We first noticed this when os_authentication suddenly stopped working and users got the ODBC login. The alert log was clean (no errors reported) but further investigation showed that we had reached the transaction limit which was indicated in the Enterprise Manager. Not having more time to investigate, we rebooted NT and the problem was resolved. Now I can see that the transactions parameter is nearing the limit again and I would like to know where to look first to know WHAT IS happening. I looked into v$%transactions% views and they were all empty. BTW, we only had about 30 sessions at that time and the transactions had reached the limit of 247 Any ideas on where to begin looking or advice on what to watch out for? Thanks for your help, George Hofilena DBA Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage 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 By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Hofilena 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).
New Subscriber / Test Message - Please Ignore
This is a test message. Please ignore. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Hofilena 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).
