Database character set for Webshpere access
Title: Database character set for Webshpere access list, I've searched the faq list and metalink. It appears the database character set for java etc should be al32utf8 and nls_character set of al16utf16 for a 9i R2 database. Has anyone altered a database from US7ASCII to al32utf8 and al16utf16? Any problems?
RE: System tablespace Oracle 9202
Title: RE: System tablespace Oracle 9202 This is a UNIX Solaris running 5.8 I created the database from sqlplus using scripts. I somehow thought the default was LMT for system rather then DICTIONARY. I changed the script to LMT and recreated, but I was surprised by the Dictionary system creation. -Original Message- From: Freeman Robert - IL [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 06, 2003 9:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: System tablespace Oracle 9202 DBCA, by default in 92 will create SYSTEM as LMT. There is an option to do dictionary if you prefer. CREATE DATABASE default is a dictionary managed SYSTEM tablespace with LMT optioinal. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 3/6/2003 6:43 PM What platform is this? I can't be sure (because my laptop is miles away at the moment) but I think on 9.2 on NT when I used the creation assistant to generate scripts for me, SYSTEM was an lmt. hth connor --- Godlewski, Melissa [EMAIL PROTECTED] wrote: List, System tablespace for Oracle 9iR2 is defaulting to Dictionary Extent Management. I thought all tablespaces defaulted to Local in this release. Thu Mar 6 15:29:43 2003 create tablespace SYSTEM datafile '/oradb/DEV/system/system01.dbf' size 201M reuse default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY online Thu Mar 6 15:29:57 2003 Completed: create tablespace SYSTEM datafile '/oradb/DEV Thu Mar 6 15:29:57 2003 create rollback segment SYSTEM tablespace SYSTEM storage (initial 50K next 50K) Completed: create rollback segment SYSTEM tablespace SYSTEM = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: System tablespace Oracle 9202
Title: RE: System tablespace Oracle 9202 Isn't that the truth. GUI's don't seems to make our DBA work easier. -Original Message- From: Chuck Hamilton [mailto:[EMAIL PROTECTED]] Sent: Friday, March 07, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Subject: Re: System tablespace Oracle 9202 Which is a good reason to save scripts from DBCA as opposed to having it create the DB for you. I always do this. I can't tell you how many times I tried to let DBCA create the DB directly only to have it crap out for one reason or another, and then you need to go back and plug in all the custom values all over again. If you save scripts, you can modify them to do whatever you want. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, March 06, 2003 4:59 PM It was only in 9.2 that it was possible to create the system tablespace as locally managed, and rumour says that in 10i system tbs defaults to locally managed. The reason it's not default in 9.2 is most likely because..: 1. Most likely they just didn't update the DBCA default scripts to use this feature when they went from 9i R1 to 9i R2 (read: the scripts was just copied from the 9i R1 source tree) 2. The feature is brand new, so if some problems turn up, most databases wont have it set, because they are created from the DBCA. Regards, Morten Egan Godlewski, Melissa wrote: List, System tablespace for Oracle 9iR2 is defaulting to Dictionary Extent Management. I thought all tablespaces defaulted to Local in this release. Thu Mar 6 15:29:43 2003 create tablespace SYSTEM datafile '/oradb/DEV/system/system01.dbf' size 201M reuse default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY online Thu Mar 6 15:29:57 2003 Completed: create tablespace SYSTEM datafile '/oradb/DEV Thu Mar 6 15:29:57 2003 create rollback segment SYSTEM tablespace SYSTEM storage (initial 50K next 50K) Completed: create rollback segment SYSTEM tablespace SYSTEM -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Morten Egan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chuck Hamilton INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
System tablespace Oracle 9202
Title: System tablespace Oracle 9202 List, System tablespace for Oracle 9iR2 is defaulting to Dictionary Extent Management. I thought all tablespaces defaulted to Local in this release. Thu Mar 6 15:29:43 2003 create tablespace SYSTEM datafile '/oradb/DEV/system/system01.dbf' size 201M reuse default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY online Thu Mar 6 15:29:57 2003 Completed: create tablespace SYSTEM datafile '/oradb/DEV Thu Mar 6 15:29:57 2003 create rollback segment SYSTEM tablespace SYSTEM storage (initial 50K next 50K) Completed: create rollback segment SYSTEM tablespace SYSTEM
Help Oracle 9i db creation scripts
Title: Help Oracle 9i db creation scripts Oracle 9i R2 Solaris 8 LIST, I always create my databases from scripts, and I have Oracle 8i create database scripts. I've been trying to get Oracle 9i DBCA working for several days, and all I get is the initializing screen. I've checked metalink, google, and orafaq for resolutions, but I'm running out of time. Does someone have a script for Oracle 9i database creation I can use as a base for my new 9i database with the new features included? TIA M.Godlewski
Database naming conventions
List, I'm use to using a standard D=development T=test P=production. So for a database newly created on development it would be called something like D24X7. Then when it was created on Production it would be called P24X7. Or along similar lines. I'm working with an other DBA who wants everything to start with ora. Therefore it would be called orad24x7 and orap24x7. I've argued the ora is rather redundant since everyone will know it's an Oracle database they are connecting to. He is adamant it should have the ora identification so it is easily identified. I feel it will cause more confusion having ora at the beging of every dbname. Any thoughts for against either position? TIA M.Godlewski
RE: Database naming conventions
Title: RE: Database naming conventions Thanks, I Talking about the SID. I got my smile for the day, putting version etc. in would certainly add to the absurdity. -Original Message- From: Jay Hostetter [mailto:[EMAIL PROTECTED]] Sent: Friday, February 14, 2003 11:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: Database naming conventions Are we talking SID or connect string? I seem to remember that there was (or is on certain OSs) a limit to the length of the SID - so I tend to keep the SIDs short and sweet. If it is the connect string - then who is it that needs to know it is an Oracle database? The user? Why? The DBA? Er...shouldn't he/she already know that? I agree with you - I would eliminate the 'ora'. You can illustrate the absurdity by insisting that it also include the version number and OS ora9201tru64p24x7. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 02/14/03 11:23AM List, I'm use to using a standard D=development T=test P=production. So for a database newly created on development it would be called something like D24X7. Then when it was created on Production it would be called P24X7. Or along similar lines. I'm working with an other DBA who wants everything to start with ora. Therefore it would be called orad24x7 and orap24x7. I've argued the ora is rather redundant since everyone will know it's an Oracle database they are connecting to. He is adamant it should have the ora identification so it is easily identified. I feel it will cause more confusion having ora at the beging of every dbname. Any thoughts for against either position? TIA M.Godlewski **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database naming conventions
Title: RE: Database naming conventions Thanks everyone for your opinions. I believe I have some good examples of why not to use ora. This list is great! -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Friday, February 14, 2003 3:59 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Database naming conventions We use following syntax ... * FAM -- ABC Family Production DB * OLDFAM -- essentially FAM but as of 2AM today (refreshed daily or on demand) * FAMQA -- FAM QA * FAMTEST -- FAM User Acceptance * FAMDEV -- Fam development This works good for us ... 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! --- "Godlewski, Melissa" [EMAIL PROTECTED] wrote: List, I'm use to using a standard D=development T=test P=production. So for a database newly created on development it would be called something like D24X7. Then when it was created on Production it would be called P24X7. Or along similar lines. I'm working with an other DBA who wants everything to start with ora. Therefore it would be called orad24x7 and orap24x7. I've argued the ora is rather redundant since everyone will know it's an Oracle database they are connecting to. He is adamant it should have the ora identification so it is easily identified. I feel it will cause more confusion having ora at the beging of every dbname. Any thoughts for against either position? TIA M.Godlewski
Slightly OT: Multiple database on one UNIX system
Sun Solaris 8 Oracle 9i Where can I find information about,a SUN Solaris 8 UNIX on how much memory can the kernel address? I'm wondering what the semaphore and shared memory settings for the SUNOS config file need to be when running multiple (20-30)databases on one physical machine. My current settings are from the Oracle install guide for 1 database only. Any help appreciated. * Oracle set shmsys:shminfo_shmmax=4294967295set shmsys:shminfo_shmmin=1set shmsys:shminfo_shmmni=256set shmsys:shminfo_shmseg=10set semsys:seminfo_semmns=1024set semsys:seminfo_semmni=512set semsys:seminfo_semmsl=512set semsys:seminfo_semvmx=32767* Oracle End /etc 330$ipcsIPC status from running system as of Fri Jan 31 11:14:35 EST 2003T ID KEY MODE OWNER GROUPMessage Queues:Shared Memory:m 23808 0x5ec12124 --rw-r- ora oracleiSemaphores:s 24576000 0x4c12445c --ra-r- ora oracleis 6094849 0x4c12445d --ra-r- ora oracleis 6094850 0x4c12445e --ra-r- ora oraclei Memory: 16G real, 12G free, 2576M swap in use, 12G swap free
RE: strange error on DBMS_STATS
Title: RE: strange error on DBMS_STATS I thought people talked to themselves so they could get all the right answers. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 3:16 PM To: Multiple recipients of list ORACLE-L Subject: Re: strange error on DBMS_STATS you and Raj had the same thought. but no, the index is owned by the table owner got access so I could run the gather with a 10046 trace. so of course it's not failing as yet. sigh. and my boss wonders why I talk to myself --- Stephane Faroult [EMAIL PROTECTED] wrote: Rachel Carmichael wrote: We are not changing passwords, so I am presuming that this involves (somehow) a change of username. According to the package header, it will throw an ORA-2 if there are insufficent privileges. We rebuilt an index yesterday but did NOT change or add any table. I had this happen once before, on a different database, never solved it, but substituted dbms_utility.analyze_schema which worked. I can do the same thing this time but I'd prefer to solve it. Anyone ever see anything like this before? oh yeah 9.2.0.1 on Solaris 8 Rachel I have not seen it but could the rebuilt index now have a different owner ? -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: limiting temp space per user
Title: RE: limiting temp space per user Also you could add a profile to apply a limit to the adhoc queries and any that surpass the limit should be tuned by a dba or a power user of the tool. MCG -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 8:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: limiting temp space per user 1) Turn the pager off ;) 2) Increase temp space 3) Review sorting requirements of this adhoc stuff. Adjust sort_area_size, sort_area_retained_size if possible at the session level to reduce disk sorts. - Kirti -Original Message- Sent: Monday, December 09, 2002 2:49 PM To: Multiple recipients of list ORACLE-L Thats what I have now. But these adhoc reports keep running out of temp space and and ends up paging me :-) Babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 09, 2002 12:48 PM The way we do it is that create two temporary tablespaces. Use one for the production applicationa and other for adhoc users so that adhoc users do not mess up the production. -Shaleen - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 09, 2002 8:04 AM SQL alter user scott quota 10M on temp; User altered. HTH, Krishna - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 09, 2002 06:24 AM All Is it possible to limit the temp space used per user - either by using profiles or some other method? I tried using profiles but it would not allow me to set a limit on space usage. TIA Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Increase size of data files and rollback segments
Title: RE: Increase size of data files and rollback segments I disagree! I do welcome Jeremiah's input on this list. David, I think you missed the smiley attached to his message. -Original Message- From: Nguyen, David M [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 10:50 AM To: Multiple recipients of list ORACLE-L Subject: RE: Increase size of data files and rollback segments Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: limiting temp space per user
Title: RE: limiting temp space per user create a smaller temp table and assign the users account to it. -Original Message- From: Babu Nagarajan [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 9:24 AM To: Multiple recipients of list ORACLE-L Subject: limiting temp space per user All Is it possible to limit the temp space used per user - either by using profiles or some other method? I tried using profiles but it would not allow me to set a limit on space usage. TIA Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babu Nagarajan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
iostat help
Title: iostat help I know what some of the headings are for the following output, but I'm not 100% sure about the CPU section. Does us=users, sy=system, wt=job queue wait, id=process id? cpu us sy wt id 1 3 1 95 extended device statistics r/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device 0.1 0.7 0.6 4.6 0.0 0.0 5.4 48.2 0 0 c0t0d0 0.0 0.9 1.3 29.8 0.0 0.0 0.0 8.0 0 1 c0t1d0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c0t6d0 0.3 1.6 18.3 14.0 0.0 0.0 0.0 2.9 0 0 c1t1d4 0.1 1.6 0.8 12.9 0.0 0.0 0.1 2.2 0 0 c1t1d5 0.0 0.0 1.6 0.0 0.0 0.0 0.0 10.6 0 0 c1t1d3 0.0 0.0 0.0 0.0 0.0 0.0 0.0 4.1 0 0 c1t1d2 5.0 0.0 161.4 0.0 0.0 0.0 0.0 2.1 0 1 rmt/0 cpu us sy wt id 0 2 0 98
RE: iostat help
Title: RE: iostat help Thanks Tim. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Subject: Re: iostat help wt=wait for I/O call completion id=idle I know what some of the headings are for the following output, but I'm not 100% sure about the CPU section. Does us=users, sy=system, wt=job queue wait, id=process id? cpu us sy wt id 1 3 1 95 extended device statistics r/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device 0.1 0.7 0.6 4.6 0.0 0.0 5.4 48.2 0 0 c0t0d0 0.0 0.9 1.3 29.8 0.0 0.0 0.0 8.0 0 1 c0t1d0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c0t6d0 0.3 1.6 18.3 14.0 0.0 0.0 0.0 2.9 0 0 c1t1d4 0.1 1.6 0.8 12.9 0.0 0.0 0.1 2.2 0 0 c1t1d5 0.0 0.0 1.6 0.0 0.0 0.0 0.0 10.6 0 0 c1t1d3 0.0 0.0 0.0 0.0 0.0 0.0 0.0 4.1 0 0 c1t1d2 5.0 0.0 161.4 0.0 0.0 0.0 0.0 2.1 0 1 rmt/0 cpu us sy wt id 0 2 0 98 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 817 on Solaris 2.6 moving to Solaris 8
Title: Oracle 817 on Solaris 2.6 moving to Solaris 8 OS upgrade relink all? We are actually moving from one physical machine to another, but in reality we are just doing and OS upgrade from Sun Solaris 2.6 to Sun Solaris 8. My idea is to just backup the database and restore to the new machine. Relink all the oracle executables, and I'm back up and running. Did I miss/forget something in here? TIA MCG
Function use across database links
Title: Function use across database links List, Oracle documentation indicates the Oracle database server breaks the distributed query into a corresponding number of remote queries which it then sends to the remote node for execution. The remote node executes the queries and sends the results back to the local node. Therefore, I ran a statement and explained it. The results show SELECT STATEMENT Cost=8 REMOTE The question I have, is what if the sql is stored in a function that doesn't exist on the remote database. Will the Oracle server use the local function? If so, does it pull the data from the table on the remote server across the network. I checked orafaq.com, but didn't find any hits on this subject, and was unable to locate any other documentation regarding function usage and Database links. TIA MCG
RE: Strange Date -- 00-JAN-00 !!!!!
We had a similar problem with aload program. I believe it had to do with the century setting for us. -Original Message-From: Sunny Verghese [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 15, 2002 8:58 PMTo: Multiple recipients of list ORACLE-LSubject: Strange Date -- 00-JAN-00 ! One of the DBAs I work with is trying to figure out how some of the records in a table with about 15 million records contains 00-Jan-00 in a specific date column. The table is populated using an application written in Power Builder. I don't know the history (if and when patches were applied / the database was upgraded). I saw a couple of notes on Metalink about upgrades causing something of this sort. Any ideas ??? Sunny Do you Yahoo!?Faith Hill - Exclusive Performances, Videos, morefaith.yahoo.com
RE: View contents of global temp table
Title: RE: View contents of global temp table The global table is visible (Global) to all sessions, but each session can only see it's own data within the table. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 11:34 AM To: Multiple recipients of list ORACLE-L Subject: RE: View contents of global temp table Chris, you just contradicted yourself GLOBAL TEMPORARY (from the docs you quoted) is visible to all sessions, TEMPORARY is visible only to the session creating it Rachel --- Grabowy, Chris [EMAIL PROTECTED] wrote: ?? The data in a global temp table is only visible to the session that inserted the data, the other sessions cannot see the data, regardless of a commit. A quick search of the doc... GLOBAL TEMPORARY Specify GLOBAL TEMPORARY to indicate that the table is temporary and that its definition is visible to all sessions. The data in a temporary table is visible only to the session that inserts the data into the table. A temporary table has a definition that persists the same as the definitions of regular tables, but it contains either session-specific or transaction-specific data. You specify whether the data is session- or transaction-specific with the ON COMMIT keywords (below). Here is the (broken up) link http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/statem3e.htm#2061078 -Original Message- Sent: Monday, October 07, 2002 10:34 AM To: Multiple recipients of list ORACLE-L Rick, it is like any other table ... if the data is committed and you have access you can see data, else no you can't. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Monday, October 07, 2002 9:43 AM To: Multiple recipients of list ORACLE-L Hi All, In session 1 I am loading data into a global temp table. Is there any way to see contents of that table? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA work load - BDBAFH #1
Title: RE: DBA work load - BDBAFH #1 An ENRON executive in training. -Original Message- From: Bob Metelsky [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 5:53 PM To: Multiple recipients of list ORACLE-L Subject: RE: DBA work load - BDBAFH #1 I don't know how he can live with himself LMAO -Original Message- Sent: Monday, September 30, 2002 2:58 PM To: Multiple recipients of list ORACLE-L The phone rings. Another user. Still pissed off, I pick it up... Database Administration, can I help you? I answer professionally. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Replication question
Title: RE: Replication question Great book, I have it too! -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 10:28 AM To: Multiple recipients of list ORACLE-L Subject: RE: Replication question Paul - I don't know multimaster replication, so bear with me. I am thumbing through my copy of Oracle Distributed Systems by Charles Dye. Does your question relate to how propagation is controlled? I think propagation is controlled by scheduled jobs. Take a look at the procedure DBMS_DEFER_SYS.SCHEDULE_PUSH, which the book says Schedules an automatic push of the deftran queue to the specified master database. Hope this helps, it may irritate someone that really knows the answer to your question into replying. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, September 04, 2002 8:04 PM To: Multiple recipients of list ORACLE-L When DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT is executed to build the necessary underpinnings for multimaster replication of an object, it creates a package called object_name$RP. This package contains code to be run when rows are inserted, updated, or deleted. There are, however, no trigges in the owning schema, nor in that of the replication administrator. What, then, is the mechanism by which the procedures in this package are called? TIA! = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Corp. move to India
Title: RE: Oracle Corp. move to India Actually it's ya, hey dare, you betcha -Original Message- From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 01, 2002 11:29 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Corp. move to India ya, hey , you betcha -Original Message- Sent: Thursday, August 01, 2002 9:38 AM To: Multiple recipients of list ORACLE-L One of these days large multi-national software companies will discover that exotic, far-off place with lower pay scales, an eager work force, a strong work ethic and lot's of talent... The Great American Midwest. You know, places like Iowa. Of course language and cultural barriers will be a challenge. :-) Steve Orr Silicon Valley Refugee in Montana -Original Message- Sent: Wednesday, July 31, 2002 2:56 PM To: Multiple recipients of list ORACLE-L I would not treat this snip of news in such a light-hearted manner. Comparing to couple of years ago, the IT job market has slumped completely from a sellers market to a buyer's market. I am not a greedy person by any means and all I asking for is a decent salary and some job security. But if this trend of massive exports of IT jobs overseas continues, I am not sure how many of us will be able to have that. BTW, before firing the slingshots at this E-mail, please note that I am pro-globalization and have heard the arguments about fair market/competition etc. But bear in mind that we are standing on uneven grounds when competing with third world programmers because of the huge housing and living expense differences. Dennis Meng Database Administrator Focal Communications Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: How to use pipe-delimited SQL*Plus output with a long
Title: RE: How to use pipe-delimited SQL*Plus output with a long datatype Cherie, Did you try a set long to some value to see if that would work? set long 2000 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 9:23 AM To: Multiple recipients of list ORACLE-L Subject: How to use pipe-delimited SQL*Plus output with a long datatype One of our developers wants to create a reusable report where the pipe-delimited output generated by SQL*Plus would be sent off and used as input into another process. The problem is the remarks field which is of type long. It causes ORA-00997 errors. If I take the pipe-delimits off, the report works o.k. If I take the remarks field out, the report works o.k. There seems to be an incompatibility between the two. The developer wants to have the remarks column included in the report and she also wants the fields to be delimited somehow. I saw an informative document on Metalink about the ORA-997 error but there is no work-around suggested. Does anyone have any bright ideas? It is not possible to convert the long within the database, at this time. This database will be obsolete in a few months so it's not worth the hassle to recode all of the apps that use this field. 1 select /*+ USE_NL(CCD,CCDX,ERLI,ERH) */ ar.acct_no || '|' || 2 ar.intl_rep_no || '|' || 3 ar.rep_id || '|' || 4 cr.last_name || '|' || 5 cr.first_name || '|' || 6 erh.cnfr_no || '|' || 7 erli.line_item_amt || '|' || 8 erli.line_item_dt || '|' || 9 erli.line_seq_no || '|' || 10 ccd.merch_name || '|' || 11 erh.remarks 12 from acct_rep ar, 13 client_rep cr, 14 exp_rpt_hdr erh, 15 exp_rpt_line_item erli, 16 chrg_card_dtl_xref ccdx, 17 chrg_card_dtl ccd 18 where '49368' = erh.acct_no 19 and ccd.intl_rep_no = erh.intl_rep_no 20 AND cr.clnt_no = ar.clnt_no 21 AND cr.intl_rep_no = ar.intl_rep_no 22 AND erh.intl_rep_no = cr.intl_rep_no 23 AND erh.acct_no = ar.acct_no 24 AND erh.intl_rep_no = ar.intl_rep_no 25 AND erh.cnfr_no = erli.cnfr_no 26 and trunc(erh.submit_dt) trunc(sysdate - 25) 27 AND '810' = erli.pay_seq_no 28 AND ccdx.cnfr_no (+) = erli.cnfr_no 29 AND ccdx.line_seq_no (+) = erli.line_seq_no 30 AND ccdx.cnfr_No is null 31 AND ar.acct_no = '49368' 32 AND ccd.acct_no = '49368' 33 AND ccd.trans_dt = erli.line_item_dt 34* AND ccd.posted_amt = erli.line_item_amt SQL / erh.remarks * ERROR at line 11: ORA-00997: illegal use of LONG datatype Thanks for any advice. Cherie Machler Oracle DBA Gelco Information Network -- 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: Permissions on user trace files
Title: RE: Permissions on user trace files Jay, Use the _trace_files_public=true in the init.ora file. FYI This opens the door for dumps of data that is sensitive. -Original Message- From: Miller, Jay [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 05, 2002 3:55 PM To: Multiple recipients of list ORACLE-L Subject: Permissions on user trace files Hi all, User Trace files are currently created as -rw-r- Is there an easy way to change the permissions when they are created to -rw-r--r-- The developers would like to be able to run Sql Trace on queries on the development box and then run tkprof on the resulting file. I'm perfectly happy giving them permission to do so, since it means I won't need to run it for them several times a day. I'm on Solaris 2.6, Oracle 8.1.7.2 TIA, Jay Miller -- 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: QUESTION 32 BIT or 64 BIT
Title: RE: QUESTION 32 BIT or 64 BIT Hamid, file $ORACLE_HOME/bin/oracle You should receive something like ELF 32-bit MSB executable SPARC Version1, dynamically linked not stripped. -Original Message- From: Hamid Alavi [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Subject: QUESTION 32 BIT or 64 BIT Hi List, Which command I have to run to findout Installed oracle running under 32 bit or 64 bit??? Oracle 8.1.7.0 or 8.1.6.2 my OS sun solaris, running under 64 bit now Thanks Hamid Alavi Office 818 737-0526 Cell 818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Installing oracle 9.0.1 on Sparc
Title: RE: Installing oracle 9.0.1 on Sparc Natalia, Check your operating system version. Version 2.6 or 5.6 is required. -Original Message- From: Natalia Laracca [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 4:18 PM To: Multiple recipients of list ORACLE-L Subject: Installing oracle 9.0.1 on Sparc Hi, I have a problem when I am installing oracle 9.0.1 on Sparc: give me the error: not can create..ins_net_client.mk... not can create..ins_net_server.mk...etc After when I want to connect with SQLPLUS: give me sqlplus: cannot execute Some idea? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Natalia Laracca INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Problem in Dropping a MV : ORA-07445: exception
Title: RE: Problem in Dropping a MV : ORA-07445: exception encountered: co Try to drop the materialized view log first. Also are you dropping the materialized view as the object owner? -Original Message- From: Reddy, Madhusudana [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 4:04 PM To: Multiple recipients of list ORACLE-L Subject: Problem in Dropping a MV : ORA-07445: exception encountered: co Hello ALL, I am having a problem in dropping an un-used Materialized view and getting the following error when I am trying to drop ORA-07445: exception encountered: core dump [kkzmtab()+76] [SIGSEGV] [Address not mapped to object] [588] [] [] I have found in metalink that it was a bug in 8.1.6 and is fixed in 8.1.7 My DB is running on 8.1.7.2 But still I am unable to drop the MV , any ideas ??? Thanks in advance, Madhu V Reddy Database Support Services -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: AUDIT_ACTIONS
Title: RE: AUDIT_ACTIONS Below explanation from Metalink. If something is being audited by session, then there are four values that determine if the same record is updated or a new record is inserted. Two of these values are the session id and the object id of the object the action is against. The third value is the constant action code 103 - this is used to show that this is a session record. The final value is the privs used. This has to match with the record already in the audit trail - i.e. if it is null, then the existing record must also be null. If it is non-null, then the existing record must have the same non-null value. So, assuming the privs remain the same, all actions on one object go into one record. This includes insert, update, delete etc. Hence we can now see why the action name can't be anything other than SESSION REC as the record has to represent all the actions possible on the object. -Original Message- From: Suzy Vordos [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 1:49 PM To: Multiple recipients of list ORACLE-L Subject: Re: AUDIT_ACTIONS select * from audit_actions where action=103; shows SESSION REC but not sure what that means Charlie Mengler wrote: 103 SESSION REC I see entries in one of my AUD$ tables with a ACTION = 103 I'd like to know exactly what this action references. I've searched my 8i online doc set but got no hits. I'm willing to RTFM is somebody will point me at which FM I should use in this case. TIA HAND! -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Am I sure? Of course I'm sure. I could be wrong, but I'm sure for now! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Cronjob
Title: RE: Cronjob A wrong keystroke could blow away the entire crontab file by accident. %:| -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Cronjob crontab -e is bad! 1000 points if you can figure out why. ( guess I'm watching too much 'Whose Line Is It Anyway? ) Jared Alex [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/24/2002 10:07 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: Re: Cronjob crontab -e On Wed, 24 Apr 2002, bill thater wrote: [EMAIL PROTECTED] wrote: Anyone whom can tell me how to delete a job that is created by crontab. Thanks in advance Roland man crontab -- -- Bill Shrek Thater ORACLE DBA [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. Your e-mail has been returned due to insufficient voltage. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
Question: system tablespace fragmentation.
I granted select on table to a user. This permission already existed in the database. The sql statement returned a Grant succeeded. I've read the fine manual and couldn't find any informationabout regranting a permission that already existed, so I ran a trace and the results are below: It appears to me Oracle just updates the objauth$ without checking if a permission already exists. This shouldn't (should it) cause fragmentation in the system tablespace since it updates an existing record with the same information. grant select on contract update obj$ set obj#=:6,type#=:7,ctime=:8,mtime=:9,stime=:10,status=:11, dataobj#=:13,flags=:14,oid$=:15 whereowner#=:1 and name=:2 and namespace=:3 and(remoteowner=:4 or remoteowner is null and :4 is null)and(linkname=:5 or linkname is null and :5 is null) and(subname=:12 or subname is null and :12 is null) call count cpu elapsed disk query current rows--- -- -- -- -- -- --Parse 1 0.00 0.00 0 0 0 0Execute 1 0.01 0.01 0 2 1 1Fetch 0 0.00 0.00 0 0 0 0--- -- -- -- -- -- --total 2 0.01 0.01 0 2 1 1 Misses in library cache during parse: 1Misses in library cache during execute: 1Optimizer goal: CHOOSEParsing user id: SYS (recursive depth: 1) Rows Row Source Operation--- --- 1 UPDATE OBJ$ 2 INDEX RANGE SCAN (object id 34) update objauth$ set option$=decode(option$,null,decode(:1,0,null,:1),option$)wheregrantor#=:2 and obj#=:3 and privilege#=:4 and grantee#=:5 and nvl(col#,0)=:6 call count cpu elapsed disk query current rows--- -- -- -- -- -- --Parse 1 0.01 0.01 0 0 0 0Execute 1 0.00 0.00 0 2 2 1Fetch 0 0.00 0.00 0 0 0 0--- -- -- -- -- -- --total 2 0.01 0.01 0 2 2 1 Misses in library cache during parse: 1Misses in library cache during execute: 1Optimizer goal: CHOOSEParsing user id: SYS (recursive depth: 1) Rows Row Source Operation--- --- 1 UPDATE OBJAUTH$ 2 INDEX RANGE SCAN (object id 100)
RE: No DBAs needed on AS400
Title: RE: No DBAs needed on AS400 Comments were made that DB2 and AS400s are not open. Does this mean that you couldn't write a client/server program to access data on DB2 (say using C++ from Windows 2000)? RUMBA/400 formerly pc support connects to the AS400 from a windows pc. Last I knew, the AS400 data need to be converted from EBCDIC into the wrkdoc area for ASCII in order for Rumba/400 to work with it correctly. -Original Message- From: Jay Hostetter [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 2:51 PM To: Multiple recipients of list ORACLE-L Subject: RE: No DBAs needed on AS400 Thank you for all the replies that I have received. It sounds like a version of DB2 comes along with the OS, or a full fledged version of DB2 can be installed. From what I have heard about their AS400 system, they can access their files directly - without going through a database. This reminds me of my COBOL days on VMS. It sounds like DB2 can be configured to use files, which would mean that you could either update the file directly or go through DB2 - is this correct? I can also make another VMS relation here - we had a tool called DataTrieve which you could configure to use regular files. You could then issue SQL like statements through DataTrieve against your files. Is DB2 like this? Somebody needed to configure DataTrieve before it could reference a file - what about DB2? Unless they never changed/added files on the AS400. Comments were made that DB2 and AS400s are not open. Does this mean that you couldn't write a client/server program to access data on DB2 (say using C++ from Windows 2000)? I'm off to find on-line docs... Answers to some questions: Does it have DB2 as the database? He didn't say that it was running DB2. If you are performing queries from Oracle to DB2 (SQL Queries), that is being performed through Oracle's gateway product. We are not doing this. [EMAIL PROTECTED] 04/11/02 10:44AM Jay - I can see the manager's confusion. After all, one expects computers to become easier and require less effort to maintain as time goes by. I forwarded your question to another list that has some AS/400 programmers. -- On the AS400 you can run queries and use SQL even though the machine is configured to use files. Under the covers it is still AS400/DB2. -- The AS/400 has a full-featured database built into the operating system. Originally it didn't even have a name but IBM started calling it DB2/400 when they found out that some people didn't know it was there. And you don't need a DBA. Virtually all the functions that are performed by a DBA on an Oracle database, for example, are handled automatically by the AS/400 under the covers. -- Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: EXTENTS?
Title: RE: EXTENTS? The Server Concepts manual Chapter on Data Blocks, Extents, and Segments would be a helpful Chapter to read. -Original Message- From: Kevin Lange [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 1:28 PM To: Multiple recipients of list ORACLE-L Subject: RE: EXTENTS? Depends on your extent size -Original Message- Sent: Monday, March 04, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Hi If DB block size is 8k then how many extents in one db block? Thanks -Seema _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Control file sequential read
Title: Control file sequential read Listers, On development I truncated a fairly large partitioned table, inserted the data from production via a db_link and then built partitioned indexes on the table. I was watching the v$session_waits for the session and noticed several sets of control file sequential reads during the index builds. I checked what file 2 was against the dba_data_files and it was showing rollback tablespace. Is this due to delayed block cleanout? SID SEQ# EVENT - - P1TEXT P1 P1RAW - P2TEXT P2 P2RAW - P3TEXT P3 P3RAW WAIT_TIME - - SECONDS_IN_WAIT STATE --- --- 12 10086 control file sequential read file# 2 0002 block# 1 0001 blocks 1 0001 -1 0 WAITED SHORT TIME FILE_NAME FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS RELATIVE_FNO AUT MAXBYTES - -- - - - --- - MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS - -- --- /u03/oradata/FDWD/rbs01.dbf 2 RBS 630194176 76928 AVAILABLE 2 NO 0 0 0 630185984 76927
RE: PLEASE HELP WITH STATEMENT.
Title: RE: PLEASE HELP WITH STATEMENT. Lance, Use the in_tab_name not the table you want to truncate. You specify table to truncate when you call the procedure. See example below using PLAN_TABLE as the table to truncate. 1 CREATE OR REPLACE procedure primus_temp_dump_test(in_tab_name in varchar2) 2 as 3 cursor_id integer; 4 execute_return_value integer; 5 last_function_code integer; 6 Begin 7 cursor_id := dbms_sql.open_cursor; 8 dbms_sql.parse (cursor_id,'TRUNCATE TABLE '||in_tab_name,dbms_sql.v7); 9 execute_return_value := dbms_sql.execute(cursor_id); 10 last_function_code := dbms_sql.last_sql_function_code; 11 dbms_sql.close_cursor(cursor_id); 12* End; SQL / Procedure created. SQL exec primus_temp_dump_test('PLAN_TABLE'); PL/SQL procedure successfully completed. SQL select count(*) from plan_table; COUNT(*) - 0 -Original Message- From: Lance Prais [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 7:38 PM To: Multiple recipients of list ORACLE-L Subject: PLEASE HELP WITH STATEMENT. I am using the following statement in Oracle 8.0.6 and getting an error I and I do not understand why it is giving it to me. CODE: CREATE OR REPLACE procedure primus_temp_dump_test(in_tab_name in varchar2) as cursor_id integer; execute_return_value integer; last_function_code integer; Begin cursor_id := dbms_sql.open_cursor; dbms_sql.parse (cursor_id,'TRUNCATE TABLE '||UPPER(PRIMUS_TEMP_DUMP),dbms_sql.v7); execute_return_value := dbms_sql.execute(cursor_id); last_function_code := dbms_sql.last_sql_function_code; dbms_sql.close_cursor(cursor_id); End; / Error: * ERROR at line 1: ORA-06550: line 1, column 29: PLS-00357: Table,View Or Sequence reference 'PRIMUS_TEMP_DUMP' not allowed in this context ORA-06550: line 1, column 7: PL/SQL: Statement ignored Thank you in advance. Lance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lance Prais INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Database Performance Question
Title: RE: Database Performance Question Partitions, Materialized views, bit map indexes. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 10:25 AM To: Multiple recipients of list ORACLE-L Subject: Database Performance Question Hello all: We have an application that is having slow response time against an 8i database, I would like to improve the response time. This is a web based application accessing the database with about 2000 users. Most of the application queries are based on complex joins on 4 big tables with each having over 5 million rows( biggest table has 18 million rows). I have tuned the Package queries for the best explain plan possible, but still do not seem to make dramatic change in the response time. Though, I was able to make significant headway tuning these packages by bringing down response times from 7 minutes to under 3 minutes. But this is not an acceptable response time from a web-application perspective. I am considering creating data cubes based on the most frequently used join conditions and pre-populate them on a nightly basis or use triggers to update the cube simultaneously. I am hoping that this enhance the response times. I would greatly appreciate your suggestions or opinions on this idea. If you have an alternative/better way of achiving this please enlighten me. Thank very much. Srini Rajendran. -- 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: SMON - Does it cause a degrade?
Title: RE: SMON - Does it cause a degrade? Check out meta link note:61997.1 SMON - Temporary Segment Cleanup and Free Space Coalescing. For one explanation. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 4:50 PM To: Multiple recipients of list ORACLE-L Subject: SMON - Does it cause a degrade? Hey Fellas, I have an application DBA who insists that the pctincrease at the data tablespace should be set to 0 so that SMON does not coalesce the tablespace. He says coalesce will be performed by using a scheduled batch job written for that purpose. He states that having SMON to perform an coalesce of the tablespace could cause an performance degrade??? I have never heard of such a thing, but then I dont wanna argue with him. He's got wrinkles on his face, and grey hair ;-) My argument would be, go back to the drawing board, get your tables sized properly, if you anticipate fragmentation. And SMON does not cause a performance degrade? It wakes up every 5 minutes, does hold ST enqueue locks if a tablespace needs coalescing, but it does not cause a performance degrade? Or does it??? Now, can I have a definitive word on this? Any sites, white papers, to refer to that says so, or to the contrary. I need to convince the higher ups. Raj -- 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).
Upgrade question
List, I plan to upgrade to 9.0.1 soon, and looking through the documentation it is not clear to me whether the 9.0.1 listener needs to be running prior to the upgrade migration utility or not. My thinking is it should be running and tested prior to the upgrade. TIA M.Godlewski
RE: HOW TO MAKE DELETION FAST
Title: RE: HOW TO MAKE DELETION FAST If you have indexes on the table you may want to drop prior to delete and rebuild them after it completes. Does this table have foreign key constraints? Rowid is the fastest data access method. Create a interim table of the rowids for the rows you want deleted and delete from table where rowid in interim table rowid column. You may want to lock the table if you are worried about row migration. -Original Message- Sent: Thursday, December 27, 2001 3:00 PM To: Multiple recipients of list ORACLE-L Hi Gurus How to make deletetion of millions rows faster? Please suggest. Thx Seema _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 install.
Title: 9i install. Is your classpath set? -Original Message-From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 11, 2001 3:45 PMTo: Multiple recipients of list ORACLE-LSubject: RE: 9i install. I hate Java! -Original Message-From: Yuval Arnon [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 11, 2001 2:20 PMTo: Multiple recipients of list ORACLE-LSubject: 9i install. Hi, I am trying to run dbca (the new name for dbassist) on Sun Solaris 2.7 and I get the following java.lang.NoClassDefFoundError: org/omg/CORBA/UserException at oracle.sysman.emSDK.common.registry.PropertiesFileRegistry.get(Proper tiesFileRegistry.java:44) at oracle.sysman.vtx.vtxOemApp.OemJavaLauncher.launch(OemJavaLauncher.ja va:161) at oracle.sysman.vtx.vtxOemApp.OemApp.launch(OemApp.java:222) at oracle.sysman.vtx.vtxOemApp.OemApp.main(OemApp.java:80) Exception in thread "main" wwf2:test9i /export/home/oracle/app/oracle/product/9. 0.1/bin$ ./dbca java.lang.NoClassDefFoundError: com/inprise/vbroker/CORBA/Object at oracle.sysman.assistants.dbca.backend.Host.init(Compiled Code) at oracle.sysman.assistants.dbca.ui.UIHost.init(Compiled Code) at oracle.sysman.assistants.dbca.ui.InteractiveHost.init(Compiled Code ) at oracle.sysman.assistants.dbca.Dbca.getHost(Compiled Code) at oracle.sysman.assistants.dbca.Dbca.execute(Compiled Code) at oracle.sysman.assistants.dbca.Dbca.main(Compiled Code) Exception in thread "main" wwf2:test9i /export/home/oracle/app/oracle/product/9. trying to re-install Oracle did not help. Nor metalink. Thanks. Yuval.
RE: Cannot Drop Column
Title: RE: Cannot Drop Column Why not create newtable as select columns wanted from oldtable, then add your column. Drop old table rename new table to old table if desired. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, December 07, 2001 4:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: Cannot Drop Column Ron, You should read the whole thread. ;) Jared Ron Rogers RROGERS@galot To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] tery.org cc: Sent by: Subject: RE: Cannot Drop Column [EMAIL PROTECTED] om 12/07/01 12:05 PM Please respond to ORACLE-L Oracle 8i ALTER TABLE name DROP COLUMN name; ROR mô¿ôm [EMAIL PROTECTED] 12/07/01 02:25PM Ken, Just add the column with the correct name, and leave the other one alone. You could create a check constraint to make sure it isn't used. Better yet, create a real account and don't use SYS or SYSTEM, as that is never a good idea. As you've already discovered, it really isn't all that convenient. ;) Jared Ken Janusz ken.janusz@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.com cc: Sent by: Subject: RE: Cannot Drop Column [EMAIL PROTECTED] om 12/07/01 09:50 AM Please respond to ORACLE-L Dave: I am working on a database to do a DB conversion from IMS to 8.1.7. It is only being used to load the data for the conversion process. No application software will be connected to it. So, for convenience I am doing everything as SYS. I am the only person using this DB on a dedicated W2000 server. I accidentally added this column by the wrong name, so I want to delete the column so I can add the column with the correct name. I would change the name of the column but I have not found any syntax to do this. Thanks, Ken -Original Message- Sent: Friday, December 07, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Ken, I rarely log into any of my databases as SYS - too much mischief can be made (and I'm just the fumble-fingered guy to make it). There are very few columns owned by SYS. Most of these are in tables designed to support the database. You need to be REAL careful. Could be that the table you're in is currently in use by virtue of the fact you're logged in as SYS. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Ken Janusz ken.janusz@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.com cc: Sent by: Subject: Cannot Drop Column [EMAIL PROTECTED] om 12/07/2001 10:05 AM Please respond to ORACLE-L 8.1.7 logged in as SYS. Will not let me drop a column because it belongs to SYS. If I am logged in as SYS why can't I drop a column owned by SYS? Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet
RE: 8i or 9i for Data Warehouse
Oracle 9i has more data warehouse functionality. ETL with external tables is beneficial depending on your data transformation requirements. If your using the star schema. Bit mapped indexes on the fact tables for each dimension could really increase your performance with either version 8i or 9i. -Original Message- Sent: Tuesday, October 30, 2001 3:05 PM To: Multiple recipients of list ORACLE-L Hi everyone - I have been asked to do the database planning for a fairly large data warehouse. The warehouse is currently in Sybase and is about 160 GB. They are planning to move to Oracle very soon. My questions - does it make more sense to spin it up on 8.1.7 or 9? (This will be a pretty good size Solaris machine). Are there newer features in 9i that would really benefit them? I am looking at partitioning tables and using some bit-mapped indexes - something they don't have today. I was originally looking at 8.1.7, but now that 9 has been around for a little bit, I'm wondering if any of you have some advice (good or bad) regarding version 9. Any and all comments are appreciated. Thanks - lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Godlewski, Melissa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Undo x Rollback Segments in 9i
/ Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Godlewski, Melissa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: CLOB trigger problem
Is the transaction committed by the client prior to your using the CLOB PL/SQL? -Original Message- Sent: Wednesday, September 19, 2001 2:15 AM To: Multiple recipients of list ORACLE-L Dear listers, I am trying to copy an updated CLOB from a table in one database (let's call it A) to the equivalent table in another database (called B just to be original). I have written triggers and procedures to do this (one package on each database), and I am passing the contents of the CLOB to the remote update procedure as VARCHAR fields in a PL/SQL table. Everything works perfectly well when I run an update against table A. I am connecting via TOAD and am logged on to Oracle as the schema owner. The contents of the CLOB are retrieved, passed across and used to update the remote table. When the client updates the CLOB in table A, however, the select statement in my package on database A which 'locates' the CLOB, retrieves a CLOB of zero length. No exception occurs in the Select statement. The client's update succeeds on table A, and my package sends an empty PL/SQL table to the remote procedure (and the CLOB on the remote table is duly erased). The client is connecting through an ASP-driven web interface via IIS, which as far as I can tell is also logging on to Oracle as the schema owner. Anyone encountered this sort of behaviour before? I've just about run out of ideas. If I can't solve this by direct means I can probably do something kludgy like launch the remote update as a background process via DBMS_JOB.SUBMIT, but I'd far rather have it under transactional control. Oracle version is 8.1.6.3 on both databases. Can supply contents of triggers etc. if needed. Cheers, James Campbell [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Campbell, James INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Godlewski, Melissa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).