Re: Help ! ORA-00600 : internal error code
this is an error code that must be reported to Oracle support along with full description of error, procedure performed that caused this error and also details about your database environment settings. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 12:01 PM Help ! What does this mean? ORA-00600: internal error cod, arguments : [733], [33719116], [pga heap], [], [], [], [], [] John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saurabh Sharma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Solaris.. help.!!
Start at Oracle Technet there is documents on installing and administering on Solaris. After that maybe ask specific questions on this list about something you don't understand and provide error messages if you have any from installing or using it. It isn't all that hard if you just want to get it up and running. The document is pretty straight forward and mostly self explanatory. If you need to do more like set up correct tablespaces and specific rollback segments to say run Oracle Financials, then perhaps you should look at spending some money on a experienced DBa to consult and or assist. HTH Peter At 04:25 PM 26/07/2001, you wrote: Hi all, please help me in finding the right doc about starting from scratch on Solaris. I'm looking for Solaris for Oracle. can anyone suggest me some good starting documentation or links on this. like introduction, architectue, installtion and configuration etc.. thanks. Saurabh Sharma mailto:[EMAIL PROTECTED][EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter McLarty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
two_task parameter
Title: RE: OT, "It's all about Alex" what is the function of two_task parameter. i have searched metalink and documantion cd but i could nor find any note or document. please could you give information ?
RE: Help ! ORA-00600 : internal error code
Earlier it used to mean Goto Oracle Support But now you have a choice. http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html And it works . most of the cases... HTH, Rajesh -Original Message- Sent: Thursday, July 26, 2001 10:31 AM To: Multiple recipients of list ORACLE-L Help ! What does this mean? ORA-00600: internal error cod, arguments : [733], [33719116], [pga heap], [], [], [], [], [] John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9i on AIX with RAC
Apparantly it is finished and out soon. Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Rajendra.Jamadagni cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) @espn.comSubject: Oracle 9i on AIX with RAC Sent by: [EMAIL PROTECTED] 18-07-2001 17:35 Please respond to ORACLE-L Hi, Anyone has any updates on 9i with RAC on AIX platform availability? Any dates? Dates without RAC ?? Thanks in advance 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 ! *2 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that
RE: two_task parameter
Arslan, Two_task basically enables you to set up an identifier for a remote database that you may want to connect to. Usually you define the local database by setting the values of ORACLE_HOME and ORACLE_SID, setting TWO_TASK = tnsconnect string allows you to identify the remote database. When connecting instead of typing the command below to connect to a local database $ sqlplus user/pass you can issue the setenv command to make the remote database your local one if you follow that. $ setenv TWO_TASK remote_db $ sqlplus newuser/newpass because you have set the TWO_TASK variable, it overrides the ORACLE_HOME and ORACLE_SID settings and when you login with newuser/newpass, the remote database is used as the local one. Hope this helps, Regards Kev Thomas Calanais Ltd. -Original Message- Sent: 26 July 2001 09:01 To: Multiple recipients of list ORACLE-L what is the function of two_task parameter. i have searched metalink and documantion cd but i could nor find any note or document. please could you give information ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Securing passwords in scripts
I have some scripts, O.S. command and SQL, which I use to perform COLD backups of DBs and other tasks. I'm not particularily happy about having username/password information in the scripts. Has anyone come up with a way to avoid same allowing for the fact the scripts should require no user input to execute. Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-00600 error
--Boundary-00=_KX21TSM1VA40 Content-Type: Text/Plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi DBA's,=0D =0D We have a database procedure which transfers the data from one database(v= er 8.1.5 on Sun) to =0D another(ver 8.0.6 on HP) though DB Link.=0D If i run this procedure from sql*plus it works fine, but if being called from =0D Pro*C Environment it gives message :=0D /***/=0D ORA-00600: internal error code, arguments: [18186], [], [], [], [], [], [= ], []=0D /***/=0D =0D Through debug i trace its because of one insert statement. One more thing= i want to describe same insert statement working fine from sql*plus and als= o from diffenent procedure.=0D =0D Anyone can help me ?=0D =0D TIA.=0D --=0D Vijay Patidar --Boundary-00=_KX21TSM1VA40 Content-Type: Text/HTML; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable meta http-equiv=3DContent-Type content=3Dtext/html; charset=3Diso-885= 9-1html head meta name=3DGENERATOR content=3DIncrediMail 1.0 /head BODY background=3D bgColor=3D#ff style=3DBACKGROUND-POSITION: 0px= 0px; FONT-SIZE: 10pt; MARGIN: 1px; FONT-FAMILY: Arial scroll=3Dyes ORGY= POS=3D0 TABLE border=3D0 cellPadding=3D0 cellSpacing=3D0 id=3DINCREDIMAINTABLE w= idth=3D95% TR TD id=3DINCREDITEXTREGION width=3D100% style=3DPADDING-RIGHT: 7px; PA= DDING-LEFT: 7px; FONT-SIZE: 10pt; FONT-FAMILY: Arial=20 DIVHi DBA's,/DIV DIVnbsp;/DIV DIVWe have a database procedure which transfers the data from one= =20 database(ver 8.1.5 onnbsp;Sun)nbsp;to BRanother(ver 8.0.6 on HP= )=20 nbsp;though DB Link.BRIf i run this procedure from sql*plus it w= orks=20 fine, but if being called from BRPro*C Environment it gives messa= ge=20 :BR/***/BRORA-00600: internal error code, arguments: [18186= ], [],=20 [], [], [], [], [], []BR/***/BR/DIV DIVThrough debug i trace its because of one insert statement. One= more=20 thing i want to describe same insert statement working fine from sq= l*plus=20 and also from diffenent procedure./DIV DIVnbsp;/DIV DIVAnyone can help me ?/DIV DIVnbsp;/DIV DIVTIA./DIV DIV--/DIV DIVVijay Patidar/DIV/TD /TR TR TD id=3DINCREDIFOOTER width=3D100% =09TABLE cellPadding=3D0 cellSpacing=3D0 width=3D100% =09TR =09TD width=3D100%/TD =09TD align=3Dmiddle id=3DINCREDISOUND vAlign=3Dbottom/TD =09TD align=3Dmiddle id=3DINCREDIANIM vAlign=3Dbottom/TD =09/TR =09/TABLE /TD /TR /TABLESPAN=20 id=3DIncrediStampSPAN dir=3DltrFONT face=3DArial, Helvetica, sans-se= rif=20 size=3D2_BRFONT=20 face=3DComic Sans MS size=3D2IIncrediMail/I - BEmail has finally= =20 evolved/B - /FONTA=20 href=3Dhttp://www.incredimail.com/redir.asp?ad_id=3D109;FONT=20 face=3DTimes New Roman size=3D3BUClick=20 Here/U/B/FONT/A/SPAN/SPAN/FONT /BODY /html --Boundary-00=_KX21TSM1VA40-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vijay Patidar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sun cluster vs Veritas cluster - Any Docs / Links ?
Steve Are there any Docs / Links Comparing the Same ? Thanks though for your Experienced Valuable input . Vivek -Original Message- From: Austin, Steve S [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 1:39 AM To: Multiple recipients of list ORACLE-L Subject: RE: Sun cluster vs Veritas cluster I have used both and somewhat prefer VCS. In both systems, we've had problems where the cluster was in an unknown state and any action to change the state was risky to all the services in the cluster. This is rare for both products. Our Sun support required for us to pay them to certify our stuff before they'd support the implementation. Don't know if you're subject to this too, but VCS has no such rule. The tests were interesting, but we could conduct the tests without their involvement. Command-line jocks may at first prefer Sun, but I think Veritas is a better bet since it's not as tied to the hardware vendor, and is more likely to be common across Unixes, if you're in a site where you've got more than one Unix vendor's stuff to support, like I am. We are in the process of migrating from Sun cluster to VCS, fyi. my 2¢ Steve -Original Message- From: KC [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 7:51 AM To: Multiple recipients of list ORACLE-L Subject: Sun cluster vs Veritas cluster List, Just wondering if anyone on the list who had experience on both Sun clustering and Veritas clustering software share their experience on both products, strength and weakness or any comparison?? KC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Securing passwords in scripts
Sean, Not sure how you'd do this on NT, since I don't know how the identified externally accounts work on NT. On Unix you can create a user in the database with the same name as one of the Unix accounts. Default is ops$username, you can change or remove the ops$ requirement via one of the init.ora commands -- (remote_something or other, I'm at home right now and no access to look it up) grant the privileges necessary to this account, then when you need to log into the database you can use / to enter username/password: ex.sqlplus / and run what you need from cron from this Unix account. Rachel From: O'Neill, Sean [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Securing passwords in scripts Date: Thu, 26 Jul 2001 00:55:28 -0800 I have some scripts, O.S. command and SQL, which I use to perform COLD backups of DBs and other tasks. I'm not particularily happy about having username/password information in the scripts. Has anyone come up with a way to avoid same allowing for the fact the scripts should require no user input to execute. Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Help ! ORA-00600 : internal error code
I enclose a metalink document that I have because of that error. Obsviously it is related with the PGA. However I add sth in contradiction with the note, I've seen a similar problem on 8.1.7. That I've resolved setting the event 10262. Doc ID: Note:131490.1 big for this port (o/s) Type: REFERENCE Status: REVIEWED Content Type: TEXT/PLAIN Creation Date: 04-JAN-2001 Last Revision Date: 25-MAY-2001 Note: For additional ORA-600 related information please read [NOTE:146580.1] PURPOSE: This article discusses the internal error ORA-600 [733], what it means and possible actions. The information here is only applicable to the versions listed and is provided only for guidance. ERROR: ORA-600 [733][a][b][c][d][e] VERSIONS: versions 7.3.X to 8.1.X DESCRIPTION: When allocating an extent in the PGA, if the minimum size requested is greater than what is allowed for this port, ORA-00600 [733] is logged. Program Global Area (PGA) heap/memory allocation error. No data corruption occurs. ARGUMENTS: [733][min_size][comment] [min_size] The minimum extent size requested, in bytes. [comment] A comment supplied by the caller. FUNCTIONALITY: MEMORY IMPLEMENATION IMPACT: PROCESS FAILURE NON CORRUPTIVE - No corruption to underlying data. SUGGESTIONS: Known issues: Bug 553250 when trying to bind 32K in a PL/SQL table, fixed in 8.1.7 release. If receiving this during a query with complex JOIN, for example, consider lowering sort_area_size or hash_area_size if hash_join_enabled = true and rerun the query again so the PGA memory requirements aren't as large. REgards. --- John Dunn [EMAIL PROTECTED] wrote: Help ! What does this mean? ORA-00600: internal error cod, arguments : [733], [33719116], [pga heap], [], [], [], [], [] John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
how do i explain this ?
list, this application heavyly make use of literals , NO BIND VARIABLES and was running without any lib cache latch or shared pool latch problems on 7.3.2 We ported the DB to 8.1.5 and v$session_wait is full of latch free event !! all the latch waits are on lib cache and shapred pool (as expected from any app NOT using bind vars) and the app is running terribly slow !! my question is... how 7.3.2 was able to handle this ?? how i explain this to my management ? i was able to convince then on porting to 8i to get better perfornace !! note: i cannot change the app. all changes must be from the back end. TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Licensing
Jack Concurrent user license is not dependent on amount of instances, however Oracle probably maintains mimimum numbers per server. Jack Alan Carbutt arcarbut@adam To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] s.edu cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: Licensing [EMAIL PROTECTED] om 18-07-2001 18:12 Please respond to ORACLE-L I am just curious if anyone knows anything about concurrent user licensing. My question is: am I limited to the number of instances or just to concurrent users? Any help is greatly appreciated. Thanks, -- Alan Carbutt Applications Programmer Adams State College 719-587-7096 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alan Carbutt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge.
RE: Some other Oracle list
Check the listserv at www.lazydba.com -Original Message- Sent: Wednesday, July 25, 2001 11:34 PM To: Multiple recipients of list ORACLE-L Pablo ksksksk wrote: I'd like to subscribe to another list too. Does anyone know if there's some other list as good as this one? thanx nope. trust me, been there, done that. -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ If a program is useful, it must be changed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help ! ORA-00600 : internal error code
Thank you Rajesh, Some of Oracle bugs are internal, you may not see all bugs. So, I've added email feature to iOraBugFinder. Now, you can send the results and uploaded file to Oracle support if iOraBugFinder doesn't return your bugs. Since trace files are analyzed, response time from Oracle support is reduced. Recommendations: - Don't upload alert file when bug depth = 0 - Upload trace file instead of alert - Use higher level bug to get close to your bug. If it doesn't return bug, select lower levels. regards.. 26/7/01 11:20:50, Rajesh Dayal [EMAIL PROTECTED] wrote: Earlier it used to mean Goto Oracle Support But now you have a choice. http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html And it works . most of the cases... HTH, Rajesh -Original Message- Sent: Thursday, July 26, 2001 10:31 AM To: Multiple recipients of list ORACLE-L Help ! What does this mean? ORA-00600: internal error cod, arguments : [733], [33719116], [pga heap], [], [], [], [], [] John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Securing passwords in scripts
I hv a workaround Change platform to Unix and set permission as 700 ;-)) -Original Message- Sean Sent: Thursday, July 26, 2001 12:55 PM To: Multiple recipients of list ORACLE-L I have some scripts, O.S. command and SQL, which I use to perform COLD backups of DBs and other tasks. I'm not particularily happy about having username/password information in the scripts. Has anyone come up with a way to avoid same allowing for the fact the scripts should require no user input to execute. Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Securing passwords in scripts
O'Neill, Sean wrote: I have some scripts, O.S. command and SQL, which I use to perform COLD backups of DBs and other tasks. I'm not particularily happy about having username/password information in the scripts. Has anyone come up with a way to avoid same allowing for the fact the scripts should require no user input to execute. Sean :) I swear by externally identified accounts. -- Regards, Stephane Faroult Oriole Corporation -- http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how do i explain this ?
Hi, If there are the same querries with different literals, try cursor_sharing = force jack Rahul rahul@ratelin To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] do.co.idcc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: how do i explain this ? [EMAIL PROTECTED] om 26-07-2001 11:37 Please respond to ORACLE-L list, this application heavyly make use of literals , NO BIND VARIABLES and was running without any lib cache latch or shared pool latch problems on 7.3.2 We ported the DB to 8.1.5 and v$session_wait is full of latch free event !! all the latch waits are on lib cache and shapred pool (as expected from any app NOT using bind vars) and the app is running terribly slow !! my question is... how 7.3.2 was able to handle this ?? how i explain this to my management ? i was able to convince then on porting to 8i to get better perfornace !! note: i cannot change the app. all changes must be from the back end. TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and
Re: Securing passwords in scripts
If you're going to be doing DBA tasks like you describe (backups which require you to shutdown the database, etc.), you can just use / as sysdba in sqlplus. This works all the way back to 7.3 as far as I know. For it to work, however, the OS account that is being used must be a member of the DBA group (Unix) or the ORA_DBA group (NT). In a UNIX script, I use it like this: sqlplus EOF / as sysdba shutdown immediate exit EOF In NT, it would be a matter of putting all the commands in a .sql script and executing the script like this: sqlplus / as sysdba @myscript.sql Hope this helps. Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 4:55 AM I have some scripts, O.S. command and SQL, which I use to perform COLD backups of DBs and other tasks. I'm not particularily happy about having username/password information in the scripts. Has anyone come up with a way to avoid same allowing for the fact the scripts should require no user input to execute. Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how do i explain this ?
You can use CURSOR_SHARING = FORCE but be careful, it's initial implementation were quite buggy and it starts with 8.1.6 (don't remember exactly). HTH, Rajesh -Original Message- Sent: Thursday, July 26, 2001 1:37 PM To: Multiple recipients of list ORACLE-L list, this application heavyly make use of literals , NO BIND VARIABLES and was running without any lib cache latch or shared pool latch problems on 7.3.2 We ported the DB to 8.1.5 and v$session_wait is full of latch free event !! all the latch waits are on lib cache and shapred pool (as expected from any app NOT using bind vars) and the app is running terribly slow !! my question is... how 7.3.2 was able to handle this ?? how i explain this to my management ? i was able to convince then on porting to 8i to get better perfornace !! note: i cannot change the app. all changes must be from the back end. TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how do i explain this ?
Is it possible that under 7.3.2 the optimizer was rule-based (I don't know when CBO was introduced) and that under 8.1.5 it is set to CHOOSE or FIRST_ROWS or ALL_ROWS? Also, is there anyway you could move to 8.1.6 and take advantage of the CURSOR_SHARING parameter? Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 5:37 AM list, this application heavyly make use of literals , NO BIND VARIABLES and was running without any lib cache latch or shared pool latch problems on 7.3.2 We ported the DB to 8.1.5 and v$session_wait is full of latch free event !! all the latch waits are on lib cache and shapred pool (as expected from any app NOT using bind vars) and the app is running terribly slow !! my question is... how 7.3.2 was able to handle this ?? how i explain this to my management ? i was able to convince then on porting to 8i to get better perfornace !! note: i cannot change the app. all changes must be from the back end. TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Data Load Options - summary - final feedback
Thanx to all who responded on my query about Data Load options. I've tried to summarise below. To try and put a lid on it I'd appreciate feedback on gaps, any corrections and obs on data volume metrics. Low volume = 10Mb Medium volume = 10Mb 100Mb High Volume = 100Mb Option Volume DataData Source Ease of use (includes learning curve) --- -- -- - SQL Script Low Simple External Simple SQL Loader Medium, HighSimple External ??? Import Medium Complex Oracle Moderate UTL_FILE??? Complex ??? ??? DB Link ??? ??? Oracle ??? ODBC from MS Access Medium ??? External ??? Pro*C ??? ??? ??? Difficult Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how do i explain this ?
this is 8.1.5, cursor_sharing starts with 8.1.6+ (i guess) -- From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED] ] Reply To: [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 5:45 PM To: Multiple recipients of list ORACLE-L Subject: Re: how do i explain this ? Hi, If there are the same querries with different literals, try cursor_sharing = force jack Rahul rahul@ratelin To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] do.co.idcc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: how do i explain this ? [EMAIL PROTECTED] om 26-07-2001 11:37 Please respond to ORACLE-L list, this application heavyly make use of literals , NO BIND VARIABLES and was running without any lib cache latch or shared pool latch problems on 7.3.2 We ported the DB to 8.1.5 and v$session_wait is full of latch free event !! all the latch waits are on lib cache and shapred pool (as expected from any app NOT using bind vars) and the app is running terribly slow !! my question is... how 7.3.2 was able to handle this ?? how i explain this to my management ? i was able to convince then on porting to 8i to get better perfornace !! note: i cannot change the app. all changes must be from the back end. TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL
RE: Some other Oracle list
Hi ???, As has been pointed out this list is probably as good as it gets. However, if you have the time to keep up with more than one list then the following are other options for you to explore and also learn from. You can sign up to lists from following web sites: www.voug.org www.lazydba.com Also you can subscribe to ORACLE-L at [EMAIL PROTECTED] and ORACLE-DB-L at [EMAIL PROTECTED] There are also loads of discussion groups available via Web sites, but you need to visit them to review postings. And there are other sites that send you newsletters relating to Oracle. Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- From: =?iso-8859-1?q?Pablo=20ksksksk?= [EMAIL PROTECTED] Date: Wed, 25 Jul 2001 22:11:33 +0200 (CEST) Subject: Some other Oracle list I'd like to subscribe to another list too. Does anyone know if there's some other list as good as this one? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how do i explain this ?
John/ list, optimizer is set to CHOOSE in both the versions, even if the optimizer is choosing a different path , it's still parsing each statement in 7.3.2 !! (that should show in latch contention) -- From: Jon Walthour[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 5:56 PM To: Multiple recipients of list ORACLE-L Subject: Re: how do i explain this ? Is it possible that under 7.3.2 the optimizer was rule-based (I don't know when CBO was introduced) and that under 8.1.5 it is set to CHOOSE or FIRST_ROWS or ALL_ROWS? Also, is there anyway you could move to 8.1.6 and take advantage of the CURSOR_SHARING parameter? Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 5:37 AM list, this application heavyly make use of literals , NO BIND VARIABLES and was running without any lib cache latch or shared pool latch problems on 7.3.2 We ported the DB to 8.1.5 and v$session_wait is full of latch free event !! all the latch waits are on lib cache and shapred pool (as expected from any app NOT using bind vars) and the app is running terribly slow !! my question is... how 7.3.2 was able to handle this ?? how i explain this to my management ? i was able to convince then on porting to 8i to get better perfornace !! note: i cannot change the app. all changes must be from the back end. TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: strtSID.cmd security hole??
$Oracle_Home\database Also, I forgot to mention that I am on windoze NT. Dave -Original Message- Sent: Wednesday, July 25, 2001 4:07 PM To: Multiple recipients of list ORACLE-L Where is the strtSID.cmd file? I don;t see it anywhere under $ORACLE_HOME. -Original Message- From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 4:47 PM To: Multiple recipients of list ORACLE-L Subject: strtSID.cmd security hole?? I inherited an Oracle 7.3.4 database that nobody knew the internal password for. So I was doing some research on metalink and came across an article that mentioned the strtSID.cmd file would have the password. I was amazed to open up this file and see the unencrypted password for internal. I then check my 8.0.5 database and the same thing. Then I checked my 8.1.7 database and it was not there. Did this gaping security hole disappear in the 8i database? I sure hope so. Both the 7.3.4 and 8.0.5 have the remote_login_passwordfile init paramater set to SHARED, whereas my 8.1.7 is set to EXCLUSIVE. I don't know if this has something to do with it. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
deletion of data from a large table
Hi All, I have deleted 3 lakhs records from a large table. But there is no effect on tablespace i.e. before I delete the data freespace in TS is 100MB , after deletion also it is showing 100MB. What could be the reason ? How to get the freespace after deleting the data ? Thanks rukmini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: strtSID.cmd security hole??
Yes, it's windoze NT 4.0. -Original Message- Sent: Wednesday, July 25, 2001 5:01 PM To: Multiple recipients of list ORACLE-L Dave, What's the platform? NT? Jared Farnsworth, Dave DFarnsworth@Ashleyfurn To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] iture.comcc: Sent by: Subject: strtSID.cmd security hole?? [EMAIL PROTECTED] 07/25/01 01:47 PM Please respond to ORACLE-L I inherited an Oracle 7.3.4 database that nobody knew the internal password for. So I was doing some research on metalink and came across an article that mentioned the strtSID.cmd file would have the password. I was amazed to open up this file and see the unencrypted password for internal. I then check my 8.0.5 database and the same thing. Then I checked my 8.1.7 database and it was not there. Did this gaping security hole disappear in the 8i database? I sure hope so. Both the 7.3.4 and 8.0.5 have the remote_login_passwordfile init paramater set to SHARED, whereas my 8.1.7 is set to EXCLUSIVE. I don't know if this has something to do with it. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help ! ORA-00600 : internal error code
That I've resolved setting the event 10262. Sorry ..I didn't understand that bit. Can you clarify please John -Original Message- From: Christian Trassens [SMTP:[EMAIL PROTECTED]] Sent: 26 July 2001 10:37 To: Multiple recipients of list ORACLE-L Subject: Re: Help ! ORA-00600 : internal error code I enclose a metalink document that I have because of that error. Obsviously it is related with the PGA. However I add sth in contradiction with the note, I've seen a similar problem on 8.1.7. That I've resolved setting the event 10262. Doc ID: Note:131490.1 big for this port (o/s) Type: REFERENCE Status: REVIEWED Content Type: TEXT/PLAIN Creation Date: 04-JAN-2001 Last Revision Date: 25-MAY-2001 Note: For additional ORA-600 related information please read [NOTE:146580.1] PURPOSE: This article discusses the internal error ORA-600 [733], what it means and possible actions. The information here is only applicable to the versions listed and is provided only for guidance. ERROR: ORA-600 [733][a][b][c][d][e] VERSIONS: versions 7.3.X to 8.1.X DESCRIPTION: When allocating an extent in the PGA, if the minimum size requested is greater than what is allowed for this port, ORA-00600 [733] is logged. Program Global Area (PGA) heap/memory allocation error. No data corruption occurs. ARGUMENTS: [733][min_size][comment] [min_size] The minimum extent size requested, in bytes. [comment] A comment supplied by the caller. FUNCTIONALITY: MEMORY IMPLEMENATION IMPACT: PROCESS FAILURE NON CORRUPTIVE - No corruption to underlying data. SUGGESTIONS: Known issues: Bug 553250 when trying to bind 32K in a PL/SQL table, fixed in 8.1.7 release. If receiving this during a query with complex JOIN, for example, consider lowering sort_area_size or hash_area_size if hash_join_enabled = true and rerun the query again so the PGA memory requirements aren't as large. REgards. --- John Dunn [EMAIL PROTECTED] wrote: Help ! What does this mean? ORA-00600: internal error cod, arguments : [733], [33719116], [pga heap], [], [], [], [], [] John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Help
Title: Help Hi DBA Gurus Suppose I have a Table myuser which has 5000 records and another table uruser also 5000 records, and the structure is same for the both... how do I put MYUSER AND 'URUSER to a new table callled OURUSER Ples help me.. with warm regards, Deewaker G. V. Baazee.com India Pvt. Ltd. (: 4611323 Extn: 216 Fax : 4611324 Deewaker G.V..vcf Deewaker G.V..vcf
RE: deletion of data from a large table
If I remember rightly, deleting rows from the table does NOT free up tablespace. In order to do that you have to trunctate the table (although this of course deletes all data from the table)...I can't for the life of me remember how you adjust the space the table is actually using after doing a delete...(to everyone else) would an analyze work? Kev. -Original Message- Sent: 26 July 2001 12:41 To: Multiple recipients of list ORACLE-L Hi All, I have deleted 3 lakhs records from a large table. But there is no effect on tablespace i.e. before I delete the data freespace in TS is 100MB , after deletion also it is showing 100MB. What could be the reason ? How to get the freespace after deleting the data ? Thanks rukmini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Help ! ORA-00600 : internal error code
call support. joe John Dunn wrote: Help ! What does this mean? ORA-00600: internal error cod, arguments : [733], [33719116], [pga heap], [], [], [], [], [] John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing) -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how do i explain this ?
Did you try making time_statistics=FALSE cause this is a bug in 8.1.5 which causes lots of latch free waits if it is set as TRUE From: Rahul [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: how do i explain this ? Date: Thu, 26 Jul 2001 01:37:18 -0800 list, this application heavyly make use of literals , NO BIND VARIABLES and was running without any lib cache latch or shared pool latch problems on 7.3.2 We ported the DB to 8.1.5 and v$session_wait is full of latch free event !! all the latch waits are on lib cache and shapred pool (as expected from any app NOT using bind vars) and the app is running terribly slow !! my question is... how 7.3.2 was able to handle this ?? how i explain this to my management ? i was able to convince then on porting to 8i to get better perfornace !! note: i cannot change the app. all changes must be from the back end. TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ARUN K C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help
Title: Help Lots of ways CREATE TABLE ouruser AS SELECT * FROM myuser UNION ALL SELECT * FROM uruser; This will create a table ouruser with 10,000 records. Rick -Original Message-From: Deewaker G.V. [mailto:[EMAIL PROTECTED]]Sent: Thursday, July 26, 2001 7:47 AMTo: Multiple recipients of list ORACLE-LSubject: Help Hi DBA Gurus Suppose I have a Table myuser which has 5000 records and another table uruser also 5000 records, and the structure is same for the both... how do I put "MYUSER" AND 'URUSER" to a new table callled "OURUSER" Ples help me.. with warm regards, Deewaker G. V. Baazee.com India Pvt. Ltd. (: 4611323 Extn: 216 Fax : 4611324 Deewaker G.V..vcf
RE: deletion of data from a large table
I think this is happening because when you DELETE data the High Water Mark(HWM) is not lowered. Essentially you have not gained any freespace. If possible you could export remaining data truncate table then re-import. Correct me if I am wrong here. Rick -Original Message- Sent: Thursday, July 26, 2001 7:41 AM To: Multiple recipients of list ORACLE-L Hi All, I have deleted 3 lakhs records from a large table. But there is no effect on tablespace i.e. before I delete the data freespace in TS is 100MB , after deletion also it is showing 100MB. What could be the reason ? How to get the freespace after deleting the data ? Thanks rukmini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: deletion of data from a large table
Rukmini, Try to do coalesce on the tablespace on which the table is sitting in after deleting rows. alter tablespace TSNAME coalesce; Baskar -Original Message- Sent: 26 July 2001 12:41 To: Multiple recipients of list ORACLE-L Hi All, I have deleted 3 lakhs records from a large table. But there is no effect on tablespace i.e. before I delete the data freespace in TS is 100MB , after deletion also it is showing 100MB. What could be the reason ? How to get the freespace after deleting the data ? Thanks rukmini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramasamy, Baskar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Veritas Backup Exec Error
OS is NT. 1010 means OCI version error. Successfully compiled and ran the OCI test program Oracle supplies. [EMAIL PROTECTED] 7/25/01 4:43:30 PM Hi, I use this same product, however I don't use it to actually backup the databases. But you never know, maybe my memory will come back to me and I could semi help.:) What OS are you using, what's the 1010 error again? KK -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jeffrey BeckstromSent: Wednesday, July 25, 2001 3:47 PMTo: Multiple recipients of list ORACLE-LSubject: Veritas Backup Exec Error Installed 8.0.6/8.1.6 as part of Oracle Financials 11i on a new server. Installed 8.1.7 in a separate home. Installed Veritas Backup Exec. The Oracle Agent keeps getting a 1010 error. Thinking might be related to the 8.1.7 stuff, renamed the 8.1.7 directory. Still get the same error. We have two other servers which are working fine. The only notable difference is that these servers at one time had Oracle 7.3 installed. Help!!! Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
Re: Help
read the fine manual, but i'm in a good mood create table ouruser as select * from myuser; insert into ouruser select * from uruser; joe Deewaker G.V. wrote: Hi DBA Gurus Suppose I have a Table myuser which has 5000 records and another table uruser also 5000 records, and the structure is same for the both... how do I put MYUSER AND 'URUSER to a new table callled OURUSER Ples help me.. with warm regards, Deewaker G. V. Baazee.com India Pvt. Ltd. (: 4611323 Extn: 216 Fax : 4611324 Deewaker G.V..vcf -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: deletion of data from a large table
This can be done . But what about the constraints ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 5:41 PM I think this is happening because when you DELETE data the High Water Mark(HWM) is not lowered. Essentially you have not gained any freespace. If possible you could export remaining data truncate table then re-import. Correct me if I am wrong here. Rick -Original Message- Sent: Thursday, July 26, 2001 7:41 AM To: Multiple recipients of list ORACLE-L Hi All, I have deleted 3 lakhs records from a large table. But there is no effect on tablespace i.e. before I delete the data freespace in TS is 100MB , after deletion also it is showing 100MB. What could be the reason ? How to get the freespace after deleting the data ? Thanks rukmini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ER Diagram of a schema
Hi guys, What queries to run on a schema to get info that would enable me to draw an ER Diagram of that schema ? Baiju Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy Music, Video, CD-ROM and Audio-Books from http://www.planetmonline.com --=_MAILER_ATTACH_BOUNDARY1_2001726417348324763920 Content-Type: text/html; charset=us-ascii PFONT face=verdana,arial,helvetica size=2Hi guys, BRWhat queries to run on a schema to get info that would enable me to draw an ER Diagram of that schema ? BRBRBaiju/FONT/P hrfont face=Arial size=2bGet Your Private, Free E-mail from Indiatimes at /fonta href=http://email.indiatimes.com;font face=Arial size=2http://email.indiatimes.com/font/a/bbrBuy Music, Video, CD-ROM and Audio-Books from A href=http://www.planetmonline.com;http://www.planetmonline.com/A --=_MAILER_ATTACH_BOUNDARY1_2001726417348324763920-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dbabaiju INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Rman and multiple channels
OS - digital unix 4.0d hardware - Alpha 8400 Rman backup to disk with 1 channel allocated - for full hot backup is taking over 8 hours. Will multiple channels allocated increase the speed or reduce the speed of the backup? Thanks in advance, Teri -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Giles, Teri INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: deletion of data from a large table
Hi folks, Rick Cale was correct in saying that a truncate would release the storage by default. The only other option is to drop and recreate the table. Oracle will only release allocated storage when it is specifically asked to. The overhead on having a process monitoring which space it can drop would be prohibitive and needless. ( Imagine an example where an interface table is constantly filled and emptied - do you really want the storage to be constantly allocated and deallocated? ). Coalescing the tablespace will group adjacent free extents together but will have no effect on allocated blocks. Regards, Mike Hately, Oracle DBA |+-- || Ramasamy, Baskar | || Baskar.Ramasamy@cal| || anais.com | || | || 07/26/01 01:17 PM | || Please respond to | || ORACLE-L| || | |+-- -| | | | To: Multiple recipients of list ORACLE-L | | [EMAIL PROTECTED]| | cc: (bcc: Mike Hately/ETECH) | | Subject: RE: deletion of data from a large table | -| Rukmini, Try to do coalesce on the tablespace on which the table is sitting in after deleting rows. alter tablespace TSNAME coalesce; Baskar -Original Message- Sent: 26 July 2001 12:41 To: Multiple recipients of list ORACLE-L Hi All, I have deleted 3 lakhs records from a large table. But there is no effect on tablespace i.e. before I delete the data freespace in TS is 100MB , after deletion also it is showing 100MB. What could be the reason ? How to get the freespace after deleting the data ? Thanks rukmini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramasamy, Baskar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
URGENT
Hi Friends, I would very need full if u could help me. I would like to know a) Howto track down how many times a user is accessinga particular table. Thanks in advance Regards Saravana.
RE: Help ! ORA-00600 : internal error code
I've seen another 0600 related with yours. The 0600 was 0600 [723]. And the solution for that was setting the event 10262 in the following way: event=10262 trace name context forever, level 2000 This appeared on a 8.1.7.1 database in Solaris. That was what I meant. Regards. PS: Have you solved it ?. --- John Dunn [EMAIL PROTECTED] wrote: That I've resolved setting the event 10262. Sorry ..I didn't understand that bit. Can you clarify please John -Original Message- From: Christian Trassens [SMTP:[EMAIL PROTECTED]] Sent: 26 July 2001 10:37 To: Multiple recipients of list ORACLE-L Subject:Re: Help ! ORA-00600 : internal error code I enclose a metalink document that I have because of that error. Obsviously it is related with the PGA. However I add sth in contradiction with the note, I've seen a similar problem on 8.1.7. That I've resolved setting the event 10262. Doc ID: Note:131490.1 big for this port (o/s) Type: REFERENCE Status: REVIEWED Content Type: TEXT/PLAIN Creation Date: 04-JAN-2001 Last Revision Date: 25-MAY-2001 Note: For additional ORA-600 related information please read [NOTE:146580.1] PURPOSE: This article discusses the internal error ORA-600 [733], what it means and possible actions. The information here is only applicable to the versions listed and is provided only for guidance. ERROR: ORA-600 [733][a][b][c][d][e] VERSIONS: versions 7.3.X to 8.1.X DESCRIPTION: When allocating an extent in the PGA, if the minimum size requested is greater than what is allowed for this port, ORA-00600 [733] is logged. Program Global Area (PGA) heap/memory allocation error. No data corruption occurs. ARGUMENTS: [733][min_size][comment] [min_size] The minimum extent size requested, in bytes. [comment] A comment supplied by the caller. FUNCTIONALITY: MEMORY IMPLEMENATION IMPACT: PROCESS FAILURE NON CORRUPTIVE - No corruption to underlying data. SUGGESTIONS: Known issues: Bug 553250 when trying to bind 32K in a PL/SQL table, fixed in 8.1.7 release. If receiving this during a query with complex JOIN, for example, consider lowering sort_area_size or hash_area_size if hash_join_enabled = true and rerun the query again so the PGA memory requirements aren't as large. REgards. --- John Dunn [EMAIL PROTECTED] wrote: Help ! What does this mean? ORA-00600: internal error cod, arguments : [733], [33719116], [pga heap], [], [], [], [], [] John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT
RE: Help
CREATE TABLE OURUSER AS SELECT * FROM MYUSER INSERT INTO OURUSER SELECT * FROM URUSER -Original Message- Sent: Thursday, July 26, 2001 7:47 AM To: Multiple recipients of list ORACLE-L Hi DBA Gurus Suppose I have a Table myuser which has 5000 records and another table uruser also 5000 records, and the structure is same for the both... how do I put MYUSER AND 'URUSER to a new table callled OURUSER Ples help me.. with warm regards, Deewaker G. V. Baazee.com India Pvt. Ltd. *: 4611323 Extn: 216 Fax : 4611324 Deewaker G.V..vcf -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chesebro, Eric INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
9i ? What is this ?
Hi Friends : Does anyone could explain in general how is the Database 9i, comparing it with 8i, 8.1, 8.0 ? I know a bit about this ... Wich part is too diferent from others versions ? Regards Eriovaldo _ Seja avisado de novas mensagens do Hotmail e use o comunique-se com seus amigos com o MSN Messenger em http://messenger.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: strtSID.cmd security hole??
All, This file is gone on 816 on NT. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, July 26, 2001 7:47 AM To: Multiple recipients of list ORACLE-L $Oracle_Home\database Also, I forgot to mention that I am on windoze NT. Dave -Original Message- Sent: Wednesday, July 25, 2001 4:07 PM To: Multiple recipients of list ORACLE-L Where is the strtSID.cmd file? I don;t see it anywhere under $ORACLE_HOME. -Original Message- From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 4:47 PM To: Multiple recipients of list ORACLE-L Subject: strtSID.cmd security hole?? I inherited an Oracle 7.3.4 database that nobody knew the internal password for. So I was doing some research on metalink and came across an article that mentioned the strtSID.cmd file would have the password. I was amazed to open up this file and see the unencrypted password for internal. I then check my 8.0.5 database and the same thing. Then I checked my 8.1.7 database and it was not there. Did this gaping security hole disappear in the 8i database? I sure hope so. Both the 7.3.4 and 8.0.5 have the remote_login_passwordfile init paramater set to SHARED, whereas my 8.1.7 is set to EXCLUSIVE. I don't know if this has something to do with it. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AW: URGENT
use auditing Volker Schön E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht-Von: Saravana Kumar [mailto:[EMAIL PROTECTED]]Gesendet: Donnerstag, 26. Juli 2001 14:43An: Multiple recipients of list ORACLE-LBetreff: URGENT Hi Friends, I would very need full if u could help me. I would like to know a) Howto track down how many times a user is accessinga particular table. Thanks in advance Regards Saravana.
RE: Rman and multiple channels
Teri, Generally, it will make the backup complete sooner. Why don't you try it and see? :) Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, July 26, 2001 8:43 AM To: Multiple recipients of list ORACLE-L OS - digital unix 4.0d hardware - Alpha 8400 Rman backup to disk with 1 channel allocated - for full hot backup is taking over 8 hours. Will multiple channels allocated increase the speed or reduce the speed of the backup? Thanks in advance, Teri -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Giles, Teri INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ER Diagram of a schema
You cannot create ER diagram of a schema, you can create only server(data) model diagram If you want to create this diagram yourself, ie on paper, using some graphic tool like M$Word, Corel or M$Paint then you will need to use at least such data dictionary views like {all/dba/user}_tables {all/dba/user}_tab_columns {all/dba/user}_views {all/dba/user}_constraints To be more seriuos I would like to suggest to use some more or less specialized tools like Oracle Designer Visio Erwin Grade (www.infologistik.com) Oracle Designer and Visio can connect to Oracle and create server model diagram from database. Oracle designer provides such a possibility like table to entity rettrofit which creates ER diagramm. Of course it could be and usually IS different than original one. I don't know about Erwin, but Grade cannot make diagrams from databses. I mentioned it just for info and I think it was rather interesting tool but cannot be in the top today. Gints Plivna dbabaiju dbabaiju@indiaTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] times.com cc: Sent by: Subject: ER Diagram of a schema [EMAIL PROTECTED] m 2001.07.26 14:35 Please respond to ORACLE-L --=_MAILER_ATTACH_BOUNDARY1_2001726417348324763920 Content-Type: text/plain; charset=us-ascii Hi guys, What queries to run on a schema to get info that would enable me to draw an ER Diagram of that schema ? Baiju Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy Music, Video, CD-ROM and Audio-Books from http://www.planetmonline.com --=_MAILER_ATTACH_BOUNDARY1_2001726417348324763920 Content-Type: text/html; charset=us-ascii PFONT face=verdana,arial,helvetica size=2Hi guys, BRWhat queries to run on a schema to get info that would enable me to draw an ER Diagram of that schema ? BRBRBaiju/FONT/P hrfont face=Arial size=2bGet Your Private, Free E-mail from Indiatimes at /fonta href=http://email.indiatimes.com;font face =Arial size=2http://email.indiatimes.com/font/a/bbrBuy Music, Video, CD-ROM and Audio-Books from A href=http://www.planetmonline.com http://www.planetmonline.com/A --=_MAILER_ATTACH_BOUNDARY1_2001726417348324763920-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dbabaiju INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other
Re: ER Diagram of a schema
hi dbabaiju you don't have to write queries to get info that would enable you to draw ER Diagram of a schema you can use TOOLS like ER-WIN or SCHEMA BUILDER to draw ER Diagram of a schema for you . i hope this solves your problem :) regards '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' Omar Khalid Software Engineer LMK Resources Voice: 111-101-101*780 Mobile: 0333-510-4465 Web: www.lmkr.com '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' dbabaiju dbabaiju@india To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] times.comcc: Sent by: Subject: ER Diagram of a schema [EMAIL PROTECTED] m 07/26/2001 08:35 PM Please respond to ORACLE-L --=_MAILER_ATTACH_BOUNDARY1_2001726417348324763920 Content-Type: text/plain; charset=us-ascii Hi guys, What queries to run on a schema to get info that would enable me to draw an ER Diagram of that schema ? Baiju Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy Music, Video, CD-ROM and Audio-Books from http://www.planetmonline.com --=_MAILER_ATTACH_BOUNDARY1_2001726417348324763920 Content-Type: text/html; charset=us-ascii PFONT face=verdana,arial,helvetica size=2Hi guys, BRWhat queries to run on a schema to get info that would enable me to draw an ER Diagram of that schema ? BRBRBaiju/FONT/P hrfont face=Arial size=2bGet Your Private, Free E-mail from Indiatimes at /fonta href=http://email.indiatimes.com;font face =Arial size=2http://email.indiatimes.com/font/a/bbrBuy Music, Video, CD-ROM and Audio-Books from A href=http://www.planetmonline.com http://www.planetmonline.com/A --=_MAILER_ATTACH_BOUNDARY1_2001726417348324763920-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dbabaiju INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be
RE: 9i ? What is this ?
Like 8i compared to 8.0, there are many differences. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Thursday, July 26, 2001 8:51 AM To: Multiple recipients of list ORACLE-L Hi Friends : Does anyone could explain in general how is the Database 9i, comparing it with 8i, 8.1, 8.0 ? I know a bit about this ... Wich part is too diferent from others versions ? Regards Eriovaldo _ Seja avisado de novas mensagens do Hotmail e use o comunique-se com seus amigos com o MSN Messenger em http://messenger.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Securing passwords in scripts
Me too. On unix and NT --- Stephane Faroult [EMAIL PROTECTED] a écrit : O'Neill, Sean wrote: I have some scripts, O.S. command and SQL, which I use to perform COLD backups of DBs and other tasks. I'm not particularily happy about having username/password information in the scripts. Has anyone come up with a way to avoid same allowing for the fact the scripts should require no user input to execute. Sean :) I swear by externally identified accounts. -- Regards, Stephane Faroult Oriole Corporation -- http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Vos albums photos en ligne, Yahoo! Photos : http://fr.photos.yahoo.com -- 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Sql/PLUS Question
Hi All, Just a short How to... Is there some way to find out what your session parameters are. I am aware of the show parameters; But an example is NLS_DATE_FORMAT, if you change it from the system default using alter session. And run show parameter It still remains with no value in the VALUE column of the output. Hope I made myself clear. Thanks In Advance Denham -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i ? What is this ?
Checkout the Oracle 9i Administrator's Guide. It a summarized section in the beginning, titled 'What's New in Oracle9i?'. You can access the Guide at http://technet.oracle.com. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Christopher Spence [SMTP:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 8:38 AM To: Multiple recipients of list ORACLE-L Subject: RE: 9i ? What is this ? Like 8i compared to 8.0, there are many differences. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Thursday, July 26, 2001 8:51 AM To: Multiple recipients of list ORACLE-L Hi Friends : Does anyone could explain in general how is the Database 9i, comparing it with 8i, 8.1, 8.0 ? I know a bit about this ... Wich part is too diferent from others versions ? Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: two_task parameter
We use the two_task parameter to allow our users to connect to the database instance defined by the two_task variable. Doing so, the users do not know or even care about the fact that multiple database instances are running on the same platform. Simplistically, if it is set to a database instance name, then the database field (during login) need not be filled in. -Original Message- From: Arslan Bahar [SMTP:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 4:01 AM To: Multiple recipients of list ORACLE-L Subject:two_task parameter what is the function of two_task parameter. i have searched metalink and documantion cd but i could nor find any note or document. please could you give information ? File: ATT00022.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Rogge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: strtSID.cmd security hole??
Comments have been made about going to UNIX and setting it to 700. Same idea on NT is to right click on the file and change it's properties. On the security tab, lock down the permissions so Administrator and Oracle are the only ones who can read, execute, or modify the file. Although creating an externally identified users will remove the need for the password in the file. Rodd Original Message On 7/26/01, 8:38:31 AM, Farnsworth, Dave [EMAIL PROTECTED] wrote regarding RE: strtSID.cmd security hole??: After doing more research on this, this file is required if you want to have the autostart of an oracle service to happen. Autostart does not work without this file present. Version 8.1.5 supposedly removed this. Dave -Original Message- Sent: Thursday, July 26, 2001 8:06 AM To: Multiple recipients of list ORACLE-L All, This file is gone on 816 on NT. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, July 26, 2001 7:47 AM To: Multiple recipients of list ORACLE-L $Oracle_Home\database Also, I forgot to mention that I am on windoze NT. Dave -Original Message- Sent: Wednesday, July 25, 2001 4:07 PM To: Multiple recipients of list ORACLE-L Where is the strtSID.cmd file? I don;t see it anywhere under $ORACLE_HOME. -Original Message- From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 4:47 PM To: Multiple recipients of list ORACLE-L Subject:strtSID.cmd security hole?? I inherited an Oracle 7.3.4 database that nobody knew the internal password for. So I was doing some research on metalink and came across an article that mentioned the strtSID.cmd file would have the password. I was amazed to open up this file and see the unencrypted password for internal. I then check my 8.0.5 database and the same thing. Then I checked my 8.1.7 database and it was not there. Did this gaping security hole disappear in the 8i database? I sure hope so. Both the 7.3.4 and 8.0.5 have the remote_login_passwordfile init paramater set to SHARED, whereas my 8.1.7 is set to EXCLUSIVE. I don't know if this has something to do with it. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com
RE: new alert regarding 8.1.7.2 patchset
This makes me wonder: what kind of regression testing is implemented by oracle? Trial and error? It makes me wonder, oh it makes me wander (Stairway to Heaven) -Original Message- From: A. Bardeen [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 6:15 AM To: Multiple recipients of list ORACLE-L Subject: FYI: new alert regarding 8.1.7.2 patchset Note: 153172.1 ALERT: Do NOT Install 8.1.7.2.0 Patch Set on top of 8.1.7.1 8.1.7.2.0 Patch Set Does Not Install Correctly Over 8.1.7.1/8.1.7.1B This alert will be updated to indicate the current status of this problem. The modification history is shown at the END of the alert. Versions Affected ~ This problem affects the installation of the 8.1.7.2.0 Patch Set. Platforms Affected ~~ This problem affects the following platforms only: HPUX (Oracle 32 bit release) HPUX (Oracle 64 bit release) Compaq Tru64 Intel Solaris This problem does NOT affect the following platform: Sun Sparc Solaris (Oracle 32 bit release) 8.1.7.2 has not been released on any other platform yet. Other platforms will have this problem corrected prior to their 8.1.7.2 Patch Set being released. Description ~~~ If the 8.1.7.2.0 Patch Set is installed on top of either 8.1.7.1 or 8.1.7.1B then the patch set does not install correctly. No errors are reported during the installation but the Oracle version banner still shows the version to be 8.1.7.1. Likelihood of Occurrence You will encounter this problem if you install the 8.1.7.2.0 patch set on top of either 8.1.7.1 or 8.1.7.1B on any of the platforms listed above. You are STRONGLY advised NOT to install 8.1.7.2.0 on top of 8.1.7.1 releases until this issue is addressed. Possible Symptoms ~ The main visible symptoms of this issue are: a. The Oracle version banner still shows the RDBMS release to be 8.1.7.1 b. SELECT * FROM V$VERSION shows the release to be 8.1.7.1 c. Bugs fixed in 8.1.7.2 may still be encountered There may be additional symptoms not yet discovered as the resulting installation contains an untested combination of modules. Workaround ~~ The only workaround to this problem is to install 8.1.7.2.0 on top of an 8.1.7.0 Oracle installation. ie: If the current installation is at release 8.1.7.1, then you must reinstall 8.1.7.0 and then apply the 8.1.7.2 patch set. If you have already installed 8.1.7.2 on top of 8.1.7.1 then it is advisable to reinstall the base release (8.1.7.0) and then apply the patch set on top of this to get a proper 8.1.7.2 release installed. Patches ~~~ The affected patch sets will be re-released shortly with the version number 8.1.7.2.1. These updated patch sets will install on top of 8.1.7.1, 8.1.7.1B or 8.1.7.0. If possible please avoid upgrading until the revised patch sets are released. References ~~ Base bug reporting the install problem [BUG:1898001] Modification History: ~ 26-Jul-2001 Initial alert that 8.1.7.2 does not install over 8.1.7.1 __ Oracle Support Services . __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to:
Re: deletion of data from a large table
Rukmini If you have good PCTUSED you are safe!! The space will be reused, Other wise You have to reorganize table!! From: Rukmini Devi [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: deletion of data from a large table Date: Thu, 26 Jul 2001 04:35:48 -0800 This can be done . But what about the constraints ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 5:41 PM I think this is happening because when you DELETE data the High Water Mark(HWM) is not lowered. Essentially you have not gained any freespace. If possible you could export remaining data truncate table then re-import. Correct me if I am wrong here. Rick -Original Message- Sent: Thursday, July 26, 2001 7:41 AM To: Multiple recipients of list ORACLE-L Hi All, I have deleted 3 lakhs records from a large table. But there is no effect on tablespace i.e. before I delete the data freespace in TS is 100MB , after deletion also it is showing 100MB. What could be the reason ? How to get the freespace after deleting the data ? Thanks rukmini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: deletion of data from a large table
Great discussion. Reminds me of lazydba list. Alex Hillman -Original Message- Sent: Thursday, July 26, 2001 8:43 AM To: Multiple recipients of list ORACLE-L Hi folks, Rick Cale was correct in saying that a truncate would release the storage by default. The only other option is to drop and recreate the table. Oracle will only release allocated storage when it is specifically asked to. The overhead on having a process monitoring which space it can drop would be prohibitive and needless. ( Imagine an example where an interface table is constantly filled and emptied - do you really want the storage to be constantly allocated and deallocated? ). Coalescing the tablespace will group adjacent free extents together but will have no effect on allocated blocks. Regards, Mike Hately, Oracle DBA |+-- || Ramasamy, Baskar | || Baskar.Ramasamy@cal| || anais.com | || | || 07/26/01 01:17 PM | || Please respond to | || ORACLE-L| || | |+-- -| | | | To: Multiple recipients of list ORACLE-L | | [EMAIL PROTECTED]| | cc: (bcc: Mike Hately/ETECH) | | Subject: RE: deletion of data from a large table | -| Rukmini, Try to do coalesce on the tablespace on which the table is sitting in after deleting rows. alter tablespace TSNAME coalesce; Baskar -Original Message- Sent: 26 July 2001 12:41 To: Multiple recipients of list ORACLE-L Hi All, I have deleted 3 lakhs records from a large table. But there is no effect on tablespace i.e. before I delete the data freespace in TS is 100MB , after deletion also it is showing 100MB. What could be the reason ? How to get the freespace after deleting the data ? Thanks rukmini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramasamy, Baskar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sql/PLUS Question
In sqlplus you can select * from v$parameter; -Original Message- Sent: Thursday, July 26, 2001 9:06 AM To: Multiple recipients of list ORACLE-L Hi All, Just a short How to... Is there some way to find out what your session parameters are. I am aware of the show parameters; But an example is NLS_DATE_FORMAT, if you change it from the system default using alter session. And run show parameter It still remains with no value in the VALUE column of the output. Hope I made myself clear. Thanks In Advance Denham -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Looking for a tool
The major tools of the market (Cognos, Business Objects , Brio) aer supposed to handle your requirements. W'e're implement Businness Objects Web Intelligence tools . It will interact with BEA Weblogic. So far Business Objects tools are not stable at all, we have almost a dirct line to the tech support . --- Reardon, Bruce (CALBBAY) [EMAIL PROTECTED] a écrit : Don't know about Discoverer 9i but I believe earlier versions would work with any ODBC database. With Oracle Oracle and Oracle Rdb that has SQLNet installed then you will get time estimations etc. ie - more features with Oracle (eg scheduling reports on dbms_job queues) but I believe will work with ODBC databases. Regards, Bruce Reardon -Original Message- Sent: Thursday, 26 July 2001 4:11 Discoverer 9i the demo at ODTUG was capable of doing almost everything that you mention here. Only two problems ... 1. works with Oracle only (AFAIK) 2. It is not available yet (last time I saw, it wasn't). Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Vos albums photos en ligne, Yahoo! Photos : http://fr.photos.yahoo.com -- 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Trigger on Create User
I tried the same thing but the trigger gives you an error about ddl operation not being allowed in a system trigger. Here is a work-around: CREATE or REPLACE TRIGGER alteruser AFTER CREATE on DATABASE DECLARE JobNo NUMBER; BEGIN IF ora_dict_obj_type = 'USER' THEN DBMS_JOB.SUBMIT( job= JobNo, what='alter_the_user('''||ora_dict_obj_name||''');', next_date=sysdate); END IF; END; The job runs once (because there is no interval), and the procedure alter_the_user is just: EXECUTE IMMEDIATE 'alter user '||user_in ||' temporary tablespace temp'; Hth, Chaim Maser, Donna (SEA) [EMAIL PROTECTED] on 07/25/2001 07:25:19 PM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Chaim Katz/Completions/Bombardier) Hi Guys, I was hoping to use the new 8i triggers to prevent new users from getting assigned to the SYSTEM tablespace. Has anyone seen a way to build a trigger on a CREATE USER statement? Thx, Donna Maser The information contained in this email is intended for the personal and confidential use of the addressee only. It may also be privileged information. If you are not the intended recipient then you are hereby notified that you have received this document in error and that any review, distribution or copying of this document is strictly prohibited. If you have received this communication in error, please notify Celltech Group immediately on: +44 (0)1753 534655, or email '[EMAIL PROTECTED]' Celltech Group plc 216 Bath Road, Slough, SL1 4EN, Berkshire, UK Registered Office as above. Registered in England No. 2159282 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maser, Donna (SEA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: deletion of data from a large table
You would need to drop any foreign key constraints pointing to that table before truncating and then recreate them after reloading the data. If I remember correctly, simply disabling them won't work since Oracle treats Truncate Table the same as Drop Table in many ways. Other constraints (NOT NULL, etc) won't be affected. Also, depending on the size of your initial extent and the amount of data you have remaining, you might be able to resize the one remaining datafile down after you truncate the table. (e.g., if your initial exent is 5 Meg and you don't anticipate ever having more than 1 Meg of data, you can RESIZE the datafile down to 5 Meg after the truncate). Jay Miller -Original Message- Sent: Thursday, July 26, 2001 8:36 AM To: Multiple recipients of list ORACLE-L This can be done . But what about the constraints ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 5:41 PM I think this is happening because when you DELETE data the High Water Mark(HWM) is not lowered. Essentially you have not gained any freespace. If possible you could export remaining data truncate table then re-import. Correct me if I am wrong here. Rick -Original Message- Sent: Thursday, July 26, 2001 7:41 AM To: Multiple recipients of list ORACLE-L Hi All, I have deleted 3 lakhs records from a large table. But there is no effect on tablespace i.e. before I delete the data freespace in TS is 100MB , after deletion also it is showing 100MB. What could be the reason ? How to get the freespace after deleting the data ? Thanks rukmini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ER Diagram of a schema
Visio Pro 2002 is great for reverse engineering schemas, and *so* much cheaper than Oracle Designer... :0) g -Original Message- Sent: Thursday, July 26, 2001 1:36 PM To: Multiple recipients of list ORACLE-L --=_MAILER_ATTACH_BOUNDARY1_2001726417348324763920 Content-Type: text/plain; charset=us-ascii Hi guys, What queries to run on a schema to get info that would enable me to draw an ER Diagram of that schema ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sql/PLUS Question
You can do SELECT * FROM nls_database_parameters; Rick -Original Message- Sent: Thursday, July 26, 2001 10:06 AM To: Multiple recipients of list ORACLE-L Hi All, Just a short How to... Is there some way to find out what your session parameters are. I am aware of the show parameters; But an example is NLS_DATE_FORMAT, if you change it from the system default using alter session. And run show parameter It still remains with no value in the VALUE column of the output. Hope I made myself clear. Thanks In Advance Denham -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[Q] exp from 8.1.7 and import to 8.1.6?
I just upgrade ORACLE from 8.1.6 to 8.1.7 (SUn Solaris). My question is can I export from 8.1.7 and bring the dump file import into 8.1.6 ORACLE server? Thanks.Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ef 8454 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Help
Or try create table ouruser as select * from (select * from myuser union select * from uruser); Joe Testa teci@the-tesTo: Multiple recipients of list ORACLE-L tas.net [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: Re: Help com 07/26/2001 08:25 AM Please respond to ORACLE-L read the fine manual, but i'm in a good mood create table ouruser as select * from myuser; insert into ouruser select * from uruser; joe Deewaker G.V. wrote: Hi DBA Gurus Suppose I have a Table myuser which has 5000 records and another table uruser also 5000 records, and the structure is same for the both... how do I put MYUSER AND 'URUSER to a new table callled OURUSER Ples help me.. with warm regards, Deewaker G. V. Baazee.com India Pvt. Ltd. (: 4611323 Extn: 216 Fax : 4611324 Deewaker G.V..vcf -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Trigger on Create User
Maybe you can simply call procedure with autonomous transaction in system trigger Is it possible? Gints Plivna [EMAIL PROTECTED] ardier.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] cc: Subject: Re: Trigger on Create User 2001.07.26 16:42 Please respond to ORACLE-L I tried the same thing but the trigger gives you an error about ddl operation not being allowed in a system trigger. Here is a work-around: CREATE or REPLACE TRIGGER alteruser AFTER CREATE on DATABASE DECLARE JobNo NUMBER; BEGIN IF ora_dict_obj_type = 'USER' THEN DBMS_JOB.SUBMIT( job= JobNo, what='alter_the_user('''||ora_dict_obj_name||''');', next_date=sysdate); END IF; END; The job runs once (because there is no interval), and the procedure alter_the_user is just: EXECUTE IMMEDIATE 'alter user '||user_in ||' temporary tablespace temp'; Hth, Chaim Maser, Donna (SEA) [EMAIL PROTECTED] on 07/25/2001 07:25:19 PM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Chaim Katz/Completions/Bombardier) Hi Guys, I was hoping to use the new 8i triggers to prevent new users from getting assigned to the SYSTEM tablespace. Has anyone seen a way to build a trigger on a CREATE USER statement? Thx, Donna Maser The information contained in this email is intended for the personal and confidential use of the addressee only. It may also be privileged information. If you are not the intended recipient then you are hereby notified that you have received this document in error and that any review, distribution or copying of this document is strictly prohibited. If you have received this communication in error, please notify Celltech Group immediately on: +44 (0)1753 534655, or email '[EMAIL PROTECTED]' Celltech Group plc 216 Bath Road, Slough, SL1 4EN, Berkshire, UK Registered Office as above. Registered in England No. 2159282 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maser, Donna (SEA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: new alert regarding 8.1.7.2 patchset
And if you listen very hard... Anyone know when the 8.1.7.2 patchset will be out for Linux? Patches, I'm depending on you Son... Steve Orr -Original Message- Sent: Thursday, July 26, 2001 8:36 AM To: Multiple recipients of list ORACLE-L This makes me wonder: what kind of regression testing is implemented by oracle? Trial and error? It makes me wonder, oh it makes me wander (Stairway to Heaven) -Original Message- From: A. Bardeen [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 6:15 AM To: Multiple recipients of list ORACLE-L Subject: FYI: new alert regarding 8.1.7.2 patchset Note: 153172.1 ALERT: Do NOT Install 8.1.7.2.0 Patch Set on top of 8.1.7.1 8.1.7.2.0 Patch Set Does Not Install Correctly Over 8.1.7.1/8.1.7.1B This alert will be updated to indicate the current status of this problem. The modification history is shown at the END of the alert. Versions Affected ~ This problem affects the installation of the 8.1.7.2.0 Patch Set. Platforms Affected ~~ This problem affects the following platforms only: HPUX (Oracle 32 bit release) HPUX (Oracle 64 bit release) Compaq Tru64 Intel Solaris This problem does NOT affect the following platform: Sun Sparc Solaris (Oracle 32 bit release) 8.1.7.2 has not been released on any other platform yet. Other platforms will have this problem corrected prior to their 8.1.7.2 Patch Set being released. Description ~~~ If the 8.1.7.2.0 Patch Set is installed on top of either 8.1.7.1 or 8.1.7.1B then the patch set does not install correctly. No errors are reported during the installation but the Oracle version banner still shows the version to be 8.1.7.1. Likelihood of Occurrence You will encounter this problem if you install the 8.1.7.2.0 patch set on top of either 8.1.7.1 or 8.1.7.1B on any of the platforms listed above. You are STRONGLY advised NOT to install 8.1.7.2.0 on top of 8.1.7.1 releases until this issue is addressed. Possible Symptoms ~ The main visible symptoms of this issue are: a. The Oracle version banner still shows the RDBMS release to be 8.1.7.1 b. SELECT * FROM V$VERSION shows the release to be 8.1.7.1 c. Bugs fixed in 8.1.7.2 may still be encountered There may be additional symptoms not yet discovered as the resulting installation contains an untested combination of modules. Workaround ~~ The only workaround to this problem is to install 8.1.7.2.0 on top of an 8.1.7.0 Oracle installation. ie: If the current installation is at release 8.1.7.1, then you must reinstall 8.1.7.0 and then apply the 8.1.7.2 patch set. If you have already installed 8.1.7.2 on top of 8.1.7.1 then it is advisable to reinstall the base release (8.1.7.0) and then apply the patch set on top of this to get a proper 8.1.7.2 release installed. Patches ~~~ The affected patch sets will be re-released shortly with the version number 8.1.7.2.1. These updated patch sets will install on top of 8.1.7.1, 8.1.7.1B or 8.1.7.0. If possible please avoid upgrading until the revised patch sets are released. References ~~ Base bug reporting the install problem [BUG:1898001] Modification History: ~ 26-Jul-2001 Initial alert that 8.1.7.2 does not install over 8.1.7.1 __ Oracle Support Services . __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services
RE: ER Diagram of a schema
Yea and it can reverse engineer not only oracle, but for example mysql database too. Designer cannot because it has too strict rules for column types. Gints Plivna Guy Hammond guy.hammond@To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] avt.co.uk cc: Sent by: Subject: RE: ER Diagram of a schema root@fatcity. com 2001.07.26 16:35 Please respond to ORACLE-L Visio Pro 2002 is great for reverse engineering schemas, and *so* much cheaper than Oracle Designer... :0) g -Original Message- Sent: Thursday, July 26, 2001 1:36 PM To: Multiple recipients of list ORACLE-L --=_MAILER_ATTACH_BOUNDARY1_2001726417348324763920 Content-Type: text/plain; charset=us-ascii Hi guys, What queries to run on a schema to get info that would enable me to draw an ER Diagram of that schema ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: new alert regarding 8.1.7.2 patchset
regression testing?, heck we are the alpha/beta/regression testers :) joe [EMAIL PROTECTED] 07/26/01 10:35AM This makes me wonder: what kind of regression testing is implemented by oracle? Trial and error? It makes me wonder, oh it makes me wander (Stairway to Heaven) -Original Message- From: A. Bardeen [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 6:15 AM To: Multiple recipients of list ORACLE-L Subject: FYI: new alert regarding 8.1.7.2 patchset Note: 153172.1 ALERT: Do NOT Install 8.1.7.2.0 Patch Set on top of 8.1.7.1 8.1.7.2.0 Patch Set Does Not Install Correctly Over 8.1.7.1/8.1.7.1B This alert will be updated to indicate the current status of this problem. The modification history is shown at the END of the alert. Versions Affected ~ This problem affects the installation of the 8.1.7.2.0 Patch Set. Platforms Affected ~~ This problem affects the following platforms only: HPUX (Oracle 32 bit release) HPUX (Oracle 64 bit release) Compaq Tru64 Intel Solaris This problem does NOT affect the following platform: Sun Sparc Solaris (Oracle 32 bit release) 8.1.7.2 has not been released on any other platform yet. Other platforms will have this problem corrected prior to their 8.1.7.2 Patch Set being released. Description ~~~ If the 8.1.7.2.0 Patch Set is installed on top of either 8.1.7.1 or 8.1.7.1B then the patch set does not install correctly. No errors are reported during the installation but the Oracle version banner still shows the version to be 8.1.7.1. Likelihood of Occurrence You will encounter this problem if you install the 8.1.7.2.0 patch set on top of either 8.1.7.1 or 8.1.7.1B on any of the platforms listed above. You are STRONGLY advised NOT to install 8.1.7.2.0 on top of 8.1.7.1 releases until this issue is addressed. Possible Symptoms ~ The main visible symptoms of this issue are: a. The Oracle version banner still shows the RDBMS release to be 8.1.7.1 b. SELECT * FROM V$VERSION shows the release to be 8.1.7.1 c. Bugs fixed in 8.1.7.2 may still be encountered There may be additional symptoms not yet discovered as the resulting installation contains an untested combination of modules. Workaround ~~ The only workaround to this problem is to install 8.1.7.2.0 on top of an 8.1.7.0 Oracle installation. ie: If the current installation is at release 8.1.7.1, then you must reinstall 8.1.7.0 and then apply the 8.1.7.2 patch set. If you have already installed 8.1.7.2 on top of 8.1.7.1 then it is advisable to reinstall the base release (8.1.7.0) and then apply the patch set on top of this to get a proper 8.1.7.2 release installed. Patches ~~~ The affected patch sets will be re-released shortly with the version number 8.1.7.2.1. These updated patch sets will install on top of 8.1.7.1, 8.1.7.1B or 8.1.7.0. If possible please avoid upgrading until the revised patch sets are released. References ~~ Base bug reporting the install problem [BUG:1898001] Modification History: ~ 26-Jul-2001 Initial alert that 8.1.7.2 does not install over 8.1.7.1 __ Oracle Support Services . __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: OT, It's all about Alex
Chris, I would post my presentation on the list and maybe somebody will be able to decipher what I tried to present :-)(hint - locally managed tablespaces, temporary tablespaces and global temporary tables) but I think it will not be appreciated by the list owner and also because it is in PP format I don't think list software will allow it - so one way is to send me e-mail (please offline - [EMAIL PROTECTED]) and I will reply with presentation or wait until it will be posted on www.maop.org -Original Message- Sent: Wednesday, July 25, 2001 4:39 PM To: Multiple recipients of list ORACLE-L Alex did great. I learned a lot...err...just not sure what I learned. (grin) Unfortunely, I had to miss his second presentation. -Original Message- Sent: Wednesday, July 25, 2001 11:47 AM To: Multiple recipients of list ORACLE-L Alex, how did the paper/present go? -Original Message- Sent: Wednesday, July 25, 2001 10:42 AM To: Multiple recipients of list ORACLE-L Maybe some spelling errors in the abstract -:) Alex Hillman -Original Message- Sent: Wednesday, July 25, 2001 9:46 AM To: Multiple recipients of list ORACLE-L What is required to submit a paper/presentation to IOUGA and get excepted. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, July 24, 2001 8:41 PM To: Multiple recipients of list ORACLE-L IOUG 2002 call for papers already. Submit your presentation via the IOUG-A Web site at http://www.ioug.org/call-m no later than FRIDAY, SEPTEMBER 14, 2001. Mini Lesson and Technical Session presenters receive complimentary registration at IOUG-A Live! 2002 when your abstract is chosen! New for 2002 - Quick Tips! Share your unique and valuable tips during these new 30-minute presentations. Quick Tips provide great experience for first time presenters and allow experienced presenters to get to the heart of the matter. This is a presentation only - papers are not required. Plus, receive a discount on the Early Bird registration rate! joe -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris
RE: RE: Data load options
Title: RE: RE: Data load options Oh yes. You are right. It loads full blocks above the HWM. Forgot to mention that... thanks for pointing out that VERY important bit of info. Must be the narcotics. Lisa -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 11:03 AM To: Multiple recipients of list ORACLE-L Subject: Re:RE: Data load options Lisa, SQL*Loader in direct path can cause you storage problems since it always appends to the table(s) ignoring blocks on the free block list. I found that out after a developer was using it for our data warehouse. At the end of a year he had burned almost 100GB of disk it kept increasing even though he was trying to keep only a rolling 180 window. On a hunch we exported the data, truncated the table imported the data back in. The amount of tablespace being used dropped 50%. Dick Goulet Reply Separator Author: Koivu; Lisa [EMAIL PROTECTED] Date: 7/25/2001 6:26 AM Hi Sean, Others have given you different options. Here's some considerations: 1. SQL Script. * Can be SLOW * May require intermittent commits in your script * Manual and error prone * Must go through SQL engine 2. SQL Loader * Can be very fast (direct - bypassing SQL engine). * Direct path load will invalidate indexes. * You can keep track of rejected records easily (.bad file) * Dependent upon your file format being EXACT, no errors. 3. Import * Requires minimal manual fiddling * Can be very slow - I once imported 150GB and it took ~3 days * Does not seamlessly handle all object types (INtermedia (domain) indexes is one example) * Restarting an import will take a lot longer. If your import fails, be sure and truncate/drop all tables before starting again. * Have the option of not including indexes (INDEXES=N) * Can also reset your storage parms prior to import (export with data=n, edit file [SSSHHH] and enter new storage parms / import, export with data=y, import data with IGNORE=Y) I'm sure others will have additional considerations to share. My choice has always been exp/imp. Lisa Koivu The Vicodin-enhanced DBA Ft. Lauderdale, FL, USA -Original Message- From: O'Neill, Sean [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 6:16 AM To: Multiple recipients of list ORACLE-L Subject: Data load options I'm trying to compile a list of options for loading data into an Oracle database on NT platform. What I've come up with so far is: [1] SQL script that performs inserts, updates. [2] SQL Loader utility [3] Import utility Are there others? Anyone care to share experience based opinions on pros and cons of the methods? Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=US-ASCII META NAME=Generator CONTENT=MS Exchange Server version 5.5.2653.12 TITLERE: Data load options/TITLE /HEAD BODY PFONT COLOR=#FF SIZE=2 FACE=ArialHi Sean, /FONT /P PFONT COLOR=#FF SIZE=2 FACE=ArialOthers have given you different options.nbsp; Here's some considerations:/FONT /P PFONT COLOR=#FF SIZE=2 FACE=Arial1.nbsp; SQL Script. /FONT ULLIFONT COLOR=#FF SIZE=2 FACE=ArialCan be SLOW /FONT/LI LIFONT COLOR=#FF SIZE=2 FACE=ArialMay require intermittent commits in your script/FONT/LI LIFONT COLOR=#FF SIZE=2 FACE=ArialManual and error prone/FONT/LI LIFONT COLOR=#FF SIZE=2 FACE=ArialMust go through SQL engine/FONT/LI BR /UL PFONT COLOR=#FF SIZE=2 FACE=Arial2.nbsp; SQL Loader/FONT ULLIFONT COLOR=#FF SIZE=2 FACE=ArialCan be very fast (direct - bypassing SQL engine). /FONT/LI LIFONT COLOR=#FF SIZE=2 FACE=ArialDirect path load will invalidate indexes. /FONT/LI LIFONT COLOR=#FF SIZE=2 FACE=ArialYou can keep track of rejected records easily (.bad file)/FONT/LI LIFONT COLOR=#FF SIZE=2 FACE=ArialDependent upon your file format being EXACT, no errors./FONT/LI BR /UL PFONT COLOR=#FF SIZE=2
Oracle pricing
Title: Oracle pricing Has anyone experienced Oracle sales people gouging each other? Seems like they are getting pretty cut throat. I got one quote for $400,000, and a second quote for less than 25% of that, from two different people. WOW. They are beginning to sound like the company I work for - different story from different people. Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments.
ot: RE: Data load options vicodin
Title: ot: RE: Data load options vicodin A pain reliever (narcotic) that makes you really woozy sleepy and stupid. Lucky I'm not actually supporting a database. I'm off the painkillers today, yesterday was bad . . . -Original Message- From: Hallas John [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 10:57 AM To: Multiple recipients of list ORACLE-L Subject: RE: Data load options Go on then Lisa, I rise to the challenge For us UK based listers what is Vicodin? John -Original Message- From: Koivu, Lisa [mailto:[EMAIL PROTECTED]] Sent: 25 July 01 15:26 To: Multiple recipients of list ORACLE-L Subject: RE: Data load options Hi Sean, Others have given you different options. Here's some considerations: 1. SQL Script. Can be SLOW May require intermittent commits in your script Manual and error prone Must go through SQL engine 2. SQL Loader Can be very fast (direct - bypassing SQL engine). Direct path load will invalidate indexes. You can keep track of rejected records easily (.bad file) Dependent upon your file format being EXACT, no errors. 3. Import Requires minimal manual fiddling Can be very slow - I once imported 150GB and it took ~3 days Does not seamlessly handle all object types (INtermedia (domain) indexes is one example) Restarting an import will take a lot longer. If your import fails, be sure and truncate/drop all tables before starting again. Have the option of not including indexes (INDEXES=N) Can also reset your storage parms prior to import (export with data=n, edit file [SSSHHH] and enter new storage parms / import, export with data=y, import data with IGNORE=Y) I'm sure others will have additional considerations to share. My choice has always been exp/imp. Lisa Koivu The Vicodin-enhanced DBA Ft. Lauderdale, FL, USA -Original Message- From: O'Neill, Sean [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 6:16 AM To: Multiple recipients of list ORACLE-L Subject: Data load options I'm trying to compile a list of options for loading data into an Oracle database on NT platform. What I've come up with so far is: [1] SQL script that performs inserts, updates. [2] SQL Loader utility [3] Import utility Are there others? Anyone care to share experience based opinions on pros and cons of the methods? Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **
RE: deletion of data from a large table
Oops, meant to say you can RESIZE the datafile down to 1 Meg after the truncate -Original Message- Sent: Thursday, July 26, 2001 11:01 AM To: Multiple recipients of list ORACLE-L You would need to drop any foreign key constraints pointing to that table before truncating and then recreate them after reloading the data. If I remember correctly, simply disabling them won't work since Oracle treats Truncate Table the same as Drop Table in many ways. Other constraints (NOT NULL, etc) won't be affected. Also, depending on the size of your initial extent and the amount of data you have remaining, you might be able to resize the one remaining datafile down after you truncate the table. (e.g., if your initial exent is 5 Meg and you don't anticipate ever having more than 1 Meg of data, you can RESIZE the datafile down to 5 Meg after the truncate). Jay Miller -Original Message- Sent: Thursday, July 26, 2001 8:36 AM To: Multiple recipients of list ORACLE-L This can be done . But what about the constraints ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 5:41 PM I think this is happening because when you DELETE data the High Water Mark(HWM) is not lowered. Essentially you have not gained any freespace. If possible you could export remaining data truncate table then re-import. Correct me if I am wrong here. Rick -Original Message- Sent: Thursday, July 26, 2001 7:41 AM To: Multiple recipients of list ORACLE-L Hi All, I have deleted 3 lakhs records from a large table. But there is no effect on tablespace i.e. before I delete the data freespace in TS is 100MB , after deletion also it is showing 100MB. What could be the reason ? How to get the freespace after deleting the data ? Thanks rukmini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or
Re: ot: RE: Data load options vicodin
Koivu, Lisa wrote: A pain reliever (narcotic) that makes you really woozy sleepy and stupid. Lucky I'm not actually supporting a database. I'm off the painkillers today, yesterday was bad . . . so how many duhvelopers did you take out to need that stuff?;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ If a program is useful, it must be changed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: deletion of data from a large table
This is what I use for truncating data from a large table with foreign key constraints. select 'alter table ' ||b.table_name ||' disable constraint '||b.constraint_name ||';' from user_constraints a, user_constraints b where a.table_name = tablename and a.constraint_name = b.r_constraint_name and b.constraint_type='R' / truncate table tablename; select 'alter table ' ||b.table_name ||' enable constraint '||b.constraint_name| |';' from user_constraints a, user_constraints b where a.table_name = tablename and a.constraint_name = b.r_constraint_name and b.constraint_type='R' / Rakesh [EMAIL PROTECTED] 07/26/01 11:01AM You would need to drop any foreign key constraints pointing to that table before truncating and then recreate them after reloading the data. If I remember correctly, simply disabling them won't work since Oracle treats Truncate Table the same as Drop Table in many ways. Other constraints (NOT NULL, etc) won't be affected. Also, depending on the size of your initial extent and the amount of data you have remaining, you might be able to resize the one remaining datafile down after you truncate the table. (e.g., if your initial exent is 5 Meg and you don't anticipate ever having more than 1 Meg of data, you can RESIZE the datafile down to 5 Meg after the truncate). Jay Miller -Original Message- Sent: Thursday, July 26, 2001 8:36 AM To: Multiple recipients of list ORACLE-L This can be done . But what about the constraints ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 5:41 PM I think this is happening because when you DELETE data the High Water Mark(HWM) is not lowered. Essentially you have not gained any freespace. If possible you could export remaining data truncate table then re-import. Correct me if I am wrong here. Rick -Original Message- Sent: Thursday, July 26, 2001 7:41 AM To: Multiple recipients of list ORACLE-L Hi All, I have deleted 3 lakhs records from a large table. But there is no effect on tablespace i.e. before I delete the data freespace in TS is 100MB , after deletion also it is showing 100MB. What could be the reason ? How to get the freespace after deleting the data ? Thanks rukmini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ:
Re: Solaris.. help.!!
http://docs.sun.com Saurabh Sharma wrote: Hi all, please help me in finding the right doc about starting from scratch on Solaris. I'm looking for Solaris for Oracle. can anyone suggest me some good starting documentation or links on this. like introduction, architectue, installtion and configuration etc.. thanks. Saurabh Sharma _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: deletion of data from a large table
Well, I have disabled FK constraints, done a truncate and re-enabled. Terry Miller, Jay wrote: You would need to drop any foreign key constraints pointing to that table before truncating and then recreate them after reloading the data. If I remember correctly, simply disabling them won't work since Oracle treats Truncate Table the same as Drop Table in many ways. Other constraints (NOT NULL, etc) won't be affected. Also, depending on the size of your initial extent and the amount of data you have remaining, you might be able to resize the one remaining datafile down after you truncate the table. (e.g., if your initial exent is 5 Meg and you don't anticipate ever having more than 1 Meg of data, you can RESIZE the datafile down to 5 Meg after the truncate). Jay Miller -Original Message- Sent: Thursday, July 26, 2001 8:36 AM To: Multiple recipients of list ORACLE-L This can be done . But what about the constraints ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 5:41 PM I think this is happening because when you DELETE data the High Water Mark(HWM) is not lowered. Essentially you have not gained any freespace. If possible you could export remaining data truncate table then re-import. Correct me if I am wrong here. Rick -Original Message- Sent: Thursday, July 26, 2001 7:41 AM To: Multiple recipients of list ORACLE-L Hi All, I have deleted 3 lakhs records from a large table. But there is no effect on tablespace i.e. before I delete the data freespace in TS is 100MB , after deletion also it is showing 100MB. What could be the reason ? How to get the freespace after deleting the data ? Thanks rukmini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
RE: effect of Initial and Next exents...
Thanks Lisa, and all who responded. Yeah I find that document interesting... From: Koivu, Lisa [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: effect of Initial and Next exents... Date: Thu, 26 Jul 2001 07:47:07 -0800 Raghu, There are differing opinions regarding multiple extents. I subscribe to the belief that multiple extents are not a bad thing. The latency between the extent reads is not a factor until the number of extents reaches ~4000. I remember reading a white paper on this topic, however I can't tell you exactly where it is off the top of my head. If I was the dba for this database, I would be more concerned with fragmentation and size of extents than the number of extents. If you understand your data thoroughly, have fairly accurate estimates for growth and understand the application it is supporting, you can choose your extent sizes properly and won't have the problem of 4000+ extents. Uniform extent sizes are optimal to avoid fragmentation. My choice to avoid fragmentation is the method in the white paper entitled 'How to Stop Defragmenting and Start Living'. I don't know about LMT's, haven't read up on them, but just from the discussions I've seen on the list about them, it looks like may be an implementation of this idea. Here's another way to look at it: If you think multiple extents are bad, are you going to create a tablespace with a 6gb datafile for your 6gb 1-extent index and hope it doesn't grow? With larger databases this idea breaks down very quickly. HTH, and list, correct me if I am wrong about LMT's. I can always blame it on the pain killers. Lisa Koivu Ft. Lauderdale, FL, USA -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 1:31 PM To: Multiple recipients of list ORACLE-L Subject:effect of Initial and Next exents... Hi Friends I obsered in my big database Tables and Indexes set different Initial and next extents..So How it will effect on performance?? Suppose one my big table has initial 72Mb and next 245Mb..All big indexes(6Gb) was set low Initial and next around 245Mb..Any ideas about the performance and rectification??... TIA Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ora 12704 - character set mismatch when select nvarchar2 column
Title: Oracle pricing Hi, I have a table t_base_props with 3 columns defined as NVARCHAR2(256)... When i try to select directly from table like select nm_display_name from t_base_props...the query is properly executed but when i try to use ncarchar2 columns in follwing query i am getting error ORA-12704: CHARACTER SET MISMATCH: What might be the reason. character set of database is WE8IS08859P1. select t_sub.id_sub, map.id_po,map.id_pi_instance,map.id_paramtable, decode(tb_ip.id_prop,NULL, tb.nm_display_name,tb_ip.nm_display_name) as instance_nm_name,tb_pt.nm_name pt_nm_name, tb_po.nm_name po_nm_name, tb_po.nm_display_name po_nm_display_name, decode(map.id_sub,null,'N','Y') as b_PersonalRate, map.b_canICB from t_base_props tb,t_base_props tb_pt,t_base_props tb_po,t_effectivedate te, t_pi_template,t_sub,t_pl_map map,t_base_props tb_ip where t_sub.id_acc = 123 and map.id_po = t_sub.id_po and tb_ip.id_prop = map.id_pi_instance_parent(+) and (map.id_sub is NULL or map.id_sub = t_sub.id_sub and map.id_acc = 123) AND tb.id_prop = map.id_pi_instance AND tb_pt.id_prop = map.id_paramtable AND tb_po.id_prop = map.id_po AND t_pi_template.id_template = map.id_pi_template AND te.id_eff_date = t_sub.id_eff_date AND ((te.dt_start = GetUTCDate() AND (GetUTCDate() = te.dt_end or te.dt_end is null)) OR (GetUTCDate() = te.dt_start)); Thanks Harvinder
Re: ot: RE: Data load options vicodin
Bill, The duhvelopers failed to take her seriously when she told them, Don't make me break my foot off in yo a**!!! Way to go Lisa! Look out Rachel - there's a new Godess climbing the slopes of Olympus! And dang is she peeved! ;-) Scott Shafer San Antonio, TX Thater, William wrote: Koivu, Lisa wrote: A pain reliever (narcotic) that makes you really woozy sleepy and stupid. Lucky I'm not actually supporting a database. I'm off the painkillers today, yesterday was bad . . . so how many duhvelopers did you take out to need that stuff?;-) _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: effect of Initial and Next exents...
Lisa, You are right about the concern about fragmentation over the number of extents. When you use LMT's that have manually sized extents rather that the auto-allocate option, you have a good handle on the fragmentation problem. If you have a number of different tablespaces you can size the extents to match the tables put in them or visa-versa. As an example: if the table is large make the extents large (20 M), if the tables are small make the extents small (10 K). when you built the tables make your initial and next extent size the same extent size as the LTM and or a multiple of the LTM extent size. The waste will be eliminated if the table is active and the WHM is moved downward. If you use the autoallocate option the LMT extents will grow in size as the need for space increases. For an explaination see: http://www.oracle.com/oramag/oracle/00-nov/o60o8i.html I have migrated a 15 tablespace , 150 table , 72 GIG database with the data critical by date in each table and there was a lot of wasted space to LMT with 148 tablespaces partitioned by date range for the tables and the waste (free space) is minimul and the speed of the applications has increased. A BI plus will be the database management options I will have when the damagements decides on the data retention policy. ROR mª¿ªm [EMAIL PROTECTED] 07/26/01 11:47AM Raghu, There are differing opinions regarding multiple extents. I subscribe to the belief that multiple extents are not a bad thing. The latency between the extent reads is not a factor until the number of extents reaches ~4000. I remember reading a white paper on this topic, however I can't tell you exactly where it is off the top of my head. If I was the dba for this database, I would be more concerned with fragmentation and size of extents than the number of extents. If you understand your data thoroughly, have fairly accurate estimates for growth and understand the application it is supporting, you can choose your extent sizes properly and won't have the problem of 4000+ extents. Uniform extent sizes are optimal to avoid fragmentation. My choice to avoid fragmentation is the method in the white paper entitled 'How to Stop Defragmenting and Start Living'. I don't know about LMT's, haven't read up on them, but just from the discussions I've seen on the list about them, it looks like may be an implementation of this idea. Here's another way to look at it: If you think multiple extents are bad, are you going to create a tablespace with a 6gb datafile for your 6gb 1-extent index and hope it doesn't grow? With larger databases this idea breaks down very quickly. HTH, and list, correct me if I am wrong about LMT's. I can always blame it on the pain killers. Lisa Koivu Ft. Lauderdale, FL, USA -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 1:31 PM To: Multiple recipients of list ORACLE-L Subject: effect of Initial and Next exents... Hi Friends I obsered in my big database Tables and Indexes set different Initial and next extents..So How it will effect on performance?? Suppose one my big table has initial 72Mb and next 245Mb..All big indexes(6Gb) was set low Initial and next around 245Mb..Any ideas about the performance and rectification??... TIA Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Regression Testing at Oracle???
This seems to be standard practice any more... SIGH! But Oracle must be one of the worst offenders. I once was looking to implement Oracle Financials as a paying beta customer (Shouldn't this be a contradiction in terms?). Oracle was the alpha and Sequent Computer in Oregon was the original beta (Oracle and Sequent had a pretty tight relationship back then). The Sequent implementation was on their own servers running Dynix, a Unix derivative. Our implementation was to be a port to VAX/VMS. What a mess! Bug city and Oracle still wanted to charge us big bucks for beta software!! Oracle eventually dropped the VMS port and I believe the first commercial version of the Oracle Apps did not ship for another 2-3 years. I wonder, how many companies paid for Oracle's development costs? Steve Orr -Original Message- Sent: Thursday, July 26, 2001 9:29 AM To: Multiple recipients of list ORACLE-L regression testing?, heck we are the alpha/beta/regression testers :) joe [EMAIL PROTECTED] 07/26/01 10:35AM This makes me wonder: what kind of regression testing is implemented by oracle? Trial and error? It makes me wonder, oh it makes me wander (Stairway to Heaven) -Original Message- From: A. Bardeen [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 6:15 AM To: Multiple recipients of list ORACLE-L Subject: FYI: new alert regarding 8.1.7.2 patchset Note: 153172.1 ALERT: Do NOT Install 8.1.7.2.0 Patch Set on top of 8.1.7.1 8.1.7.2.0 Patch Set Does Not Install Correctly Over 8.1.7.1/8.1.7.1B This alert will be updated to indicate the current status of this problem. The modification history is shown at the END of the alert. Versions Affected ~ This problem affects the installation of the 8.1.7.2.0 Patch Set. Platforms Affected ~~ This problem affects the following platforms only: HPUX (Oracle 32 bit release) HPUX (Oracle 64 bit release) Compaq Tru64 Intel Solaris This problem does NOT affect the following platform: Sun Sparc Solaris (Oracle 32 bit release) 8.1.7.2 has not been released on any other platform yet. Other platforms will have this problem corrected prior to their 8.1.7.2 Patch Set being released. Description ~~~ If the 8.1.7.2.0 Patch Set is installed on top of either 8.1.7.1 or 8.1.7.1B then the patch set does not install correctly. No errors are reported during the installation but the Oracle version banner still shows the version to be 8.1.7.1. Likelihood of Occurrence You will encounter this problem if you install the 8.1.7.2.0 patch set on top of either 8.1.7.1 or 8.1.7.1B on any of the platforms listed above. You are STRONGLY advised NOT to install 8.1.7.2.0 on top of 8.1.7.1 releases until this issue is addressed. Possible Symptoms ~ The main visible symptoms of this issue are: a. The Oracle version banner still shows the RDBMS release to be 8.1.7.1 b. SELECT * FROM V$VERSION shows the release to be 8.1.7.1 c. Bugs fixed in 8.1.7.2 may still be encountered There may be additional symptoms not yet discovered as the resulting installation contains an untested combination of modules. Workaround ~~ The only workaround to this problem is to install 8.1.7.2.0 on top of an 8.1.7.0 Oracle installation. ie: If the current installation is at release 8.1.7.1, then you must reinstall 8.1.7.0 and then apply the 8.1.7.2 patch set. If you have already installed 8.1.7.2 on top of 8.1.7.1 then it is advisable to reinstall the base release (8.1.7.0) and then apply the patch set on top of this to get a proper 8.1.7.2 release installed. Patches ~~~ The affected patch sets will be re-released shortly with the version number 8.1.7.2.1. These updated patch sets will install on top of 8.1.7.1, 8.1.7.1B or 8.1.7.0. If possible please avoid upgrading until the revised patch sets are released. References ~~ Base bug reporting the install problem [BUG:1898001] Modification History: ~ 26-Jul-2001 Initial alert that 8.1.7.2 does not install over 8.1.7.1 __ Oracle Support Services . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California--
RE: how do i explain this ?
Did you try cursor_sharing=force? Regards, Waleed -Original Message- Sent: Thursday, July 26, 2001 5:37 AM To: Multiple recipients of list ORACLE-L list, this application heavyly make use of literals , NO BIND VARIABLES and was running without any lib cache latch or shared pool latch problems on 7.3.2 We ported the DB to 8.1.5 and v$session_wait is full of latch free event !! all the latch waits are on lib cache and shapred pool (as expected from any app NOT using bind vars) and the app is running terribly slow !! my question is... how 7.3.2 was able to handle this ?? how i explain this to my management ? i was able to convince then on porting to 8i to get better perfornace !! note: i cannot change the app. all changes must be from the back end. TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
NULL Foreign Key Value
Can somebody explain why Oracle would allow a foreign key to be null and still enforce the referential integrity constraint. Thanks, George Hofilena DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Hofilena INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Dedicated / Multi Threaded oracle server.
Can someone tell me about the difference between Dedicated and Multi Threaded Oracle Server. Let me assume one server is installed as dedicated, can we change to MTS mode and vice versa and how? Thanks. Dharminder Kumar This e-mail and any attachments may contain confidential and privileged information. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient is unauthorized and may be illegal. Unless otherwise stated, opinions expressed in this e-mail are those of the author and are not endorsed by the author's employer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kumar, Dharminder INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how do i explain this ?
This is true. Check Note:1020706.102 on the Metalink. Regards, Waleed -Original Message- Sent: Thursday, July 26, 2001 7:52 AM To: Multiple recipients of list ORACLE-L Did you try making time_statistics=FALSE cause this is a bug in 8.1.5 which causes lots of latch free waits if it is set as TRUE From: Rahul [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: how do i explain this ? Date: Thu, 26 Jul 2001 01:37:18 -0800 list, this application heavyly make use of literals , NO BIND VARIABLES and was running without any lib cache latch or shared pool latch problems on 7.3.2 We ported the DB to 8.1.5 and v$session_wait is full of latch free event !! all the latch waits are on lib cache and shapred pool (as expected from any app NOT using bind vars) and the app is running terribly slow !! my question is... how 7.3.2 was able to handle this ?? how i explain this to my management ? i was able to convince then on porting to 8i to get better perfornace !! note: i cannot change the app. all changes must be from the back end. TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ARUN K C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ot: RE: Data load options vicodin
a HIGHLY addictive pain-reliever, I believe that more than 5 days on it is enough to addict someone. I was given a prescription for this after knee surgery. I very reluctantly took half of one (I had read about how addictive it was) the first night after my surgery when I was going out of my head with pain. When half did not completely relieve the pain, I took the other half. Good thing I was in bed when I did that. I went out so fast I would have hit the floor if I had been standing up. Never took another one From: Koivu, Lisa [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: ot: RE: Data load options vicodin Date: Thu, 26 Jul 2001 07:47:05 -0800 A pain reliever (narcotic) that makes you really woozy sleepy and stupid. Lucky I'm not actually supporting a database. I'm off the painkillers today, yesterday was bad . . . -Original Message- From: Hallas John [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 10:57 AM To: Multiple recipients of list ORACLE-L Subject:RE: Data load options Go on then Lisa, I rise to the challenge For us UK based listers what is Vicodin? John -Original Message- From: Koivu, Lisa [mailto:[EMAIL PROTECTED]] Sent: 25 July 01 15:26 To: Multiple recipients of list ORACLE-L Subject: RE: Data load options Hi Sean, Others have given you different options. Here's some considerations: 1. SQL Script. * Can be SLOW * May require intermittent commits in your script * Manual and error prone * Must go through SQL engine 2. SQL Loader * Can be very fast (direct - bypassing SQL engine). * Direct path load will invalidate indexes. * You can keep track of rejected records easily (.bad file) * Dependent upon your file format being EXACT, no errors. 3. Import * Requires minimal manual fiddling * Can be very slow - I once imported 150GB and it took ~3 days * Does not seamlessly handle all object types (INtermedia (domain) indexes is one example) * Restarting an import will take a lot longer. If your import fails, be sure and truncate/drop all tables before starting again. * Have the option of not including indexes (INDEXES=N) * Can also reset your storage parms prior to import (export with data=n, edit file [SSSHHH] and enter new storage parms / import, export with data=y, import data with IGNORE=Y) I'm sure others will have additional considerations to share. My choice has always been exp/imp. Lisa Koivu The Vicodin-enhanced DBA Ft. Lauderdale, FL, USA -Original Message- From: O'Neill, Sean [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 6:16 AM To: Multiple recipients of list ORACLE-L Subject:Data load options I'm trying to compile a list of options for loading data into an Oracle database on NT platform. What I've come up with so far is: [1] SQL script that performs inserts, updates. [2] SQL Loader utility [3] Import utility Are there others? Anyone care to share experience based opinions on pros and cons of the methods? Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium.
moving tables to a different tablespace
Hi Group, Please explain what I am doing wrong. 1) exp outln/outln@webprod mailto:outln/outln@webprod file=exp_file tables = 'OL$' 'OL$HINTS' 2) Dropped the tables: 'OL$' and 'OL$HINTS' on webprod 3) Created tablespace outln_ts on webprod 4) Altered user outln default tablespace outln_ts 5) imp outln/outln@webprod mailto:outln/outln@webprod file=exp_file tables = 'OL$' 'OL$HINTS' 6) SQL select table_name, tablespace_name from dba_tables where owner = 'OUTLN'; TABLE_NAME TABLESPACE_NAME -- -- OL$SYSTEM OL$HINTS SYSTEM XX OUTLN_TS WHY are the tables being re-imported back into SYSTEM tablespace Oracle 8.1.7 on Sun Solaris 5.7 TIA Al Rusnak 804-734-8453 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rusnak, George A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle pricing
Title: Oracle pricing Yes I have. On the last set of quotes I got from Orance the price ranged from $175,000 to $70,000 for the same set of products. It just depended onwho I spoke with. I also think timing has something to do with it. Salesmen meeting quotas and the company reporting profit/loss. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, July 26, 2001 11:47 AMTo: Multiple recipients of list ORACLE-LSubject: Oracle pricing Has anyone experienced Oracle sales people gouging each other? Seems like they are getting pretty cut throat. I got one quote for $400,000, and a second quote for less than 25% of that, from two different people. WOW. They are beginning to sound like the company I work for - different story from different people. Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments.
Re:Oracle pricing
Lisa, I've not experienced that particular behavior from the Oracle sales droids. But, we did have ours in yesterday (new droids wanting to put faces to names) and since Oracle's revenues are down they suggested that they might be coming around to perform an audit! Now that I think is a heavy handed way of pumping up the revenue stream. Guess I'd better learn DB2!! Dick Goulet Reply Separator Author: Koivu; Lisa [EMAIL PROTECTED] Date: 7/26/2001 7:47 AM Has anyone experienced Oracle sales people gouging each other? Seems like they are getting pretty cut throat. I got one quote for $400,000, and a second quote for less than 25% of that, from two different people. WOW. They are beginning to sound like the company I work for - different story from different people. Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments. !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=US-ASCII META NAME=Generator CONTENT=MS Exchange Server version 5.5.2653.12 TITLEOracle pricing/TITLE /HEAD BODY PFONT SIZE=2 FACE=Book AntiquaHas anyone experienced Oracle sales people gouging each other?nbsp; Seems like they are getting pretty cut throat.nbsp; I got one quote for $400,000, and a second quote for less than 25% of that, from two different people.nbsp; WOW.nbsp;nbsp;nbsp; They are beginning to sound like the company I work for - different story from different people./FONT/P PFONT SIZE=2 FACE=Book AntiquaLisa Koivu/FONT BRFONT SIZE=2 FACE=Book AntiquaOracle Database Administrator/FONT BRFONT SIZE=2 FACE=Tahoma954-935-4117/FONT /P PFONT SIZE=2 FACE=TahomaThe information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful./FONT/P PFONT SIZE=2 FACE=TahomaThe sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments. /FONT/P BR /BODY /HTML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OTRE: Regression Testing at Oracle???
Supports my personal theory (no peer-reviewed work, yet, sorry Eric! :) that large corporations routinely get away with lots of things that you and I would get killed, sued, beat up, and/or besmirched for. -Original Message- Sent: Thursday, July 26, 2001 1:57 PM To: Multiple recipients of list ORACLE-L This seems to be standard practice any more... SIGH! But Oracle must be one of the worst offenders. I once was looking to implement Oracle Financials as a paying beta customer (Shouldn't this be a contradiction in terms?). Oracle was the alpha and Sequent Computer in Oregon was the original beta (Oracle and Sequent had a pretty tight relationship back then). The Sequent implementation was on their own servers running Dynix, a Unix derivative. Our implementation was to be a port to VAX/VMS. What a mess! Bug city and Oracle still wanted to charge us big bucks for beta software!! Oracle eventually dropped the VMS port and I believe the first commercial version of the Oracle Apps did not ship for another 2-3 years. I wonder, how many companies paid for Oracle's development costs? Steve Orr -Original Message- Sent: Thursday, July 26, 2001 9:29 AM To: Multiple recipients of list ORACLE-L regression testing?, heck we are the alpha/beta/regression testers :) joe [EMAIL PROTECTED] 07/26/01 10:35AM This makes me wonder: what kind of regression testing is implemented by oracle? Trial and error? It makes me wonder, oh it makes me wander (Stairway to Heaven) -Original Message- From: A. Bardeen [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 6:15 AM To: Multiple recipients of list ORACLE-L Subject: FYI: new alert regarding 8.1.7.2 patchset Note: 153172.1 ALERT: Do NOT Install 8.1.7.2.0 Patch Set on top of 8.1.7.1 8.1.7.2.0 Patch Set Does Not Install Correctly Over 8.1.7.1/8.1.7.1B This alert will be updated to indicate the current status of this problem. The modification history is shown at the END of the alert. Versions Affected ~ This problem affects the installation of the 8.1.7.2.0 Patch Set. Platforms Affected ~~ This problem affects the following platforms only: HPUX (Oracle 32 bit release) HPUX (Oracle 64 bit release) Compaq Tru64 Intel Solaris This problem does NOT affect the following platform: Sun Sparc Solaris (Oracle 32 bit release) 8.1.7.2 has not been released on any other platform yet. Other platforms will have this problem corrected prior to their 8.1.7.2 Patch Set being released. Description ~~~ If the 8.1.7.2.0 Patch Set is installed on top of either 8.1.7.1 or 8.1.7.1B then the patch set does not install correctly. No errors are reported during the installation but the Oracle version banner still shows the version to be 8.1.7.1. Likelihood of Occurrence You will encounter this problem if you install the 8.1.7.2.0 patch set on top of either 8.1.7.1 or 8.1.7.1B on any of the platforms listed above. You are STRONGLY advised NOT to install 8.1.7.2.0 on top of 8.1.7.1 releases until this issue is addressed. Possible Symptoms ~ The main visible symptoms of this issue are: a. The Oracle version banner still shows the RDBMS release to be 8.1.7.1 b. SELECT * FROM V$VERSION shows the release to be 8.1.7.1 c. Bugs fixed in 8.1.7.2 may still be encountered There may be additional symptoms not yet discovered as the resulting installation contains an untested combination of modules. Workaround ~~ The only workaround to this problem is to install 8.1.7.2.0 on top of an 8.1.7.0 Oracle installation. ie: If the current installation is at release 8.1.7.1, then you must reinstall 8.1.7.0 and then apply the 8.1.7.2 patch set. If you have already installed 8.1.7.2 on top of 8.1.7.1 then it is advisable to reinstall the base release (8.1.7.0) and then apply the patch set on top of this to get a proper 8.1.7.2 release installed. Patches ~~~ The affected patch sets will be re-released shortly with the version number 8.1.7.2.1. These updated patch sets will install on top of 8.1.7.1, 8.1.7.1B or 8.1.7.0. If possible please avoid upgrading until the revised patch sets are released. References ~~ Base bug reporting the install problem [BUG:1898001] Modification History: ~ 26-Jul-2001 Initial alert that 8.1.7.2 does not install over 8.1.7.1 __
RE: Dangerous AIX Bug!
Ross, we are also running AIX 4.3.3 with a mix of 8.0.5.2.1 and 8.1.7 databases, headed to all 8.1.7. We are mostly running S80s here. Just shoot me a note and we'll talk. John D. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: moving tables to a different tablespace
Is it possible that the original user that the export was taken from was in the system tablespace? Try doing a FROMUSER/TOUSER kk -Original Message- George A. Sent: Thursday, July 26, 2001 1:51 PM To: Multiple recipients of list ORACLE-L Hi Group, Please explain what I am doing wrong. 1) exp outln/outln@webprod mailto:outln/outln@webprod file=exp_file tables = 'OL$' 'OL$HINTS' 2) Dropped the tables: 'OL$' and 'OL$HINTS' on webprod 3) Created tablespace outln_ts on webprod 4) Altered user outln default tablespace outln_ts 5) imp outln/outln@webprod mailto:outln/outln@webprod file=exp_file tables = 'OL$' 'OL$HINTS' 6) SQL select table_name, tablespace_name from dba_tables where owner = 'OUTLN'; TABLE_NAME TABLESPACE_NAME -- -- OL$SYSTEM OL$HINTS SYSTEM XX OUTLN_TS WHY are the tables being re-imported back into SYSTEM tablespace Oracle 8.1.7 on Sun Solaris 5.7 TIA Al Rusnak 804-734-8453 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rusnak, George A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Data load options
Okay Lisa, WHY were you on painkillers? Rachel From: Koivu, Lisa [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: Data load options Date: Thu, 26 Jul 2001 07:47:06 -0800 Oh yes. You are right. It loads full blocks above the HWM. Forgot to mention that... thanks for pointing out that VERY important bit of info. Must be the narcotics. Lisa -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 11:03 AM To: Multiple recipients of list ORACLE-L Subject:Re:RE: Data load options Lisa, SQL*Loader in direct path can cause you storage problems since it always appends to the table(s) ignoring blocks on the free block list. I found that out after a developer was using it for our data warehouse. At the end of a year he had burned almost 100GB of disk it kept increasing even though he was trying to keep only a rolling 180 window. On a hunch we exported the data, truncated the table imported the data back in. The amount of tablespace being used dropped 50%. Dick Goulet Reply Separator Author: Koivu; Lisa [EMAIL PROTECTED] Date: 7/25/2001 6:26 AM Hi Sean, Others have given you different options. Here's some considerations: 1. SQL Script. * Can be SLOW * May require intermittent commits in your script * Manual and error prone * Must go through SQL engine 2. SQL Loader * Can be very fast (direct - bypassing SQL engine). * Direct path load will invalidate indexes. * You can keep track of rejected records easily (.bad file) * Dependent upon your file format being EXACT, no errors. 3. Import * Requires minimal manual fiddling * Can be very slow - I once imported 150GB and it took ~3 days * Does not seamlessly handle all object types (INtermedia (domain) indexes is one example) * Restarting an import will take a lot longer. If your import fails, be sure and truncate/drop all tables before starting again. * Have the option of not including indexes (INDEXES=N) * Can also reset your storage parms prior to import (export with data=n, edit file [SSSHHH] and enter new storage parms / import, export with data=y, import data with IGNORE=Y) I'm sure others will have additional considerations to share. My choice has always been exp/imp. Lisa Koivu The Vicodin-enhanced DBA Ft. Lauderdale, FL, USA -Original Message- From: O'Neill, Sean [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 6:16 AM To: Multiple recipients of list ORACLE-L Subject: Data load options I'm trying to compile a list of options for loading data into an Oracle database on NT platform. What I've come up with so far is: [1] SQL script that performs inserts, updates. [2] SQL Loader utility [3] Import utility Are there others? Anyone care to share experience based opinions on pros and cons of the methods? Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=US-ASCII META NAME=Generator CONTENT=MS Exchange Server version 5.5.2653.12 TITLERE: Data load options/TITLE /HEAD BODY PFONT COLOR=#FF SIZE=2 FACE=ArialHi Sean, /FONT /P PFONT COLOR=#FF SIZE=2 FACE=ArialOthers have given you different options.nbsp; Here's some considerations:/FONT /P PFONT COLOR=#FF SIZE=2 FACE=Arial1.nbsp; SQL Script. /FONT ULLIFONT COLOR=#FF SIZE=2 FACE=ArialCan be SLOW /FONT/LI LIFONT COLOR=#FF SIZE=2 FACE=ArialMay require intermittent commits in your script/FONT/LI LIFONT COLOR=#FF SIZE=2 FACE=ArialManual and error
need procedure to extract DDL for table
Does anybody have stored procedure or PL/SQL script to extract DDL for the table? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Securing passwords in scripts
Interesting topic. Would anyone be interested in a password server? Not foolproof, but considerably more secure than putting passwords in a script, and infinitely more flexible. Jared O'Neill, SeanTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sean.ONeill@o cc: rganon.ie Subject: Securing passwords in scripts Sent by: [EMAIL PROTECTED] om 07/26/01 01:55 AM Please respond to ORACLE-L I have some scripts, O.S. command and SQL, which I use to perform COLD backups of DBs and other tasks. I'm not particularily happy about having username/password information in the scripts. Has anyone come up with a way to avoid same allowing for the fact the scripts should require no user input to execute. Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).