RE: RAC or Oracle Fail Safe
Title: RE: RAC or Oracle Fail Safe Hi Rajesh, Thanks for the detailed reply and I really appreciate that. Certain clarifications. 1. With reference to what you said about using both the nodes, you meant that we can install another database (lets say for reporting purpose) or/and also 9iAS on one node and our main production database on the other 2. Incase of OFS, the database service fails over from one node to the other, and then it starts, but it is automatic, right? 3. When you talk about Resources and that they cant be shared, you are not referring to the shared storage vault (we are using DAS Direct Attached Storage) because that has to be at least available to both the servers. And when the database fails over from one server to the other, and it starts its services on the other server, then the obviously that other server will make use of the DAS on which reside our datafiles. 4. RAC costs roughly 20k$ per CPU and it doesnt come bundled with Oracle 9i License? (For confirmation purposes) 5. From various mails I gather that OFS is basically a safe bet, if the hardware supporting is good. And if, God-forbid, one server goes down then the only time lapse is the time it takes to start the services on the other server. 6. The transactions taking place at the time when main server goes down will be lost, I mean it will give a feeling of hung database or some other error. Thanks in advance, and waiting for your reply. Regards, Hussain -Original Message- From: RAJESH DAYAL [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 12:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: RAC or Oracle Fail Safe Hi Hussain ! RAC can have Active-Active or Active-Passive combination for two nodes. While OFS can't give you Active-Active combination of two nodes. Basically a resource sharing is not possible in Oracle Fail safe so one resource can be used by only one node at one point of time. ( Resource means Hard Disk Space, Oracle Service, Listener etc). RAC can give Transparent Application Failover TAF which is out of consideration in OFS. In case of node failure on RAC System, the user will just need to attempt relogin and he will be connected _immediately_ to another surviving instance ( If tnsnames.ora is configured properly). While there is a significant amount of delay in case of OFS, the Database service has to failover from one node to another node and this may take it's own _sweet_ amount of time based on amount and type of activity being performed on the database. Of course both the systems are screwed when your (shared) storage system is down ;-) Lastly why would someone want to use only 1 out of 2 nodes when it is possible to use both the nodes? One possible answer is that, on one node you configure One server (say 9iAS) and on another node you configure database. Then under normal condition they will run on their respective nodes and when one fails they would switch-over to the surviving node. So your performance may suffer for the time during which any node is down. So you are the best judge to decide now ;-) Just my .2 c Regards, Rajesh -Original Message- HREF="" PROTECTED]mailto:[EMAIL PROTECTED] On Behalf Of Hussain Ahmed Qadri Sent: Wednesday, July 16, 2003 8:44 PM To: Multiple recipients of list ORACLE-L Subject: RAC or Oracle Fail Safe Hello all, We have setup a Microsoft Cluster Server (MSCS) cluster, with two nodes, using W2K, and now are in the process of deploying Oracle 9i on it. For the purpose of high availability (HA), we are deliberating on setting up either RAC or Oracle Fail Safe. The confusion is over the fact that if we get HA with oracle Fail Safe, i.e. if one node is down due to any problem, then the other takes over, then can we do without RAC? Which of these two is more transparent to the user, i.e. which will take less time to shift the load from one node (server) to the other node? Can any one explain the benefits of using RAC over Oracle Fail Safe, or vice versa. Regards, Hussain DBA SKMCHRC -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hussain Ahmed Qadri 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: DB2 pointers
From a previous request to the list try these: DB2 links from SearchDatabase.com - http://searchdatabase.techtarget.com/bestWebLinks/0,289521,sid13_tax282900,00.html Learning the Lingo - article from DB2 Magazine that maps some Oracle and DB2 concepts - http://www.db2mag.com/db_area/archives/2002/q1/pdfs/Kolluru.pdf DB2 Self-Study course (u can download it for free): http://www-3.ibm.com/software/data/db2/selfstudy/index.html DB2 Manuals - http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v7pubs.d2w/en_main hth, Marin Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. hrishy [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 19-07-2003 04:34 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:DB2 pointers Hi All are there any Db2 mailing lists which are active like this one..where i can develop my knowledge on Db2.I know this is a Oracle mailing lists but i thought maybe one of you might be Db2 DBA as well.. regards Hrishy Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?hrishy?= 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: 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: RAC or Oracle Fail Safe
Title: RE: RAC or Oracle Fail Safe Hi Hussain, Replies are inline . With reference to what you said about using both the nodes, you meant that we can install another database (lets say for reporting purpose) or/and also 9iAS on one node and our main production database on the other Yes you can do that. You can very well make use of other node, in above ways. Advantage of running some standard services would be that they will also fail-over to the surviving node. So _effectively_ you are using both the nodes at any point of time. Here we have 2 node cluster where one node is running Database and another node is running 9ias Server. and they failover to each other automatically if one of them them goes down. In fact you can decide your failback policies also so that the nodes know when (may be off-peak hour) to fail-back once the failed node is back. Incase of OFS, the database service fails over from one node to the other, and then it starts, but it is automatic, right? Yes, it is a configurable parameter and can be set to automatic mode. When you talk about Resources and that they cant be shared, you are not referring to the shared storage vault (we are using DAS Direct Attached Storage) because that has to be at least available to both the servers. And when the database fails over from one server to the other, and it starts its services on the other server, then the obviously that other server will make use of the DAS on which reside our datafiles. I think you got me wrong here. They cant be shared at the same point of time. Actually the shared storage would be physically connected to both the nodes. And they can/will have multiple drives defined on them ( say U,V,W,X).So at one point of time say UV would be owned by node1 and WX would be owned by node2. If node1 fails then node2 will own all the 4 drives U,V,W and X. RAC costs roughly 20k$ per CPU and it doesnt come bundled with Oracle 9i License? (For confirmation purposes) Absolutely right. From various mails I gather that OFS is basically a safe bet, if the hardware supporting is good. And if, God-forbid, one server goes down then the only time lapse is the time it takes to start the services on the other server. Here I would beg to differ. RAC is more safe. _Almost_ half of your online user (who are on surviving node) wont even notice the node failure when one node in a RAC environment goes down. And those who were unlucky users (connected to failed node), can connect immediately to the surviving node, without any delay. Of course you need to configure these parameters manually. While in OFS environment your users have to wait till the time surviving node brings up the database and all related services (listener etc) completely. The price you may for these features is more money and more complex database environment to manage. The transactions taking place at the time when main server goes down will be lost, I mean it will give a feeling of hung database or some other error. I think users will have a hung screen with/without some ORA error message. Hope this helps you decide, Regards, Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Hussain Ahmed Qadri Sent: Saturday, July 19, 2003 11:44 AM To: Multiple recipients of list ORACLE-L Subject: RE: RAC or Oracle Fail Safe Hi Rajesh, Thanks for the detailed reply and I really appreciate that. Certain clarifications. 1. With reference to what you said about using both the nodes, you meant that we can install another database (lets say for reporting purpose) or/and also 9iAS on one node and our main production database on the other 2. Incase of OFS, the database service fails over from one node to the other, and then it starts, but it is automatic, right? 3. When you talk about Resources and that they cant be shared, you are not referring to the shared storage vault (we are using DAS Direct Attached Storage) because that has to be at least available to both the servers. And when the database fails over from one server to the other, and it starts its services on the other server, then the obviously that other server will make use of the DAS on which reside our datafiles. 4. RAC costs roughly 20k$ per CPU and it doesnt come bundled with Oracle 9i License? (For confirmation purposes) 5. From various mails I gather that OFS is basically a safe bet, if the hardware supporting is good. And if, God-forbid, one server goes down then the only time lapse is the time it takes to start the services on the other server. 6. The transactions taking place at the time when main server goes down will be lost, I mean it will give a feeling of hung database or some other error. Thanks in advance, and waiting for your reply. Regards, Hussain -Original Message- From: RAJESH DAYAL [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 12:30 PM To: Multiple recipients of
imp table data, but not PK indexes?
Hi, I sent this yesterday but it did not seem to get posted. Anyway I am posting it again. I am trying to speed up a schema imp process by import data and indexes separately to an Oracle 8173 db. While importing table data, I don't want to import PK indexes which are sitting in tablespace indexes (because I can create PK indexes later from a script), So I have this running before imp data: alter user ABC quota 0 on indexes; alter user ABC quota unlimited on ABC_DEFAULT_TS; I found that this way the PK indexes are imported in ABC_DEFAULT_TS, together with table data. So my question is what I can/should do so that I can imp only table data into ABC_DEFAULT_TS, and not imp PK indexes at the same time? Thanks. Guang -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei 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 tablespace, which way is better?
Please correct me if I am wrong. With option 1, the datafile will dynamically extend, 1M at a time and there is no guarantee the datafile is contiguous on disk. That will increase your I/O time when Oracle need to find data all over the disk. And also with autoextend, you may run out of space on that disk at any time (ie someone else created a big datafile on that disk), with option 2 at least you know you have 100M available for that datafile on the disk. Jos"Liu, Jack" [EMAIL PROTECTED] wrote: Hi, I want to increase tablespace, just want to know which way is better:1. ALTER TABLESPACE SYSTEMADD DATAFILE '/u01/oradata/orcl/users02.dbf'SIZE 1MAUTOEXTEND ONNEXT 1MMAXSIZE 100M; 2.alter tablespace system add datafile '/u01/oradata/orcl/users02.dbf' size 100m; Thanks, Jack Yahoo! Mobile - Check & compose your email via SMS on your Telstra or Vodafone mobile.
Re: imp table data, but not PK indexes?
Set indexes=no in the import script At 06:14 AM 7/19/2003 -0800, you wrote: Hi, I sent this yesterday but it did not seem to get posted. Anyway I am posting it again. I am trying to speed up a schema imp process by import data and indexes separately to an Oracle 8173 db. While importing table data, I don't want to import PK indexes which are sitting in tablespace indexes (because I can create PK indexes later from a script), So I have this running before imp data: alter user ABC quota 0 on indexes; alter user ABC quota unlimited on ABC_DEFAULT_TS; I found that this way the PK indexes are imported in ABC_DEFAULT_TS, together with table data. So my question is what I can/should do so that I can imp only table data into ABC_DEFAULT_TS, and not imp PK indexes at the same time? Thanks. Guang -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei 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). Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: imp table data, but not PK indexes?
Use the Indexes = N Option and Create the Index Seperatley .. AFAIK that should work ... Regards, Ganesh R HP : (+65)9067-8474 Mail : [EMAIL PROTECTED] == All Opinions expressed are my own and do not in anyway reflect those of my employer == -Original Message- Guang Mei Sent: Saturday, July 19, 2003 10:14 PM To: Multiple recipients of list ORACLE-L Hi, I sent this yesterday but it did not seem to get posted. Anyway I am posting it again. I am trying to speed up a schema imp process by import data and indexes separately to an Oracle 8173 db. While importing table data, I don't want to import PK indexes which are sitting in tablespace indexes (because I can create PK indexes later from a script), So I have this running before imp data: alter user ABC quota 0 on indexes; alter user ABC quota unlimited on ABC_DEFAULT_TS; I found that this way the PK indexes are imported in ABC_DEFAULT_TS, together with table data. So my question is what I can/should do so that I can imp only table data into ABC_DEFAULT_TS, and not imp PK indexes at the same time? Thanks. Guang -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei 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: Ganesh Raja 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: Empty String is interpreted as NULL
Thanks for all replies. Right now I think I can afford just make the column NULL, so that's what I'll do. But still, something doesn't feel quite right with empty string == NULL :). RDB On Friday 18 July 2003 03:22 pm, Mercadante, Thomas F wrote: Reuben, While I agree that an empty string is not logically equal to a null, Oracle interprets an empty string in INSERT and UPDATE statements as a NULL. So you really do not have a choice here. If you have the need to insert an empty string into a column, you have two choices: - Define a character to represent an empty string and insert that character (pretty dumb suggestion) - Change the table to allow null values in that column, and perform the INSERT as your example showed. Good Luck and hope these helped. Tom Mercadante Oracle Certified Professional -Original Message- From: Reuben D. Budiardja [mailto:[EMAIL PROTECTED] Sent: Friday, July 18, 2003 4:10 PM To: Multiple recipients of list ORACLE-L Subject: Empty String is interpreted as NULL Hello all, Suppose I have this table SQL DESC FRUIT Name Null?Type - ORANGENOT NULL VARCHAR2(10) APPLE NOT NULL VARCHAR2(10) If I do this insert: SQL / INSERT INTO FRUIT VALUES ('hello', '') * ERROR at line 1: ORA-01400: cannot insert NULL into (LIGHTCONE.FRUIT.APPLE) I got an error cannot insert NULL. But, what if I meant is to insert empty string '' ? Certainly empty string is NOT equal to NULL values. So how do I get around this? Thanks in advance for any help. Reuben D. Budiardja -- Reuben D. Budiardja Department of Physics and Astronomy The University of Tennessee, Knoxville, TN - /\ ASCII Ribbon Campaign against HTML \ / email and proprietary format X attachments. / \ - Have you been used by Microsoft today? Choose your life. Choose freedom. Choose LINUX. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reuben D. Budiardja INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: imp table data, but not PK indexes?
as PK comes under 'constraints' you might also have to do constraints=N also... On Sat, 19 Jul 2003 07:04:23 -0800, Ganesh Raja [EMAIL PROTECTED] wrote : Use the Indexes = N Option and Create the Index Seperatley .. AFAIK that should work ... Regards, Ganesh R HP : (+65)9067-8474 Mail : [EMAIL PROTECTED] == All Opinions expressed are my own and do not in anyway reflect those of my employer == -Original Message- Guang Mei Sent: Saturday, July 19, 2003 10:14 PM To: Multiple recipients of list ORACLE-L Hi, I sent this yesterday but it did not seem to get posted. Anyway I am posting it again. I am trying to speed up a schema imp process by import data and indexes separately to an Oracle 8173 db. While importing table data, I don't want to import PK indexes which are sitting in tablespace indexes (because I can create PK indexes later from a script), So I have this running before imp data: alter user ABC quota 0 on indexes; alter user ABC quota unlimited on ABC_DEFAULT_TS; I found that this way the PK indexes are imported in ABC_DEFAULT_TS, together with table data. So my question is what I can/should do so that I can imp only table data into ABC_DEFAULT_TS, and not imp PK indexes at the same time? Thanks. Guang -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei 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: Ganesh Raja 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: rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: imp table data, but not PK indexes?
as PK comes under 'constraints' you might also have to do constraints=N also... On Sat, 19 Jul 2003 07:04:23 -0800, Ganesh Raja [EMAIL PROTECTED] wrote : Use the Indexes = N Option and Create the Index Seperatley .. AFAIK that should work ... Regards, Ganesh R HP : (+65)9067-8474 Mail : [EMAIL PROTECTED] == All Opinions expressed are my own and do not in anyway reflect those of my employer == -Original Message- Guang Mei Sent: Saturday, July 19, 2003 10:14 PM To: Multiple recipients of list ORACLE-L Hi, I sent this yesterday but it did not seem to get posted. Anyway I am posting it again. I am trying to speed up a schema imp process by import data and indexes separately to an Oracle 8173 db. While importing table data, I don't want to import PK indexes which are sitting in tablespace indexes (because I can create PK indexes later from a script), So I have this running before imp data: alter user ABC quota 0 on indexes; alter user ABC quota unlimited on ABC_DEFAULT_TS; I found that this way the PK indexes are imported in ABC_DEFAULT_TS, together with table data. So my question is what I can/should do so that I can imp only table data into ABC_DEFAULT_TS, and not imp PK indexes at the same time? Thanks. Guang -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei 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: Ganesh Raja 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: rahul 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: pls-00123 Program too Large
Title: RE: pls-00123 Program too Large David, that trigger is way too long ... IMO. but if you really must, convert the logic into a package and pass parameters to the package call from within the trigger. Raj -Original Message- From: Ehresmann, David [mailto:[EMAIL PROTECTED]] Sent: Friday, July 18, 2003 7:10 PM To: Multiple recipients of list ORACLE-L Subject: pls-00123 Program too Large List, I have a trigger that is 2315 lines long and essentially one big long code block. The trigger compiles in an 8.1.7 instance, but not in a 8.1.6 instance. The error it gives is PLS-00123 Program too Large. These are on separate boxes. I have been reading on metalink about splitting the trigger into two pieces to cut down its size. Besides that, is there anything else to look at to get the trigger to compile. David Ehresmann PerotSystems [EMAIL PROTECTED] 972.577.6236 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: DBA/Programmer GUI tool for Oracle in Linux
Title: RE: DBA/Programmer GUI tool for Oracle in Linux TORA can't beat it. most value for money ... search on smartforge.net Raj -Original Message- From: Reuben D. Budiardja [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 19, 2003 11:54 AM To: Multiple recipients of list ORACLE-L Subject: DBA/Programmer GUI tool for Oracle in Linux Hello, I am rather new on using oracle in linux. I have some more experience with just programming web application with oracle as the backend database, but not so much with the administration of it. So, I am wondering what are some of the tool that you use for doing simple admin and programming tool. Nothing fancy, just probably a gui tool that can do Add/Remove user + password, create/drop table/column, alter table/column, and inserting data into table. I've seen TOAD before, but never really used it. But I think it's only run in MS Windows. So something similar to TOAD that runs in linux would be sufficient. I've tried TOra, it can do more stuff than I can understand right now, but it lacks basic things like dropping and creating table, altering table, etc. Any info will be greatly appreciated. Thanks in Advance Reuben D. Budiardja -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reuben D. Budiardja INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: Physical Design Question
Title: RE: Physical Design Question Exactly, We had that Windows Server monitoring database on a w2K box, and due to performance issues, the monitoring app used to put so much load on the boxes it was supposed to monitor that we had to crash the boxes in out test lab. So, we (DBA and Unix) generously offered them to host their db on our dev cluster. No one is complaining ... Our monitoring happens from a Linux cluster ... did we say we are paranoid about availability? Raj -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 18, 2003 6:08 PM To: [EMAIL PROTECTED] Cc: Jamadagni, Rajendra Subject: RE: Physical Design Question Importance: High 95% of my DBA work is done from linux. Most monitoring is done from linux as well. Jared Jamadagni, Rajendra [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/18/2003 10:29 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE: Physical Design Question Tom, for your amusement ... we have a software that keeps a tab on all the 2K servers we have and stores and monitors performance related information in its database. Works absolutely fine, but it is most stable when the database is on Oracle on Unix. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Sent: Friday, July 18, 2003 1:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: Physical Design Question isolated for you mere mortals! REAL MEN STRESS NT boxes!! *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: Increase tablespace, which way is better?
Title: Message We prefer to size them correctly to a max limit and then keep adding files. Because for each raw file, we have a backup file and a tertiary file. This helps in doing backups quickly and in case of crash, we can bring up the database on backup or tertiary data files. We prefer to add files. Raj -Original Message-From: Stephane Paquette [mailto:[EMAIL PROTECTED]Sent: Friday, July 18, 2003 5:15 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Increase tablespace, which way is better? Why not just resizing the file ? alter database datafile . resize 500M; Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of AKSent: Friday, July 18, 2003 4:59 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Increase tablespace, which way is better? what are u gaining in #1 . -ak - Original Message - From: Liu, Jack To: Multiple recipients of list ORACLE-L Sent: Friday, July 18, 2003 1:29 PM Subject: Increase tablespace, which way is better? Hi, I want to increase tablespace, just want to know which way is better:1. ALTER TABLESPACE SYSTEMADD DATAFILE '/u01/oradata/orcl/users02.dbf'SIZE 1MAUTOEXTEND ONNEXT 1MMAXSIZE 100M; 2.alter tablespace system add datafile '/u01/oradata/orcl/users02.dbf' size 100m; Thanks, Jack This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Re: faq broke? -- Other options
Don't think that the only searchable archives are on orafaq. Fat City has the definitive archives that date back to the start of the list here. You should consider using the archives here as well. You can find them here: http://www.listguru.com thanks, bruce -Original Message- Sent: Thursday, July 17, 2003 9:20 AM To: Multiple recipients of list ORACLE-L Is it just me, or . . . I have not been able to search the faq archives all week (www.orfaq.net). When I find a match and try to open it, I get a message Our apologies. The page you are looking for might have been removed, had its name changed, or is temporarily unavailable Is it just me, or are others having problems? Barb -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruce A. Bergman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: imp table data, but not PK indexes?
PK is a constraint too constraints=Y by default. --- Ganesh Raja [EMAIL PROTECTED] wrote: Use the Indexes = N Option and Create the Index Seperatley .. AFAIK that should work ... Regards, Ganesh R HP : (+65)9067-8474 Mail : [EMAIL PROTECTED] == All Opinions expressed are my own and do not in anyway reflect those of my employer == -Original Message- Guang Mei Sent: Saturday, July 19, 2003 10:14 PM To: Multiple recipients of list ORACLE-L Hi, I sent this yesterday but it did not seem to get posted. Anyway I am posting it again. I am trying to speed up a schema imp process by import data and indexes separately to an Oracle 8173 db. While importing table data, I don't want to import PK indexes which are sitting in tablespace indexes (because I can create PK indexes later from a script), So I have this running before imp data: alter user ABC quota 0 on indexes; alter user ABC quota unlimited on ABC_DEFAULT_TS; I found that this way the PK indexes are imported in ABC_DEFAULT_TS, together with table data. So my question is what I can/should do so that I can imp only table data into ABC_DEFAULT_TS, and not imp PK indexes at the same time? Thanks. Guang -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei 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: Ganesh Raja 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!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ravi Kulkarni 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).
Antw: DBA/Programmer GUI tool for Oracle in Linux
Hi there! I am using the Oracle Enterprise Manager. Just download Oracle for Linux and install only the whole client part inlcuding OEM. It has the whole functionality even fro new feature and is included in your server license if you are not using enhanced version. Sven -- Sven Jensen Unix/Oracle Administration Talkline GmbH Co. KG E-Mail: [EMAIL PROTECTED] Phone : +49-4121-41-2458 [EMAIL PROTECTED] 19.07.03 17:54:24 Hello, I am rather new on using oracle in linux. I have some more experience with just programming web application with oracle as the backend database, but not so much with the administration of it. So, I am wondering what are some of the tool that you use for doing simple admin and programming tool. Nothing fancy, just probably a gui tool that can do Add/Remove user + password, create/drop table/column, alter table/column, and inserting data into table. I've seen TOAD before, but never really used it. But I think it's only run in MS Windows. So something similar to TOAD that runs in linux would be sufficient. I've tried TOra, it can do more stuff than I can understand right now, but it lacks basic things like dropping and creating table, altering table, etc. Any info will be greatly appreciated. Thanks in Advance Reuben D. Budiardja -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reuben D. Budiardja 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: Jensen Sven INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: imp table data, but not PK indexes?
- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, July 20, 2003 2:04 AM as PK comes under 'constraints' you might also have to do constraints=N also... On Sat, 19 Jul 2003 07:04:23 -0800, Ganesh Raja [EMAIL PROTECTED] wrote : Use the Indexes = N Option and Create the Index Seperatley .. Yes, but IIRC CONSTRAINTS=Y is an exp parameter, not imp? Best way to handle these things is to export twice. Once with all the bells and whistles turned on but ROWS=N (this gives you a small export file with all the schema logic added and takes no time at all). The next one is with CONSTRAINTS=N, ROWS=Y, INDEXES=N, DIRECT=Y. This one is used for bulk data load. With these two exports, one can do just about any manipulation needed. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto 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).