char vs. varchar in a data warehouse
Hi - We are in the process of building a data warehouse and data stores. This will be built on a Sun Solaris (2.8) machine running Oracle 9i R1. Estimates are approximately 180GB. The developers have defined most of their small character fields as varchar2 - even the ones of size 1! They tell me that if the column does not have a value, they do not want to have to deal with a 'space' when manipulating that value. Does this make sense? Should I be pursuing this further or shouldn't I care as the DBA? 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).
64-bit OS
Hi - We have just installed Solaris 2.8 (8) on a new SUN server. Is there a command I can run to tell if it's running in 64-bit mode? If I'm building a database for a homegrown Oracle data warehouse - would it be best to run 64-bit Oracle? 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).
RE: Oracle AQ & MQ Series
Title: RE: Oracle AQ & MQ Series Waleed - I tried implementing AQ to MQ with the MEssaging Gateway. I could not find anyone at Oracle to support it. When I would open a TAR, the analyst would come back and say 'this is not an Oracle product'. I finally got it escalated to the point that I was talking to the developer of the Messaging Gateway component. He helped me get it running, but after all the hassle, we went back and told our application group that we could not support the use of AQ in this situation. Hopefully, the product will mature and it can be useable someday. Lisa -Original Message-From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 19, 2002 6:03 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle AQ & MQ Series Thanks for the reply. I think what we need is: the Messaging Gateway. I saw this yesterday and was not sure. So opened a TAR where Oracle support told me they can not find anything related to my issue! Here is a link: http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/appdev.920/a96587/mgw.htm Thanks Waleed -Original Message-From: Aponte, Tony [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 19, 2002 5:30 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle AQ & MQ Series Oracle provides an AQ-to-MQ gateway as part of the Integration Server ($). IBM provides a PL/SQL gateway for free (but implemented as an external procedure) which can be used to create your own bridge between the 2 messaging systems. The support pack can be found at http://www-3.ibm.com/software/ts/mqseries/txppacs/ma0i.html. HTH Tony Aponte -Original Message- From: Khedr, Waleed [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 19, 2002 4:22 PM To: Multiple recipients of list ORACLE-L Subject: Oracle AQ & MQ Series I have an application (informatica) that can read/write to MQ Series. We want the tool to be able to read/write to Oracle AQ. Do you know of any product that could act as a listener for Oracle AQ to provide an interface layer that act similar to MQ Series so that these applications that work with MQ could work directly with Oracle AQ? Thanks Waleed -- 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).
sqlplus and substr command
Title: sqlplus and substr command Hi - Can someone tell me if sqlplus functionality has changed between version 8.1.5 and 8.1.7 (on Sun Solaris)? I have a couple of queries that used the substr function on some longer columns. When I run it against my 8.1.5 database, the substr works fine. It appears to be ignored when I run the same query against my 8.1.7 database. How do I get around this? If I define a fixed-length column, will that do it? Thanks for any assistance you can give me - Lisa
RE: Diffs in SQL*Plus formatting between 8/8i
Title: RE: Diffs in SQL*Plus formatting between 8/8i I noticed this same difference between versions 8.1.5 and 8.1.7. In 8.1.5, the substr() function (ie. select substr(column1,1,10) works just fine.but in 8.1.7 it seems to be ignored. Defining the column seems to take care of it. Lisa -- From: Jesse, Rich To: Multiple recipients of list ORACLE-L Subject: Diffs in SQL*Plus formatting between 8/8i Date: Thursday, August 16, 2001 5:43PM Hey all, One other slightly puzzling, erm, puzzle. The default column format seems to have changed between 8.0.6 and 8.1.7 in SQL*Plus, but I can't seem to figure out what it is or find any mention of it in any Oracle doc. We aren't using any "login.sql" files. It doesn't really bug me because it forces an explicit "COLUMN" statement, which I'm all in favor of for production SQL*Plus scripts, but I'm curious as to what changed. I purposely didn't include an example in the hopes that it's not just me... Anyone? TIA, Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle license costs
Title: Oracle license costs Hi - I'm sorry to bring this up again - I know it was discussed fairly recently .. Where can I find information on Oracle's new pricing structure? We are looking for additional licenses to run on a new Sun Solaris machine. I seem to remember that license costs were related directly to number of CPUs(?) If someone can point me to a web url for this information, I would greatly appreciate it. Thank you - Lisa
ksqsttyp in x$ksqst
Title: ksqsttyp in x$ksqst Hi - Where can I find out what the values mean in the ksqsttyp column on the x$ksqst table? I am having some waits associated with the value "CF", but I don't know what that means. If anyone can help, I'd greatly appreciate it. Lisa
Import of sequences
Title: Import of sequences Hi - I have inherited an application and I'm trying to clean it up. I have received an export from the current database (to which I have no access). Everything was built as user SYSTEM. I can import all the tables and data onto a new server by listing all the tables in a parameter file. The problem I'm having is trying to import the sequences. Does anyone know a way to import sequences (without doing a full import)? Am I better off just listing the export file and creating the sequences myself? Thanks for any and all help - Lisa
Multiple instances - Sun Solaris
Hi - We are running a solaris server (2.6) for our develoment environment. We currently have 5 instances on the server. When we create another instance and try to start it, we get a ORA-27101: shared memory realm does not exist. The text reads 'Unable to locate shared meory realm'. We have set the following kernal parameters to what we believe to be appropriate. SHMMAX=1207959552 SHMMIN=1 SHMSEG=10 SEMMNI=100 SEMMSL=350 SEMMNS =1000 SEMOPM =100 SEMVMX=32767 Does anyone know of any other kernal parameter settings that may be causing this error? 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).
32-bit Oracle on 64-bit Unix
Hi - We are about to upgrade a Unix box (Sun Solaris) to version 8 (2.8). Someone mentioned that we can't run the 64-bit version because that would require the 64-bit version of Oracle. I thought that you could run the 32-bit version of Oracle on a 64-bit operating system. Am I wrong? 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).
BMC Patrol DBXray / CA Unicenter
Hi - Does anyone have experience with either of these products? I'm interested in ease of installation, ease of use, and quality of support. I realize they are both pricey, but they both seem to do a lot. I've been asked to look at alternatives (I'm sure the cost will be prohibitive, but we'll see). Also if you know of any comparable tools, I'm very interested to hear about them. Thanks much - 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).
RE: BMC Patrol DBXray / CA Unicenter
Title: RE: BMC Patrol DBXray / CA Unicenter That's the kind of .02 I'm looking for. I don't need any more nightmares .was it bad from an installation perspective or usage? thanks! -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 04, 2001 2:49 PMTo: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'Subject: RE: BMC Patrol DBXray / CA Unicenter Hi Lisa, CA Unicenter has been a source of many nightmares and sleepless nights in the past for me. I was very glad when I quit that job... Just my .02 Lisa Koivu Certified Monkey Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: YTTRI Lisa [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, December 04, 2001 3:25 PM To: Multiple recipients of list ORACLE-L Subject: BMC Patrol DBXray / CA Unicenter Hi - Does anyone have experience with either of these products? I'm interested in ease of installation, ease of use, and quality of support. I realize they are both pricey, but they both seem to do a lot. I've been asked to look at alternatives (I'm sure the cost will be prohibitive, but we'll see). Also if you know of any comparable tools, I'm very interested to hear about them. Thanks much - 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).
RE: BMC Patrol DBXray / CA Unicenter
Ideally, we'd like to find a common tool to monitor Oracle, Sybase and SQL Server databases running on both NT and Unix platforms. There are separate groups that are responsible for NT support and Unix support. If we could all use the same tool, we'd be delighted, but if not, then one tool for all databases would be our next choice. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 04, 2001 3:15 PM To: Multiple recipients of list ORACLE-L Lisa, What are you trying to monitor - just Oracle databases, the OS as well (if so which OS) and anything else? We use the Watchdog functionality (part of CA Unicenter) to monitor our VMS servers (where we don't run Oracle) and it good for that. It depends on what you are trying to achieve. HTH, Bruce Reardon -Original Message- Sent: Wednesday, 5 December 2001 7:25 Hi - Does anyone have experience with either of these products? I'm interested in ease of installation, ease of use, and quality of support. I realize they are both pricey, but they both seem to do a lot. I've been asked to look at alternatives (I'm sure the cost will be prohibitive, but we'll see). Also if you know of any comparable tools, I'm very interested to hear about them. Thanks much - Lisa -- 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). -- 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).
RE: BMC Patrol DBXray / CA Unicenter
We are using OEM currently on our Oracle environments. However, we have about 100 Sybase servers and about 10 Microsoft SQL Server servers in addition to the 20 or so Oracle instances we have. There are only 6 of us supporting all these environments, and not everybody is knowledgeable in all the dbms'. What we'd like to get is a proactive monitoring tool that can be used for all of our databases. If I could get OEM to monitor the others, I would! -Original Message- Sent: Wednesday, December 05, 2001 7:35 PM To: Multiple recipients of list ORACLE-L I have evaluated I/Watch and it was pretty good. Especially with Spotlight. I have actually seen Spotlight help me quickly identify a problem which I am not sure I could have found so easily with out the visual picture. I had both tools for about 3 months but could not get anyone to agree to the bucks. Depending on what you are looking for out of OEM it really is not a bad tool. It is the one that is the least intrusive on your servers and you need not create objects in your database for it. Thing I learned though is to make sure you set up warnings for email and not page. Really annoying when you get paged at 3AM cause a tablespace is 80% full. Ya, so, tell me tomorrow. Make sure you do not have alert log monitoring on for development systems. If you do you may be tempted to kill your developers. It might not be the best tool out there but if you work with the right versions of Oracle and use the OEM agents for 8.1.7 or 9i its pretty good. It does not have those problems of not being able to deregister and all that fun stuff that existing in 8. Don't forget that the agents do not have be the same version as the database. -Original Message- WILLIAMS Sent: Wednesday, December 05, 2001 8:20 AM To: Multiple recipients of list ORACLE-L I appreciate everyone sharing their experiences. My question on this topic is what tools are appropriate for what environments? Some tools seem more extensive (and expensive) and therefore appropriate to sites with many Oracle instances. I am currently responsible for 5 production instances all at our HQ datacenter. On those rare occasions when something goes down, some usually quickly contacts me, so I haven't felt the need for a monitoring tool. However, we are discussing a project to put servers in a handful of manufacturing plants and they would be more 23x7 situations, so I have been reviewing OEM (it fails a lot more often than the instance, I'm not about to turn on its remote notification). Naturally vendors will claim that their product is just ideal for your type of site. Does anyone have any input on which monitoring tools are appropriate for sites with a smaller number of Oracle instances? Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 05, 2001 6:40 AM To: Multiple recipients of list ORACLE-L I second that, too long to list the problems I had w/ CA Unicenter, worthless expensive product. CA touts their product to top management, then you get the call to implement. Just my $.02, since you asked :) Gene >>> [EMAIL PROTECTED] 12/04/01 08:35PM >>> CA Unicenter sucks, CA support sucks. CA sucks. Stay away. -Original Message- Sent: Tuesday, December 04, 2001 12:25 PM To: Multiple recipients of list ORACLE-L Hi - Does anyone have experience with either of these products? I'm interested in ease of installation, ease of use, and quality of support. I realize they are both pricey, but they both seem to do a lot. I've been asked to look at alternatives (I'm sure the cost will be prohibitive, but we'll see). Also if you know of any comparable tools, I'm very interested to hear about them. Thanks much - 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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, inclu
RE: BMC Patrol DBXray / CA Unicenter
We use some of those, too. DBArtisan is primarily used by the Sybase and SQL Server DBAs. It has a couple of quirks when connected to Oracle. ER/Studio is our modelling tool, and we're looking at Change Manager for source control. We have inquired about Performance Center, but it is still pretty new. For the money though, they do prove to be very useful. Lisa -Original Message- Sent: Thursday, December 06, 2001 2:30 PM To: Multiple recipients of list ORACLE-L Embarcadero products? -Original Message- Sent: Thursday, December 06, 2001 2:40 PM To: Multiple recipients of list ORACLE-L We are using OEM currently on our Oracle environments. However, we have about 100 Sybase servers and about 10 Microsoft SQL Server servers in addition to the 20 or so Oracle instances we have. There are only 6 of us supporting all these environments, and not everybody is knowledgeable in all the dbms'. What we'd like to get is a proactive monitoring tool that can be used for all of our databases. -- 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: 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).
8.0.5 to 8.1.7 - export/import
Hi - I believe I can do this, but I would like some confirmation and or warnings, etc. We are migrating an application from 8.0.5 on NT to 8.1.7 on Unix (Solaris 2.6). I would like to do this by creating the 8.1.7 instance and then importing the data. Is it possible to export from the NT database (using the 8.0.5 exp command) and then import into the 8.1.7 database on Unix (using the 8.1.7 imp command)? Thank you- 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).
Number of CPUs vs. Speed of CPUs
We are in the process of sizing a new server for multiple Oracle instances. What factors are useful as input in determining how many CPUs and the relative speed of them? For example, do we want fewer, faster CPUs or do we want more, slower CPUs? Are there any good guidelines to determine what the number of CPUs should be? Thanks in advance - 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).
Donald Burleson
Hi - Does anyone know if Donald Burleson has a website? If so, do you have the url? Has anyone read his book 9i Unix Administration Handbook? comments please... 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).
char vs. varchar2
Is there any overhead (ie. internal conversion) in comparing a char to a varchar2? We found an instance where a primary key in one table is defined as char(2) and the foreign key referencing it from another table is varchar2(2). We are going to change it, but I'm curious what, if anything, happens when resolving the integrity? 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).
RE: Oracle Messaging Gateway
I have installed it. I got the code and the documentation via a tar. They then placed it all on their ftp site. I also had to upgrade to 9.0.1.2. -Original Message- Sent: Monday, April 29, 2002 5:38 AM To: Multiple recipients of list ORACLE-L Hi All, Is there anybody among you who has installed and configured Oracle Messaging Gateway and if so, could you please tell me where I can get the guidelines for the same ?? Any help would b greatly appreciated. Thanks and Regards, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).
CA's Data Dictionary for Oracle v9i Poster
http://ca.com/products/posters/oraclev9i_poster_form.htm 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).
Upgrade and it says it doesn't need it
HI - I'm trying to upgrade my database from 9.0.1.0 to 9.0.1.2 (Sun Solaris). The installer tells me there are no files that need to be applied. When I click on installed products, under 9i it only show the client install, not the enterprise edition server. Does anyone know what I can do to get the installer to realize that I do have the server installed? Thank you - 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).
AQ using a trigger?
Does anyone have experience with AQ tables? I would like to put a trigger on my AQ table so that when a message comes in, it will automatically fire off a job to dequeue the message. I opened a TAR and was told that I can put a trigger on the table, but it's not recommended. When I asked why, they said 'it just wasn't recommended'. I'm curious if anyone actually knows why I shouldn't or if I really can. It really seems to be a slick way to handle the messages, but if it will cause problems, I'd like to know that upfront. Thank you - 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).
RE: Upgrade and it says it doesn't need it
Unfortunately - this is what I'm having a problem with. I did install with OUI. The log files from that installation are in the "oraInventory" directory. Subsequently, I installed some client software (precompilers) on the machine. The oraInventory only shows the client installation, not the real server. And...I have confirmed - the oraInst.loc file does correctly point to the oraInventory directory. It just looks as though the installer process didn't update the oraInventory correctly. Now I'm afraid I'm Screwed on the upgrade! -Original Message- Sent: Saturday, May 18, 2002 9:58 AM To: Multiple recipients of list ORACLE-L I'm guessing that the 9.0.1.0 server software was not installed using the Oracle installer? Did you "tar" it over from somewhere else? For a server installed using the installer, you'll find a file in "/var/opt/oracle" named "oraInst.loc", which contains the name of the directory containing the Oracle Universal Installer's "oraInventory" directory. Your installer running the 9.0.1.2 patch is checking for that file in "/var/opt/oracle" and probably not finding it. Or, it is finding it and the "oraInventory" directory, but the inventory says that only the client has been installed... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, May 17, 2002 3:38 PM > HI - > > I'm trying to upgrade my database from 9.0.1.0 to 9.0.1.2 (Sun Solaris). > The installer tells me there are no files that need to be applied. When I > click on installed products, under 9i it only show the client install, not > the enterprise edition server. Does anyone know what I can do to get the > installer to realize that I do have the server installed? > > Thank you - > 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: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).
Multiple Oracle Instances on NT
Title: Multiple Oracle Instances on NT Hi everyone - I have worked exclusively with Oracle on Unix, but not at all with Oracle on NT. Our users have come to us with a requirement to run an application with their database on NT. They want to build both a test and production environment on the same NT box. I would like to know some "basics" about running Oracle on NT - can you run multiple instances of Oracle on one NT machine - if so, what do I need to look out for (ie. what things are different that a Unix installation) - are any of the processes, etc. drastically different - ie. security, networking, logging - what type of system requirements (ie. memory, CPU) are needed on NT Thanks for any help you can give me! Lisa
Moving table with interMedia datatype
Title: Moving table with interMedia datatype Hi - I have a table that contains 1 column with an interMedia datatype (ordsys.ordimage) and a blob column. I want to move the data from the table in our test server to our production server. I don't think an exp and imp will work on these datatypes. Does anyone know how I can accomplish this? Thanks in advance, Lisa
RE: CASE Expressions
Title: RE: CASE Expressions It must have been new with 8.1.6. I run it successfully on 8.1.6, but I get errors on 8.1.5. -- From: MacGregor, Ian A. To: Multiple recipients of list ORACLE-L Subject: RE: CASE Expressions Date: Monday, July 23, 2001 11:10AM CASE has been around since at least 8.1.6. The syntax you posted is incorrect. I believe you wanted something akin to the following: 1 select case 2 when 1=1 then 2 3 else 3 4 end "1" 5* from dual SQL> / 1 - 2 Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, July 23, 2001 8:03 AM To: Multiple recipients of list ORACLE-L I'm doing some research for a book, and I need to know when Oracle began to support CASE expressions. I thought it was in Oracle9i, but the new features list seems to imply that CASE may have come about in 8.1.7. Can anyone with 8.1.7 verify this for me? I have 8.1.6 and 9.whatever, but not 8.1.7 or I'd try it myself. If you have 8.1.7, and have a second to experiment, try the following query as a test: SELECT CASE 1 WHEN 1 THEN 2 FROM dual; Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: MacGregor, Ian 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).
UPgrade or Reinstall ?
Hi everyone - I have recently installed an instance of Oracle, version 8.1.7 on a Sun Solaris machine (running 2.6). I have the base instance completed, and am waiting for the clients to finalize their design. Now, after discussing it, we've decided we should try to implement on 9i instead. At this point - am I better off starting over and installing 9i, or would an upgrade of the instance be better? I'm interested both from a time perspective and from the complexity of the tasks, as well as the probability that it will work. Thanks in advance for any input! Lisa Yttri IBM Global Services Oracle Database Administration (262) 636-6797 -- 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).
oraInventory
Hi - Can anyone tell me if the oraInventory directory concept is still used with versions 8i and 9i? If so, I have a question. We have an installation of Oracle Express that contains the oraInventory directory (since it was installed long before Oracle on this server). They are now planning to move the Oracle Express software off of this machine so we can use it strictly for Oracle databases. Do I need them to keep that directory and oraInventory file on the server when they move? Can I recreate it? If so, how? This is Sun Solaris 2.6, Oracle versions 8.1.5 and 8.1.7. Lisa Yttri IBM Global Services Oracle Database Administration (262) 636-6797 -- 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).
RE: UPgrade or Reinstall ?
It's unanimous - start over. Thanks everyone. -Original Message- Sent: Wednesday, February 06, 2002 9:44 AM To: Multiple recipients of list ORACLE-L Lisa, As far as I'm concerned, I would trash your existing instance and start over. The only real reason to perform a migration is to preserve an existing database. In your case, you have nothing except for a vanilla instance which can be re-created easily. On the other hand, if you wish to see what must be done to perform a migration, and you have the time, you can follow the migration steps. Just my own little 2 cents. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, February 06, 2002 10:13 AM To: Multiple recipients of list ORACLE-L Hi everyone - I have recently installed an instance of Oracle, version 8.1.7 on a Sun Solaris machine (running 2.6). I have the base instance completed, and am waiting for the clients to finalize their design. Now, after discussing it, we've decided we should try to implement on 9i instead. At this point - am I better off starting over and installing 9i, or would an upgrade of the instance be better? I'm interested both from a time perspective and from the complexity of the tasks, as well as the probability that it will work. Thanks in advance for any input! Lisa Yttri IBM Global Services Oracle Database Administration (262) 636-6797 -- 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Advanced Queueing
Hi - Is anybody using Oracle's AQ feature with MQ Series? If so, please contact me, I have some questions on what is needed - ie. Gateway from MQ, Gateway from Oracle. Thank you! Lisa Yttri IBM Global Services Oracle Database Administration (262) 636-6797 -- 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).
FW: rename foreign keys from system-assigned constraint names to
|| v_fklist_R || ';' ); DBMS_OUTPUT.new_line (); END LOOP; END; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).
Database Recovery - any options?
Hi - We've encountered some problems with a Unix reboot and I'm trying to figure out if we have any options other than copying all files back and doing a full recovery. The boot drive was bad on the machine (sun 2.6) and they unix sa replaced it. When it came back up, all of the control files were a old. Also the redo log files were old. The unix sa cannot explain why this happened, so it's my problem to fix it. When I try to start up the database, it says that my files are more recent than my controlfile. Do I have any options other than a full recovery from previous day? This option is OK, since we are archiving, but it is time consuming because there are 8 databases on this machine, each with a large number of datafiles. I appreciate any help, comments and feedback! 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).
RE: Database Recovery - any options?
Exactly that . we don't know what the SA did, nor will he give us much info. This will be pursued once we get all instances back up. We do have the control files dumped to trace, but unfortunately, then it expects the redo logs to be intact, which they are not. We are in the process of restoring from previous backups and rolling forward to the final archive log. The best we can do under these circumstances. Thanks for the input - Lisa -Original Message- Sent: Wednesday, March 06, 2002 1:19 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] It sounds like one of 2 things to me. 1) The disk partition(s) with your redo logs and control files were on the root disk. Bad idea. 2) The SA restored files other than just those needed for the root filesystem. Could be others, but that's what comes to mind. Do you have control files to trace that you could use to rebuild the controlfiles and then start the databases? You would have to open them with RESETLOGS, which means you would then need a cold backup of each database. Restoring is probably a better option. In any case, it sounds like the SA needs to come clean with what really happened so it can be avoided in the future. Jared YTTRI Lisa <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/06/02 07:28 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Database Recovery - any options? Hi - We've encountered some problems with a Unix reboot and I'm trying to figure out if we have any options other than copying all files back and doing a full recovery. The boot drive was bad on the machine (sun 2.6) and they unix sa replaced it. When it came back up, all of the control files were a old. Also the redo log files were old. The unix sa cannot explain why this happened, so it's my problem to fix it. When I try to start up the database, it says that my files are more recent than my controlfile. Do I have any options other than a full recovery from previous day? This option is OK, since we are archiving, but it is time consuming because there are 8 databases on this machine, each with a large number of datafiles. I appreciate any help, comments and feedback! 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: 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).
Recall: ORACLE VS. SYBASE
YTTRI Lisa would like to recall the message, "ORACLE VS. SYBASE". -- 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).
RE: ORACLE VS. SYBASE
-Original Message- Sent: Wednesday, September 26, 2001 12:01 PM To: Multiple recipients of list ORACLE-L No guarantees as to accuracy, but I heard this story about 7 years ago from someone who said he was there. Apparently when the major Wall St. firms were deciding whether to go with Oracle or Sybase they arranged to have both companies come in and do presentations and say what special arrangements they'd be willing to offer. Sybase sent high level management who came with a list of features, explained their policies and offered a substantial discount. Oracle sent Larry Ellison who told them Oracle didn't have to offer discounts because it was obviously superior and anyone who bought Sybase was an idiot. They bought Sybase. Jay Miller -Original Message- Sent: Tuesday, September 25, 2001 9:40 AM To: Multiple recipients of list ORACLE-L -- Guy Hammond <[EMAIL PROTECTED]> > That's about all I can be bothered to type for now. In summary, I would > like to say that Sybase is a fine product for your grandmother to store > her recipes in :0) Interesting to note that a good number of financial companies -- who make a living off of fast, stable databases -- use Sybase. They tend to prefer it for its combination of speed and cost of operation. None of them store recipies on it that I know of, nor do they allow their grandmothers access to the systems. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: 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).
SQL Loader questions
Hi everyone - I need some help. We have an application running on 8.0.5 on NT. My programmer tells me that she should be able to add columns to a table simply by changing the sql loader control file definition of the input. I have looked through the documentation and tried several tests, but I can't see any way that this would work. Is this actually possible with SQL Loader? Also, she tells me that if a record exists in the table and she has the same record (key value only) in the input file, that SQL Loader should update the record with any changed field values. Is there a special keyword to do this - I can't seem to find anything on that either? Thanks in advance for any help you can give me. 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).
RE: SQL Loader questions
Thanks to all for reconfirming this for me. I had never heard of SQL Loader doing these things, but couldn't quite convince the programmer. What I have since found out is that once upon a time, a consultant came in and set up the job that loads their data - and left without documenting it. Lo and behold, there's a lot of other stuff the script is doing besides running SQL Loader. Thanks again for all your responses. Lisa :D -Original Message- Sent: Wednesday, October 24, 2001 1:00 PM To: Multiple recipients of list ORACLE-L what documentation has your programmer been reading? as far as I know you can't add a column on the fly through a sqlloader control file, nor will oracle do an update to existing data. I'm not an expert, but I've never been able to do that --- YTTRI Lisa <[EMAIL PROTECTED]> wrote: > Hi everyone - > > I need some help. We have an application running on 8.0.5 on NT. My > programmer tells me that she should be able to add columns to a table > simply > by changing the sql loader control file definition of the input. I > have > looked through the documentation and tried several tests, but I can't > see > any way that this would work. > > Is this actually possible with SQL Loader? > > Also, she tells me that if a record exists in the table and she has > the same > record (key value only) in the input file, that SQL Loader should > update the > record with any changed field values. Is there a special keyword to > do this > - I can't seem to find anything on that either? > > Thanks in advance for any help you can give me. > > 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). __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).
RE: equivalent of LPAD in Transact SQL
I believe you would use the 'stuff' command. -Original Message-From: Suhen Pather [mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 24, 2001 9:55 PMTo: Multiple recipients of list ORACLE-LSubject: equivalent of LPAD in Transact SQL List, Bit of an inappropriate question to the Oracle List. Does anybody know the SQL Server (Transact SQL) equivalent of the LPAD function. Regards Suhen
RE: OMW
Contact Oracle Migration Workbench Support [[EMAIL PROTECTED]]. They were very helpful to me on my conversion from MS SQL Server to Oracle. -Original Message- Sent: Friday, October 26, 2001 3:00 PM To: Multiple recipients of list ORACLE-L Hi all: I'm having problems using OMW to migrate from mysql to Oracle8i. If a date field in mysql database has a default date, OMW doesn't seem to add the to_date to convert to date from character. Also the numbers are being converted to oracle numbers with precision 250 which is higher than max precicion allowed in Oracle. Does anyone have any experience with that tool who can shed some light on this? thanks = __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).
8i or 9i for Data Warehouse
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).
OT: Oracle and MQ
Hi - Does anyone have experience with using MQ w/Oracle. We have an application that is using MQ to get data from the mainframe into Oracle. We are trying to determine what our options are for retrieving the data from the MQ queues. We know one option is to write a Pro*C program to handle this, but this means creating all our own error logic, etc. Does AQ fit into this scenario at all, or is that primarily for non-middleware queues? Any information / insight would be greatly 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).
RE: Oracle and MQ
Title: RE: Oracle and MQ Tony - Do you have error handling built in to your VB program, or do you just load it into Oracle and then cleanse/validate the data there? Do you think it would also be possible to access MQ via external stored procedures? -Original Message-From: Aponte, Tony [mailto:[EMAIL PROTECTED]]Sent: Tuesday, November 20, 2001 4:02 PMTo: [EMAIL PROTECTED]Cc: [EMAIL PROTECTED]Subject: RE: Oracle and MQ I believe Oracle sells an MQ-to-AQ bridge that just moves messages between queuing systems. We use VB to pull messages out of MQ and issue SQL to get it into the database. HTH Tony Aponte -Original Message- From: YTTRI Lisa [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 11:50 AM To: Multiple recipients of list ORACLE-L Subject: OT: Oracle and MQ Hi - Does anyone have experience with using MQ w/Oracle. We have an application that is using MQ to get data from the mainframe into Oracle. We are trying to determine what our options are for retrieving the data from the MQ queues. We know one option is to write a Pro*C program to handle this, but this means creating all our own error logic, etc. Does AQ fit into this scenario at all, or is that primarily for non-middleware queues? Any information / insight would be greatly 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).
Free Java dba monitoring tool and Java source code
Title: Free Java dba monitoring tool and Java source code Hi - There was a post a couple of months ago from someone who had written this java tool and you could e-mail him to get a copy. Does anyone have his e-mail or a web site where the software can be found? Thanks - Lisa
Automatic password locking
Title: Automatic password locking Hi everyone - I am trying to implement a process on our production servers. If requested for emergencies, an id is automatically unlocked. This id was previously defined with all access (select, insert, update, delete) to all objects in a schema. I want this id to be active for only 4 hours, then I would like it to automatically get locked. Is there any information maintained in oracle as to the length of time a user id has been unlocked (or active)? I could then query that column and once it was over 4 hours, I could terminate any active sessions using that id and lock it. If I audit this id, would there be useful information in the audit tables regarding length of use? Any help - or other ideas to accomplish this - would be greatly appreciated. Thanks - lisa
OT: Tool needed for database access
Title: OT: Tool needed for database access Hi - We are a sybase and oracle shop. We are considering building a tool (probably web-based) to allow the Security group to set up new users and to allow the developers to add stored procedures as the schema owner, etc. We don't want them to have the specific access themselves, but we would like the tool to log in with an appropriate ID - based on information we have stored in some database tables - and perform their request. Does anyone know of such a tool that is available, or are we stuck writing our own? Just out of curiousity - I'd like to know how others implement developer's code (such as stored procedures) in a non-development environment? Is it a task that the DBA staff does? We currently do, and we are looking for a way to eliminate that workload without giving too much access for them to affect other database objects. Any information would be really appreciated. Thanks - Lisa
Implementing Stored Procedures
Title: Implementing Stored Procedures Hi - I'd like some advice on implementing stored procedures containing application logic (ie. written by developers). We have several applications where the developers use stored procedures for much of their coding. We let the developers create or replace their procedures in a development environment under their own schema (with access to all application tables, etc.) to test the logic, but it currently requires a DBA to implement the proc under the application schema. It has gotten to be a very time-consuming job. We don't want to give out the schema owner password to the developers, nor do we know of a way they could add them as the schema owner without giving them more privileges than we want. I am curious of how others are handling stored procedure additions and modifications. Do you somehow allow developers this access? If so, how do you restrict them from damaging other things? If not, does the DBA do it? Does anyone have an automated way? Also, do you keep track of the original "source code" for the procedure, or do you extract it out of the database as needed? Thanks so much for your input - Lisa
RE: Oracle 8i database & ER diagram
Title: RE: Oracle 8i database & ER diagram Q-Designer is Sybase's PowerDesigner - same product, just remarketed by Quest. Although it's a good modelling tool for Sybase, it has its limitations when doing Oracle modelling. -- From: Adams, Matthew (GEA, 088130) To: Multiple recipients of list ORACLE-L Subject: RE: Oracle 8i database & ER diagram Date: Tuesday, June 12, 2001 1:17PM Has any tried Q-Designer from Quest? R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. > -Original Message- > From: [EMAIL PROTECTED] > [ mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 12, 2001 11:26 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: Oracle 8i database & ER diagram > > > > Embarcadero's ERStudio works pretty well (I like it better > than ERWin). > You can download a demo copy from their website. > > David A. Barbour > Oracle DBA, OCP > AISD > 512-414-1002 > > > > > "magesh" > > > recipients of list ORACLE-L <[EMAIL PROTECTED]> > .ne.jp> cc: > > Sent by: Subject: Oracle > 8i database & ER diagram > root@fatcity. > > com > > > > > > 06/12/2001 > > 04:00 AM > > Please > > respond to > > ORACLE-L > > > > > > > > > > Hi > > We are exploring the possibility of generating ER diagram from the > Oracle 8i database. We want to know how it can be done. > > Thanks & Regards > Magesh > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: magesh > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: (Fwd) Use of third-party tools in Oracle environments [Note:4
Title: Re: (Fwd) Use of third-party tools in Oracle environments [Note:47292.1] Do you think this policy would apply to a tool like SQL BackTrack? -- From: Eric D. Pierce To: Multiple recipients of list ORACLE-L Subject: Re: (Fwd) Use of third-party tools in Oracle environments [Note:47292.1] Date: Monday, March 12, 2001 9:05PM (fyi, from Metalink) ---begin--- Doc ID: Note:47292.1 Subject: Official Backup Policy -- Certification, RMAN, EBU, Third-Party Software Type: FAQ Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 16-OCT-1997 Last Revision Date: 04-MAY-2000 Language: USAENG Oracle *DOES NOT* certify media management software with Recovery Manager (RMAN) or the Enterprise Backup Utility (OBACKUP, EBU). Source: Bernard Vincent, Director, Operations and Services Planning, Worldwide Customer Support. September 2, 1997 Use of third-party tools in Oracle environments To: Worldwide Oracle Support Customers To protect customer data against loss or damage and ensure Oracle's ability to provide timely service and support, Oracle Worldwide Customer Support and Oracle Server Technologies have developed the following policy: Oracle cannot guarantee customers data integrity and product functionality where third-party products alter the internal contents of the Oracle database files, data blocks, log files or control files. Third-party products or customer-developed programs which alter the internal contents of these files may introduce inconsistencies that render the data to be unusable. In such situations, customers may be required to restore from the last backup prior to the first use of the third-party product in order for Oracle to provide effective assistance. Examples of such products include data reorganization tools, data loaders, [***]defragmentation tools[***], products that conduct incremental backups of only changed portions of data, or any product that attempts to alter the contents of the Oracle data files, blocks, logs or control files. This [***]excludes[***] simple copying utilities such as operating system utilities or any other product that reproduces an exact image of the data as it was originally written by Oracle. Oracle customers are encouraged to work with third-party software vendors to determine how that vendors' product interacts with Oracle technology, and if the above information is pertinent to their environment or may compromise their data retention and recovery capabilities. . Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of Use. ---end--- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Recovery Manager vs. SQL Back Track
Title: Recovery Manager vs. SQL Back Track Hi everyone - Currently we are doing backups manually, periodic cold backups, and hot backups in between - we are running in archivelog mode. We are running 8.1.5 and 8.1.6 (soon to be 8.1.7) on Sun Solaris. Today there are only a few small production servers (2 - 5 GB), but we are anticipating a couple large ones (~200GB), and a data warehouse (anticipated to be around 500GB). We have started playing around with Recovery Manager. Our Sybase DBAs are telling us we should look at SQL BackTrack instead. For those of you who are using either one, I'd appreciate your comments on how well you like / don't like it and any "gotcha's" that you have run into. Other than the cost factor, what would you recommend? Thanks very much - Lisa
BLOB vs. B-File
Title: BLOB vs. B-File Hi everyone - I'm looking for some information based on your experiences. We have an application that has large objects to store. They are wondering which way would be better - to store them as BLOBs within the database, or as bfiles outside the database. My instincts tell me BLOBs would be better, but I have no actual facts to base this on. Does anyone have any information or know of any documentation I could review that might help define the differences - re. coding programs to access the objects, performance, administration, etc.? Thanks - Lisa
FW: Dependent objects
Title: FW: Dependent objects Hi - Does anyone have (or know where I can find) a script to identify dependencies on a table? When we make table modifications, we would like to be able to run a script that recursively identifies dependent objects. We pulled one from Metalink, but it doesn't seem to work. Thanks - Lisa
Somewhat OT: Blobs and Ordimage types
Title: Somewhat OT: Blobs and Ordimage types Hi - We have an application group that is interested in storing documents in the database. Some of these documents are word docs or excel spreadsheets, while others are actual image files. We have looked into the interMedia ordimage type, which seems to work great for the images, but doesn't work for the documents. Is there some other way within interMedia to manipulate the documents? Would they need more than one column - ie. one to store images and another to store documents? From a DBA perspective - does it make sense to store these in the database? Thanks for any help you can offer - Lisa
Constraint dependencies
Title: Constraint dependencies Hi - When dropping and/or re-applying constraints for an entire schema, is there a dictionary table that can be queried (or some other way) to determine constraint dependencies - or do you just keep running the script until you do not get those errors? I would like to be able to identify the order that the constraints should be dropped (or added) so that I can write a script to be automated ( for example, to refresh test data from production). If anyone has any good ideas on how to do this, I'd really be interested in hearing from you. Thanks - Lisa
RMAN
Title: RMAN Hi - I think I remember seeing this posted awhile back, but I do not remember the specifics. We have installed the RMAN catalog on an 8.1.6 server (UNIX). We are trying to register an 8.1.5 server, but it won't let us. I seem to remember that you have to run a script on the 8.1.5 server. Can anyone tell me what that script is? Thanks - Lisa
RE: RMAN
Title: RE: RMAN Aren't there problems though, if you're running different versions? For example, we are running 8.1.6 and 8.1.5 database instances. I had installed 8.1.6 RMAN, but it won't let me register the 8.1.5 version in the catalog. Does anybody know of a workaround - short of upgrading our 8.1.5 database? Thanks - Lisa -- From: Vadim Gorbounov To: Multiple recipients of list ORACLE-L Subject: RE: RMAN Date: Tuesday, February 06, 2001 3:01PM Hi, William, I used to have may rman backups since 8.0.5, and I could say, 8.1.6 makes a BIG difference. It is much more stable and worth to go, especially if you have big/frequantly updated database. Even 8.1.5 is well behind 8.1.6. My preference is to have rman backup information in catalog rather than controlfile. Anytime you can export it and restore to any database, even on different platform. Works fine. My current configuration is 8.1.6 on Solaris + NetBackup. Vadim Gorbounov Oracle DBA -Original Message- Sent: Tuesday, January 30, 2001 8:51 AM To: Multiple recipients of list ORACLE-L Hi, At one time, I had implemented RMAN in my 8.0 environment. It had some bugs, so I went back to my old way of doing backups. Now that I have upgraded to 8.1.6, I was thinking of re-implementing RMAN. But some of the discussion here implies that there are still problems. Can someone elaborate on all of this so we might make an informed decision? Bill Carle AT&T Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), NLCIO INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RMAN
Title: RE: RMAN That's my dilemma - I would have to install both .. but I have not heard anything good about version 8.1.5. I don't want to install it and have to deal with all kinds of issues. Does anyone know - is RMAN always going to be this way (that you need a catalog for each specific version of the software you are running?). Are there also issues with restoring - ie. if I backup an 8.1.5 database, can RMAN restore that into a different version database? We're trying to determine if this product is worth it, or if we should work on a different backup/recovery strategy. For now we're doing periodic cold backups and nightly hot backups, with manual management of the output. That works OK, but we'd like to have a more automated approach. I'd appreciate hearing about any ideas/strategies that you are using. Thanks for your help - Lisa -- From: Kevin Kostyszyn To: Multiple recipients of list ORACLE-L Subject: RE: RMAN Date: Tuesday, February 06, 2001 4:03PM I don't know if this is a workaround, but couldn't you use the rman for 815 seperately. Also, someone on this list said that 815 is not very good. Just thinkin outloud again. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Yttri, Lisa Sent: Tuesday, February 06, 2001 4:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: RMAN Aren't there problems though, if you're running different versions? For example, we are running 8.1.6 and 8.1.5 database instances. I had installed 8.1.6 RMAN, but it won't let me register the 8.1.5 version in the catalog. Does anybody know of a workaround - short of upgrading our 8.1.5 database? Thanks - Lisa -- From: Vadim Gorbounov To: Multiple recipients of list ORACLE-L Subject: RE: RMAN Date: Tuesday, February 06, 2001 3:01PM Hi, William, I used to have may rman backups since 8.0.5, and I could say, 8.1.6 makes a BIG difference. It is much more stable and worth to go, especially if you have big/frequantly updated database. Even 8.1.5 is well behind 8.1.6. My preference is to have rman backup information in catalog rather than controlfile. Anytime you can export it and restore to any database, even on different platform. Works fine. My current configuration is 8.1.6 on Solaris + NetBackup. Vadim Gorbounov Oracle DBA -Original Message- Sent: Tuesday, January 30, 2001 8:51 AM To: Multiple recipients of list ORACLE-L Hi, At one time, I had implemented RMAN in my 8.0 environment. It had some bugs, so I went back to my old way of doing backups. Now that I have upgraded to 8.1.6, I was thinking of re-implementing RMAN. But some of the discussion here implies that there are still problems. Can someone elaborate on all of this so we might make an informed decision? Bill Carle AT&T Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), NLCIO INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Vendor Package Implementation Strategy
Title: Vendor Package Implementation Strategy Hi everyone - I posted this some time ago and didn't really get much response, so I'm trying again. For those of you that are implementing multiple application packages, how to you determine how many Oracle instances and servers to use? For example - do you build one instance per application package and, if so, on one server or separate? Is this possibly a use of NT vs. Oracle (if you only have 1 small application per instance, you wouldn't necessarily need the machine power)? We implemented a few different vendor packages onto one Unix server. We are now looking to upgrade oracle (and Solaris) and are having problems finding a common version that all packages can run on. I have been asked to propose a different strategy going forward, so that we have more flexibility for upgrades, etc. I would like to hear how others have implemented and supported the vendor-provided package scenario. Thanks in advance - Lisa
Extent allocation
Title: Extent allocation Hi - I am confused now about how oracle actually determines the size an extent should be. I have db_block_size set at 8192 and have defined a tablespace (and tables) at initial and next extents of 128K. When I do a show parameter db_file_multiblock_read_count it says 8. Therefore I thought 128K would be a good number, since it is a multiple of these numbers. However, when I check my extent sizes, I see that each extent contains 10 blocks which is 160K. I remember reading an article some time ago about how oracle actually determines what it thinks the extent size should be. Does anyone know of an article like this, or can anyone explain to me why it chose a different extent size? By the way, I looked at several tables and the one common thing I noticed is that the number of blocks allocated seems to be a multiple of 5 - ie. some are 5 blocks, some 10, some 20, etc. I don't know if that's coincidence or a big clue to the whole thing Lisa
RE: Extent allocation
Title: RE: Extent allocation I found a document on metalink #69343.1 that pretty much explains it. Unfortunately, it makes it sound like you can never be sure of the sizing you choose, because it looks at the size of the first two open blocks, rather than finding a block that fits what you want. Am I missing something? -- From: Shakeel Qureshi To: Multiple recipients of list ORACLE-L Subject: RE: Extent allocation Date: Thursday, February 08, 2001 1:34PM Hi Paul, I created an object with initial_extent 128K and it took 13 blocks. I then created the same object with 208K and still it took 13 blocks. My db_block size is 16K. I tested this on 8.1.5 and 8.1.6 and they both behave the same. TIA, Shakeel Qureshi [EMAIL PROTECTED] --- Paul Baumgartel <[EMAIL PROTECTED]> wrote: > It is a big clue. Oracle rounds to multiples of 5 > extents to prevent the > existence of a free extent of fewer than 5 blocks, > which is unlikely to be > usable. > > > > Paul Baumgartel > InstiPro, Inc. > [EMAIL PROTECTED] > 212 813-0829 x103 (office) > 917 549-4717 (mobile) > > -Original Message- > Sent: Wednesday, February 07, 2001 4:26 PM > To: Multiple recipients of list ORACLE-L > > > > Hi - > > I am confused now about how oracle actually > determines the size an extent > should be. I have db_block_size set at 8192 and > have defined a tablespace > (and tables) at initial and next extents of 128K. > When I do a show > parameter db_file_multiblock_read_count it says 8. > Therefore I thought 128K > would be a good number, since it is a multiple of > these numbers. > > However, when I check my extent sizes, I see that > each extent contains 10 > blocks which is 160K. > > I remember reading an article some time ago about > how oracle actually > determines what it thinks the extent size should be. > Does anyone know of an > article like this, or can anyone explain to me why > it chose a different > extent size? > > By the way, I looked at several tables and the one > common thing I noticed is > that the number of blocks allocated seems to be a > multiple of 5 - ie. some > are 5 blocks, some 10, some 20, etc. I don't know > if that's coincidence or > a big clue to the whole thing > > Lisa > > __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shakeel Qureshi INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
export / import 8.1.5 to 8.0 ?
Title: export / import 8.1.5 to 8.0 ? Hi all - Is it possible to export an 8.1.5 database and import it into an 8.0.x database? Does the compatibility or anything else special need to be set in order to make this happen? Thanks - Lisa
OT: ODBC version errors
Title: OT: ODBC version errors Hi everyone - I have several developers telling me that their web applications (some are purchased packages and some are developed in-house) do not work with Oracle ODBC drivers if they are version 8. Every one of their applications seems to run fine with the 7.3.4 ODBC drivers. They get a variety of errors - some get odd messages when they try to login, others get Dr. Watson errors when there are more than x number of users connecting. Does anyone know of existing problems (or fixes) related to the 8 (both 8.0 and 8.1) drivers? or, can you point me to any documents / sites / user groups that could better answer my question? Thanks very much - Lisa