imp/exp question
Hello, I have a problem and I hope you can help me. We have a Oracle 9 installation two users with two different default tablespaces. The problem is to move data between theese two users with imp/exp. I'll try to explain it a little bit more. we have userA with the default tablescape tabA and userB with tablB. first we want to do something like: exp userA/passA owner=(userA) file=dump.dmp and after: imp userB/passB fromuser=(userA) touser=(userB) file=dump.dmp If we do not have BLOB columns everything works fine. I think the problem resides in the fact that in the case of a BLOB column the STORAGE clause specifies in which tablespace the BLOB column should be stored and this is not handled by the imp program (not relocated in the tablespace B). I'm sure there should be a way to handle this but I was not able to find it. Please help. Adrian -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Ciocildau INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Win2k Perl accessing Oracle Parameters?
Title: Win2k Perl accessing Oracle Parameters?
Hello All,
I am writing an perl script. I cann't figure out and have been going through the docs, but cann't find exactly what I need.
A way to access Oracle Parameters as they are set up in the Win2k registary. I am specifically thinking of ORACLE_HOME. I do know how to obtain an environmental variable/parameter with $ENV{}.
But the ORACLE_HOME is not an environmental parameter per se.
I have a workaround by setting it up in the enviroment, however I would like to write this script with the aim at it being machine unspecific.
(Jared, hope you can answer me on this. Want to get a copy of your book, unfortunately with the exchange rate and import taxes etc it will cost me R590,00. Quiet a chunk of the ole budget, maybe early next year.)
Regards
Denham Eva
Oracle DBA
UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity.
Dennis Ritchie.
DISCLAIMER
This message is for the named person's use
only. It may contain confidential, proprietary or legally privileged
information. No confidentiality or privilege is waived or lost by any
mistransmission. If you receive this message in error, please immediately delete
it and all copies of it from your system, destroy any hard copies of it and
notify the sender. You must not, directly or indirectly, use, disclose,
distribute, print, or copy any part of this message if you are not the intended
recipient. TFMC, its holding company, and any of its subsidiaries each reserve
the right to monitor and manage all e-mail communications through its
networks.
Any views expressed in this message are those
of the individual sender, except where the message states otherwise and the
sender is authorized to state them to be views of any such entity.
This e-mail message has been scanned for Viruses and Content and cleared by
MailMarshal -
For more information please visit
www.marshalsoftware.com
RE: imp/exp question
Dear One of the solution is you can export in system user with two user tables. You can exp/ imp blob column also. Later you can imp thru system, but use from user and to user options. I think it will help u. Thanks and Regards V.Baskaran -Original Message- Ciocildau Sent: Tuesday, October 29, 2002 11:18 To: Multiple recipients of list ORACLE-L Hello, I have a problem and I hope you can help me. We have a Oracle 9 installation two users with two different default tablespaces. The problem is to move data between theese two users with imp/exp. I'll try to explain it a little bit more. we have userA with the default tablescape tabA and userB with tablB. first we want to do something like: exp userA/passA owner=(userA) file=dump.dmp and after: imp userB/passB fromuser=(userA) touser=(userB) file=dump.dmp If we do not have BLOB columns everything works fine. I think the problem resides in the fact that in the case of a BLOB column the STORAGE clause specifies in which tablespace the BLOB column should be stored and this is not handled by the imp program (not relocated in the tablespace B). I'm sure there should be a way to handle this but I was not able to find it. Please help. Adrian -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Ciocildau INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oracle INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: imp/exp question
Adrian Ciocildau wrote: Hello, I have a problem and I hope you can help me. We have a Oracle 9 installation two users with two different default tablespaces. The problem is to move data between theese two users with imp/exp. I'll try to explain it a little bit more. we have userA with the default tablescape tabA and userB with tablB. first we want to do something like: exp userA/passA owner=(userA) file=dump.dmp and after: imp userB/passB fromuser=(userA) touser=(userB) file=dump.dmp If we do not have BLOB columns everything works fine. I think the problem resides in the fact that in the case of a BLOB column the STORAGE clause specifies in which tablespace the BLOB column should be stored and this is not handled by the imp program (not relocated in the tablespace B). I'm sure there should be a way to handle this but I was not able to find it. Please help. Adrian Adrian, what imp tries to do is recreate the object in the same tablespace as it originates from, and if this fails (because the tablespace doesn't exist or the target schema is not allowed to create segments in it) then it falls back on the default tablespace. Check that your target user HAS NOT the UNLIMITED TABLESPACE privilege, and play on quotas (setting them, even temporarily, to 0, when you do not want something to land somewhere) to direct segment creation where you want it to happen. It would be easy if you only had tables, but the presence of indexes, partitions or LOBs as in your case makes it a little difficult to play with when you want to totally relocate everything. It may be simpler to reimport under a different user but in the same tablespaces and then MOVE objects. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
net8 for linux
hi, i learned that i need net8 for linux to rebuild the DBD-Oracle perl module. where can i download one for free -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sonny e. supilanas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Win2k Perl accessing Oracle Parameters?
Here's something to read registry keys I used a while back. Obviously needs
the win32 module installed.
use Win32::Registry;
$terminal = $ARGV[0];
$HKEY_LOCAL_MACHINE-Connect ($terminal, $hNode) || die Cannot connect to
$node;
$hNode-Open (SOFTWARE\\Microsoft\\Windows NT\\CurrentVersion\\Winlogon,
$hKey) || die Cannot open registry !;
$hKey-GetValues (\%values);
$hKey-Close ();
$hNode-Close ();
foreach $value (keys(%values)) {
$RegType = $values{$value}-[1];
$RegValue = $values{$value}-[2];
$RegKey = $values{$value}-[0];
if ($RegKey eq DefaultUserName) {$username = $RegValue;
print $RegValue\n;
}
}
exit;
Modify accordingly. HTH.
Lewis Bishop
---
Barclays Enable - ISS - E-NTRUST/Bexleyheath NT
Oracle Database Consultant
Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R)
Phone : 020 8298 3418
Mobile: 07950 380857
Email : [EMAIL PROTECTED]
Enabling Competitive Advantage for Barclays in IT and Business Processing
-Original Message-
Sent: 29 October 2002 08:43
To: Multiple recipients of list ORACLE-L
This header confirms that this email message has been swept for the
presence of computer viruses.
Corporate IT
THE WOOLWICH
--
Hello All,
I am writing an perl script. I cann't figure out and have been going through
the docs, but cann't find exactly what I need.
A way to access Oracle Parameters as they are set up in the Win2k registary.
I am specifically thinking of ORACLE_HOME. I do know how to obtain an
environmental variable/parameter with $ENV{}.
But the ORACLE_HOME is not an environmental parameter per se.
I have a workaround by setting it up in the enviroment, however I would like
to write this script with the aim at it being machine unspecific.
(Jared, hope you can answer me on this. Want to get a copy of your book,
unfortunately with the exchange rate and import taxes etc it will cost me
R590,00. Quiet a chunk of the ole budget, maybe early next year.)
Regards
Denham Eva
Oracle DBA
UNIX is basically a simple operating system, but you have to be a genius to
understand the simplicity.
Dennis Ritchie.
_
DISCLAIMER
This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission. If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender. You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. TFMC, its holding company, and any of its subsidiaries each
reserve the right to monitor and manage all e-mail communications through
its networks.
Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized to
state them to be views of any such entity.
_
_
This e-mail message has been scanned for Viruses and Content and cleared by
MailMarshal - For more information please visit
http://www.marshalsoftware.com www.marshalsoftware.com
_
--_=_NextPart_001_01C27F2F.5CF0F180
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN
html xmlns:v=3Durn:schemas-microsoft-com:vml =
xmlns:o=3Durn:schemas-microsoft-com:office:office =
xmlns:w=3Durn:schemas-microsoft-com:office:word =
xmlns:st1=3Durn:schemas-microsoft-com:office:smarttags =
xmlns=3Dhttp://www.w3.org/TR/REC-html40;
head
META HTTP-EQUIV=3DContent-Type CONTENT=3Dtext/html; =
charset=3Dus-ascii
meta name=3DProgId content=3DWord.Document
meta name=3DGenerator content=3DMicrosoft Word 10
meta name=3DOriginator content=3DMicrosoft Word 10
link rel=3DFile-List href=3Dcid:filelist.xml;01C27F2F.66CF0930
link rel=3DEdit-Time-Data href=3Dcid:editdata.mso;01C27F2F.66CF0930
!--[if !mso]
style
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
/style
![endif]--
titleWin2k Perl accessing Oracle Parameters?/title
o:SmartTagType =
namespaceuri=3Durn:schemas-microsoft-com:office:smarttags
name=3Ddate/
o:SmartTagType =
namespaceuri=3Durn:schemas-microsoft-com:office:smarttags
name=3Dtime/
o:SmartTagType =
namespaceuri=3Durn:schemas-microsoft-com:office:smarttags
name=3Dplace/
o:SmartTagType =
namespaceuri=3Durn:schemas-microsoft-com:office:smarttags
name=3DPostalCode/
o:SmartTagType =
namespaceuri=3Durn:schemas-microsoft-com:office:smarttags
name=3DCity/
!--[if gte mso 9]xml
o:OfficeDocumentSettings
o:DoNotRelyOnCSS/
/o:OfficeDocumentSettings
/xml![endif]--!--[if gte mso 9]xml
w:WordDocument
w:SpellingStateClean/w:SpellingState
w:GrammarStateClean/w:GrammarState
w:DocumentKindDocumentEmail/w:DocumentKind
w:EnvelopeVis/
Problem with Java/DBAStudio ??
Hi List, We have Oracle 8.1.7, SunOS 5.8, SunFire 280r. While using dbastudio and trying to add a database to the tree, no dialog box opened to allow this operation. I previously (some weeks before) have used dbastudio without any problems and have added several databases to the tree but this time no luck.I checked the output on the x-session window that was running dbastudio and the following information was displayed (please see below). I have asked out SA what has changed on our system and he says nothing ! (ie no patches, no different versions of java etc) I have trawled the web for some help on this but to no avail. If anyone has come across this problem before I would welcome any assistance. Thanks in advance, Ron. Output Information :- Exception occurred during event dispatching: java.lang.NullPointerException at java.text.CollationElementIterator init(CollationElementIterator.java:109) at java.text.RuleBasedCollator.compare(RuleBasedCollator.java:364) at oracle.sysman.vth.VthCredentialRegistry$CredentialRecord compare(VthCredentialRegistry.java:413) at oracle.sysman.vth.VthCredentialRegistry$RecordList compareWithMask(VthCredentialRegistry.java:436) at oracle.sysman.vxx.VxxSortedList.compare(VxxSortedList.java:172) at oracle.bali.share.sort.Search._bSearch(Search.java:88) at oracle.bali.share.sort.Search.bSearch(Search.java:31) at oracle.sysman.vxx.VxxSortedList.search(VxxSortedList.java:180) at oracle.sysman.vth.VthCredentialRegistry getDBCredential(VthCredentialRegistry.java:108) at oracle.sysman.vth.VthAddConnCmd._getAliasSrc(VthAddConnCmd java:429) at oracle.sysman.vth.VthAddConnCmd._createUI(VthAddConnCmd.java:320) at oracle.sysman.vth.VthAddConnCmd.run(VthAddConnCmd.java:129) at oracle.sysman.vth.VthCommandHandler _addDbConnection(VthCommandHandler.java:138) at oracle.sysman.vth.VthCommandHandler commandIssued(VthCommandHandler.java:106) at oracle.sysman.emSDK.client.guiComponent.commandAdapter ApplicationAdapter.commandIssued(ApplicationAdapter.java:172) at oracle.sysman.emSDK.client.guiComponent.commandAdapter SystemCommandAdapter.commandIssued(SystemCommandAdapter.java:105) at oracle.sysman.emSDK.client.guiComponent.commandAdapter CommandAdapter.actionPerformed(CommandAdapter.java:386) at oracle.sysman.emSDK.client.guiComponent.commandAdapter ApplicationAdapter.actionPerformed(ApplicationAdapter.java:187) at oracle.sysman.emSDK.client.guiComponent.commandAdapter SystemCommandAdapter.actionPerformed(SystemCommandAdapter.java:114) at oracle.ewt.lwAWT.lwMenu.LWMenuItem.processActionEvent(Unknown Source) at oracle.ewt.lwAWT.lwMenu.LWMenuItem.processEventImpl(Unknown Source) at oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source) at oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source) at oracle.ewt.lwAWT.lwMenu.LWMenuItem.activate(Unknown Source) at oracle.ewt.lwAWT.lwMenu.laf.VertMenuItemController mouseReleased(Unknown Source) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster java:228) at java.awt.Component.processMouseEvent(Component.java:2375) at oracle.sysman.vth.VthCommandHandler commandIssued(VthCommandHandler.java:106) at oracle.sysman.emSDK.client.guiComponent.commandAdapter ApplicationAdapter.commandIssued(ApplicationAdapter.java:172) at oracle.sysman.emSDK.client.guiComponent.commandAdapter SystemCommandAdapter.commandIssued(SystemCommandAdapter.java:105) at oracle.sysman.emSDK.client.guiComponent.commandAdapter CommandAdapter.actionPerformed(CommandAdapter.java:386) at oracle.sysman.emSDK.client.guiComponent.commandAdapter ApplicationAdapter.actionPerformed(ApplicationAdapter.java:187) at oracle.sysman.emSDK.client.guiComponent.commandAdapter SystemCommandAdapter.actionPerformed(SystemCommandAdapter.java:114) at oracle.ewt.lwAWT.lwMenu.LWMenuItem.processActionEvent(Unknown Source) at oracle.ewt.lwAWT.lwMenu.LWMenuItem.processEventImpl(Unknown Source) at oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source) at oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source) at oracle.ewt.lwAWT.lwMenu.LWMenuItem.activate(Unknown Source) at oracle.ewt.lwAWT.lwMenu.laf.VertMenuItemController mouseReleased(Unknown Source) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster java:228) at java.awt.Component.processMouseEvent(Component.java:2375) at oracle.sysman.vth.VthCommandHandler commandIssued(VthCommandHandler.java:106) at oracle.sysman.emSDK.client.guiComponent.commandAdapter ApplicationAdapter.commandIssued(ApplicationAdapter.java:172) at oracle.sysman.emSDK.client.guiComponent.commandAdapter SystemCommandAdapter.commandIssued(SystemCommandAdapter.java:105) at oracle.sysman.emSDK.client.guiComponent.commandAdapter CommandAdapter.actionPerformed(CommandAdapter.java:386) at oracle.sysman.emSDK.client.guiComponent.commandAdapter
Re: Oracle Internals course
Tom, I didn't mean to imply that you were going into damagement! I was lucky enough to have someone point me to seminars and figured I'd share my luck. I think the reason they don't publicize it is that he is the only one teaching it and it's full without publicizing. Can you imagine if they made it generally available? He'd have time to do nothing else! Rachel --- Tom Pall [EMAIL PROTECTED] wrote: Rachel, I'm not bucking for a management slot by being clueless about the details. Really I'm not. I registered online for the internals course by searching for it. I just kind of assumed from what Scott said that I just managed to luck out when I searched for the course and found it. I mistakenly assumed the course was quietly being removed from online registration after hearing Scott's statements about hiding and not publicizing the course. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 28, 2002 8:58 PM I registered for it online, at education.oracle.com you have to search on seminars, not classes. It's difficult to find, but it IS there --- Tom Pall [EMAIL PROTECTED] wrote: RE: Oracle Internals courseThat rumor's been going on for versions now. As has been Scott's desire to offer a two week internals course. Course participants would sign all sorts of non-disclosure forms then get a scaled down version of what's taught to Customer Support. Wait a minute! Customer Support takes these courses? Surely not all the Silver Support people I've called. A difficulty with a two week course is that the very DBAs most likely to benefit from the course are the ones least likely to be let free for two weeks. The internals course is slated to be yanked every time a new version of Oracle comes out. Why teach internals when there are no initialization parameters and the database maintains and tunes itself? There's been an economic downturn and Oracle DBAs have lost their jobs. But anybody know an Oracle DBA who lost his job because a later version doesn't require a DBA? Oracle on CDs 1,2 and 3, huh? I think if I dig enough I can find that old version of Oracle I had that came on a single diskette. Scott says the internals course is purposely hidden. You have to call Oracle directly and ask for it. A number of people registered for the course from the paper or online catalogs, showed up then complained that they weren't about to get anything out of the course.. - Original Message - From: Nick Wagner To: Multiple recipients of list ORACLE-L Sent: Monday, October 28, 2002 3:23 PM Subject: RE: Oracle Internals course rumor has it that this course is not going to be offered/modified for the 9.2 release of Oracle. Can anyone confirm or deny it? Nick p.s. Had a close friend take this class, and they also came back extremely pleased with it. -Original Message- From: Rachel Carmichael [mailto:wisernet100;yahoo.com] Sent: Monday, October 28, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Internals course Scott is the instructors's instructor he learns the new features, then teaches them to the instructors so they can teach them to you I had the pleasure of taking those classes with Scott a few years ago as well. He's a great teacher. If he is ever presenting at any conference you go to, GO SEE HIM --- Tom Pall [EMAIL PROTECTED] wrote: I took that very course with Scott a few years ago. Yup, Scott flies through the Internals and Dump/Traces courses with lots of extra material to spare. It's really refreshing to hear him tell the class how the developers documented something then tell how it's actually built. He keeps a database running in his notebook to prove what he says. Scott's one great teacher. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 28, 2002 12:53 PM I just wanted to say... If you have a chance to take the Oracle Internals course with Scott Gossett at Oracle, I highly recommend it. I wish I knew half of what he knows! The course isn't included in the OCP tracks, I think it should be given a higher profile though. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED]
Re: [Q] what kind of documents shoud contractor provide to me before
I suspect the contractor will only provide the documents all parties agreed to be delivered at completion. Deliverables are part of the contract and require a considerable amount of effort. If your company did not account for this my guess is to document it in your lessons learned. Mark Richard mrichard@transurb To: Multiple recipients of list ORACLE-L an.com.au[EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: [Q] what kind of documents shoud contractor provide to me before 10/28/2002 06:18 PM Please respond to ORACLE-L I agree with the others... Asking a contractor for a pile of documentation at the end of the project may or may not be well accepted... If he's paid by the hour he may not mind, if it was fixed price then he may develop a hearing problem. Having said that... If you do have the luxury of naming documents then I would suggest a capacity plan that includes both initial sizing and growth estimates broken down to a good level of detail. It amazing how often people don't even consider this when building an application with a tiny amount of test data. hth, Mark paquette stephane stephane_paquette@ To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] yahoo.comcc: Sent by: Subject: Re: [Q] what kind of documents shoud contractor provide to [EMAIL PROTECTED] me before project end? 29/10/2002 09:18 Please respond to ORACLE-L The list of documents should have been established before the contract was signed. A professionnal contractor would have told you that. The contractor must follow your methodology and give you the same documents as your internal IT teams. On the DBA side, you should expect : database architecture, logical data model, physical data model, naming convention, backup and recovery guide, security guide, a benchmarking document (if some benchmarking was done). --- dist cash [EMAIL PROTECTED] a écrit : We have a application use ORACLE 8.1.6 and Forms 6i. This project going to finish soon. Can anyone tell me what kind of documents should contractor provide to us before they leave? Thanks. _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: Oracle Internals course
Are these Internals classes only available in the US? -Original Message- Carmichael Sent: 29 October 2002 11:04 To: Multiple recipients of list ORACLE-L Subject:Re: Oracle Internals course Tom, I didn't mean to imply that you were going into damagement! I was lucky enough to have someone point me to seminars and figured I'd share my luck. I think the reason they don't publicize it is that he is the only one teaching it and it's full without publicizing. Can you imagine if they made it generally available? He'd have time to do nothing else! Rachel --- Tom Pall [EMAIL PROTECTED] wrote: Rachel, I'm not bucking for a management slot by being clueless about the details. Really I'm not. I registered online for the internals course by searching for it. I just kind of assumed from what Scott said that I just managed to luck out when I searched for the course and found it. I mistakenly assumed the course was quietly being removed from online registration after hearing Scott's statements about hiding and not publicizing the course. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 28, 2002 8:58 PM I registered for it online, at education.oracle.com you have to search on seminars, not classes. It's difficult to find, but it IS there --- Tom Pall [EMAIL PROTECTED] wrote: RE: Oracle Internals courseThat rumor's been going on for versions now. As has been Scott's desire to offer a two week internals course. Course participants would sign all sorts of non-disclosure forms then get a scaled down version of what's taught to Customer Support. Wait a minute! Customer Support takes these courses? Surely not all the Silver Support people I've called. A difficulty with a two week course is that the very DBAs most likely to benefit from the course are the ones least likely to be let free for two weeks. The internals course is slated to be yanked every time a new version of Oracle comes out. Why teach internals when there are no initialization parameters and the database maintains and tunes itself? There's been an economic downturn and Oracle DBAs have lost their jobs. But anybody know an Oracle DBA who lost his job because a later version doesn't require a DBA? Oracle on CDs 1,2 and 3, huh? I think if I dig enough I can find that old version of Oracle I had that came on a single diskette. Scott says the internals course is purposely hidden. You have to call Oracle directly and ask for it. A number of people registered for the course from the paper or online catalogs, showed up then complained that they weren't about to get anything out of the course.. - Original Message - From: Nick Wagner To: Multiple recipients of list ORACLE-L Sent: Monday, October 28, 2002 3:23 PM Subject: RE: Oracle Internals course rumor has it that this course is not going to be offered/modified for the 9.2 release of Oracle. Can anyone confirm or deny it? Nick p.s. Had a close friend take this class, and they also came back extremely pleased with it. -Original Message- From: Rachel Carmichael [mailto:wisernet100;yahoo.com] Sent: Monday, October 28, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Internals course Scott is the instructors's instructor he learns the new features, then teaches them to the instructors so they can teach them to you I had the pleasure of taking those classes with Scott a few years ago as well. He's a great teacher. If he is ever presenting at any conference you go to, GO SEE HIM --- Tom Pall [EMAIL PROTECTED] wrote: I took that very course with Scott a few years ago. Yup, Scott flies through the Internals and Dump/Traces courses with lots of extra material to spare. It's really refreshing to hear him tell the class how the developers documented something then tell how it's actually built. He keeps a database running in his notebook to prove what he says. Scott's one great teacher. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 28, 2002 12:53 PM I just wanted to say... If you have a chance to take the Oracle Internals course with Scott Gossett at Oracle, I highly recommend it. I wish I knew half of what he knows! The course isn't included in the OCP tracks, I think it should be given a higher profile though. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology
RE: Scheduling software
Try BMC 's Control-M Thanks -Original Message- Sent: Friday, October 25, 2002 11:34 PM To: Multiple recipients of list ORACLE-L To ALL, About a week ago I asked if anyone had an opinion of CA's AutoSys product. Thanks to those who replied, but that was a pretty SMALL number. Therefore the boss is asking what product(s) are the most used, especially in a PeopleSoft environment where jobs have dependencies on each other. OH, BTW the why would also be appreciated. Thanks in advance. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anthony, Baiju INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: List of Rows Updated
Title: RE: List of Rows Updated Auditing is much simpler and usable than logminer for *this purpose*. 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! -Original Message- From: Tom Pall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 29, 2002 1:39 AM To: Multiple recipients of list ORACLE-L Subject: Re: List of Rows Updated Logminer comes to mind. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 28, 2002 10:23 PM Hi, I want to get the list of rows which were updated(then commited) in a particular table say X on a specific date e.g yesterday. Is this possible and how ? Thanks Manoj. *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
[no subject]
Hi, I've installed Application Server Infrastructure 9i Release 2, but i skipped the configuration assistants. The Enterprise Manager Console doesn't discover the Oracle HTTP Server even if was started with the dcmctl utility. Are there configuration tools that configure the HTTP server and integrate it with the other components? Levente Bodrogi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Levente Bodrogi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: oracle or mssql
List, I'm always keen to refresh on database comparisons so thanks for everyone's pointers. I'm surprised Oracle doesn't make more of an issue about their locking and concurrency methods (i.e. redo/rollback/undo). MSSQL seems to deal with it in two ways: Default: readers and writers prevent writers from accessing data until they are finished with it! Other method: no control, you just get dirty reads! Anyone got anything to add to this? Or am I wrong? - Mike. -Original Message- Sent: 24 October 2002 17:29 To: Multiple recipients of list ORACLE-L As I said, use mssql ONLY if your boss is willing to be strapped into a MicroSlop only platform. If he's even remotely thinking of using a different OS then you can't use mssql. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 10/23/2002 11:48 PM goodmorning everybody who responded to my basic question : thanks summary professional : use oracle enterprise edition semi professional : use oracle standard edition / mssql enterprise edition in all other cases mssql standard edition -Oorspronkelijk bericht- Van: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]] Verzonden:woensdag 23 oktober 2002 20:51 Aan: Multiple recipients of list ORACLE-L Onderwerp:RE: oracle or mssql Xenix is history now...SCO itself stopped it sometime in 1990 Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 23 Oct 2002 09:02:19 -0800 XENIX maybe. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 23, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Is MSSQL server available on UNIX? -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get faster connections -- switch to MSN Internet Access! http://resourcecenter.msn.com/access/plans/default.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City
Re: Re: 9iR1 vs 9iR2 ?
We had to decide the same thing. As soon as I saw that support is down in 9 months I decided to go with 9.2. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 3:53 AM Thanx Joe. let me think about it. Jp. On Mon, 28 Oct 2002 Joe Testa wrote : based on metalink note, first level of support for 9ir1 ends 6/30/2003. you decide. joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Installing iAS 9.0.2.0.1
made the same experiences with iAS 92 and ended up using 9iAS 1.0.2.2 for various reasons. but we will try again, when oracle - hopefully - does provide a more comfortable way of installation. we use portal, single sign on in connection with novel ldap. was quite a toil to get it up and running but now it works fine. did the same with iAS 9.2.0 but response time and performance were horrible so we removed it again and ...see above. good luck [EMAIL PROTECTED] 10/28/02 16:42 PM If you only want it to do web apps it's not a problem. We installed the OC4J and web cache portion on Solaris in an hour. Very easy. Needed it for version 1.3 of Java. Next we will tackle the full install with the infrastructure which will allow the use of Portal, Reports and Discoverer. Expecting big time headaches based on the documentation and the fact that we want to use iPlanet not the OID for our LDAP. Ben -Original Message- [EMAIL PROTECTED] Sent: October 25, 2002 3:56 PM To: Multiple recipients of list ORACLE-L Gene, We tried it on HPUX and it was not pretty. We ended up going back to 9iAS 1.0.2.2 for various reasons. Good luck. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Gene Sais [SMTP:[EMAIL PROTECTED]] Sent: Friday, October 25, 2002 2:34 PM To: Multiple recipients of list ORACLE-L Subject: Installing iAS 9.0.2.0.1 Has anyone installed iAS 9.0.2.0.1 on Intel Linux? I have downloaded the reams of documentation and this is a beast, much different than OAS 4.0.8. It requires a 9i db, Oracle Single SignOn, OID, OEM Server, 9i Listener w/ port 1521 free for iAS, etc. So many dependencies for iAS and I haven't even looked at deploying forms yet :). I can't wait til 10i when DBA's are no longer required, *HA!* Gene -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Internals course
Back in 1999, I taught the 8.0 version of these seminars in Venezuela and Argentina and was scheduled to do so in Columbia as well, except for some minor problems like a US State Department travel warning due to kidnapping of US citizens. I don't know if they ever tried to teach these in more obscure places like the UK and Europe, but since they were compiled by a guy in Oracle Netherlands, it is quite probable. I'm guessing that if the request was made in sufficient numbers, then it could be arranged, if its not already hidden somewhere on the website? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 4:58 AM Are these Internals classes only available in the US? -Original Message- Carmichael Sent: 29 October 2002 11:04 To: Multiple recipients of list ORACLE-L Tom, I didn't mean to imply that you were going into damagement! I was lucky enough to have someone point me to seminars and figured I'd share my luck. I think the reason they don't publicize it is that he is the only one teaching it and it's full without publicizing. Can you imagine if they made it generally available? He'd have time to do nothing else! Rachel --- Tom Pall [EMAIL PROTECTED] wrote: Rachel, I'm not bucking for a management slot by being clueless about the details. Really I'm not. I registered online for the internals course by searching for it. I just kind of assumed from what Scott said that I just managed to luck out when I searched for the course and found it. I mistakenly assumed the course was quietly being removed from online registration after hearing Scott's statements about hiding and not publicizing the course. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 28, 2002 8:58 PM I registered for it online, at education.oracle.com you have to search on seminars, not classes. It's difficult to find, but it IS there --- Tom Pall [EMAIL PROTECTED] wrote: RE: Oracle Internals courseThat rumor's been going on for versions now. As has been Scott's desire to offer a two week internals course. Course participants would sign all sorts of non-disclosure forms then get a scaled down version of what's taught to Customer Support. Wait a minute! Customer Support takes these courses? Surely not all the Silver Support people I've called. A difficulty with a two week course is that the very DBAs most likely to benefit from the course are the ones least likely to be let free for two weeks. The internals course is slated to be yanked every time a new version of Oracle comes out. Why teach internals when there are no initialization parameters and the database maintains and tunes itself? There's been an economic downturn and Oracle DBAs have lost their jobs. But anybody know an Oracle DBA who lost his job because a later version doesn't require a DBA? Oracle on CDs 1,2 and 3, huh? I think if I dig enough I can find that old version of Oracle I had that came on a single diskette. Scott says the internals course is purposely hidden. You have to call Oracle directly and ask for it. A number of people registered for the course from the paper or online catalogs, showed up then complained that they weren't about to get anything out of the course.. - Original Message - From: Nick Wagner To: Multiple recipients of list ORACLE-L Sent: Monday, October 28, 2002 3:23 PM Subject: RE: Oracle Internals course rumor has it that this course is not going to be offered/modified for the 9.2 release of Oracle. Can anyone confirm or deny it? Nick p.s. Had a close friend take this class, and they also came back extremely pleased with it. -Original Message- From: Rachel Carmichael [mailto:wisernet100;yahoo.com] Sent: Monday, October 28, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Internals course Scott is the instructors's instructor he learns the new features, then teaches them to the instructors so they can teach them to you I had the pleasure of taking those classes with Scott a few years ago as well. He's a great teacher. If he is ever presenting at any conference you go to, GO SEE HIM --- Tom Pall [EMAIL PROTECTED] wrote: I took that very course with Scott a few years ago. Yup, Scott flies through the Internals and Dump/Traces courses with lots of extra material to spare. It's really refreshing to hear him tell the class how the developers documented something then tell how it's actually built. He keeps a database running in his notebook to prove what he says. Scott's one great teacher. - Original Message -
sqlplus /nolog
Title: sqlplus /nolog Hi! I was wondering what sqlplus /nolog actually does on Unix? Is it only used for not listing username/password when doing a ps ? Or anything else? This is 8.1.7 on Sun Solaris. Thanks, Helmut
variables in reports
hello to everybody has somebody ever had the problem of accessing a variable in reports - need one that i can store a value on, retrieve a value from, that is accessible globally and can be displayed in the body part, regardless of frequency of group by's ecc. - something like a user parameter but without the ugly side effect of appearing every time the report is invoked. kr mrr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: BLOB Storage
I have a 1tb db w/ 95% of it inline blobs, same tbs as data. No performance degradation. However, if I were to do it again, I would have separated the blobs out as B/R is a nightmare, soon to be better w/ RMAN. I haven't received my RF RMAN book yet, amazon must be backfilling orders. hth, Gene [EMAIL PROTECTED] 10/28/02 09:18PM We've got a table with a BLOB column that is currently at 3+ Gig (400,000 records). The max value in the BLOB column is 3k (average (1.5 K). We are currently storing the BLOB out of line (in a separate tablespace). The cache size for the BLOB is 8k (also the block size). Each BLOB is taking up 8K (at the least twice the space required by the BLOB). This table is expected to grow to 10+ million records in the next year. First of all, we're trying to convince the vendor to agree to partition the table. In addition (FINALLY the question :-) !!!), we're trying to decide whether we would gain anything (space being a constraint right now), from a storage standpoint in making the BLOB in line. Obviously we're not going to going to risk performance in order to save space :-) !!! I'm hoping someone in this list would have had some goog or bad experience in this regard. Would there be a major performance hit if I change the BLOB to be in line Thanks, Sunny - Do you Yahoo!? Y! Web Hosting - Let the expert host your web site -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Internals course
No I have given them for Oracle in Holland, Belgium, Norway, Singapore and Malaysia. Anjo. -Original Message- Sent: Tuesday, October 29, 2002 12:58 PM To: Multiple recipients of list ORACLE-L Are these Internals classes only available in the US? -Original Message- Carmichael Sent: 29 October 2002 11:04 To: Multiple recipients of list ORACLE-L Subject:Re: Oracle Internals course Tom, I didn't mean to imply that you were going into damagement! I was lucky enough to have someone point me to seminars and figured I'd share my luck. I think the reason they don't publicize it is that he is the only one teaching it and it's full without publicizing. Can you imagine if they made it generally available? He'd have time to do nothing else! Rachel --- Tom Pall [EMAIL PROTECTED] wrote: Rachel, I'm not bucking for a management slot by being clueless about the details. Really I'm not. I registered online for the internals course by searching for it. I just kind of assumed from what Scott said that I just managed to luck out when I searched for the course and found it. I mistakenly assumed the course was quietly being removed from online registration after hearing Scott's statements about hiding and not publicizing the course. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 28, 2002 8:58 PM I registered for it online, at education.oracle.com you have to search on seminars, not classes. It's difficult to find, but it IS there --- Tom Pall [EMAIL PROTECTED] wrote: RE: Oracle Internals courseThat rumor's been going on for versions now. As has been Scott's desire to offer a two week internals course. Course participants would sign all sorts of non-disclosure forms then get a scaled down version of what's taught to Customer Support. Wait a minute! Customer Support takes these courses? Surely not all the Silver Support people I've called. A difficulty with a two week course is that the very DBAs most likely to benefit from the course are the ones least likely to be let free for two weeks. The internals course is slated to be yanked every time a new version of Oracle comes out. Why teach internals when there are no initialization parameters and the database maintains and tunes itself? There's been an economic downturn and Oracle DBAs have lost their jobs. But anybody know an Oracle DBA who lost his job because a later version doesn't require a DBA? Oracle on CDs 1,2 and 3, huh? I think if I dig enough I can find that old version of Oracle I had that came on a single diskette. Scott says the internals course is purposely hidden. You have to call Oracle directly and ask for it. A number of people registered for the course from the paper or online catalogs, showed up then complained that they weren't about to get anything out of the course.. - Original Message - From: Nick Wagner To: Multiple recipients of list ORACLE-L Sent: Monday, October 28, 2002 3:23 PM Subject: RE: Oracle Internals course rumor has it that this course is not going to be offered/modified for the 9.2 release of Oracle. Can anyone confirm or deny it? Nick p.s. Had a close friend take this class, and they also came back extremely pleased with it. -Original Message- From: Rachel Carmichael [mailto:wisernet100;yahoo.com] Sent: Monday, October 28, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Internals course Scott is the instructors's instructor he learns the new features, then teaches them to the instructors so they can teach them to you I had the pleasure of taking those classes with Scott a few years ago as well. He's a great teacher. If he is ever presenting at any conference you go to, GO SEE HIM --- Tom Pall [EMAIL PROTECTED] wrote: I took that very course with Scott a few years ago. Yup, Scott flies through the Internals and Dump/Traces courses with lots of extra material to spare. It's really refreshing to hear him tell the class how the developers documented something then tell how it's actually built. He keeps a database running in his notebook to prove what he says. Scott's one great teacher. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 28, 2002 12:53 PM I just wanted to say... If you have a chance to take the Oracle Internals course with Scott Gossett at Oracle, I highly recommend it. I wish I knew half of what he knows! The course isn't included in the OCP tracks, I think it should be given a
RE: Convert DM TSP to LM TSP w/ lots of data
Govind - I agree with Tom. Since you phrased your original question asking for those who had done the conversion, the silence was your answer. If you had also asked for replies from those who had decided to build new tablespaces and convert the data ourselves, then more of us could have replied. My reason for not using the conversion utility has to do with the smell test. After you've been a DBA for awhile, you realize you have limited time and you lose your eagerness to pursue things that will eat up enormous amounts of time and come to nothing. In my situation, I was able to move a table at a time to LMT as time permitted, and somehow I felt that the resulting data situation would be better. I believe some of the new nologging options may allow you to perform this while the table is still available for DML. When first introduced, the conversion routines had some bugs. I don't think the conversion routines are bad today, so they may work just fine. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 29, 2002 12:34 AM To: Multiple recipients of list ORACLE-L I tried having Oracle convert DMT to LMT out a few times on 10 GB tablespaces. Whether or not that's a lot of data depends on you. Worked like a champ. And this was in the early days of LMT. People who pay a lot of attention to the internals will warn you that converting a DMT to LMT is not optimal. Your bitmaps wind up at the end of the files instead of the headers. I've read posts here and elsewhere where people worried about the same issues as they did with DMT. They wanted to limit the number of extents segments grew to by creating tablespaces with different sized fixed extents. A DBA I worked with pointed out how very easy and quickly things worked with letting Oracle automatically size the next extent. I've gone that way whenever possible and have never regretted it. I've not done a rigorous benchmark but can tell you from casual observation dropping an object with lots of extents doesn't happen in the blink of an eye but doesn't lock out all other space allocation as UET/FET weren't constantly in use and the ST enque wasn't locked for exclusive use. It's prudent to follow Oracle's recommendations if conditions permit. Create a new LMT and move your data to it. - Original Message - To: Multiple mailto:ORACLE-L;fatcity.com recipients of list ORACLE-L Sent: Monday, October 28, 2002 8:43 PM I am reposting this. Has anyone tried to convert a dictionary managed table space containing lots of data to locally managed? We have tried this out successfully on empty table spaces or created a new LMT tablespace and moved the existing objects to it. Thanks, Govind -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Table Size
The best way to calculate the size of a table is to load it with 1000 production data rows. Then calculate the size of the predicted volume. You should be able to handle the first year of data at day 1. Do not loose time to calculate the table size at the byte level with formulas. For the temp tablespace, it depends on your application needs. You should be able to rebuild all objects successfully. As for the rollback segment tablespace, then again it depends on your application and number of users. Do not forget space for exports, backups, workspace, at least 2 versions of Oracle software, ... I just went to a DB2 fast track for experienced DBA. According to IBM, the total size for the DB environment is 4 times the size of the data in the DB. (DB2 uses a lot of temporary files outside the DB). --- [EMAIL PROTECTED] a écrit : Dear List, I am using Oracle 9i database. I need to identify the space requirements for our database for the production database. Can anybody suggest how to calculate the size of a table. and also additionally how to calculate the size of the whole database.? Regards Prem = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Implicit Date conversion problem
Title: Implicit Date conversion problem
We have a query (please don't ask me why it is written this way)
--Doesn't work:
select ea1.ep_number, ea1.est_dt, veas.est_dt
from (select a.ep_number, ea.est_dt
from v_episode_avail_summary_break a, episode_airings ea
where a.ep_number = ea.ep_number
and ea.est_dt between '20-Dec-02' and '01-Jan-03'
group by a.ep_number, ea.est_dt) veas,
episode_airings ea1
where veas.ep_number = ea1.ep_number
and ea1.est_dt between '20-Dec-02' and '01-Jan-03'
vs.
--Works:
select ea1.ep_number, ea1.est_dt, veas.est_dt
from (select a.ep_number, ea.est_dt
from v_episode_avail_summary_break a, episode_airings ea
where a.ep_number = ea.ep_number
and ea.est_dt between '20-Dec-02' and '01-Jan-03'
group by a.ep_number, ea.est_dt) veas,
episode_airings ea1
where veas.ep_number = ea1.ep_number
and ea1.est_dt between trunc(to_date('20-Dec-02','DD-Mon-YY'))
and trunc(to_date('01-Jan-03','DD-Mon-YY'))
Also if we comment and ea1.est_dt between '20-Dec-02' and '01-Jan-03' the non-working query runs fine.
Does anyone know what could be wrong? The est_dt is a date column. This is 9201 ...
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!
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.*2
Re: SPARC-III v Alpha
Thanks for the link ! Hemant At 06:33 AM 28-10-02 -0800, you wrote: Hemant K Chitale wrote: Does anyone have benchmark or comparative figures for Sun SPARC v Compaq (thenewhp) Alpha for Oracle Databases ? I found some benchmark figures for Datawarehouses at the Oracle website but not for OLTP [then again, the machines configured for those benchmarks were extra-large machines !]. Hemant K Chitale My web site page is : http://hkchital.tripod.com Perhaps that http://www.tpc.org/tpcc/results/tpcc_results.asp?orderby=hardware can help ? -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Internals course
that I know of yes unfortunately, because I believe Scott is the only one teaching the classes. Is there a separate and distinct Oracle education site for the UK and Europe? Rachel --- Mark Leith [EMAIL PROTECTED] wrote: Are these Internals classes only available in the US? -Original Message- Carmichael Sent: 29 October 2002 11:04 To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Internals course Tom, I didn't mean to imply that you were going into damagement! I was lucky enough to have someone point me to seminars and figured I'd share my luck. I think the reason they don't publicize it is that he is the only one teaching it and it's full without publicizing. Can you imagine if they made it generally available? He'd have time to do nothing else! Rachel --- Tom Pall [EMAIL PROTECTED] wrote: Rachel, I'm not bucking for a management slot by being clueless about the details. Really I'm not. I registered online for the internals course by searching for it. I just kind of assumed from what Scott said that I just managed to luck out when I searched for the course and found it. I mistakenly assumed the course was quietly being removed from online registration after hearing Scott's statements about hiding and not publicizing the course. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 28, 2002 8:58 PM I registered for it online, at education.oracle.com you have to search on seminars, not classes. It's difficult to find, but it IS there --- Tom Pall [EMAIL PROTECTED] wrote: RE: Oracle Internals courseThat rumor's been going on for versions now. As has been Scott's desire to offer a two week internals course. Course participants would sign all sorts of non-disclosure forms then get a scaled down version of what's taught to Customer Support. Wait a minute! Customer Support takes these courses? Surely not all the Silver Support people I've called. A difficulty with a two week course is that the very DBAs most likely to benefit from the course are the ones least likely to be let free for two weeks. The internals course is slated to be yanked every time a new version of Oracle comes out. Why teach internals when there are no initialization parameters and the database maintains and tunes itself? There's been an economic downturn and Oracle DBAs have lost their jobs. But anybody know an Oracle DBA who lost his job because a later version doesn't require a DBA? Oracle on CDs 1,2 and 3, huh? I think if I dig enough I can find that old version of Oracle I had that came on a single diskette. Scott says the internals course is purposely hidden. You have to call Oracle directly and ask for it. A number of people registered for the course from the paper or online catalogs, showed up then complained that they weren't about to get anything out of the course.. - Original Message - From: Nick Wagner To: Multiple recipients of list ORACLE-L Sent: Monday, October 28, 2002 3:23 PM Subject: RE: Oracle Internals course rumor has it that this course is not going to be offered/modified for the 9.2 release of Oracle. Can anyone confirm or deny it? Nick p.s. Had a close friend take this class, and they also came back extremely pleased with it. -Original Message- From: Rachel Carmichael [mailto:wisernet100;yahoo.com] Sent: Monday, October 28, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Internals course Scott is the instructors's instructor he learns the new features, then teaches them to the instructors so they can teach them to you I had the pleasure of taking those classes with Scott a few years ago as well. He's a great teacher. If he is ever presenting at any conference you go to, GO SEE HIM --- Tom Pall [EMAIL PROTECTED] wrote: I took that very course with Scott a few years ago. Yup, Scott flies through the Internals and Dump/Traces courses with lots of extra material to spare. It's really refreshing to hear him tell the class how the developers documented something then tell how it's actually built. He keeps a database running in his notebook to prove what he says. Scott's one great teacher. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 28, 2002 12:53 PM I just wanted to say... If you have a chance to take the Oracle Internals course with Scott Gossett at
RE: Oracle Internals course
Any idea about the chances in INDIA? Regards Naveen -Original Message- Sent: Tuesday, October 29, 2002 6:39 PM To: Multiple recipients of list ORACLE-L Back in 1999, I taught the 8.0 version of these seminars in Venezuela and Argentina and was scheduled to do so in Columbia as well, except for some minor problems like a US State Department travel warning due to kidnapping of US citizens. I don't know if they ever tried to teach these in more obscure places like the UK and Europe, but since they were compiled by a guy in Oracle Netherlands, it is quite probable. I'm guessing that if the request was made in sufficient numbers, then it could be arranged, if its not already hidden somewhere on the website? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 4:58 AM Are these Internals classes only available in the US? -Original Message- Carmichael Sent: 29 October 2002 11:04 To: Multiple recipients of list ORACLE-L Tom, I didn't mean to imply that you were going into damagement! I was lucky enough to have someone point me to seminars and figured I'd share my luck. I think the reason they don't publicize it is that he is the only one teaching it and it's full without publicizing. Can you imagine if they made it generally available? He'd have time to do nothing else! Rachel --- Tom Pall [EMAIL PROTECTED] wrote: Rachel, I'm not bucking for a management slot by being clueless about the details. Really I'm not. I registered online for the internals course by searching for it. I just kind of assumed from what Scott said that I just managed to luck out when I searched for the course and found it. I mistakenly assumed the course was quietly being removed from online registration after hearing Scott's statements about hiding and not publicizing the course. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 28, 2002 8:58 PM I registered for it online, at education.oracle.com you have to search on seminars, not classes. It's difficult to find, but it IS there --- Tom Pall [EMAIL PROTECTED] wrote: RE: Oracle Internals courseThat rumor's been going on for versions now. As has been Scott's desire to offer a two week internals course. Course participants would sign all sorts of non-disclosure forms then get a scaled down version of what's taught to Customer Support. Wait a minute! Customer Support takes these courses? Surely not all the Silver Support people I've called. A difficulty with a two week course is that the very DBAs most likely to benefit from the course are the ones least likely to be let free for two weeks. The internals course is slated to be yanked every time a new version of Oracle comes out. Why teach internals when there are no initialization parameters and the database maintains and tunes itself? There's been an economic downturn and Oracle DBAs have lost their jobs. But anybody know an Oracle DBA who lost his job because a later version doesn't require a DBA? Oracle on CDs 1,2 and 3, huh? I think if I dig enough I can find that old version of Oracle I had that came on a single diskette. Scott says the internals course is purposely hidden. You have to call Oracle directly and ask for it. A number of people registered for the course from the paper or online catalogs, showed up then complained that they weren't about to get anything out of the course.. - Original Message - From: Nick Wagner To: Multiple recipients of list ORACLE-L Sent: Monday, October 28, 2002 3:23 PM Subject: RE: Oracle Internals course rumor has it that this course is not going to be offered/modified for the 9.2 release of Oracle. Can anyone confirm or deny it? Nick p.s. Had a close friend take this class, and they also came back extremely pleased with it. -Original Message- From: Rachel Carmichael [mailto:wisernet100;yahoo.com] Sent: Monday, October 28, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Internals course Scott is the instructors's instructor he learns the new features, then teaches them to the instructors so they can teach them to you I had the pleasure of taking those classes with Scott a few years ago as well. He's a great teacher. If he is ever presenting at any conference you go to, GO SEE HIM --- Tom Pall [EMAIL PROTECTED] wrote: I took that very course with Scott a few years ago. Yup, Scott flies through the Internals and Dump/Traces courses with lots of extra material to spare. It's really refreshing to hear him tell the class how the developers documented something then tell how it's actually
RE: SPARC-III v Alpha
As a Consultant in a previous life I had done installations and upgrades
on various *nixs. I did think that Alpha and HP PA-RISC were better
than SPARC.
In this current organisation [as an internal DBA], about 66% of the
larger databases are on Alpha and the rest on SPARC. Again, I get
the gut-feeling that Alpha is better.
Next week we'll be benchmarking a database that is going from Wintel
to either Alpha or SPARC. As an organisation, I think we are looking
at balancing between SPARC and Alpha so I will be seeing more
Sun servers running Oracle here. But there's no talk of HP PA-RISC
or Itanium yet !!
Regards
Hemant
At 07:28 AM 28-10-02 -0800, you wrote:
The whole point is a bit moot now that Alpha is a dead platform.
Compaq sold the Alpha technology to Intel. As far as HP's continued support
for Alpha, consider that HP is in a VERY competitive business; Unix makes up
only a small part of its bottom line; and it is currently sitting on three
Unix platforms: The old HP/UX boxes; the (supposed) new Itanium platform (so
they say, but I remain skeptical); and the Alpha platform that it inherited.
Even if Carly herself walked in and swore up and down that HP will continue
to support the Alpha, I would insist that there is no way HP is going to
commit resources to supporting three Unix platforms. Right now, I think HP
is busy holding its finger to the wind and actively consulting The Magic 8
Ball and a Ouija board to determine its future Unix direction.
We use Alpha here. I came to this shop from a predominantly Sun/Aix
environment. I can say that Compaq's handling of the Alpha/Tru64 platform
make it the only version of Unix that makes NT look good. My opinion is --
and this is just an opinion -- that any performance enhancements that were
achieved by the Compaq bunch were done so in the same way you would do it
with your PC: Overclock the bejeezus out of everything with the
accompanying reduction of stability and component life. I am convinced that
the latest Alpha technology is three year old tweaking of five year old
Alpha technology.
(Hope I didn't scuff up the soap box too much.)
And as long as I am at it here:
ps -eo args | nawk -F_ 'NF == 3 /ora_smon_/ {print $3}'
-Original Message-
From: Hemant K Chitale [mailto:hkchital;singnet.com.sg]
Sent: Monday, October 28, 2002 8:19 AM
To: Multiple recipients of list ORACLE-L
Subject: SPARC-III v Alpha
Does anyone have benchmark or comparative figures for Sun
SPARC v Compaq
(thenewhp) Alpha
for Oracle Databases ? I found some benchmark figures for
Datawarehouses
at the
Oracle website but not for OLTP [then again, the machines
configured for those
benchmarks were extra-large machines !].
Hemant K Chitale
My web site page is : http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hemant K Chitale
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
My web site page is : http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hemant K Chitale
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: Oracle Internals course
Title: Message It is just me or does 500-2000 per day seem a little "steep"? Oracle8i: Everything You Always Wanted to Know about the Optimizer Instructor-Led inClass US$ 500 1 Day English English OR INTRODUCTION TO ORACLE9I: SQL (ILT) BLOOMFIELD, CT 02-DEC-02 US$2000 Remove from Shopping Cart INTRODUCTION TO ORACLE 8I: SQL AND PL/SQL (ILT) BLOOMFIELD, CT 17-FEB-03 US$2000 Remove from Shopping Cart ADVANCED PL/SQL (ILT) BLOOMFIELD, CT 07-NOV-02 US$1000 Remove from Shopping Cart
RE: Oracle Internals course
Tim, Do you mean this Scott Gosset is working here in the Netherlands or used to be? Any idea about these courses in the Netherlands? I can always call Oracle support here but I doubt if they know about it. Tia, Jeroen -Oorspronkelijk bericht- Van: Tim Gorman [mailto:Tim;SageLogix.com] Verzonden: dinsdag 29 oktober 2002 14:09 Aan: Multiple recipients of list ORACLE-L Onderwerp: Re: Oracle Internals course Back in 1999, I taught the 8.0 version of these seminars in Venezuela and Argentina and was scheduled to do so in Columbia as well, except for some minor problems like a US State Department travel warning due to kidnapping of US citizens. I don't know if they ever tried to teach these in more obscure places like the UK and Europe, but since they were compiled by a guy in Oracle Netherlands, it is quite probable. I'm guessing that if the request was made in sufficient numbers, then it could be arranged, if its not already hidden somewhere on the website? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 4:58 AM Are these Internals classes only available in the US? -Original Message- Carmichael Sent: 29 October 2002 11:04 To: Multiple recipients of list ORACLE-L Tom, I didn't mean to imply that you were going into damagement! I was lucky enough to have someone point me to seminars and figured I'd share my luck. I think the reason they don't publicize it is that he is the only one teaching it and it's full without publicizing. Can you imagine if they made it generally available? He'd have time to do nothing else! Rachel --- Tom Pall [EMAIL PROTECTED] wrote: Rachel, I'm not bucking for a management slot by being clueless about the details. Really I'm not. I registered online for the internals course by searching for it. I just kind of assumed from what Scott said that I just managed to luck out when I searched for the course and found it. I mistakenly assumed the course was quietly being removed from online registration after hearing Scott's statements about hiding and not publicizing the course. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 28, 2002 8:58 PM I registered for it online, at education.oracle.com you have to search on seminars, not classes. It's difficult to find, but it IS there --- Tom Pall [EMAIL PROTECTED] wrote: RE: Oracle Internals courseThat rumor's been going on for versions now. As has been Scott's desire to offer a two week internals course. Course participants would sign all sorts of non-disclosure forms then get a scaled down version of what's taught to Customer Support. Wait a minute! Customer Support takes these courses? Surely not all the Silver Support people I've called. A difficulty with a two week course is that the very DBAs most likely to benefit from the course are the ones least likely to be let free for two weeks. The internals course is slated to be yanked every time a new version of Oracle comes out. Why teach internals when there are no initialization parameters and the database maintains and tunes itself? There's been an economic downturn and Oracle DBAs have lost their jobs. But anybody know an Oracle DBA who lost his job because a later version doesn't require a DBA? Oracle on CDs 1,2 and 3, huh? I think if I dig enough I can find that old version of Oracle I had that came on a single diskette. Scott says the internals course is purposely hidden. You have to call Oracle directly and ask for it. A number of people registered for the course from the paper or online catalogs, showed up then complained that they weren't about to get anything out of the course.. - Original Message - From: Nick Wagner To: Multiple recipients of list ORACLE-L Sent: Monday, October 28, 2002 3:23 PM Subject: RE: Oracle Internals course rumor has it that this course is not going to be offered/modified for the 9.2 release of Oracle. Can anyone confirm or deny it? Nick p.s. Had a close friend take this class, and they also came back extremely pleased with it. -Original Message- From: Rachel Carmichael [mailto:wisernet100;yahoo.com] Sent: Monday, October 28, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Internals course Scott is the instructors's instructor he learns the new features, then teaches them to the instructors so they can teach them to you I had the pleasure of taking those classes with Scott a few years ago as well. He's a great teacher. If he is ever presenting at any conference you go to, GO SEE HIM --- Tom Pall [EMAIL PROTECTED] wrote: I took that very course with Scott a few years ago.
Re: sqlplus /nolog
Title: sqlplus /nolog It opens up a sqlplus session session/shell on the server without logging into a database. The 9i version of sqlplus does not allow for a command line: sqlplus / as sysdba command. You have to login to sqlplus and when prompted for the username then add / as sysdba. The /nolog allows you to script running sqlplus and then having the connect / as sysdba as the first line in your sqlscript ie: sqlplus /nolog @myscript.sql myscript.sql: connect / as sysdba select name from v$database; Rodd On Tue, 2002-10-29 at 07:29, Daiminger, Helmut wrote: Hi! I was wondering what sqlplus /nolog actually does on Unix? Is it only used for not listing username/password when doing a ps ? Or anything else? This is 8.1.7 on Sun Solaris. Thanks, Helmut -- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED]
RE: Oracle Internals course
Actually, he isn't. There is another guy, named Scott Heisey, who teaches an OPS/RAC version of this course. He is also supposed to be one of the great sages of the Oracle Corp. I've attended Scott Gossett's course and it was fabulous. I've only heard about Scott Heisey and it is my great wish to go to his course. -Original Message- From: Rachel Carmichael [mailto:wisernet100;yahoo.com] Sent: Tuesday, October 29, 2002 8:24 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Internals course that I know of yes unfortunately, because I believe Scott is the only one teaching the classes. Is there a separate and distinct Oracle education site for the UK and Europe? Rachel --- Mark Leith [EMAIL PROTECTED] wrote: Are these Internals classes only available in the US? -Original Message- Carmichael Sent: 29 October 2002 11:04 To: Multiple recipients of list ORACLE-L Subject:Re: Oracle Internals course Tom, I didn't mean to imply that you were going into damagement! I was lucky enough to have someone point me to seminars and figured I'd share my luck. I think the reason they don't publicize it is that he is the only one teaching it and it's full without publicizing. Can you imagine if they made it generally available? He'd have time to do nothing else! Rachel --- Tom Pall [EMAIL PROTECTED] wrote: Rachel, I'm not bucking for a management slot by being clueless about the details. Really I'm not. I registered online for the internals course by searching for it. I just kind of assumed from what Scott said that I just managed to luck out when I searched for the course and found it. I mistakenly assumed the course was quietly being removed from online registration after hearing Scott's statements about hiding and not publicizing the course. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 28, 2002 8:58 PM I registered for it online, at education.oracle.com you have to search on seminars, not classes. It's difficult to find, but it IS there --- Tom Pall [EMAIL PROTECTED] wrote: RE: Oracle Internals courseThat rumor's been going on for versions now. As has been Scott's desire to offer a two week internals course. Course participants would sign all sorts of non-disclosure forms then get a scaled down version of what's taught to Customer Support. Wait a minute! Customer Support takes these courses? Surely not all the Silver Support people I've called. A difficulty with a two week course is that the very DBAs most likely to benefit from the course are the ones least likely to be let free for two weeks. The internals course is slated to be yanked every time a new version of Oracle comes out. Why teach internals when there are no initialization parameters and the database maintains and tunes itself? There's been an economic downturn and Oracle DBAs have lost their jobs. But anybody know an Oracle DBA who lost his job because a later version doesn't require a DBA? Oracle on CDs 1,2 and 3, huh? I think if I dig enough I can find that old version of Oracle I had that came on a single diskette. Scott says the internals course is purposely hidden. You have to call Oracle directly and ask for it. A number of people registered for the course from the paper or online catalogs, showed up then complained that they weren't about to get anything out of the course.. - Original Message - From: Nick Wagner To: Multiple recipients of list ORACLE-L Sent: Monday, October 28, 2002 3:23 PM Subject: RE: Oracle Internals course rumor has it that this course is not going to be offered/modified for the 9.2 release of Oracle. Can anyone confirm or deny it? Nick p.s. Had a close friend take this class, and they also came back extremely pleased with it. -Original Message- From: Rachel Carmichael [mailto:wisernet100;yahoo.com] Sent: Monday, October 28, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Internals course Scott is the instructors's instructor he learns the new features, then teaches them to the instructors so they can teach them to you I had the pleasure of taking those classes with Scott a few years ago as well. He's a great teacher. If he is ever presenting at any conference you go to, GO SEE HIM --- Tom Pall [EMAIL PROTECTED] wrote: I took that very course with Scott a few years ago. Yup, Scott flies
RE: RAID5+
Thanks Greg. I'd be very interested in what you find. To address the other responses, 1. the raid-1 configuration had 24 mirrored disk sets (48 spindles total). The raid-5 configuration also had a total of 48 spindles. 2. I'll be glad to send the whitepaper to anyone who requests it. Russ -Original Message- Sent: Tuesday, October 29, 2002 7:47 AM To: Brooks, Russ Russ- The hardware architects within our shop have pointed out similar performance information to me... We are using HDS 9960 boxes, and the file systems will be setup as a RAID5 on the SAN as compared to RAID0+1 on the EMC frames that we have.. I believe the RAID5 issue is related on to aHDS disk sub-system.. I'm trying to get some info from our HDS rep now. greg -Original Message- Sent: Monday, October 28, 2002 5:24 PM To: Multiple recipients of list ORACLE-L Hi, I just got forwarded a whitepaper from Hitachi and Oracle, that compairs raid 5+ and raid 1 using the TPC-C benchmark test suite. The claim is that raid 5 is as fast or faster. While I'm waiting for a comparison or raid 5+ with raid 0+1, I thought I'd take a poll with the list. The benchmark is using the Hitachi 7700E. Has anyone heard other recommendations attributed to Oracle that are pushing raid 5+ as the configuraton for unrivaled performance? Has new disk technology changed the general conception that raid 0 or 0+1 provides better performance than other raid levels? Thanks, Russ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brooks, Russ INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Internals course
What is shown to you on the Oracle Ed site, is actually based upon where you are located, within your login profile. I don't see any mention of Seminars what so ever (being UK based).. Can anyone else in the UK confirm this? Cheers Mark -Original Message- Carmichael Sent: 29 October 2002 13:24 To: Multiple recipients of list ORACLE-L Subject:RE: Oracle Internals course that I know of yes unfortunately, because I believe Scott is the only one teaching the classes. Is there a separate and distinct Oracle education site for the UK and Europe? Rachel --- Mark Leith [EMAIL PROTECTED] wrote: Are these Internals classes only available in the US? -Original Message- Carmichael Sent: 29 October 2002 11:04 To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Internals course Tom, I didn't mean to imply that you were going into damagement! I was lucky enough to have someone point me to seminars and figured I'd share my luck. I think the reason they don't publicize it is that he is the only one teaching it and it's full without publicizing. Can you imagine if they made it generally available? He'd have time to do nothing else! Rachel --- Tom Pall [EMAIL PROTECTED] wrote: Rachel, I'm not bucking for a management slot by being clueless about the details. Really I'm not. I registered online for the internals course by searching for it. I just kind of assumed from what Scott said that I just managed to luck out when I searched for the course and found it. I mistakenly assumed the course was quietly being removed from online registration after hearing Scott's statements about hiding and not publicizing the course. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 28, 2002 8:58 PM I registered for it online, at education.oracle.com you have to search on seminars, not classes. It's difficult to find, but it IS there --- Tom Pall [EMAIL PROTECTED] wrote: RE: Oracle Internals courseThat rumor's been going on for versions now. As has been Scott's desire to offer a two week internals course. Course participants would sign all sorts of non-disclosure forms then get a scaled down version of what's taught to Customer Support. Wait a minute! Customer Support takes these courses? Surely not all the Silver Support people I've called. A difficulty with a two week course is that the very DBAs most likely to benefit from the course are the ones least likely to be let free for two weeks. The internals course is slated to be yanked every time a new version of Oracle comes out. Why teach internals when there are no initialization parameters and the database maintains and tunes itself? There's been an economic downturn and Oracle DBAs have lost their jobs. But anybody know an Oracle DBA who lost his job because a later version doesn't require a DBA? Oracle on CDs 1,2 and 3, huh? I think if I dig enough I can find that old version of Oracle I had that came on a single diskette. Scott says the internals course is purposely hidden. You have to call Oracle directly and ask for it. A number of people registered for the course from the paper or online catalogs, showed up then complained that they weren't about to get anything out of the course.. - Original Message - From: Nick Wagner To: Multiple recipients of list ORACLE-L Sent: Monday, October 28, 2002 3:23 PM Subject: RE: Oracle Internals course rumor has it that this course is not going to be offered/modified for the 9.2 release of Oracle. Can anyone confirm or deny it? Nick p.s. Had a close friend take this class, and they also came back extremely pleased with it. -Original Message- From: Rachel Carmichael [mailto:wisernet100;yahoo.com] Sent: Monday, October 28, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Internals course Scott is the instructors's instructor he learns the new features, then teaches them to the instructors so they can teach them to you I had the pleasure of taking those classes with Scott a few years ago as well. He's a great teacher. If he is ever presenting at any conference you go to, GO SEE HIM --- Tom Pall [EMAIL PROTECTED] wrote: I took that very course with Scott a few years ago. Yup, Scott flies through the Internals and Dump/Traces courses with lots of extra material to spare. It's really refreshing to hear him tell the class how the developers documented something then tell how it's actually built. He keeps a database
RE: Scheduling software
Oxford is using maestro and it is a good software. -Original Message- From: BALA,PRAKASH (HP-USA,ex1) [mailto:prakash.bala;hp.com] Sent: Monday, October 28, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: Scheduling software I have heard that 'Maestro' is pretty good. I have not used it so far. Prakash -Original Message- Sent: Friday, October 25, 2002 15:56 To: Multiple recipients of list ORACLE-L Dick - We've ended up using a variety: Built-in Unix cron, our ERP package has a built-in scheduler, and on a home-grown development project the developers wrote their own scheduler so it has the same GUI interface as their application. It is just another screen their users can select. But we are more of a medium-sided site. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 25, 2002 1:04 PM To: Multiple recipients of list ORACLE-L To ALL, About a week ago I asked if anyone had an opinion of CA's AutoSys product. Thanks to those who replied, but that was a pretty SMALL number. Therefore the boss is asking what product(s) are the most used, especially in a PeopleSoft environment where jobs have dependencies on each other. OH, BTW the why would also be appreciated. Thanks in advance. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: BALA,PRAKASH (HP-USA,ex1) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Table Size
Prem - Simple way to get in the ballpark with table size. Figure out how large your average row is and multiply by the number of rows. This is only approximate and you'll want to size larger for indexes and other effects like the fact that your data blocks won't be 100% utilized. Better yet, create a test table, insert some data, ANALYZE the table, and then get the average row length from USER_TABLES view. How large the entire database will be depends on many factors. If you are just creating a simple test database and have a gig or so of space, then you shouldn't have a problem. Oracle Installer is good today about sizing everything for you. If you care to, look up the new feature Oracle Managed Files, designed just for people like you. On the other hand, if you have a special reason for being really, really concerned about precisely how much space it will take, then welcome to the world of the Oracle DBA. We can help you, but you need to provide more information. Hope this is what you were asking. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, October 28, 2002 10:44 PM To: Multiple recipients of list ORACLE-L Dear List, I am using Oracle 9i database. I need to identify the space requirements for our database for the production database. Can anybody suggest how to calculate the size of a table. and also additionally how to calculate the size of the whole database.? Regards Prem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Internals course
Rachel Carmichael wrote: Is there a separate and distinct Oracle education site for the UK and Europe? Rachel I am sure that Oracle UK has opted out of most of what is common fare on the continent. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sqlplus /nolog
Title: sqlplus /nolog it starts sqlplus without logging in to a database - -Original Message-From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 29, 2002 8:29 AMTo: Multiple recipients of list ORACLE-LSubject: sqlplus /nolog Hi! I was wondering what sqlplus /nolog actually does on Unix? Is it only used for not listing username/password when doing a ps ? Or anything else? This is 8.1.7 on Sun Solaris. Thanks, Helmut
Re: oracle client for linux
On Mon, Oct 28, 2002 at 08:58:32PM -0800, sonny e. supilanas wrote: hi, i'm totally new to oracle, we have a webserver running on mandrake and can make queries to mysql dbase using perl/cgi scripts on same unit which works fine for our sites. but now, we have to connect to a remote oracle dbase w/c is on a remote server. i'm trying to install DBD:oracle module for perl connect string to oracle dbase, but compilation of this module aborts cause it looks for ORACLE_HOME parameters, where can i get a free oracle clients for linux or sources of these oracle libraries for linux so i can rebuild the Makefile.pl of the DBD:oracle module and set the required parameters...i've been trying to download it from OTN site (technet.oracle.com) but to no avail...any suggestions, thank you -- I downloaded 9.2.0 for Linux from otn just a few weeks ago. I installs without a hitch on Mandrake 9.0. I am not sure why you can't download, it should work. What are the symptoms of the failure at download? I also installed 8.1.6 on Mandrake 8.2, but that was a year or so back. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Implicit Date conversion problem
Title: RE: Implicit Date conversion problem
Well,
Let me point out one thing following is the original query ...
-- this returns no rows ...
select ea1.ep_number, ea1.est_dt, veas.est_dt
from (select a.ep_number, ea.est_dt
from v_episode_avail_summary_break a, episode_airings ea
where a.ep_number = ea.ep_number
and ea.est_dt between '20-Dec-02' and '01-Jan-03'
group by a.ep_number, ea.est_dt) veas,
episode_airings ea1
where veas.ep_number = ea1.ep_number
and ea1.est_dt between '20-Dec-02' and '01-Jan-03'
-- This DOES work ... returns all the right rows
select ea1.ep_number, ea1.est_dt, veas.est_dt
from (select a.ep_number, ea.est_dt
from v_episode_avail_summary_break a, episode_airings ea
where a.ep_number = ea.ep_number
and ea.est_dt between '20-Dec-02' and '01-Jan-03'
group by a.ep_number, ea.est_dt) veas,
episode_airings ea1
where veas.ep_number = ea1.ep_number
-- and ea1.est_dt between '20-Dec-02' and '01-Jan-03'
Point to consider is that the commented out where clause is the same as the one used in the from clause query ... then why does it fail?
Tom: according to Oracle, when comparing a varchar2 to a date column, the string does get converted to a date ...
The reason i am asking this I have to explain the developers on why this isn't working. They agree that explicit datatype conversion is a good idea but their managers want to know why ??
(yeah ... sure go ahead pity me ...)
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!
-Original Message-
From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 29, 2002 10:35 AM
To: '[EMAIL PROTECTED]'
Cc: Jamadagni, Rajendra
Subject: RE: Implicit Date conversion problem
Raj,
you are forgetting how dates are stored internally vs. how they are displayed by sqlplus.
change your first query to:
select ea1.ep_number, ea1.est_dt, veas.est_dt
from (select a.ep_number, ea.est_dt
from v_episode_avail_summary_break a, episode_airings ea
where a.ep_number = ea.ep_number
and ea.est_dt between to_date('20-Dec-2002','dd-mon-') and to_date('01-Jan-2003' ,'dd-mon-')
group by a.ep_number, ea.est_dt) veas,
episode_airings ea1
where veas.ep_number = ea1.ep_number
and ea1.est_dt between between to_date('20-Dec-2002','dd-mon-') and to_date('01-Jan-2003' ,'dd-mon-')
Your selection was not working properly because you ended up comparing string values with string values.
example: 21-Dec-2002 is not between 20-Dec-2002 and 01-Jan-2003 using string comparison
(21 is greater than 20 and 01 both).
hope this helps.
Tom Mercadante
Oracle Certified Professional
*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
Stand-by database implementation ...
Looks like I'm gonna implement a stand-by database on Windows 2000 using Oracle 8.1.7.4 Anyone have any good article, how-tos, caviots I need to consider or read up on? Lizz __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lizz Pena INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SPARC-III v Alpha
If the TPCs can be believed, I guess this would make a good ruler, too: http://www.top500.org/list/2002/06/ I don't even know what 3016 processors look like. ;) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Hemant K Chitale [mailto:hkchital;singnet.com.sg] Sent: Tuesday, October 29, 2002 7:34 AM To: Multiple recipients of list ORACLE-L Subject: Re: SPARC-III v Alpha Thanks for the link ! Hemant At 06:33 AM 28-10-02 -0800, you wrote: Hemant K Chitale wrote: Does anyone have benchmark or comparative figures for Sun SPARC v Compaq (thenewhp) Alpha for Oracle Databases ? I found some benchmark figures for Datawarehouses at the Oracle website but not for OLTP [then again, the machines configured for those benchmarks were extra-large machines !]. Hemant K Chitale My web site page is : http://hkchital.tripod.com Perhaps that http://www.tpc.org/tpcc/results/tpcc_results.asp?orderby=hardware can help ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sqlplus /nolog
Title: sqlplus /nolog Helmut, It makes sqlplus act like svrmgrl. I use sqlplus this way, followed internally by a connect as sysdba command to start and shutdown the database on 9i. Tom Mercadante Oracle Certified Professional -Original Message-From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 29, 2002 8:29 AMTo: Multiple recipients of list ORACLE-LSubject: sqlplus /nolog Hi! I was wondering what sqlplus /nolog actually does on Unix? Is it only used for not listing username/password when doing a ps ? Or anything else? This is 8.1.7 on Sun Solaris. Thanks, Helmut
RE: sqlplus /nolog
Title: sqlplus /nolog It originates fromthe wonderful OS that used to have commands like "SET DEF", "MONITOR MODES", "BACKUP/IGNORE=INTERLOCK SYS$ORACLE:[]*.* MU:" and alike. There is also an abomination of this OS created by David Cuttler. -Original Message-From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 29, 2002 8:29 AMTo: Multiple recipients of list ORACLE-LSubject: sqlplus /nolog Hi! I was wondering what sqlplus /nolog actually does on Unix? Is it only used for not listing username/password when doing a ps ? Or anything else? This is 8.1.7 on Sun Solaris. Thanks, Helmut
Re: Implicit Date conversion problem
What does doesn't work mean?
Wrong data?
Error message?
etc...??
Also the trunc(to_date('01-Jan-03','DD-Mon-YY')) is not quite right
most likely.
It should probably be:
trunc(to_date('01-Jan-03','DD-Mon-YY'))
to_date('01-Jan-03 23:59:59','DD-Mon-YY' HH24:MI:SS')
or if used with a variable:
trunc(mydate+1) - (1/86400)
Jared
On Tuesday 29 October 2002 05:54, Jamadagni, Rajendra wrote:
We have a query (please don't ask me why it is written this way)
--Doesn't work:
select ea1.ep_number, ea1.est_dt, veas.est_dt
from (select a.ep_number, ea.est_dt
from v_episode_avail_summary_break a, episode_airings ea
where a.ep_number = ea.ep_number
and ea.est_dt between '20-Dec-02' and '01-Jan-03'
group by a.ep_number, ea.est_dt) veas,
episode_airings ea1
where veas.ep_number = ea1.ep_number
and ea1.est_dt between '20-Dec-02' and '01-Jan-03'
vs.
--Works:
select ea1.ep_number, ea1.est_dt, veas.est_dt
from (select a.ep_number, ea.est_dt
from v_episode_avail_summary_break a, episode_airings ea
where a.ep_number = ea.ep_number
and ea.est_dt between '20-Dec-02' and '01-Jan-03'
group by a.ep_number, ea.est_dt) veas,
episode_airings ea1
where veas.ep_number = ea1.ep_number
and ea1.est_dt between trunc(to_date('20-Dec-02','DD-Mon-YY'))
and trunc(to_date('01-Jan-03','DD-Mon-YY'))
Also if we comment and ea1.est_dt between '20-Dec-02' and '01-Jan-03' the
non-working query runs fine.
Does anyone know what could be wrong? The est_dt is a date column. This is
9201 ...
Raj
__
Rajendra JamadagniMIS, 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!
Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1
Content-Transfer-Encoding: quoted-printable
Content-Description:
Content-Type: text/plain; charset=iso-8859-1; name=ESPN_Disclaimer.txt
Content-Transfer-Encoding: 7bit
Content-Description:
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Oracle Internals course
No. Scott said he's been to a number of Pacific Ocean countries to teach the course. I suspect those courses where hosted by a company which had offered enough internal enrollment. As I recall, there's another instructor who also teaches the Internals, Crashes/Dump/Traces and Backup/Recovery seminars. Be careful of all Oracle courses. Some of them are subcontracted out. I don't warn you to put down consultants. But this thread has been about Scott and his internals course. Scott's the star. If you really want to make sure Scott's going to teach your course, phone him up or drop him an email. Don't expect him to respond the same day you try to contact him. When he's teaching, he's tied up through lunch and dinner and sometimes even on the ride to the airport. Many people go to the course with specific questions they want answered. Scott often handles those during out of class hours. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 5:58 AM Are these Internals classes only available in the US? -Original Message- Carmichael Sent: 29 October 2002 11:04 To: Multiple recipients of list ORACLE-L Tom, I didn't mean to imply that you were going into damagement! I was lucky enough to have someone point me to seminars and figured I'd share my luck. I think the reason they don't publicize it is that he is the only one teaching it and it's full without publicizing. Can you imagine if they made it generally available? He'd have time to do nothing else! Rachel --- Tom Pall [EMAIL PROTECTED] wrote: Rachel, I'm not bucking for a management slot by being clueless about the details. Really I'm not. I registered online for the internals course by searching for it. I just kind of assumed from what Scott said that I just managed to luck out when I searched for the course and found it. I mistakenly assumed the course was quietly being removed from online registration after hearing Scott's statements about hiding and not publicizing the course. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 28, 2002 8:58 PM I registered for it online, at education.oracle.com you have to search on seminars, not classes. It's difficult to find, but it IS there --- Tom Pall [EMAIL PROTECTED] wrote: RE: Oracle Internals courseThat rumor's been going on for versions now. As has been Scott's desire to offer a two week internals course. Course participants would sign all sorts of non-disclosure forms then get a scaled down version of what's taught to Customer Support. Wait a minute! Customer Support takes these courses? Surely not all the Silver Support people I've called. A difficulty with a two week course is that the very DBAs most likely to benefit from the course are the ones least likely to be let free for two weeks. The internals course is slated to be yanked every time a new version of Oracle comes out. Why teach internals when there are no initialization parameters and the database maintains and tunes itself? There's been an economic downturn and Oracle DBAs have lost their jobs. But anybody know an Oracle DBA who lost his job because a later version doesn't require a DBA? Oracle on CDs 1,2 and 3, huh? I think if I dig enough I can find that old version of Oracle I had that came on a single diskette. Scott says the internals course is purposely hidden. You have to call Oracle directly and ask for it. A number of people registered for the course from the paper or online catalogs, showed up then complained that they weren't about to get anything out of the course.. - Original Message - From: Nick Wagner To: Multiple recipients of list ORACLE-L Sent: Monday, October 28, 2002 3:23 PM Subject: RE: Oracle Internals course rumor has it that this course is not going to be offered/modified for the 9.2 release of Oracle. Can anyone confirm or deny it? Nick p.s. Had a close friend take this class, and they also came back extremely pleased with it. -Original Message- From: Rachel Carmichael [mailto:wisernet100;yahoo.com] Sent: Monday, October 28, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Internals course Scott is the instructors's instructor he learns the new features, then teaches them to the instructors so they can teach them to you I had the pleasure of taking those classes with Scott a few years ago as well. He's a great teacher. If he is ever presenting at any conference you go to, GO SEE HIM --- Tom Pall [EMAIL PROTECTED] wrote: I took that very course with Scott a few years ago. Yup, Scott flies through the Internals and Dump/Traces courses with lots
Re: sqlplus /nolog
This is a multi-part message in MIME format. --=002_Dragon805267761306_= Content-Type: text/plain; charset=GB2312 Content-Transfer-Encoding: quoted-printable Daiminger, Helmut=A3=AC=C4=FA=BA=C3=A3=A1 =A1=A1=A1=A1It is used when you want to do it in your shell script, or $sqlplus /nolog SQLconn / as sysdba =3D=3D=3D=3D=3D=3D=3D=3D 2002-10-29 05:29:00 =C4=FA=D4=DA=C0=B4=D0=C5=D6=D0=D0=B4=B5=C0=A3=BA =3D=3D=3D=3D=3D=3D=3D=3D Hi! I was wondering what sqlplus /nolog actually does on Unix? Is it only used for not listing= username/password when doing a ps ? Or anything else? This is 8.1.7 on Sun Solaris. Thanks, Helmut =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=D6=C2 =C0=F1=A3=A1 =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1chao_ping [EMAIL PROTECTED] =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A12002-10-29 --=002_Dragon805267761306_= Content-Type: text/html; charset=GB2312 Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META content=3Dtext/html; charset=3Dgb2312= http-equiv=3DContent-Type META content=3DMSHTML 5.00.3315.2870 name=3DGENERATOR/HEAD BODY bgColor=3D#eaeaeaFONT size=3D2FONT face=3D=CB=CE=CC=E5Daiminger,= Helmut=A3=AC=C4=FA=BA=C3=A3=A1/FONT /FONT DIVnbsp;/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2=A1=A1=A1=A1It is used when you want to do it= in your shell script, or /FONT/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2/FONTnbsp;/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2$sqlplus /nolog/FONT/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2SQLgt;conn / as sysdba/FONT/DIV DIVnbsp;/DIV DIVnbsp;/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2=3D=3D=3D=3D=3D=3D=3D=3D= 2002-10-29nbsp;05:29:00nbsp;=C4=FA=D4=DA=C0=B4=D0=C5=D6=D0=D0=B4=B5=C0=A3=BA =3D=3D=3D=3D=3D=3D=3D=3D/FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2 TABLE width=3D100% TBODY TR TD width=3D100% BLOCKQUOTE style=3DBORDER-LEFT: #00 2px solid; MARGIN-LEFT: 5px;= MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px PFONT size=3D2Hi!/FONT /P PFONT size=3D2I was wondering what/FONT /P PFONT size=3D2sqlplus /nolog/FONT /P PFONT size=3D2actually does on Unix?nbsp; Is it only= used for not listing username/password when doing a ps ? Or anything= else?/FONT /P PFONT size=3D2This is 8.1.7 on Sun Solaris./FONT= /P PFONT size=3D2Thanks,/FONT BRFONT= size=3D2Helmut/FONT /P/BLOCKQUOTE/TD/TR/TBODY/TABLE/FONT/DIV DIV PFONT face=3D=CB=CE=CC=E5 size=3D2=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D= =3D =3D /FONT/P PFONT face=3D=CB=CE=CC=E5 size=3D2=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=D6=C2BR=C0=F1=A3=A1/FONT/P DIVnbsp;/DIV DIVFONT face=3D=CB=CE=CC=E5= size=3D2=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1chao_ping/FONT/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2FONT face=3D=CB=CE=CC=E5= size=3D2=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1/FONTA href=3Dmailto:chao_ping;vip.163.com[EMAIL PROTECTED]/A/FO= NT/DIV DIVFONT face=3D=CB=CE=CC=E5= size=3D2=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A12002-10-29/FONT/DIV= DIVnbsp;/DIV/DIV/BODY/HTML --=002_Dragon805267761306_=-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
oracle 8i CD
can someone provide me with a link to get a oracle 8i CD ? there was one available from the oracle store for around $40 (for 8i). i don't find that link there any more. __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oracle prep INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: variables in reports
If the value is not dependent on the parameters entered by the user then you can have it a user parameter not displayed in the parameter form. Alternatively, you can also use a placeholder column to achieve the same. You can place it outside of any group. Regards Naveen -Original Message- Sent: Tuesday, October 29, 2002 6:54 PM To: Multiple recipients of list ORACLE-L hello to everybody has somebody ever had the problem of accessing a variable in reports - need one that i can store a value on, retrieve a value from, that is accessible globally and can be displayed in the body part, regardless of frequency of group by's ecc. - something like a user parameter but without the ugly side effect of appearing every time the report is invoked. kr mrr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sqlplus /nolog
Title: sqlplus /nolog sqlplus /nolog starts sqlplus, but does not connect you to any database, nor does it prompt you for a username/password. - Original Message - From: Daiminger, Helmut To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 29, 2002 8:29 AM Subject: sqlplus /nolog Hi! I was wondering what sqlplus /nolog actually does on Unix? Is it only used for not listing username/password when doing a ps ? Or anything else? This is 8.1.7 on Sun Solaris. Thanks, Helmut
RE: Scheduling software
Dick, We've looked at another scheduling tool that's paticularly good at cross platform job dependancies etc. that has support for Peoplesoft. The product is called OpCon/xps from a US based company called SMA. Before you ask, no, I receive no commisions from this company.. ;) We did in fact look in to taking on a distribution agreement (we knew one of the developers from a past life), but decided it wasn't an area we wanted to be in at the moment.. http://www.smausa.com/products/platforms.htm Very good product by all accounts.. HTH Mark -Original Message- Mladen Sent: 29 October 2002 14:44 To: Multiple recipients of list ORACLE-L Subject:RE: Scheduling software Oxford is using maestro and it is a good software. -Original Message- From: BALA,PRAKASH (HP-USA,ex1) [mailto:prakash.bala;hp.com] Sent: Monday, October 28, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: Scheduling software I have heard that 'Maestro' is pretty good. I have not used it so far. Prakash -Original Message- Sent: Friday, October 25, 2002 15:56 To: Multiple recipients of list ORACLE-L Dick - We've ended up using a variety: Built-in Unix cron, our ERP package has a built-in scheduler, and on a home-grown development project the developers wrote their own scheduler so it has the same GUI interface as their application. It is just another screen their users can select. But we are more of a medium-sided site. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 25, 2002 1:04 PM To: Multiple recipients of list ORACLE-L To ALL, About a week ago I asked if anyone had an opinion of CA's AutoSys product. Thanks to those who replied, but that was a pretty SMALL number. Therefore the boss is asking what product(s) are the most used, especially in a PeopleSoft environment where jobs have dependencies on each other. OH, BTW the why would also be appreciated. Thanks in advance. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: BALA,PRAKASH (HP-USA,ex1) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting
Re: List of Rows Updated
Title: RE: List of Rows Updated Gosh. I wish I worked in your shop. I'm typically asked to produce an audit report for yesterday on a table I didn't even know existed. "What do you mean you can't do that? Aren't you an Oracle DBA?" - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 29, 2002 5:58 AM Subject: RE: List of Rows Updated Auditing is much simpler and usable than logminer for *this purpose*. 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! -Original Message- From: Tom Pall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 29, 2002 1:39 AM To: Multiple recipients of list ORACLE-L Subject: Re: List of Rows Updated Logminer comes to mind. - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, October 28, 2002 10:23 PM Hi, I want to get the list of rows which were updated(then commited) in a particular table say X on a specific date e.g yesterday. Is this possible and how ? Thanks Manoj.
RE: Implicit Date conversion problem
Title: RE: Implicit Date conversion problem http://technet.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a96540/sql_elements2a.htm#54201 Look up for table 2-10 and then below the table look for 4th bullet ... that's where I found it out ... At-least Tom you know my pain. but hey in this downturn economy along with saving money we are in a process of saving keystrokes (there-by saving electrons-electricity-company_bill-eventually_saving_company_money). I have just about given up explaining this issue to developers and have asked them to open a tar with Oracle. They will believe it when OWS tells them this is wrong, what I say doesn't matter. 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! -Original Message- From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 29, 2002 10:53 AM To: Jamadagni, Rajendra; '[EMAIL PROTECTED]' Subject: RE: Implicit Date conversion problem Raj, you said: according to Oracle, when comparing a varchar2 to a date column, the string does get converted to a date ... This has got to be wrong. If you compare a varchar2 column with a number, Oracle try's to convert the varchar2 to a number, and we end up with an invalid number error. Oracle has not choice but to attempt to convert a database column to a literal - it can *never* go in the other direction because it cannot make the correct assumption. At least I would not try and provide that service. I would explain to the developers and the managers that this is the way it works. And it will always work correctly if they do explicit date conversion in their Sql. Once they begin coding this correctly, they will always be happy - it will always work consistently. The manuals have been known to be wrong in the past, and if you and they have found the above quote in a manual, it is wrong. At least I have *never* seen Oracle act like this. Hope this helps. Tom Mercadante Oracle Certified Professional 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.*2
Re: Stand-by database implementation ...
Look out for the Pentium 4 bug. Other than that I've found it to be pretty straightforward. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Internals course
Title: Message Oracle didn't start offering instruction directly at your desktop or urge you to open up an iTAR instead of talking to a Customer Service person for nothing. People are expensive. - Original Message - From: Bob Metelsky To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 29, 2002 8:33 AM Subject: RE: Oracle Internals course It is just me or does 500-2000 per day seem a little "steep"? Oracle8i: Everything You Always Wanted to Know about the Optimizer Instructor-Led inClass US$ 500 1 Day English English OR INTRODUCTION TO ORACLE9I: SQL (ILT) BLOOMFIELD, CT 02-DEC-02 US$2000 Remove from Shopping Cart INTRODUCTION TO ORACLE 8I: SQL AND PL/SQL (ILT) BLOOMFIELD, CT 17-FEB-03 US$2000 Remove from Shopping Cart ADVANCED PL/SQL (ILT) BLOOMFIELD, CT 07-NOV-02 US$1000 Remove from Shopping Cart
Re: sqlplus /nolog
On Tue, Oct 29, 2002 at 06:58:49AM -0800, Gogala, Mladen wrote: It originates from the wonderful OS that used to have commands like SET DEF, MONITOR MODES, BACKUP/IGNORE=INTERLOCK SYS$ORACLE:[]*.* MU: and alike. There is also an abomination of this OS created by David Cuttler. Cutler === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Win2k Perl accessing Oracle Parameters?
In addition to BIshop's excellent response, be sure to install
the latest version of Tie:Registry. The one that comes with
ActiveState Perl doesn't work properly.
The current version (as installed from ActiveState via PPM)
is I believe 1.24. Just reinstall it.
Jared
On Tuesday 29 October 2002 01:53, Bishop Lewis wrote:
Here's something to read registry keys I used a while back. Obviously needs
the win32 module installed.
use Win32::Registry;
$terminal = $ARGV[0];
$HKEY_LOCAL_MACHINE-Connect ($terminal, $hNode) || die Cannot connect to
$node;
$hNode-Open (SOFTWARE\\Microsoft\\Windows NT\\CurrentVersion\\Winlogon,
$hKey) || die Cannot open registry !;
$hKey-GetValues (\%values);
$hKey-Close ();
$hNode-Close ();
foreach $value (keys(%values)) {
$RegType = $values{$value}-[1];
$RegValue = $values{$value}-[2];
$RegKey = $values{$value}-[0];
if ($RegKey eq DefaultUserName) {$username = $RegValue;
print $RegValue\n;
}
}
exit;
Modify accordingly. HTH.
Lewis Bishop
---
Barclays Enable - ISS - E-NTRUST/Bexleyheath NT
Oracle Database Consultant
Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R)
Phone : 020 8298 3418
Mobile: 07950 380857
Email : [EMAIL PROTECTED]
Enabling Competitive Advantage for Barclays in IT and Business Processing
-Original Message-
Sent: 29 October 2002 08:43
To: Multiple recipients of list ORACLE-L
This header confirms that this email message has been swept for the
presence of computer viruses.
Corporate IT
THE WOOLWICH
--
Hello All,
I am writing an perl script. I cann't figure out and have been going
through the docs, but cann't find exactly what I need.
A way to access Oracle Parameters as they are set up in the Win2k
registary. I am specifically thinking of ORACLE_HOME. I do know how to
obtain an environmental variable/parameter with $ENV{}.
But the ORACLE_HOME is not an environmental parameter per se.
I have a workaround by setting it up in the enviroment, however I would
like to write this script with the aim at it being machine unspecific.
(Jared, hope you can answer me on this. Want to get a copy of your book,
unfortunately with the exchange rate and import taxes etc it will cost me
R590,00. Quiet a chunk of the ole budget, maybe early next year.)
Regards
Denham Eva
Oracle DBA
UNIX is basically a simple operating system, but you have to be a genius
to understand the simplicity.
Dennis Ritchie.
_
DISCLAIMER
This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission. If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender. You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. TFMC, its holding company, and any of its subsidiaries each
reserve the right to monitor and manage all e-mail communications through
its networks.
Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized to
state them to be views of any such entity.
_
_
This e-mail message has been scanned for Viruses and Content and cleared by
MailMarshal - For more information please visit
http://www.marshalsoftware.com www.marshalsoftware.com
_
--_=_NextPart_001_01C27F2F.5CF0F180
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN
html xmlns:v=3Durn:schemas-microsoft-com:vml =
xmlns:o=3Durn:schemas-microsoft-com:office:office =
xmlns:w=3Durn:schemas-microsoft-com:office:word =
xmlns:st1=3Durn:schemas-microsoft-com:office:smarttags =
xmlns=3Dhttp://www.w3.org/TR/REC-html40;
head
META HTTP-EQUIV=3DContent-Type CONTENT=3Dtext/html; =
charset=3Dus-ascii
meta name=3DProgId content=3DWord.Document
meta name=3DGenerator content=3DMicrosoft Word 10
meta name=3DOriginator content=3DMicrosoft Word 10
link rel=3DFile-List href=3Dcid:filelist.xml;01C27F2F.66CF0930
link rel=3DEdit-Time-Data href=3Dcid:editdata.mso;01C27F2F.66CF0930
!--[if !mso]
style
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
/style
![endif]--
titleWin2k Perl accessing Oracle Parameters?/title
o:SmartTagType =
namespaceuri=3Durn:schemas-microsoft-com:office:smarttags
name=3Ddate/
o:SmartTagType =
namespaceuri=3Durn:schemas-microsoft-com:office:smarttags
name=3Dtime/
o:SmartTagType =
namespaceuri=3Durn:schemas-microsoft-com:office:smarttags
name=3Dplace/
o:SmartTagType =
namespaceuri=3Durn:schemas-microsoft-com:office:smarttags
name=3DPostalCode/
RE: SQL*Plus COPY error solved (sort of)
Hadn't thought of trying that; makes sense. Thanks. --- Reardon, Bruce (CALBBAY) [EMAIL PROTECTED] wrote: When you tried under NT, did you use sqlplus.exe or sqlplusw.exe? If you used sqlplusw.exe, this sounds like Bug No. 1504702 The workaround is to use the copy command from the character version of sqlplus (sqlplus.exe) rather than the GUI version. HTH, Bruce Reardon __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Stand-by database implementation ...
One of the best sources of information is a white paper by Lawrence To called Graceful Switchover and Switchback for Standby Databases (Metalink note 90817.1) Another one under the White papers sectiopn is note 91570.1 but I have not looked at that John -Original Message- Sent: 29 October 2002 15:24 To: Multiple recipients of list ORACLE-L Looks like I'm gonna implement a stand-by database on Windows 2000 using Oracle 8.1.7.4 Anyone have any good article, how-tos, caviots I need to consider or read up on? Lizz __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lizz Pena INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Internals course
Scott Heisey taught the New Features for 8i administrators class that I took. Yeah, he's in my top ten of Oracle instructors. A not at all complete, in no particular order list is: Scott Gossett Scott Heisey Sue Jang John Hough Please note, I have NOT taken classes from all the Oracle instructors, nor have I taken a class in recent years, so if there are new and/or as good, instructors, I don't know of them. Rachel --- Gogala, Mladen [EMAIL PROTECTED] wrote: Actually, he isn't. There is another guy, named Scott Heisey, who teaches an OPS/RAC version of this course. He is also supposed to be one of the great sages of the Oracle Corp. I've attended Scott Gossett's course and it was fabulous. I've only heard about Scott Heisey and it is my great wish to go to his course. -Original Message- From: Rachel Carmichael [mailto:wisernet100;yahoo.com] Sent: Tuesday, October 29, 2002 8:24 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Internals course that I know of yes unfortunately, because I believe Scott is the only one teaching the classes. Is there a separate and distinct Oracle education site for the UK and Europe? Rachel --- Mark Leith [EMAIL PROTECTED] wrote: Are these Internals classes only available in the US? -Original Message- Carmichael Sent: 29 October 2002 11:04 To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Internals course Tom, I didn't mean to imply that you were going into damagement! I was lucky enough to have someone point me to seminars and figured I'd share my luck. I think the reason they don't publicize it is that he is the only one teaching it and it's full without publicizing. Can you imagine if they made it generally available? He'd have time to do nothing else! Rachel --- Tom Pall [EMAIL PROTECTED] wrote: Rachel, I'm not bucking for a management slot by being clueless about the details. Really I'm not. I registered online for the internals course by searching for it. I just kind of assumed from what Scott said that I just managed to luck out when I searched for the course and found it. I mistakenly assumed the course was quietly being removed from online registration after hearing Scott's statements about hiding and not publicizing the course. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 28, 2002 8:58 PM I registered for it online, at education.oracle.com you have to search on seminars, not classes. It's difficult to find, but it IS there --- Tom Pall [EMAIL PROTECTED] wrote: RE: Oracle Internals courseThat rumor's been going on for versions now. As has been Scott's desire to offer a two week internals course. Course participants would sign all sorts of non-disclosure forms then get a scaled down version of what's taught to Customer Support. Wait a minute! Customer Support takes these courses? Surely not all the Silver Support people I've called. A difficulty with a two week course is that the very DBAs most likely to benefit from the course are the ones least likely to be let free for two weeks. The internals course is slated to be yanked every time a new version of Oracle comes out. Why teach internals when there are no initialization parameters and the database maintains and tunes itself? There's been an economic downturn and Oracle DBAs have lost their jobs. But anybody know an Oracle DBA who lost his job because a later version doesn't require a DBA? Oracle on CDs 1,2 and 3, huh? I think if I dig enough I can find that old version of Oracle I had that came on a single diskette. Scott says the internals course is purposely hidden. You have to call Oracle directly and ask for it. A number of people registered for the course from the paper or online catalogs, showed up then complained that they weren't about to get anything out of the course.. - Original Message - From: Nick Wagner To: Multiple recipients of list ORACLE-L Sent: Monday, October 28, 2002 3:23 PM Subject: RE: Oracle Internals course rumor has it that this course is not going to be offered/modified for the 9.2 release of Oracle. Can anyone confirm or deny it? Nick p.s. Had a close friend take this class, and they also came back extremely pleased with it. -Original Message- From: Rachel Carmichael [mailto:wisernet100;yahoo.com] Sent: Monday, October 28, 2002 12:19
Re: oracle client for linux
otn.oracle.com is the right place. Jared On Monday 28 October 2002 20:58, sonny e. supilanas wrote: hi, i'm totally new to oracle, we have a webserver running on mandrake and can make queries to mysql dbase using perl/cgi scripts on same unit which works fine for our sites. but now, we have to connect to a remote oracle dbase w/c is on a remote server. i'm trying to install DBD:oracle module for perl connect string to oracle dbase, but compilation of this module aborts cause it looks for ORACLE_HOME parameters, where can i get a free oracle clients for linux or sources of these oracle libraries for linux so i can rebuild the Makefile.pl of the DBD:oracle module and set the required parameters...i've been trying to download it from OTN site (technet.oracle.com) but to no avail...any suggestions, thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Implicit Date conversion problem
Title: Implicit Date conversion problem
Raj,
you
are forgetting how dates are stored internally vs. how they are displayed by
sqlplus.
change
your first query to:
select ea1.ep_number, ea1.est_dt,
veas.est_dt from (select a.ep_number, ea.est_dt
from
v_episode_avail_summary_break a, episode_airings ea
where a.ep_number =
ea.ep_number
and ea.est_dt betweento_date('20-Dec-2002','dd-mon-') andto_date('01-Jan-2003','dd-mon-')
group by a.ep_number, ea.est_dt) veas,
episode_airings ea1 where veas.ep_number = ea1.ep_number and
ea1.est_dt between betweento_date('20-Dec-2002','dd-mon-') andto_date('01-Jan-2003','dd-mon-')
Your
selection was not working properly because you ended up comparing string values
with string values.
example: 21-Dec-2002 is not between 20-Dec-2002
and 01-Jan-2003 using string comparison
(21 is greater than 20 and 01 both).
hope
this helps.
Tom Mercadante Oracle Certified Professional
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 29, 2002
8:54 AMTo: Multiple recipients of list ORACLE-LSubject:
Implicit Date conversion problem
We have a query (please don't ask me why it is
written this way)
--Doesn't work: select ea1.ep_number, ea1.est_dt, veas.est_dt
from (select a.ep_number, ea.est_dt
from
v_episode_avail_summary_break a, episode_airings ea where
a.ep_number = ea.ep_number
and ea.est_dt between '20-Dec-02' and '01-Jan-03' group by
a.ep_number, ea.est_dt) veas, episode_airings
ea1 where veas.ep_number =
ea1.ep_number and ea1.est_dt
between '20-Dec-02' and '01-Jan-03'
vs.
--Works: select ea1.ep_number, ea1.est_dt, veas.est_dt
from (select a.ep_number, ea.est_dt
from
v_episode_avail_summary_break a, episode_airings ea where
a.ep_number = ea.ep_number
and ea.est_dt between '20-Dec-02' and '01-Jan-03' group by
a.ep_number, ea.est_dt) veas, episode_airings
ea1 where veas.ep_number =
ea1.ep_number and ea1.est_dt
between trunc(to_date('20-Dec-02','DD-Mon-YY'))
and trunc(to_date('01-Jan-03','DD-Mon-YY'))
Also if we comment "and ea1.est_dt between
'20-Dec-02' and '01-Jan-03'" the non-working query runs fine. Does anyone know what could be wrong? The est_dt is a date
column. This is 9201 ...
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!
RE: Flat file generation integrity ideas...
Actually, I am sending and receiving files. They will be handling the FTP of the files, and making sure it has FTPed correctly. I just have to have a sanity check of the file. Basically, I decided to prefix each data line with 'DAT', and the CRC line with 'CRC'. The flat file is read into the database via an external table. I query the CRC record, get the expected record count and then count how many rows were actually sent. And then if there is a number column, then I sum that up and check it against the CRC expected sum. Perhaps all this is overkill, but I know that the odds of data corruption are slim to none. I don't like making assumptions, and I can't assume the file is ok. Many thanks to everyone that responded!!! -Original Message- Sent: Monday, October 28, 2002 11:54 AM To: Multiple recipients of list ORACLE-L But he was talking about sending, not receiving. and he says that the ftp is assured to work ok. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 25, 2002 2:48 AM Unfortunately it is a trust issue... Trust me when I say a file can get scrambled. I have seen it happen. In our wierdest scenario two received files appeared to be merged into a single file - on the source system they had two intact files, on our system 1.5 files merged into a single file and .5 of a file missing. We could never replicate it, we had extensive testing on ftp processes, etc, all we know is that it happened and our validation techniques saw it and saved us a lot of greif. Yechiel Adar adar76@inter. To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] net.il cc: Sent by: Subject: Re: Flat file generation integrity ideas... [EMAIL PROTECTED] om 25/10/2002 06:14 Please respond to ORACLE-L I do not see how the file can get scrambled. You write it out ok. The ftp is guaranteed. So what is the problem. I will go along with the suggestion to zip it. It saves on the ftp time and also gives you some protection. Yechiel Adar Mehish - Original Message - From: Grabowy, Chris To: Multiple recipients of list ORACLE-L Sent: Thursday, October 24, 2002 7:34 PM Subject: Flat file generation integrity ideas... I have to create packages that will generate several flat files of data from tables that will be sent to other systems to be processed. I am looking for ideas on how to ensure data integrity in the flat files. For example, the expected record count is stored on the first line of the file to ensure that the correct amount of records was received. The systems group is chartered to ensure the flat files are correctly FTPed between systems, so that's covered. I just worry that if somehow a flat file is scrambled then the scrambled data is loaded into the database, therefore corrupting it. At this phase, XML is not an option I keep thinking that some sort of CRC should be stored with each line in the flat file. And then before the line is loaded into the database, the CRC is compared against the generated CRC of the just read line. Has anyone done anything like this? Any examples out there? Many TIA!! Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --
RE: Implicit Date conversion problem
Title: RE: Implicit Date conversion problem
Sorry about that ... I am working on a sev-1 problem with Oracle (ora-904 error if anyone is interested).
Doesn't work means it doesn't return any data the working query returns correct number of rows. the trunc() syntax is right ... est_dt column stored date with hh:mi:ss set to 00:00:00. It has a companion column called est_tm that stores time as number of seconds since midnight.
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!
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 29, 2002 10:24 AM
To: [EMAIL PROTECTED]; Jamadagni, Rajendra
Subject: Re: Implicit Date conversion problem
What does doesn't work mean?
Wrong data?
Error message?
etc...??
Also the trunc(to_date('01-Jan-03','DD-Mon-YY')) is not quite right
most likely.
It should probably be:
trunc(to_date('01-Jan-03','DD-Mon-YY'))
to_date('01-Jan-03 23:59:59','DD-Mon-YY' HH24:MI:SS')
or if used with a variable:
trunc(mydate+1) - (1/86400)
Jared
*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
Re: net8 for linux
On Tue, Oct 29, 2002 at 01:48:38AM -0800, sonny e. supilanas wrote: hi, i learned that i need net8 for linux to rebuild the DBD-Oracle perl module. where can i download one for free otn.oracle.com, you have to download oracle for linux and install it. The installer gives you the option to install the client only. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RAID5+
Russ: We're using EMC Clariion disk arrays. These are using EMC's version of RAID-5; they call it RAID-S. There is 2GB of cache if front of the disks. They claim that the cache is write guaranteed so that we'll never lose an update. So far, so good, and the performance has been acceptable, except (you knew this was coming, huh?) when we do large file moves from one tray to another, or when doing a refresh of our SAP stage system. This activity kinda buries the internal bus as well as the fiber, so that other users suffer. I guess to make a short answer even longer, this RAID-S technology seems to work a lot better than RAID-5 used to. Remember, though, YMMV. Cheers, Mike -Original Message- Sent: Monday, October 28, 2002 5:24 PM To: Multiple recipients of list ORACLE-L Hi, I just got forwarded a whitepaper from Hitachi and Oracle, that compairs raid 5+ and raid 1 using the TPC-C benchmark test suite. The claim is that raid 5 is as fast or faster. While I'm waiting for a comparison or raid 5+ with raid 0+1, I thought I'd take a poll with the list. The benchmark is using the Hitachi 7700E. Has anyone heard other recommendations attributed to Oracle that are pushing raid 5+ as the configuraton for unrivaled performance? Has new disk technology changed the general conception that raid 0 or 0+1 provides better performance than other raid levels? Thanks, Russ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brooks, Russ INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Joseph Testa has sent you a 10% discount]
What a guy that Joe is. ;-) But Joe, I thought you were getting out of the DBA business. --- Joe Testa [EMAIL PROTECTED] wrote: well that didnt work, ok how about cut/paste :) Joseph Testa bought a few things at Amazon.com and wanted to offer you a discount on them. Its the new RMAN book by Robert Freeman Under Amazon.com's Share the Love program, if you purchase any items from the following list by November 1, 2002, you'll save on each product: http://www.amazon.com/exec/obidos/redirect?tag=love102-20path=stl/12A1CL3R5FA30 Oh, and we almost forgot: Each item you buy may earn Joseph Testa credit toward future Amazon.com purchases. You save money, and your friend saves money--it's a beautiful thing. Joseph Testa requested that we send this message. If you have questions about Share the Love, please visit our Help department at http://www.amazon.com/share-the-love-help Hope to see you soon! Your friends at Amazon.com Amazon.com Earth's Biggest Selection Find, Discover, and Buy Virtually Anything http://www.amazon.com Joe Testa wrote: This is a multi-part message in MIME format. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
analyze table takes forever
Dear gurus ! We are trying to analyze a table partition (estimate 2 %) and it takes forever. analyze table ... partition (P20021022) estimate statistics sample 2 percent; For instance, select count(*) from the same partition takes 10 minutes , but the analyze takes literally infinite amount of time , once i left it to run for half a day and killed it since it did not finish. Even when i do analyze ... estimate statistics sample 100 rows; , it takes almost 2 minutes to ananlyze 100 rows. Any ideas ? It's Oracle 8.1.6 on an expensive 6 CPUs HP machine with EMC storage. Thanks a lot in advance. DBAndrey * 03-9254520 * 058-548133 * mailto:andreyb;elrontelesoft.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Internals course
Mark Leith wrote: What is shown to you on the Oracle Ed site, is actually based upon where you are located, within your login profile. I don't see any mention of Seminars what so ever (being UK based).. Can anyone else in the UK confirm this? Cheers Mark Nothing of the sort visible from the other side of the Channel either. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Internals course
Some guy in the Netherlands uh huh --- Anjo Kolk [EMAIL PROTECTED] wrote: No I have given them for Oracle in Holland, Belgium, Norway, Singapore and Malaysia. Anjo. -Original Message- Sent: Tuesday, October 29, 2002 12:58 PM To: Multiple recipients of list ORACLE-L Are these Internals classes only available in the US? -Original Message- Carmichael Sent: 29 October 2002 11:04 To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Internals course Tom, I didn't mean to imply that you were going into damagement! I was lucky enough to have someone point me to seminars and figured I'd share my luck. I think the reason they don't publicize it is that he is the only one teaching it and it's full without publicizing. Can you imagine if they made it generally available? He'd have time to do nothing else! Rachel --- Tom Pall [EMAIL PROTECTED] wrote: Rachel, I'm not bucking for a management slot by being clueless about the details. Really I'm not. I registered online for the internals course by searching for it. I just kind of assumed from what Scott said that I just managed to luck out when I searched for the course and found it. I mistakenly assumed the course was quietly being removed from online registration after hearing Scott's statements about hiding and not publicizing the course. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 28, 2002 8:58 PM I registered for it online, at education.oracle.com you have to search on seminars, not classes. It's difficult to find, but it IS there --- Tom Pall [EMAIL PROTECTED] wrote: RE: Oracle Internals courseThat rumor's been going on for versions now. As has been Scott's desire to offer a two week internals course. Course participants would sign all sorts of non-disclosure forms then get a scaled down version of what's taught to Customer Support. Wait a minute! Customer Support takes these courses? Surely not all the Silver Support people I've called. A difficulty with a two week course is that the very DBAs most likely to benefit from the course are the ones least likely to be let free for two weeks. The internals course is slated to be yanked every time a new version of Oracle comes out. Why teach internals when there are no initialization parameters and the database maintains and tunes itself? There's been an economic downturn and Oracle DBAs have lost their jobs. But anybody know an Oracle DBA who lost his job because a later version doesn't require a DBA? Oracle on CDs 1,2 and 3, huh? I think if I dig enough I can find that old version of Oracle I had that came on a single diskette. Scott says the internals course is purposely hidden. You have to call Oracle directly and ask for it. A number of people registered for the course from the paper or online catalogs, showed up then complained that they weren't about to get anything out of the course.. - Original Message - From: Nick Wagner To: Multiple recipients of list ORACLE-L Sent: Monday, October 28, 2002 3:23 PM Subject: RE: Oracle Internals course rumor has it that this course is not going to be offered/modified for the 9.2 release of Oracle. Can anyone confirm or deny it? Nick p.s. Had a close friend take this class, and they also came back extremely pleased with it. -Original Message- From: Rachel Carmichael [mailto:wisernet100;yahoo.com] Sent: Monday, October 28, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Internals course Scott is the instructors's instructor he learns the new features, then teaches them to the instructors so they can teach them to you I had the pleasure of taking those classes with Scott a few years ago as well. He's a great teacher. If he is ever presenting at any conference you go to, GO SEE HIM --- Tom Pall [EMAIL PROTECTED] wrote: I took that very course with Scott a few years ago. Yup, Scott flies through the Internals and Dump/Traces courses with lots of extra material to spare. It's really refreshing to hear him tell the class how the developers documented something then tell how it's actually built. He keeps a database running in his notebook to prove what he says. Scott's one great teacher. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 28, 2002 12:53 PM I just wanted to say... If you have a chance to
Re: Implicit Date conversion problem
Raj: The date column has a timestamp value as well. By using the TRUNC function, you are getting all dates regardless of the time value (i.e. 12:01 AM, etc.) . When dealing with DATE datatypes it is always a good practice to use the TRUNC function on the columns to prevent the time of day portion of the date from being considered in the query. You can also make the TRUNC function part of a constraint or trigger, or create a general trigger, to ensure that only the date is placed in the column, and if a time is inserted, then it will be uniform time of , say 12:00AM. RWB -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Stand-by database implementation ...
On Tue, Oct 29, 2002 at 07:23:33AM -0800, Lizz Pena wrote: Looks like I'm gonna implement a stand-by database on Windows 2000 using Oracle 8.1.7.4 Anyone have any good article, how-tos, caviots I need to consider or read up on? -- caveat, from Latin, let him beware. Ain't English great, never a dull moment. I think the oracle docs cover it well, amazingly. leave it to you to manage the archivelogs, so you need to write some scripts. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sqlplus /nolog
Title: sqlplus /nolog It doesn't? $ sqlplus "/ as sysdba" SQL*Plus: Release 9.2.0.1.0 - Production on Tue Oct 29 10:39:53 2002 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to:Oracle9i Enterprise Edition Release 9.2.0.1.0 - ProductionWith the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.1.0 - Production SYS@hydra@fins SQL -Original Message-From: Rodd Holman [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 29, 2002 9:54 AMTo: Multiple recipients of list ORACLE-LSubject: Re: sqlplus /nologIt opens up a sqlplus session session/shell on the server without logging into a database. The 9i version of sqlplus does not allow for a command line: sqlplus / as sysdba command. You have to login to sqlplus and when prompted for the username then add / as sysdba. The /nolog allows you to script running sqlplus and then having the connect / as sysdba as the first line in your sqlscript ie: sqlplus /nolog @myscript.sql myscript.sql: connect / as sysdba select name from v$database; Rodd On Tue, 2002-10-29 at 07:29, Daiminger, Helmut wrote: Hi! I was wondering what sqlplus /nolog actually does on Unix? Is it only used for not listing username/password when doing a ps ? Or anything else? This is 8.1.7 on Sun Solaris. Thanks, Helmut -- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED]
O/S Authentication
Greetings ALL.. I have been assigned a security research project by my boss. Really simple topic, o/s authentication vs. password file authentication. Currently we use a password file, and the boss wants to know what it would take to convert to o/s authentication instead. However, I'm not familiar with o/s authentication. Can anyone assist? Currently we are using Oracle 81730 - Standard edition - on a windows platform. Suggestions are welcome. thanks, C- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Turner, Christine INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: oracle or mssql
It's these readers-blocks-writers and dirty reads that makes people migrate their data to Oracle. Blocking writers kills performance. Of course constantly rolling back blocks to give queries consistent views uses i/o and cpu. But that extra overhead rarely impacts overall performance as badly as blocking readers/writers does. The typical impetus to migrate is that Oracle's redo/rollback/undo allows it to scale a lot better than MSSQL. It happens all the time. MSSQL was cheap, easy to set up and manage, ran as an integral part of WinTel, handled the low transaction rate. The transaction rate increases. Eventually all attempts to distribute the data amongst multiple boxes to handle the increased transaction rate fails. Exit MSSQL, enter Oracle. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 6:18 AM List, I'm always keen to refresh on database comparisons so thanks for everyone's pointers. I'm surprised Oracle doesn't make more of an issue about their locking and concurrency methods (i.e. redo/rollback/undo). MSSQL seems to deal with it in two ways: Default: readers and writers prevent writers from accessing data until they are finished with it! Other method: no control, you just get dirty reads! Anyone got anything to add to this? Or am I wrong? - Mike. -Original Message- Sent: 24 October 2002 17:29 To: Multiple recipients of list ORACLE-L As I said, use mssql ONLY if your boss is willing to be strapped into a MicroSlop only platform. If he's even remotely thinking of using a different OS then you can't use mssql. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 10/23/2002 11:48 PM goodmorning everybody who responded to my basic question : thanks summary professional : use oracle enterprise edition semi professional : use oracle standard edition / mssql enterprise edition in all other cases mssql standard edition -Oorspronkelijk bericht- Van: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]] Verzonden:woensdag 23 oktober 2002 20:51 Aan: Multiple recipients of list ORACLE-L Onderwerp:RE: oracle or mssql Xenix is history now...SCO itself stopped it sometime in 1990 Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 23 Oct 2002 09:02:19 -0800 XENIX maybe. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 23, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Is MSSQL server available on UNIX? -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get faster connections -- switch to MSN Internet Access! http://resourcecenter.msn.com/access/plans/default.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed
Re: imp/exp question
Hi, what do you mean with to export in system user with two user tables ? Regards, Adrian Ciocildau Oracle wrote: Dear One of the solution is you can export in system user with two user tables. You can exp/ imp blob column also. Later you can imp thru system, but use from user and to user options. I think it will help u. Thanks and Regards V.Baskaran -Original Message- Ciocildau Sent: Tuesday, October 29, 2002 11:18 To: Multiple recipients of list ORACLE-L Hello, I have a problem and I hope you can help me. We have a Oracle 9 installation two users with two different default tablespaces. The problem is to move data between theese two users with imp/exp. I'll try to explain it a little bit more. we have userA with the default tablescape tabA and userB with tablB. first we want to do something like: exp userA/passA owner=(userA) file=dump.dmp and after: imp userB/passB fromuser=(userA) touser=(userB) file=dump.dmp If we do not have BLOB columns everything works fine. I think the problem resides in the fact that in the case of a BLOB column the STORAGE clause specifies in which tablespace the BLOB column should be stored and this is not handled by the imp program (not relocated in the tablespace B). I'm sure there should be a way to handle this but I was not able to find it. Please help. Adrian -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Ciocildau INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Installing iAS 9.0.2.0.1
Thanks for all the replies. It makes me rethink going to iAS 9.0.2.0.1. Does iAS 1.0.2 require all the same dependencies, i.e. infrastructure install? Gene [EMAIL PROTECTED] 10/29/02 07:53AM made the same experiences with iAS 92 and ended up using 9iAS 1.0.2.2 for various reasons. but we will try again, when oracle - hopefully - does provide a more comfortable way of installation. we use portal, single sign on in connection with novel ldap. was quite a toil to get it up and running but now it works fine. did the same with iAS 9.2.0 but response time and performance were horrible so we removed it again and ...see above. good luck [EMAIL PROTECTED] 10/28/02 16:42 PM If you only want it to do web apps it's not a problem. We installed the OC4J and web cache portion on Solaris in an hour. Very easy. Needed it for version 1.3 of Java. Next we will tackle the full install with the infrastructure which will allow the use of Portal, Reports and Discoverer. Expecting big time headaches based on the documentation and the fact that we want to use iPlanet not the OID for our LDAP. Ben -Original Message- [EMAIL PROTECTED] Sent: October 25, 2002 3:56 PM To: Multiple recipients of list ORACLE-L Gene, We tried it on HPUX and it was not pretty. We ended up going back to 9iAS 1.0.2.2 for various reasons. Good luck. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Gene Sais [SMTP:[EMAIL PROTECTED]] Sent: Friday, October 25, 2002 2:34 PM To: Multiple recipients of list ORACLE-L Subject: Installing iAS 9.0.2.0.1 Has anyone installed iAS 9.0.2.0.1 on Intel Linux? I have downloaded the reams of documentation and this is a beast, much different than OAS 4.0.8. It requires a 9i db, Oracle Single SignOn, OID, OEM Server, 9i Listener w/ port 1521 free for iAS, etc. So many dependencies for iAS and I haven't even looked at deploying forms yet :). I can't wait til 10i when DBA's are no longer required, *HA!* Gene -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Implicit Date conversion problem
Title: RE: Implicit Date conversion problem
Raj,
you
said:
"according to Oracle, when comparing a
varchar2 to a date column, the string does get converted to a date ...
"
This
has got to be wrong. If you compare a varchar2 column with anumber,
Oracle try's to convert the varchar2 to a number, and we end up with an "invalid
number" error. Oracle has not choice but to attempt to convert a database
column to a literal - it can *never* go in the other direction because it cannot
make the correct assumption. At least I would not try and provide that
service.
I
would explain to the developers and the managers that this is the way it
works. And it will always work correctly if they do explicit date
conversion in their Sql. Once they begin coding this correctly, they will
always be happy - it will always work consistently.
The
manuals have been known to be wrong in the past, and if you and they have found
the above quote in a manual, it is wrong. At least I have *never* seen
Oracle act like this.
Hope
this helps.
Tom Mercadante Oracle Certified Professional
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 29, 2002
10:42 AMTo: 'Mercadante, Thomas F';
'[EMAIL PROTECTED]'Subject: RE: Implicit Date conversion
problem
Well,
Let me point out one thing following is the original
query ...
-- this returns no rows ... select
ea1.ep_number, ea1.est_dt, veas.est_dt from
(select a.ep_number, ea.est_dt from
v_episode_avail_summary_break a, episode_airings ea where a.ep_number =
ea.ep_number and
ea.est_dt between '20-Dec-02' and '01-Jan-03' group by a.ep_number,
ea.est_dt) veas,
episode_airings ea1 where veas.ep_number =
ea1.ep_number and ea1.est_dt between
'20-Dec-02' and '01-Jan-03'
-- This DOES work ... returns all the right rows
select ea1.ep_number, ea1.est_dt, veas.est_dt
from (select a.ep_number, ea.est_dt
from v_episode_avail_summary_break a, episode_airings ea where a.ep_number =
ea.ep_number and
ea.est_dt between '20-Dec-02' and '01-Jan-03' group by a.ep_number,
ea.est_dt) veas,
episode_airings ea1 where veas.ep_number =
ea1.ep_number -- and ea1.est_dt between
'20-Dec-02' and '01-Jan-03'
Point to consider is that the "commented out where clause" is
the same as the one used in the from clause query ... then why does it
fail?
Tom: according to Oracle, when comparing a varchar2 to a date
column, the string does get converted to a date ...
The reason i am asking this I have to explain the developers
on why this isn't working. They agree that explicit datatype conversion is a
good idea but their managers want to know why ??
(yeah ... sure go ahead pity me ...) 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!
-Original Message- From:
Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 29, 2002 10:35 AM To: '[EMAIL PROTECTED]' Cc: Jamadagni,
Rajendra Subject: RE: Implicit Date conversion
problem
Raj,
you are forgetting how dates are stored internally vs. how
they are displayed by sqlplus.
change your first query to:
select ea1.ep_number, ea1.est_dt, veas.est_dt from (select a.ep_number, ea.est_dt from
v_episode_avail_summary_break a, episode_airings ea where a.ep_number =
ea.ep_number and
ea.est_dt between to_date('20-Dec-2002','dd-mon-') and
to_date('01-Jan-2003' ,'dd-mon-') group by a.ep_number,
ea.est_dt) veas,
episode_airings ea1 where veas.ep_number =
ea1.ep_number and ea1.est_dt between between
to_date('20-Dec-2002','dd-mon-') and to_date('01-Jan-2003'
,'dd-mon-')
Your selection was not working properly because you ended up
comparing string values with string values.
example: 21-Dec-2002 is not between 20-Dec-2002 and
01-Jan-2003 using string comparison
(21 is greater than 20 and 01 both).
hope this helps.
Tom Mercadante Oracle Certified
Professional
RE: Data guard
Solaris 5.7 From: Fink, Dan [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Data guard Date: Mon, 28 Oct 2002 13:43:33 -0800 What platform are you on? If UNIX, make sure your i/o settings for reads and writes (asynch or synch) are set to the same value and they agree with the system configuration. There was a known bug in 7.3 that corrupted archive logs that was supposedly fixed in 7.3.4. Do a search on metalink for 'alter system switch logfile'. -Original Message- Sent: Monday, October 28, 2002 1:38 PM To: Multiple recipients of list ORACLE-L Hi I have setup dataguard on 8.1.7.4 and have been noticing corruption of archive logs at standby end some times.What could be reason? With regards -Seema _ Surf the Web without missing calls! Get MSN Broadband. http://resourcecenter.msn.com/access/plans/freeactivation.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Broadband? Dial-up? Get reliable MSN Internet Access. http://resourcecenter.msn.com/access/plans/default.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Implicit Date conversion problem
Jamadagni, Rajendra wrote: Well, Let me point out one thing following is the original query ... -- this returns no rows ... select ea1.ep_number, ea1.est_dt, veas.est_dt from (select a.ep_number, ea.est_dt from v_episode_avail_summary_break a, episode_airings ea where a.ep_number = ea.ep_number and ea.est_dt between '20-Dec-02' and '01-Jan-03' group by a.ep_number, ea.est_dt) veas, episode_airings ea1 where veas.ep_number = ea1.ep_number and ea1.est_dt between '20-Dec-02' and '01-Jan-03' -- This DOES work ... returns all the right rows select ea1.ep_number, ea1.est_dt, veas.est_dt from (select a.ep_number, ea.est_dt from v_episode_avail_summary_break a, episode_airings ea where a.ep_number = ea.ep_number and ea.est_dt between '20-Dec-02' and '01-Jan-03' group by a.ep_number, ea.est_dt) veas, episode_airings ea1 where veas.ep_number = ea1.ep_number -- and ea1.est_dt between '20-Dec-02' and '01-Jan-03' Point to consider is that the commented out where clause is the same as the one used in the from clause query ... then why does it fail? Tom: according to Oracle, when comparing a varchar2 to a date column, the string does get converted to a date ... The reason i am asking this I have to explain the developers on why this isn't working. They agree that explicit datatype conversion is a good idea but their managers want to know why ?? (yeah ... sure go ahead pity me ...) Raj Raj, I think I've got it. In the in-line view the implicit conversion going on is a to_date() applied to the string constants (since it works). Outside it must be a to_char() applied to the date column. Why it is so escapes my understanding but it may have something to do with getting the column directly from a well known table in the first case, and from a built-on-the-fly view in the second one. Talking about the developers and their managers, perhaps you could hint that having a GROUP BY without any aggregate function is probably their way to program SELECT DISTINCT, and that since they are using only a single column from (which by the way happens to also be in episode_airings, since it's used for the join) is a bit weird (unless you have simplified the query for testing purposes?). I am sure that the query would be better directly working on the tables 'below' v_episode_avail_summary_break. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
9i RAC
A quick question out to the masses.. How many of you out there are ACTUALLY USING 9i RAC technology? If not already using it - how many have plans to use it (or at least plan to investigate it)? Cheers Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Implicit Date conversion problem
Tom,
If the string matches the NLS_DATE_FORMAT, Oracle will convert it to a
date.
Try this:
create table d( d date );
alter session set nls_date_format = 'dd-mon-yy';
insert into d values('21-dec-02');
insert into d values('22-dec-02');
insert into d values('23-dec-02');
insert into d values('24-dec-02');
commit;
select *
from d
where d.d between '22-dec-02' and '23-dec-02'
/
Jared
Mercadante, Thomas F [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/29/2002 07:54 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Implicit Date conversion problem
Raj,
you said:
according to Oracle, when comparing a varchar2 to a date column, the
string does get converted to a date ...
This has got to be wrong. If you compare a varchar2 column with a number,
Oracle try's to convert the varchar2 to a number, and we end up with an
invalid number error. Oracle has not choice but to attempt to convert a
database column to a literal - it can *never* go in the other direction
because it cannot make the correct assumption. At least I would not try
and provide that service.
I would explain to the developers and the managers that this is the way it
works. And it will always work correctly if they do explicit date
conversion in their Sql. Once they begin coding this correctly, they will
always be happy - it will always work consistently.
The manuals have been known to be wrong in the past, and if you and they
have found the above quote in a manual, it is wrong. At least I have
*never* seen Oracle act like this.
Hope this helps.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, October 29, 2002 10:42 AM
To: 'Mercadante, Thomas F'; '[EMAIL PROTECTED]'
Well,
Let me point out one thing following is the original query ...
-- this returns no rows ...
select ea1.ep_number, ea1.est_dt, veas.est_dt
from (select a.ep_number, ea.est_dt
from v_episode_avail_summary_break a, episode_airings ea
where a.ep_number = ea.ep_number
and ea.est_dt between '20-Dec-02' and '01-Jan-03'
group by a.ep_number, ea.est_dt) veas,
episode_airings ea1
where veas.ep_number = ea1.ep_number
and ea1.est_dt between '20-Dec-02' and '01-Jan-03'
-- This DOES work ... returns all the right rows
select ea1.ep_number, ea1.est_dt, veas.est_dt
from (select a.ep_number, ea.est_dt
from v_episode_avail_summary_break a, episode_airings ea
where a.ep_number = ea.ep_number
and ea.est_dt between '20-Dec-02' and '01-Jan-03'
group by a.ep_number, ea.est_dt) veas,
episode_airings ea1
where veas.ep_number = ea1.ep_number
-- and ea1.est_dt between '20-Dec-02' and '01-Jan-03'
Point to consider is that the commented out where clause is the same as
the one used in the from clause query ... then why does it fail?
Tom: according to Oracle, when comparing a varchar2 to a date column, the
string does get converted to a date ...
The reason i am asking this I have to explain the developers on why this
isn't working. They agree that explicit datatype conversion is a good idea
but their managers want to know why ??
(yeah ... sure go ahead pity me ...)
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!
-Original Message-
Sent: Tuesday, October 29, 2002 10:35 AM
To: '[EMAIL PROTECTED]'
Cc: Jamadagni, Rajendra
Raj,
you are forgetting how dates are stored internally vs. how they are
displayed by sqlplus.
change your first query to:
select ea1.ep_number, ea1.est_dt, veas.est_dt
from (select a.ep_number, ea.est_dt
from v_episode_avail_summary_break a, episode_airings ea
where a.ep_number = ea.ep_number
and ea.est_dt between to_date('20-Dec-2002','dd-mon-') and
to_date('01-Jan-2003' ,'dd-mon-')
group by a.ep_number, ea.est_dt) veas,
episode_airings ea1
where veas.ep_number = ea1.ep_number
and ea1.est_dt between between to_date('20-Dec-2002','dd-mon-') and
to_date('01-Jan-2003' ,'dd-mon-')
Your selection was not working properly because you ended up comparing
string values with string values.
example: 21-Dec-2002 is not between 20-Dec-2002 and 01-Jan-2003 using
string comparison
(21 is greater than 20 and 01 both).
hope this helps.
Tom Mercadante
Oracle Certified Professional
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
RE: Convert DM TSP to LM TSP w/ lots of data
This is what we have in mind. For the partitioned tables that are going to have the 'rotation' logic, we will convert them to LMT when they become empty. We drop the 'oldest' partition and create a new one for next month. This will be carried out every month. Partition for November data is empty now and is being converted to use LMT as of this week; Next month we will do the same for December partition; This way, we would convert all our 5 CALLDETAIL tablespaces to use LMT in 5 months time. Now, for other tablespaces that contain data and indexes, we need to decide whether we should create corresponding LMT tablespaces and move the existing objects to it or change them using the procedure that Oracle recommends; Some of these tablespaces are sized anywhere from 5Gb to 60Gb and we do not have much of freespace as buffer. Our database size is about 1.2 tera bytes. Also for this we might have to ask for a bigger maintenance window which will be hard to get. So we are toying up with the idea of converting them from DMT to LMT using 'in place' mechanism and rebuild the tables/indexes eventually as time permits. Obviously, we are not trying cause any outage knowingly. Hence these questions to the forum. Thanks, Govind -Original Message- Sent: Tuesday, October 29, 2002 8:49 AM To: Multiple recipients of list ORACLE-L Govind - I agree with Tom. Since you phrased your original question asking for those who had done the conversion, the silence was your answer. If you had also asked for replies from those who had decided to build new tablespaces and convert the data ourselves, then more of us could have replied. My reason for not using the conversion utility has to do with the smell test. After you've been a DBA for awhile, you realize you have limited time and you lose your eagerness to pursue things that will eat up enormous amounts of time and come to nothing. In my situation, I was able to move a table at a time to LMT as time permitted, and somehow I felt that the resulting data situation would be better. I believe some of the new nologging options may allow you to perform this while the table is still available for DML. When first introduced, the conversion routines had some bugs. I don't think the conversion routines are bad today, so they may work just fine. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 29, 2002 12:34 AM To: Multiple recipients of list ORACLE-L I tried having Oracle convert DMT to LMT out a few times on 10 GB tablespaces. Whether or not that's a lot of data depends on you. Worked like a champ. And this was in the early days of LMT. People who pay a lot of attention to the internals will warn you that converting a DMT to LMT is not optimal. Your bitmaps wind up at the end of the files instead of the headers. I've read posts here and elsewhere where people worried about the same issues as they did with DMT. They wanted to limit the number of extents segments grew to by creating tablespaces with different sized fixed extents. A DBA I worked with pointed out how very easy and quickly things worked with letting Oracle automatically size the next extent. I've gone that way whenever possible and have never regretted it. I've not done a rigorous benchmark but can tell you from casual observation dropping an object with lots of extents doesn't happen in the blink of an eye but doesn't lock out all other space allocation as UET/FET weren't constantly in use and the ST enque wasn't locked for exclusive use. It's prudent to follow Oracle's recommendations if conditions permit. Create a new LMT and move your data to it. - Original Message - To: Multiple mailto:ORACLE-L;fatcity.com recipients of list ORACLE-L Sent: Monday, October 28, 2002 8:43 PM I am reposting this. Has anyone tried to convert a dictionary managed table space containing lots of data to locally managed? We have tried this out successfully on empty table spaces or created a new LMT tablespace and moved the existing objects to it. Thanks, Govind -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting
RE: Win2k Perl accessing Oracle Parameters?
Jared:
PPM search Tie::Registry
PPM search Win32::Registry
Packages available from
http://ppm.ActiveState.com/cgibin/PPM/ppmserver.pl?urn:/
PPMServer:
Win32-Registry-File [1.09] Perl interface to MS-Windows registry files.
PPM
Is 1.09 really what I want to install?
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas
-Original Message-
Still
Sent: Tuesday, October 29, 2002 9:35 AM
To: Multiple recipients of list ORACLE-L
In addition to BIshop's excellent response, be sure to install
the latest version of Tie:Registry. The one that comes with
ActiveState Perl doesn't work properly.
The current version (as installed from ActiveState via PPM)
is I believe 1.24. Just reinstall it.
Jared
On Tuesday 29 October 2002 01:53, Bishop Lewis wrote:
Here's something to read registry keys I used a while back. Obviously
needs
the win32 module installed.
use Win32::Registry;
$terminal = $ARGV[0];
$HKEY_LOCAL_MACHINE-Connect ($terminal, $hNode) || die Cannot
connect to
$node;
$hNode-Open (SOFTWARE\\Microsoft\\Windows
NT\\CurrentVersion\\Winlogon,
$hKey) || die Cannot open registry !;
$hKey-GetValues (\%values);
$hKey-Close ();
$hNode-Close ();
foreach $value (keys(%values)) {
$RegType = $values{$value}-[1];
$RegValue = $values{$value}-[2];
$RegKey = $values{$value}-[0];
if ($RegKey eq DefaultUserName) {$username = $RegValue;
print $RegValue\n;
}
}
exit;
Modify accordingly. HTH.
Lewis Bishop
---
Barclays Enable - ISS - E-NTRUST/Bexleyheath NT
Oracle Database Consultant
Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R)
Phone : 020 8298 3418
Mobile: 07950 380857
Email : [EMAIL PROTECTED]
Enabling Competitive Advantage for Barclays in IT and Business
Processing
-Original Message-
Sent: 29 October 2002 08:43
To: Multiple recipients of list ORACLE-L
This header confirms that this email message has been swept for the
presence of computer viruses.
Corporate IT
THE WOOLWICH
--
Hello All,
I am writing an perl script. I cann't figure out and have been going
through the docs, but cann't find exactly what I need.
A way to access Oracle Parameters as they are set up in the Win2k
registary. I am specifically thinking of ORACLE_HOME. I do know how to
obtain an environmental variable/parameter with $ENV{}.
But the ORACLE_HOME is not an environmental parameter per se.
I have a workaround by setting it up in the enviroment, however I
would
like to write this script with the aim at it being machine unspecific.
(Jared, hope you can answer me on this. Want to get a copy of your
book,
unfortunately with the exchange rate and import taxes etc it will cost
me
R590,00. Quiet a chunk of the ole budget, maybe early next year.)
Regards
Denham Eva
Oracle DBA
UNIX is basically a simple operating system, but you have to be a
genius
to understand the simplicity.
Dennis Ritchie.
_
DISCLAIMER
This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission.
If
you receive this message in error, please immediately delete it and
all
copies of it from your system, destroy any hard copies of it and
notify the
sender. You must not, directly or indirectly, use, disclose,
distribute,
print, or copy any part of this message if you are not the intended
recipient. TFMC, its holding company, and any of its subsidiaries each
reserve the right to monitor and manage all e-mail communications
through
its networks.
Any views expressed in this message are those of the individual
sender,
except where the message states otherwise and the sender is authorized
to
state them to be views of any such entity.
_
_
This e-mail message has been scanned for Viruses and Content and
cleared by
MailMarshal - For more information please visit
http://www.marshalsoftware.com www.marshalsoftware.com
_
--_=_NextPart_001_01C27F2F.5CF0F180
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN
html xmlns:v=3Durn:schemas-microsoft-com:vml =
xmlns:o=3Durn:schemas-microsoft-com:office:office =
xmlns:w=3Durn:schemas-microsoft-com:office:word =
xmlns:st1=3Durn:schemas-microsoft-com:office:smarttags =
xmlns=3Dhttp://www.w3.org/TR/REC-html40;
head
META HTTP-EQUIV=3DContent-Type CONTENT=3Dtext/html; =
charset=3Dus-ascii
meta name=3DProgId content=3DWord.Document
meta name=3DGenerator content=3DMicrosoft Word 10
meta name=3DOriginator content=3DMicrosoft Word 10
link rel=3DFile-List href=3Dcid:filelist.xml;01C27F2F.66CF0930
link rel=3DEdit-Time-Data
Re: 9i RAC
I run it at home on the laptop if that counts :-) But seriously, I'm working with a client who are migrating from a large Sun box to a 4node Tru64 RAC architecture on 9.2 Do I think it will workprobably not Cheers Connor --- Mark Leith [EMAIL PROTECTED] wrote: A quick question out to the masses.. How many of you out there are ACTUALLY USING 9i RAC technology? If not already using it - how many have plans to use it (or at least plan to investigate it)? Cheers Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Logon Trigger
Sorry in advance, but I didn't think I'd need this. There was a discussion about 4 weeks ago if memory serves correct, about denying users logging on to Oracle directly either through SQL*Plus or other tools such as TOAD. Tried searching the archives but getting too many hits. Someone posted trigger code that did this. Anyone have a copy of this? Thanks mkb __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sqlplus /nolog
I beg to differ Mr. Holman. The sqlplus command should work if the / as sysdba is enclosed in quotes. So , the command would be sqlplus / as sysdba . This works in Oracle9i on Unix and Windows NT/2000 environmnents. At least it does so in my environments. RWB Rodd Holman [EMAIL PROTECTED]@fatcity.com on 10/29/2002 08:54:00 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: It opens up a sqlplus session session/shell on the server without logging into a database. The 9i version of sqlplus does not allow for a command line: sqlplus / as sysdba command. You have to login to sqlplus and when prompted for the username then add / as sysdba. The /nolog allows you to script running sqlplus and then having the connect / as sysdba as the first line in your sqlscript ie: sqlplus /nolog @myscript.sql myscript.sql: connect / as sysdba select name from v$database; Rodd On Tue, 2002-10-29 at 07:29, Daiminger, Helmut wrote: Hi! I was wondering what sqlplus /nolog actually does on Unix? Is it only used for not listing username/password when doing a ps ? Or anything else? This is 8.1.7 on Sun Solaris. Thanks, Helmut -- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Installing iAS 9.0.2.0.1
No, 1.0.2 is a leaner product - no infrastructure required. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Gene Sais [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, October 29, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Subject: RE: Installing iAS 9.0.2.0.1 Thanks for all the replies. It makes me rethink going to iAS 9.0.2.0.1. Does iAS 1.0.2 require all the same dependencies, i.e. infrastructure install? Gene [EMAIL PROTECTED] 10/29/02 07:53AM made the same experiences with iAS 92 and ended up using 9iAS 1.0.2.2 for various reasons. but we will try again, when oracle - hopefully - does provide a more comfortable way of installation. we use portal, single sign on in connection with novel ldap. was quite a toil to get it up and running but now it works fine. did the same with iAS 9.2.0 but response time and performance were horrible so we removed it again and ...see above. good luck -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: BLOB Storage
The BLOB can be in line if the size is less than 4k, otherwise it is stored as out-of-line. RWB Gene Sais [EMAIL PROTECTED]@fatcity.com on 10/29/2002 07:39:01 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: I have a 1tb db w/ 95% of it inline blobs, same tbs as data. No performance degradation. However, if I were to do it again, I would have separated the blobs out as B/R is a nightmare, soon to be better w/ RMAN. I haven't received my RF RMAN book yet, amazon must be backfilling orders. hth, Gene [EMAIL PROTECTED] 10/28/02 09:18PM We've got a table with a BLOB column that is currently at 3+ Gig (400,000 records). The max value in the BLOB column is 3k (average (1.5 K). We are currently storing the BLOB out of line (in a separate tablespace). The cache size for the BLOB is 8k (also the block size). Each BLOB is taking up 8K (at the least twice the space required by the BLOB). This table is expected to grow to 10+ million records in the next year. First of all, we're trying to convince the vendor to agree to partition the table. In addition (FINALLY the question :-) !!!), we're trying to decide whether we would gain anything (space being a constraint right now), from a storage standpoint in making the BLOB in line. Obviously we're not going to going to risk performance in order to save space :-) !!! I'm hoping someone in this list would have had some goog or bad experience in this regard. Would there be a major performance hit if I change the BLOB to be in line Thanks, Sunny - Do you Yahoo!? Y! Web Hosting - Let the expert host your web site -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i RAC
We are planning to use it on Solaris. Gerardo -Original Message- Sent: Tuesday, October 29, 2002 8:30 AM To: Multiple recipients of list ORACLE-L A quick question out to the masses.. How many of you out there are ACTUALLY USING 9i RAC technology? If not already using it - how many have plans to use it (or at least plan to investigate it)? Cheers Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Molina, Gerardo INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sqlplus /nolog
Title: sqlplus /nolog Ah ha. It's the double quotes you use. These were not necessary with svrmgrl Rodd On Tue, 2002-10-29 at 09:49, Toepke, Kevin M wrote: It doesn't? $ sqlplus / as sysdba SQL*Plus: Release 9.2.0.1.0 - Production on Tue Oct 29 10:39:53 2002 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production SYS@hydra@fins SQL -Original Message- From: Rodd Holman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 29, 2002 9:54 AM To: Multiple recipients of list ORACLE-L Subject: Re: sqlplus /nolog It opens up a sqlplus session session/shell on the server without logging into a database. The 9i version of sqlplus does not allow for a command line: sqlplus / as sysdba command. You have to login to sqlplus and when prompted for the username then add / as sysdba. The /nolog allows you to script running sqlplus and then having the connect / as sysdba as the first line in your sqlscript ie: sqlplus /nolog @myscript.sql myscript.sql: connect / as sysdba select name from v$database; Rodd On Tue, 2002-10-29 at 07:29, Daiminger, Helmut wrote: Hi! I was wondering what sqlplus /nolog actually does on Unix? Is it only used for not listing username/password when doing a ps ? Or anything else? This is 8.1.7 on Sun Solaris. Thanks, Helmut -- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED] -- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED]
Mixing OLTP with DSS
Am I looking for trouble by mixing an OLTP type database with a DSS type database? I currently have a relatively small database that is used for quick lookup type actions. The company wants to add a much bigger and constantly growing application for historical reporting on the same machine. Should I create another instance or keep it in the same instance? Keeping it in the same instance would seem to defeat having anything cached seeing that the large reports will flush out the cache each and every time. I am running Oracle 8.1.7, on Solaris 2.8. Any suggestions would be helpful. Thanks, Rick Stephenson
Re: RV: Nuestra Profesión Ing. Sistemas
Esto me dio mucha risa. Alguien lo va a traducir al ingles para el resto de la lista? Esteban [EMAIL PROTECTED] 10/24/02 12:05PM Ups colegas ! @lex Lic. Alexander Ordóñez Arroyo Soporte Tru64Unix BD Oracle Caja Costarricense del Seguro Social Telefono: 295-2004, San José, Costa Rica [EMAIL PROTECTED] Celular 397-0532 The truth is out there in WWW Tomado de Un amigo Estoy pensando seriamente dejar de ser ingeniero en sistemas 1.- Trabajas en horas extrañas. !Como las putas! 2.- Te pagan para mantener al cliente feliz. !Como las putas! 3.- El cliente paga mucho mas pero tu jefe se queda con casi todo el dinero. !Como las putas! 4.- Cobras por hora pero tu tiempo se extiende hasta que termines. ! Como las putas! 5.- Si eres bueno, nunca estas orgulloso de lo que haces. !Como las putas! 6.- Te recompensan por satisfacer las fantasías de tus clientes. !Como las putas! 7.- Es difícil tener y mantener una familia. !Como las putas! 8.- Cuando te preguntan en que trabajas no lo puedes explicar. !Como las putas! 9.- Tus amigos se distancian de ti y tu solo andas con otros igual que tu. !Como las putas! 10.- El cliente paga tu cuenta del hotel y por horas trabajadas. !Como las putas! 11.- Tu jefe tiene un buen coche. !Como las putas! 12.- Cuando vas a hacer una asistencia al cliente estas óptimo. !Como las putas!. 13.- Pero cuando vuelves pareces haber salido del infierno. !Como las putas! 14.- Evalúan tu capacidad con horribles pruebas. !Como las putas! 15.- El cliente siempre quiere pagar menos y encima quiere que hagas maravillas. !Como las putas! 16.- Cada día al levantarte dices !!!NO VOY A HACER ESTO TODA MI VIDA!!!. !Como las putas! 17.- Sin conocer nada de su problema los clientes esperan que les des el consejo que necesitan. !Como las putas! 18.- Si las cosas salen mal es siempre culpa tuya. !Como las putas! 19.- Tienes que brindarle servicios gratis a tu jefe, amigos y familiares. !Como las putas! !Puta! ¿¿Hasta cuándo?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i RAC
Mark, If you read the latest Oracle Mag (Peer-to-Peer), you will find that a (sometime?) list member Murali Vallath is using RAC and is actually planning a book sometime later. Maybe you can address the question to him? Murali presents/attends IOUG and I know for sure that he 'speakes from the trenches' (unlike a lot of the bull from Oracle marketing). John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Mark Leith [mailto:mark;cool-tools.co.uk] Sent: Tuesday, October 29, 2002 8:30 AM To: Multiple recipients of list ORACLE-L Subject: 9i RAC A quick question out to the masses.. How many of you out there are ACTUALLY USING 9i RAC technology? If not already using it - how many have plans to use it (or at least plan to investigate it)? Cheers Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: analyze table takes forever
Title: RE: analyze table takes forever what's the structure of the table? And try taking an export of this partition and import it into it's own table in a development box... see if you can analyze it there. Nick -Original Message- From: Andrey Bronfin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 29, 2002 7:49 AM To: Multiple recipients of list ORACLE-L Subject: analyze table takes forever Dear gurus ! We are trying to analyze a table partition (estimate 2 %) and it takes forever. analyze table ... partition (P20021022) estimate statistics sample 2 percent; For instance, select count(*) from the same partition takes 10 minutes , but the analyze takes literally infinite amount of time , once i left it to run for half a day and killed it since it did not finish. Even when i do analyze ... estimate statistics sample 100 rows; , it takes almost 2 minutes to ananlyze 100 rows. Any ideas ? It's Oracle 8.1.6 on an expensive 6 CPUs HP machine with EMC storage. Thanks a lot in advance. DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i RAC
We are currently running 8i OPS and having serious issues with global cache request waits that kill the performance on the machines. Because of this issue, we are almost being forced to upgrade to 9i RAC. I hope and pray that this will work out, but I've learned to not count on much until you actually see it running in your environment. I'm not concerned though because the sales people tell me it's the best thing since sliced bread. :) Rick Stephenson Oracle Database Administrator Ovid Technologies, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 29, 2002 10:49 AM To: Multiple recipients of list ORACLE-L I run it at home on the laptop if that counts :-) But seriously, I'm working with a client who are migrating from a large Sun box to a 4node Tru64 RAC architecture on 9.2 Do I think it will workprobably not Cheers Connor --- Mark Leith [EMAIL PROTECTED] wrote: A quick question out to the masses.. How many of you out there are ACTUALLY USING 9i RAC technology? If not already using it - how many have plans to use it (or at least plan to investigate it)? Cheers Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rick Stephenson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Implicit Date conversion problem
Jared,
Of course, I have been corrected!
Woo-hoo! I win! I learned something new today! I get to go home early!
Wow. This was really a shocker to me. I tried a little test myself on an
817 database and it works as Raj (and the documentation) said it would.
Does this mean I will change my coding-ways and depend on it to work in the
future? Of course not! I like explicitly coding things so that I'm not
surprised! Old Dog.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, October 29, 2002 12:54 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Importance: High
Tom,
If the string matches the NLS_DATE_FORMAT, Oracle will convert it to a
date.
Try this:
create table d( d date );
alter session set nls_date_format = 'dd-mon-yy';
insert into d values('21-dec-02');
insert into d values('22-dec-02');
insert into d values('23-dec-02');
insert into d values('24-dec-02');
commit;
select *
from d
where d.d between '22-dec-02' and '23-dec-02'
/
Jared
Mercadante, Thomas F [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/29/2002 07:54 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Implicit Date conversion problem
Raj,
you said:
according to Oracle, when comparing a varchar2 to a date column, the
string does get converted to a date ...
This has got to be wrong. If you compare a varchar2 column with a number,
Oracle try's to convert the varchar2 to a number, and we end up with an
invalid number error. Oracle has not choice but to attempt to convert a
database column to a literal - it can *never* go in the other direction
because it cannot make the correct assumption. At least I would not try
and provide that service.
I would explain to the developers and the managers that this is the way it
works. And it will always work correctly if they do explicit date
conversion in their Sql. Once they begin coding this correctly, they will
always be happy - it will always work consistently.
The manuals have been known to be wrong in the past, and if you and they
have found the above quote in a manual, it is wrong. At least I have
*never* seen Oracle act like this.
Hope this helps.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, October 29, 2002 10:42 AM
To: 'Mercadante, Thomas F'; '[EMAIL PROTECTED]'
Well,
Let me point out one thing following is the original query ...
-- this returns no rows ...
select ea1.ep_number, ea1.est_dt, veas.est_dt
from (select a.ep_number, ea.est_dt
from v_episode_avail_summary_break a, episode_airings ea
where a.ep_number = ea.ep_number
and ea.est_dt between '20-Dec-02' and '01-Jan-03'
group by a.ep_number, ea.est_dt) veas,
episode_airings ea1
where veas.ep_number = ea1.ep_number
and ea1.est_dt between '20-Dec-02' and '01-Jan-03'
-- This DOES work ... returns all the right rows
select ea1.ep_number, ea1.est_dt, veas.est_dt
from (select a.ep_number, ea.est_dt
from v_episode_avail_summary_break a, episode_airings ea
where a.ep_number = ea.ep_number
and ea.est_dt between '20-Dec-02' and '01-Jan-03'
group by a.ep_number, ea.est_dt) veas,
episode_airings ea1
where veas.ep_number = ea1.ep_number
-- and ea1.est_dt between '20-Dec-02' and '01-Jan-03'
Point to consider is that the commented out where clause is the same as
the one used in the from clause query ... then why does it fail?
Tom: according to Oracle, when comparing a varchar2 to a date column, the
string does get converted to a date ...
The reason i am asking this I have to explain the developers on why this
isn't working. They agree that explicit datatype conversion is a good idea
but their managers want to know why ??
(yeah ... sure go ahead pity me ...)
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!
-Original Message-
Sent: Tuesday, October 29, 2002 10:35 AM
To: '[EMAIL PROTECTED]'
Cc: Jamadagni, Rajendra
Raj,
you are forgetting how dates are stored internally vs. how they are
displayed by sqlplus.
change your first query to:
select ea1.ep_number, ea1.est_dt, veas.est_dt
from (select a.ep_number, ea.est_dt
from v_episode_avail_summary_break a, episode_airings ea
where a.ep_number = ea.ep_number
and ea.est_dt between to_date('20-Dec-2002','dd-mon-') and
to_date('01-Jan-2003' ,'dd-mon-')
group by a.ep_number, ea.est_dt) veas,
episode_airings ea1
where veas.ep_number = ea1.ep_number
and ea1.est_dt between between to_date('20-Dec-2002','dd-mon-') and
RE: 9i RAC
Title: RE: 9i RAC forget 9201 ... 9202 has about 20+ fixes that are related to RAC code. ... 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! -Original Message- From: Rick Stephenson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 29, 2002 1:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: 9i RAC We are currently running 8i OPS and having serious issues with global cache request waits that kill the performance on the machines. Because of this issue, we are almost being forced to upgrade to 9i RAC. I hope and pray that this will work out, but I've learned to not count on much until you actually see it running in your environment. I'm not concerned though because the sales people tell me it's the best thing since sliced bread. :) Rick Stephenson Oracle Database Administrator Ovid Technologies, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 29, 2002 10:49 AM To: Multiple recipients of list ORACLE-L I run it at home on the laptop if that counts :-) But seriously, I'm working with a client who are migrating from a large Sun box to a 4node Tru64 RAC architecture on 9.2 Do I think it will workprobably not Cheers Connor --- Mark Leith [EMAIL PROTECTED] wrote: A quick question out to the masses.. How many of you out there are ACTUALLY USING 9i RAC technology? If not already using it - how many have plans to use it (or at least plan to investigate it)? Cheers Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rick Stephenson INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). *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
RE: Win2k Perl accessing Oracle Parameters?
Cary,
Here's what my search of Registry revealed:
PPM search Registry
Packages available from
http://ppm.ActiveState.com/cgibin/PPM/ppmserver.pl?urn:/PPMServer:
Win32-Registry-File [1.09] Perl interface to MS-Windows
registry
files.
Win32-TieRegistry [0.24] Powerful and easy ways to
manipulate a
registry [on Win32 for now].
Win32-TieRegistry-Dump [0.03] dump Win32 registry tree
Win32-TieRegistry-PMVersionInfo [0.2 ] store in Win32 Registry PM $VERSION
info
XML-Registry[0.02] Perl module for loading and saving
an
XML registry.
PPM
The version that usually comes with ActiveState Perl is 0.23, not 1.23 as
I implied before.
The version you want is version 0.24.
HTH
Jared
Cary Millsap [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/29/2002 09:13 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Win2k Perl accessing Oracle Parameters?
Jared:
PPM search Tie::Registry
PPM search Win32::Registry
Packages available from
http://ppm.ActiveState.com/cgibin/PPM/ppmserver.pl?urn:/
PPMServer:
Win32-Registry-File [1.09] Perl interface to MS-Windows registry files.
PPM
Is 1.09 really what I want to install?
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas
-Original Message-
Still
Sent: Tuesday, October 29, 2002 9:35 AM
To: Multiple recipients of list ORACLE-L
In addition to BIshop's excellent response, be sure to install
the latest version of Tie:Registry. The one that comes with
ActiveState Perl doesn't work properly.
The current version (as installed from ActiveState via PPM)
is I believe 1.24. Just reinstall it.
Jared
On Tuesday 29 October 2002 01:53, Bishop Lewis wrote:
Here's something to read registry keys I used a while back. Obviously
needs
the win32 module installed.
use Win32::Registry;
$terminal = $ARGV[0];
$HKEY_LOCAL_MACHINE-Connect ($terminal, $hNode) || die Cannot
connect to
$node;
$hNode-Open (SOFTWARE\\Microsoft\\Windows
NT\\CurrentVersion\\Winlogon,
$hKey) || die Cannot open registry !;
$hKey-GetValues (\%values);
$hKey-Close ();
$hNode-Close ();
foreach $value (keys(%values)) {
$RegType = $values{$value}-[1];
$RegValue = $values{$value}-[2];
$RegKey = $values{$value}-[0];
if ($RegKey eq DefaultUserName) {$username = $RegValue;
print $RegValue\n;
}
}
exit;
Modify accordingly. HTH.
Lewis Bishop
---
Barclays Enable - ISS - E-NTRUST/Bexleyheath NT
Oracle Database Consultant
Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R)
Phone : 020 8298 3418
Mobile: 07950 380857
Email : [EMAIL PROTECTED]
Enabling Competitive Advantage for Barclays in IT and Business
Processing
-Original Message-
Sent: 29 October 2002 08:43
To: Multiple recipients of list ORACLE-L
This header confirms that this email message has been swept for the
presence of computer viruses.
Corporate IT
THE WOOLWICH
--
Hello All,
I am writing an perl script. I cann't figure out and have been going
through the docs, but cann't find exactly what I need.
A way to access Oracle Parameters as they are set up in the Win2k
registary. I am specifically thinking of ORACLE_HOME. I do know how to
obtain an environmental variable/parameter with $ENV{}.
But the ORACLE_HOME is not an environmental parameter per se.
I have a workaround by setting it up in the enviroment, however I
would
like to write this script with the aim at it being machine unspecific.
(Jared, hope you can answer me on this. Want to get a copy of your
book,
unfortunately with the exchange rate and import taxes etc it will cost
me
R590,00. Quiet a chunk of the ole budget, maybe early next year.)
Regards
Denham Eva
Oracle DBA
UNIX is basically a simple operating system, but you have to be a
genius
to understand the simplicity.
Dennis Ritchie.
_
DISCLAIMER
This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission.
If
you receive this message in error, please immediately delete it and
all
copies of it from your system, destroy any hard copies of it and
notify the
sender. You must not, directly or indirectly, use, disclose,
distribute,
print, or copy any part of this message if you are not the intended
recipient. TFMC, its holding company, and any of its subsidiaries each
reserve the right to monitor and manage all e-mail communications
through
its networks.
Any views expressed in this message
Re: 9i RAC
John Kanagaraj wrote: Mark, If you read the latest Oracle Mag (Peer-to-Peer), you will find that a (sometime?) list member Murali Vallath is using RAC and is actually planning a book sometime later. Maybe you can address the question to him? Murali presents/attends IOUG What is more relevant, perhaps, to Mark is that Murali should be in Brum in december. and I know for sure that he 'speakes from the trenches' (unlike a lot of the bull from Oracle marketing). John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Mark Leith [mailto:mark;cool-tools.co.uk] Sent: Tuesday, October 29, 2002 8:30 AM To: Multiple recipients of list ORACLE-L Subject: 9i RAC A quick question out to the masses.. How many of you out there are ACTUALLY USING 9i RAC technology? If not already using it - how many have plans to use it (or at least plan to investigate it)? Cheers Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
