Default database blocksize
Hi, How do I check the default database blocksize ? Thanks. Regds, New DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Question abount Unique Keys
Without diving into the docs, the differences I can think of are that a unique index is just that, an index that will not allow duplicate values on the key, as long as none of the columns are nullable. A unique constraint is a different beastie. It can be referred to by a foreign key, and just as a PK requires an index to help enforce it effeciently, so does a unique constraint. Jared On Tuesday 10 April 2001 20:53, Helmut Daiminger wrote: Hi! I have a question about unique keys: When I issue the statement CREATE UNIQUE INDEX UK_TBDOCUMENT ON TBDOCUMENT(DOCUMENTID) Oracle creates a unique index (as in user_indexes) but no unique constraint (as in user_constraints) When I issue that statement in a create table statement create table CONSTRAINT UK_TBDOCUMENT UNIQUE (DOCUMENTID) Oracle creates a unique constraint plus an index. Why is Oracle doing this? Could somebody please shed some light on this? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: shell script to compare nos.
Hello, I need some help in comparing 2 nos. in a unix shell. 1) e.g var1="7.04.03" and var2="7.05" I want to test:- if [ "$var2" "$var1" ];then then $var2 version is greater than $var1" fi 2) 2nd condition is :- var1="7.04.03" var2="7.04.02" I want to test:- if [ "$var1" "$var2" ];then then $var1 version is greater than $var2" fi How can I do the above in shell? Can you please help me, a seemingly simple one! Raja Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: shell script to compare nos.
Hello, I need some help in comparing 2 nos. in a unix shell. 1) e.g var1="7.04.03" and var2="7.05" I want to test:- if [ "$var2" "$var1" ];then then $var2 version is greater than $var1" fi 2) 2nd condition is :- var1="7.04.03" var2="7.04.02" I want to test:- if [ "$var1" "$var2" ];then then $var1 version is greater than $var2" fi Can some one send me a code? How can I do the above in shell? Can you please help me, a seemingly simple one! Raja Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Parallel Query Question
My attachmenst ( sql files ) apparently didn't make it to the list, although someone was able to send a meg of log file stuff to everyone. I'll have to check into that... Jared On Tuesday 10 April 2001 20:53, Jared Still wrote: Here's a few. Jared On Tuesday 10 April 2001 14:15, Chuck Hamilton wrote: Looks like my first email got truncated so I'll try again. Is there a way to associate parallel query processes with the session that's running the query? - Do You Yahoo!? Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Default database blocksize
u can check it from listing the db_block_size parameter. when u don't specify or change it while creating a new database it is set to default, which is 2048 bytes i.e. 2k on NT, may differ on OS. saurabh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 11, 2001 12:40 PM Hi, How do I check the default database blocksize ? Thanks. Regds, New DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saurabh Sharma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How can you have 2 default_domain's in sqlnet.ora
What we do is to take out the NAMES.DEFAULT_DOMAIN altogether. Instead, I have set up aliases on the names server so that each d/b can be accessed by its db_name alone, as well as by the full global_name. Not sure that this fully covers your problem, but it works for us. David Lord Senior DBA, Hays Commercial Services, IT Solutions -Original Message- Sent: 09 April 2001 19:16 To: Multiple recipients of list ORACLE-L Dear Guru's, We have to have some of our users also be users on another system. The folks who are running this system said we should add another NAMES.DEFAULT_DOMAIN= NEW_DOMAIN to our sqlnet.ora for these users. The default_domain is already specified in their sqlnet.ora as the domain for our databases. How can we point to both domains? Any help will be greatly appreciated. Ruth B. Gramolini ORACLE DB2 DBA VT Dept. of Taxes ph# 802.828.5708 fax# 802.828..3754 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord David INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OCP: Book review - midnight madness.
I have this problem. This book (Couchman Oracle 8 OCP) just seems to sit on my shelf, next to 2 other OCP books, and not want to move. Somehow, the term "OCP Study Guide" or "Certification Exam Guide" makes a book seem so much less appealing than the term "101". "101" makes me think - this won't make my brain hurt. I can read it in a couple of sittings, and lend it to a friend afterwards. "Beginner's Guide" is way too newbie. Can't even think of walking to a checkout line in a bookstore with that. "Learning ..." works better for me than "Beginner's Guide". "Learning the Korn Shell", "... Python" and "... the vi Editor" are recent purchases that are still awaiting initial binding-cracking. But they're all tools that I want to learn. Ka-ching. "Using ..." is inviting in a practical way - as in - the reason why you installed that module in the first place. Some things - are such a battle to install, that after you complete the install, the *use* part gets forgotten. No wonder we need 60 GB hard drives - for room for installing the things that we never end up using, but might. I think that "Handbook" is still appealing, but more in a pick it up to look something up, and put it back kind of way. The word "Practical" works for me. "Essential" I usually construe as '4 years outdated'. "Definitive Guide" might have been so in its time, but usually a full version ago. "In a nutshell" usually means - this is a book that I might possibly read someday - but its highly unlikely - and a handbook will probably offer better reference. "Webmaster in a nutshell" - what was I thinking? Some books I wonder - who was running the show that day - "Windows 2000 Active Directory?" I guess I really wanted to implement LDAP for external authentication. To sum up this nonsense, its the immediate usefulness that drives me to actually fetch the text from the shelf. Or, in a more Torvalds way of thinking - the *entertainment factor* needs to be higher. But that's me - looking for entertainment in a technical reference. thanks for tuning in. Pd "Bala, Prakash" wrote: Hi, Please let me know your views on the following 2 books by Jason Couchman: Oracle8i Certified Professional DBA Certification Exam Guide Oracle8i Certified Professional DBA Practice Exams Thanks Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bala, Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Default database blocksize
select value from v$parameter where name='db_block_size'; "CHAN Chor Ling Catherine (CSC)" wrote: Hi, How do I check the default database blocksize ? Thanks. Regds, New DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Optimizer theory: Question on access paths for outer joins
Hi Jay, Under rule based optimization deficient (outer joined) relations are always last in the join order. In general cost based optimization will do the same, but it is not bound to do so. For example, if T2 below is a complex view, then it cannot be merged into the parent query because it is being outer joined. That would mean that the view must be instantiated and accessed via a sort-merge join or hash join or used to drive query. If so, the optimizer may well choose to instantiate the view and drive the query as a nested loops join from there. However, in general it will no do so without a good reason. In this case however I suspect that the problem is that at least one of the in-line views T0 and T1 are mergeable. Because the merging of in-line views is done before query optimization, the optimizer never gets to consider the cardinality of the potential instantiations of the in-line views. The optimizer is presented with a merged query involving all the base tables for the merged views and PHONE and ACCOUNT. Worse than that, because transitivity analysis is not done for join predicates, you end up with an almost linear join topology. Also, because PHONE and T2 are outer joined, OR expansion and IN-list iterators cannot be used (lest duplicates might be introduced) to obtain index-based access paths to the other base tables involved and thus driving the query from PHONE (or from an index on ACCOUNT with your extraneous predicate) is natural. If this analysis is right, and you are right about the cardinality of the in-line views, the correct approach to optimizing this query is to place a NO_MERGE hint in the query block for the relevant in-line views, move T2 to the end of the from clause, and place ORDERED and USE_HASH(T2) hints in the outer query block. Hope this help, @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Hi all, I was just trying to figure out why in an outer join Oracle prefers to access the table with the (+) first. I would have thought that the table from which all the data was coming would come first and then appropriate rows would come from the second table with nulls being generated for non-existent rows. I started looking at it because of the following query: Simplified SQL: select stuff from inlineview1 T0, inlineview2 T1, inlineview3 T2, account ac, phone ph where T0.generic_id = T1.account_id and T1.account_id = T2.account_id (+) and T1.valid_flag = T2.valid_flag (+) and T0.generic_id = ac.id and ac.id = ph.current_phone_id(+) In this query the inline views are rather complicated but apply substantial restrictions on ACCOUNT (a huge table, as is PHONE). Logically, it is faster to run the inline views first, join them to ACCOUNT and then go to PHONE. The Optimizer kept doing a full table scan on PHONE first, and then joining to Account. I tried ORDERED, FIRST_ROWS and INDEX hints to no avail. The hints work if I take away the outer join symbol (but of course this gives incomplete results). I finally tricked Oracle into going in the correct order by adding a WHERE clause to the ACCOUNT of AND ac.id 0 (presumably causing the Optimizer to think there's more of a restriction on ACCOUNT and therefore taking it first). Since id is always greater than 0 this doesn't change the results but makes the query run much faster. So I have it working the way I want, but I'm still wonderinG why the Optimizer prefers to read the (+) table first? From the "Everything you always Wanted to Know About the Oracle Optimizer" book I know that the Optimizer tries to sort the join orders in ascending order of their computed cardinality. I'd guess that the Optimizer assumes an outer joined table will be returning some default percentage of the other table and therefore should always be accessed first? Can anyone confirm or refute this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Patches
Hi, since I don't have Meta Link, where can I possibly get any Oracle patches/updates etc. ? -- Regards, Stefan Jahnke BOV AG @:D2 Vodafone, Abt.: FIBM AMS-Gebude: E6 R08 Tel.: 0211/533-4893 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Default database blocksize
Hi, I've found the answer : SELECT * FROM V$PARAMETER WHERE NAME='db_block_size' Regds, New DBA -Original Message- From: CHAN Chor Ling Catherine (CSC) Sent: Wednesday, April 11, 2001 3:11 PM To: Multiple recipients of list ORACLE-L Subject:Default database blocksize Hi, How do I check the default database blocksize ? Thanks. Regds, New DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Default database blocksize
SQL show parameter db_block_size NAME TYPEVALUE --- - db_block_sizeinteger 8192 Regards Mark -Original Message- Ling Catherine (CSC) Sent: Wednesday, April 11, 2001 08:11 To: Multiple recipients of list ORACLE-L Hi, How do I check the default database blocksize ? Thanks. Regds, New DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Error-00103 While Creating Type
Dear Vadim Gorbounov Thank you, very much. It works. I was missing 'AS OBJECT' Thanx once again. Regards, Aleem -Original Message- Sent: Tuesday, April 10, 2001 8:13 PM To: Multiple recipients of list ORACLE-L Subject:RE: Error-00103 While Creating Type Hi, Aleem, Try this: CREATE OR REPLACE TYPE abc as object ( Emp_Name VARCHAR2(30), Emp_Desgn VARCHAR2(30), Emp_Addrs VARCHAR2(50) ); / Hope this helps Vadim Gorbounov Oracle DBA -Original Message- Sent: Tuesday, April 10, 2001 3:20 AM To: Multiple recipients of list ORACLE-L Thanks, I used Abc, Test_1 etc. but the error remains. Any other suggestion! TIA Aleem -Original Message- Sent: Monday, April 09, 2001 9:46 PM To: Multiple recipients of list ORACLE-L Subject:RE: Error-00103 While Creating Type Test is a reserved word. Use TEST_1 and everything will be all right. -Original Message- Sent: Saturday, April 07, 2001 3:00 AM To: Multiple recipients of list ORACLE-L Hi! When I execute the following code on Oracle 8i release 3 (8.1.7) CREATE OR REPLACE TYPE Test ( Emp_Name VARCHAR2(30), Emp_Desgn VARCHAR2(30), Emp_Addrs VARCHAR2(50) ); It gives error "Type created with compilation errors". The All_Errors view indicates Error-00103 at line 2 position 6 "Encountered symbol '(' when expecting ; is authid as compress compiled wrapped' TIA Regards, Aleem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: shell script to send mail
Hi, you can run mailx in verbose and then check the messages for any errors echo "this is a test" | mailx -v -s "from the sco box" [EMAIL PROTECTED] cheers alex Hello, This is the second time I am writing this message, dont know what happened where the last message went. Basically wanted to thank every one who ever responded, with this easy construct in the shell. But the problem, is that I sent like this, mailx -s "from the sco box" [EMAIL PROTECTED] msg where msg is a regular file and contains the string - this is a test only But I have waited for a long time and it did not appear in the above address. Any ideas why it did not reach. I have looked at the man for mailx, and I have already checked the various files, like dead.letter etc. but of no use, it simply does not exist. Please help. Regards, Raja -- On Tue, 10 Apr 2001 09:15:40 SHAIBAL TALUKDER wrote: Raja, If you have unix mail utility you can send mail form unix. At the system prompt type - mailx -s "Subject" [EMAIL PROTECTED] msg hope this helps. Shaibal Viraj Luthra [EMAIL PROTECTED] wrote: Paul, I dont need that software. I need the code to write in my software itself. rgds, raja -- On Mon, 09 Apr 2001 21:10:52 Paul Drake wrote: check out tripwire ... http://sourceforge.net/projects/tripwire/ Viraj Luthra wrote: Hello all, I need help. I need to write a shell script (aix box), when ever some loads a piece of software. thanks raja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists - Do You Yahoo!? Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail. Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Apostolopoulos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Optimizer theory: Question on access paths for outer joins
Hi Jay, Under rule based optimization deficient (outer joined) relations are always last in the join order. In general cost based optimization will do the same, but it is not bound to do so. For example, if T2 below is a complex view, then it cannot be merged into the parent query because it is being outer joined. That would mean that the view must be instantiated and accessed via a sort-merge join or hash join or used to drive query. If so, the optimizer may well choose to instantiate the view and drive the query as a nested loops join from there. However, in general it will no do so without a good reason. In this case however I suspect that the problem is that at least one of the in-line views T0 and T1 are mergeable. Because the merging of in-line views is done before query optimization, the optimizer never gets to consider the cardinality of the potential instantiations of the in-line views. The optimizer is presented with a merged query involving all the base tables for the merged views and PHONE and ACCOUNT. Worse than that, because transitivity analysis is not done for join predicates, you end up with an almost linear join topology. Also, because PHONE and T2 are outer joined, OR expansion and IN-list iterators cannot be used (lest duplicates might be introduced) to obtain index-based access paths to the other base tables involved and thus driving the query from PHONE (or from an index on ACCOUNT with your extraneous predicate) is natural. If this analysis is right, and you are right about the cardinality of the in-line views, the correct approach to optimizing this query is to place a NO_MERGE hint in the query block for the relevant in-line views, move T2 to the end of the from clause, and place ORDERED and USE_HASH(T2) hints in the outer query block. Hope this help, @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Hi all, I was just trying to figure out why in an outer join Oracle prefers to access the table with the (+) first. I would have thought that the table from which all the data was coming would come first and then appropriate rows would come from the second table with nulls being generated for non-existent rows. I started looking at it because of the following query: Simplified SQL: select stuff from inlineview1 T0, inlineview2 T1, inlineview3 T2, account ac, phone ph where T0.generic_id = T1.account_id and T1.account_id = T2.account_id (+) and T1.valid_flag = T2.valid_flag (+) and T0.generic_id = ac.id and ac.id = ph.current_phone_id(+) In this query the inline views are rather complicated but apply substantial restrictions on ACCOUNT (a huge table, as is PHONE). Logically, it is faster to run the inline views first, join them to ACCOUNT and then go to PHONE. The Optimizer kept doing a full table scan on PHONE first, and then joining to Account. I tried ORDERED, FIRST_ROWS and INDEX hints to no avail. The hints work if I take away the outer join symbol (but of course this gives incomplete results). I finally tricked Oracle into going in the correct order by adding a WHERE clause to the ACCOUNT of AND ac.id 0 (presumably causing the Optimizer to think there's more of a restriction on ACCOUNT and therefore taking it first). Since id is always greater than 0 this doesn't change the results but makes the query run much faster. So I have it working the way I want, but I'm still wonderinG why the Optimizer prefers to read the (+) table first? From the "Everything you always Wanted to Know About the Oracle Optimizer" book I know that the Optimizer tries to sort the join orders in ascending order of their computed cardinality. I'd guess that the Optimizer assumes an outer joined table will be returning some default percentage of the other table and therefore should always be accessed first? Can anyone confirm or refute this? - You can view this message online at http://www.ixora.com.au/q+a/0104/11164729.htm To unsubscribe from Ixora Answers send a blank email to [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: shell script to compare nos.
Hi I'm sure there are better ways but awk does the trick echo $var1 $var2 | awk '{ if ( $1 $2 ) { print "1"} else { print"0" } }' cheers alex Hello, I need some help in comparing 2 nos. in a unix shell. 1) e.g var1="7.04.03" and var2="7.05" I want to test:- if [ "$var2" "$var1" ];then then $var2 version is greater than $var1" fi 2) 2nd condition is :- var1="7.04.03" var2="7.04.02" I want to test:- if [ "$var1" "$var2" ];then then $var1 version is greater than $var2" fi Can some one send me a code? How can I do the above in shell? Can you please help me, a seemingly simple one! Raja Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Apostolopoulos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Temporarily Renaming the sgadefSID.dbf File
Hi We clone very frequent (once a week at least) on the same machine and never encountered that problem yet, What are the steps you are taking?? Jack "Morrow, Steve" To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] SMorrow@admin cc: .usf.eduSubject: Temporarily Renaming the sgadefSID.dbf File Sent by: [EMAIL PROTECTED] om 10-04-2001 22:35 Please respond to ORACLE-L Hi All, Trying to clone our PROD to a test database on the same machine for testing our 734--8i upgrade, and of course we're encountering the "can't-start-the-new-without-shutting-down-the-old" database problem (ie, ORA-9782 on the CREATE CONTROLFILE command). We've worked around this in the past by scheduling a time to bring down PROD. I know that this is the safest, most reliable way (besides NOT doing this on a production box...but I have no choice), but believe it or not, I actually saw a reference on a Metalink forum to rename the sgadefSID.dbf file, start up the new database, then rename the file to its original name. Obviously sgadef gets created at instance startup as a memory map, but it doesn't look like it's used for anything after that (it's certainly doesn't seem to be written to). I do know that you can get an octal dump of the file to determine the shared memory ID for whatever reason. Everything else I've heard/seen about this file has pretty much said DON'T TOUCH IT!!! But if the instance only uses it at instance startup, is there any harm in renaming it temporarily to get the other database up? If so...why? And have any of you tried renaming or deleting the file in your cloning (or other) efforts? Did it blow up, or work? TIA, Steve _ Steve Morrow IT/Tech Support University of South Florida phone: 813-974-5519 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Morrow, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopien te verwijderen en te vernietigen. Ernst
RE: OT: shell script to compare nos.
Why not simply do the following passing two parameters to the script eg. call the script test.sh and call it so test.sh 2 1 This results in output "VAR1 is greater than VAR2" then test.sh 1 2 this results in output "VAR2 is greater than VAR1" Cheers. #!/bin/ksh VAR1=$1 VAR2=$2 if [ "$VAR1" -gt "$VAR2" ] then echo "VAR1 is greater than VAR2" else echo "VAR2 is greater than VAR1" fi -Original Message- Sent: 11 April 2001 10:01 To: Multiple recipients of list ORACLE-L Hi I'm sure there are better ways but awk does the trick echo $var1 $var2 | awk '{ if ( $1 $2 ) { print "1"} else { print"0" } }' cheers alex Hello, I need some help in comparing 2 nos. in a unix shell. 1) e.g var1="7.04.03" and var2="7.05" I want to test:- if [ "$var2" "$var1" ];then then $var2 version is greater than $var1" fi 2) 2nd condition is :- var1="7.04.03" var2="7.04.02" I want to test:- if [ "$var1" "$var2" ];then then $var1 version is greater than $var2" fi Can some one send me a code? How can I do the above in shell? Can you please help me, a seemingly simple one! Raja Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Apostolopoulos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: shell script to compare nos.
OK then try the following #!/bin/ksh VAR1=$1 VAR2=$2 opersign=`echo "$VAR1 - $VAR2"|bc| cut -c1` if [ "$opersign" = "-" ] then echo "VAR2 is greater than VAR1" else echo "VAR1 is greater than VAR2" fi That should definitely work. Cheers Lee - Using no book and currently at Acxiom in the UK. -Original Message- Sent: 11 April 2001 11:07 To: 'lerobe - Lee Robertson' Hi Lee, This script only works when the numbers to be compared are whole numbers. It always gives out the result "VAR2 is greater than Var1" when the numbers are real like 7.1, 7.023, 8.6, 9.7 etc. How to return the correct result when the numbers are real? BTW which book do you refer for Korn shell scripting? Where are you now? Whom are you working for? Regards, Ranganath -Original Message- Lee Robertson Sent: Wednesday, April 11, 2001 4:01 PM To: Multiple recipients of list ORACLE-L Why not simply do the following passing two parameters to the script eg. call the script test.sh and call it so test.sh 2 1 This results in output "VAR1 is greater than VAR2" then test.sh 1 2 this results in output "VAR2 is greater than VAR1" Cheers. #!/bin/ksh VAR1=$1 VAR2=$2 if [ "$VAR1" -gt "$VAR2" ] then echo "VAR1 is greater than VAR2" else echo "VAR2 is greater than VAR1" fi -Original Message- Sent: 11 April 2001 10:01 To: Multiple recipients of list ORACLE-L Hi I'm sure there are better ways but awk does the trick echo $var1 $var2 | awk '{ if ( $1 $2 ) { print "1"} else { print"0" } }' cheers alex Hello, I need some help in comparing 2 nos. in a unix shell. 1) e.g var1="7.04.03" and var2="7.05" I want to test:- if [ "$var2" "$var1" ];then then $var2 version is greater than $var1" fi 2) 2nd condition is :- var1="7.04.03" var2="7.04.02" I want to test:- if [ "$var1" "$var2" ];then then $var1 version is greater than $var2" fi Can some one send me a code? How can I do the above in shell? Can you please help me, a seemingly simple one! Raja Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Apostolopoulos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Parallel Query Question
Hi Chuck, I think this should do what you want. select p.inst_idcoord_instance, p.indx coord_pid, s.inst_idslave_instance, s.kxfpdpnum slave_pid from x$kxfpdp s, x$ksupr p where s.kxfpdpnum != 999 and p.addr = s.kxfpdpcpr and p.inst_id = s.kxfpdpcin order by 1, 2, 3, 4 / @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Wednesday, 11 April 2001 7:16 To: Multiple recipients of list ORACLE-L Is there a way to associate parallel query processes with the session that's running the query? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Quote Of The Day
Add a couple more to the list - the first and second in the series, Wizard's Bane and The Wizardry Compiled. These two are probably out of stock, so amazon wouldn't list them. Terry Rachel Carmichael wrote: Mall Purchase Night The Wiz Biz The Wizardry Quested The Wizardry Consulted The Wizardry Cursed no, I haven't read any of these. But my mom was a librarian and I know how to do research (amazon.com is a wonderful thing :) ) Rachel From: Terry Ball [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Fwd: Quote Of The Day Date: Tue, 10 Apr 2001 08:50:22 -0800 Rick Cook is a Fantasy writer. One of his series is about a coputer wizard who gets pulled into an alternate universe where magic works. And, in this case, it works by way of computer programs. Rick Cook says he is computer illiterate, but knows many people who work with computers. He has a lot of truisms in his books. (Can't for the life of me remember the title of any of them). I find them a good,. humorous read. Terry Jared Still wrote: I don't know who Rich Cook is, but I like him. ;) Jared - Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.--Rich Cook -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- 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: Terry Ball INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: shell script to send mail
Raja, Do you have your sendmail running, Does it have access to the outside world to be able to "send" the mail? Check the logs and message status to determine the problem. ROR mm [EMAIL PROTECTED] 04/11/01 12:10AM Hello, This is the second time I am writing this message, dont know what happened where the last message went. Basically wanted to thank every one who ever responded, with this easy construct in the shell. But the problem, is that I sent like this, mailx -s "from the sco box" [EMAIL PROTECTED] msg where msg is a regular file and contains the string - this is a test only But I have waited for a long time and it did not appear in the above address. Any ideas why it did not reach. I have looked at the man for mailx, and I have already checked the various files, like dead.letter etc. but of no use, it simply does not exist. Please help. Regards, Raja -- On Tue, 10 Apr 2001 09:15:40 SHAIBAL TALUKDER wrote: Raja, If you have unix mail utility you can send mail form unix. At the system prompt type - mailx -s "Subject" [EMAIL PROTECTED] msg hope this helps. Shaibal Viraj Luthra [EMAIL PROTECTED] wrote: Paul, I dont need that software. I need the code to write in my software itself. rgds, raja -- On Mon, 09 Apr 2001 21:10:52 Paul Drake wrote: check out tripwire ... http://sourceforge.net/projects/tripwire/ Viraj Luthra wrote: Hello all, I need help. I need to write a shell script (aix box), when ever some loads a piece of software. thanks raja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists - Do You Yahoo!? Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail. Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: shell script to compare nos.
But this does not work for real numbers, ex: 2.51 ot 2.01, it compares only integers -Message d'origine- De : lerobe - Lee Robertson [mailto:[EMAIL PROTECTED]] Envoy : mercredi 11 avril 2001 12:31 : Multiple recipients of list ORACLE-L Objet : RE: OT: shell script to compare nos. Why not simply do the following passing two parameters to the script eg. call the script test.sh and call it so test.sh 2 1 This results in output "VAR1 is greater than VAR2" then test.sh 1 2 this results in output "VAR2 is greater than VAR1" Cheers. #!/bin/ksh VAR1=$1 VAR2=$2 if [ "$VAR1" -gt "$VAR2" ] then echo "VAR1 is greater than VAR2" else echo "VAR2 is greater than VAR1" fi -Original Message- Sent: 11 April 2001 10:01 To: Multiple recipients of list ORACLE-L Hi I'm sure there are better ways but awk does the trick echo $var1 $var2 | awk '{ if ( $1 $2 ) { print "1"} else { print"0" } }' cheers alex Hello, I need some help in comparing 2 nos. in a unix shell. 1) e.g var1="7.04.03" and var2="7.05" I want to test:- if [ "$var2" "$var1" ];then then $var2 version is greater than $var1" fi 2) 2nd condition is :- var1="7.04.03" var2="7.04.02" I want to test:- if [ "$var1" "$var2" ];then then $var1 version is greater than $var2" fi Can some one send me a code? How can I do the above in shell? Can you please help me, a seemingly simple one! Raja Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Apostolopoulos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ALEMU Abiy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Temporarily Renaming the sgadefSID.dbf File
Hi Steve I have actually done exactly what you are thinking of trying several times over i.e. renamed the sgadefSID.dbf file when trying to clone a database. Once the clone was created I just renamed it to its original name with no problems. Regards Natasha - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 10, 2001 4:35 PM Hi All, Trying to clone our PROD to a test database on the same machine for testing our 734--8i upgrade, and of course we're encountering the "can't-start-the-new-without-shutting-down-the-old" database problem (ie, ORA-9782 on the CREATE CONTROLFILE command). We've worked around this in the past by scheduling a time to bring down PROD. I know that this is the safest, most reliable way (besides NOT doing this on a production box...but I have no choice), but believe it or not, I actually saw a reference on a Metalink forum to rename the sgadefSID.dbf file, start up the new database, then rename the file to its original name. Obviously sgadef gets created at instance startup as a memory map, but it doesn't look like it's used for anything after that (it's certainly doesn't seem to be written to). I do know that you can get an octal dump of the file to determine the shared memory ID for whatever reason. Everything else I've heard/seen about this file has pretty much said DON'T TOUCH IT!!! But if the instance only uses it at instance startup, is there any harm in renaming it temporarily to get the other database up? If so...why? And have any of you tried renaming or deleting the file in your cloning (or other) efforts? Did it blow up, or work? TIA, Steve _ Steve Morrow IT/Tech Support University of South Florida phone: 813-974-5519 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Morrow, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Natasha Batson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
XML SQL (XSU) Errors
Good morning everyone - Has anyone successfully installed and used the XML SQL (XSU) utility? I'm getting this error and 1. there's nothing on Metalink that tells me exactly why I am missing this resource/class or where to get it and 2. I'm pretty sure I installed everything correctly - including the PL/SQL XML parser. The code executing here is trying to take a CLOBwith only two xml fields and insert it into a table using DBMS_XMLSave via PL/SQL. To make everything even better, I was told yesterday that our support contract expired two days ago. The joys of working for a small company. Any experiences or comments are appreciated. Thanks SQL @test_xmlORA-29532: Java call terminated by uncaught Java exception:java.util.MissingResourceException: can't find resource fororacle.xml.sql.mesg.XSUMessages_en_US PL/SQL procedure successfully completed. SQL Lisa Rutland KoivuOracle Database Administrator[EMAIL PROTECTED]4850 N. State Rd. 7, #G104 Ft. Lauderdale, FL 33319 Phone: 954.484.3191 Fax: 954.484.2933 www.neom.comwww.paperclick.comwww.qode.com
Re: How can you have 2 default_domain's in sqlnet.ora
Thanks for the reply. The problem is actually with the other domain's application. We just used their domain as the default because our tnsnames.ora has fully qualified service_names/ Regards, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, April 11, 2001 4:55 AM What we do is to take out the NAMES.DEFAULT_DOMAIN altogether. Instead, I have set up aliases on the names server so that each d/b can be accessed by its db_name alone, as well as by the full global_name. Not sure that this fully covers your problem, but it works for us. David Lord Senior DBA, Hays Commercial Services, IT Solutions -Original Message- Sent: 09 April 2001 19:16 To: Multiple recipients of list ORACLE-L Dear Guru's, We have to have some of our users also be users on another system. The folks who are running this system said we should add another NAMES.DEFAULT_DOMAIN= NEW_DOMAIN to our sqlnet.ora for these users. The default_domain is already specified in their sqlnet.ora as the domain for our databases. How can we point to both domains? Any help will be greatly appreciated. Ruth B. Gramolini ORACLE DB2 DBA VT Dept. of Taxes ph# 802.828.5708 fax# 802.828..3754 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord David INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Question abount Unique Keys
Hi, I think it's a different approach. If you create a constraint, you actually tell Oracle that you want to set up some kind of data integrity. A unique key constraint in your case. Since Oracle has to do something in order to achieve this, it goes ahead and creates a Unique Index. You can refer to this constraint in order to built referential integrity (foreign keys). Nevertheless, you can just build the unique index, let's say to speed up some queries and making sure to only retrieve one row per condition on the unique index without havin g to use distinct (AFAIK, distinct forces Oracle to do a full tablescan first, and then get rid of the redundant entries in the resultset to return). Basically, just a different approach -- Regards, Stefan Jahnke @:D2 Vodafone Jared Still schrieb: Without diving into the docs, the differences I can think of are that a unique index is just that, an index that will not allow duplicate values on the key, as long as none of the columns are nullable. A unique constraint is a different beastie. It can be referred to by a foreign key, and just as a PK requires an index to help enforce it effeciently, so does a unique constraint. Jared On Tuesday 10 April 2001 20:53, Helmut Daiminger wrote: Hi! I have a question about unique keys: When I issue the statement CREATE UNIQUE INDEX UK_TBDOCUMENT ON TBDOCUMENT(DOCUMENTID) Oracle creates a unique index (as in user_indexes) but no unique constraint (as in user_constraints) When I issue that statement in a create table statement create table CONSTRAINT UK_TBDOCUMENT UNIQUE (DOCUMENTID) Oracle creates a unique constraint plus an index. Why is Oracle doing this? Could somebody please shed some light on this? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Patches
try oracle-ftp.us.oracle.com -Daniel -Original Message- Jahnke Sent: Wednesday, April 11, 2001 4:30 AM To: Multiple recipients of list ORACLE-L Hi, since I don't have Meta Link, where can I possibly get any Oracle patches/updates etc. ? -- Regards, Stefan Jahnke BOV AG @:D2 Vodafone, Abt.: FIBM AMS-Gebude: E6 R08 Tel.: 0211/533-4893 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Daniel Harron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: shell script to send mail
Viraj, As I remember, your initial query mentioned you were trying to send a message from an AIX box. First check to see if sendmail is running on your system. Execute the command ps -ef |grep sendmail . You should receive a response that includes a line like the following: root 3900 2084 0 Mar 24 - 0:01 sendmail: accepting connections If you don't, then your system isn't going to send any mail, because it isn't configured. If it's running, check your /etc/sendmail.cf file. This may be the cause of your problem. Remember, if you make any changes to this file, you must recompile it and issue the refresh -s sendmail command before it becomes effective. Your problem may also lie in the /etc/aliases file. This also needs to be recompiled and the refresh command issued if changed. There is a little bit of work required in setting up sendmail on any UNIX system - not just AIX - but these are three good places to look for problems to begin with. I suggest you get a copy of O'Reilly's Sendmail if you're going to be using mail from UNIX boxes on a regular basis. Assuming your sendmail is running, AIX uses the commands mail, Mail, and mailx interchangeably. I just use mail (cause I hate to type extra characters). Make sure you're executing the mail command from the directory containing the msg file, otherwise you'll need a fully qualified path. Try using single quotes instead of double quotes around your subject. To see if your box is sending mail at all try: mail -s 'Test' myusername@myunixhostnamemsg If you don't get the mail, see your sys admin. If you do, then the problem most likely lies in one of the two files I mentioned earlier. You'll probably need to see your sys admin there as well. Hope this helps. David A. Barbour Oracle DBA Viraj Luthra wrote: Hello, This is the second time I am writing this message, dont know what happened where the last message went. Basically wanted to thank every one who ever responded, with this easy construct in the shell. But the problem, is that I sent like this, mailx -s "from the sco box" [EMAIL PROTECTED] msg where msg is a regular file and contains the string - this is a test only But I have waited for a long time and it did not appear in the above address. Any ideas why it did not reach. I have looked at the man for mailx, and I have already checked the various files, like dead.letter etc. but of no use, it simply does not exist. Please help. Regards, Raja -- On Tue, 10 Apr 2001 09:15:40 SHAIBAL TALUKDER wrote: Raja, If you have unix mail utility you can send mail form unix. At the system prompt type - mailx -s "Subject" [EMAIL PROTECTED] msg hope this helps. Shaibal Viraj Luthra [EMAIL PROTECTED] wrote: Paul, I dont need that software. I need the code to write in my software itself. rgds, raja -- On Mon, 09 Apr 2001 21:10:52 Paul Drake wrote: check out tripwire ... http://sourceforge.net/projects/tripwire/ Viraj Luthra wrote: Hello all, I need help. I need to write a shell script (aix box), when ever some loads a piece of software. thanks raja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists - Do You Yahoo!? Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail. Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).
RE: database links
Hi, Millie, Try this location ftp://oracle-ftp.oracle.com/server/ HTH Vadim Gorbounov Oracle DBA -Original Message- Sent: Wednesday, April 11, 2001 10:26 AM To: Multiple recipients of list ORACLE-L I have set the global_names parameter to false on my mainframe database ORS1 and recycled the data base. When I do a select * from global_name, it show the name of ORS1. When I do the same on the unix database dw1, it show the name of DW1.WORLD. When I do select * from dba_db_link on ORS1, it show other host as dw1.world. How can I change my global_name to be ors1.world? What should the SERVICE_NAME parameter be? We don't use this parameter, I tried serveral different names, but it didn't seem to make any difference. Thanks. Millie -Original Message- Sent: Saturday, April 07, 2001 2:00 AM To: Multiple recipients of list ORACLE-L Millie, Check both instances and verify if global_names parameter is switched on. What is the name of your db link? select * from global_name; Is it the same as global_name? I have a problems creating database links when I have global_names parameter set to TRUE. I normally switch global_names=false unless the application uses global_names. I create my database link using the connect description from my tnsnames.ora file for that instance. It normally works. eg. create database link test connect to jdatest identified by jdatest using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = odbms)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = test) ) )' ; This normally works for me. DB links are very fussy when it comes to global names. Also the name that is given to your db link when global names are used. HTH Suhen Suhen We are setting up a test Oracle 8i (8.1.7 with OSDI) on our mainframe (os/390 v2.8), we can connect to the database instance (ORS1) from windows NT client, but when we try to connect to it using database links set up from our unix platform, we get ORA-12154 TNS: Could not resolve service name When we try to link from ors1 I get: ORA-02019 Connection Description For Remote Database Not Found. We created a tar with Oracle and waiting to hear from them. Just wondering if anyone on the list has the same problem? Millie Chan Rutgers, The State University of New Jersey Administrative Computing Services 65 Davidson Road Piscataway, NJ 08855 Tel: (732)445-5433 EMAIL: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chan, Millie INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Chan, Millie INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
memory refresher
Hi all, If I am doing a migration of say 70 thousand records, isn't it a good idea to turn off all of my little rollback segments and turn on a couple of big rgs? And, how big do you guys think they should be if that is the case? I am trying to increase the performance of this migration, but it is not easy. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Patches
Hi, Stefan , try this ftp://oracle-ftp.oracle.com/server/ HTH Vadim Gorbounov Oracle DBA -Original Message- Sent: Wednesday, April 11, 2001 4:30 AM To: Multiple recipients of list ORACLE-L Hi, since I don't have Meta Link, where can I possibly get any Oracle patches/updates etc. ? -- Regards, Stefan Jahnke BOV AG @:D2 Vodafone, Abt.: FIBM AMS-Gebude: E6 R08 Tel.: 0211/533-4893 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
AR_TAX_INTERFACE - Vertex Issue
We have been updating our Tax rates through the AR_TAX_INTERFACE table using Vertex data since 1997 and only recently discovered that there was a problem. This issue may not be simply a Vertex issue as I believe it primarily lies in the process Oracle uses to apply the rate changes to the AR_LOCATION_RATES table. If you have been receiving feeds, applying them, and assumed that everything is correctly being updated, you need to take a look at the AR_TAX_INTERFACE table after the 'Sales Tax Rate Interface' program has been run. Check the STATUS field. What we found after one of our major customers complained was that we had over 7,000 records in this table with the 'NARROWER-ZIP-RANGE' status. When a record has this status, any new rates for the particular location_segment_id will not get updated. We have had a running TAR with Oracle since January 25th that has failed to correct this problem. They provided a script to end-date the records, but it left about 2000 records unchanged with the 'NARROWER-ZIP-RANGE' status. When we proceeded to apply the next month's data, the number of records jumped to over 14,000... We are frustrated! We recently tried to work with Vertex thinking that they could apply knowledge (and pressure) to get this resolved. Obviously, if we can't rely on the feed from vertex to correctly update our records, it doesn't make sense to pay an sizable annual fee to continue this service. The Vertex people were polite, but to date have not provided any quicker response from Oracle. If anyone has had this, and has a solution, PLEASE let us know. Thanks, -- 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: Need fragmentation reports
Nobody have a script for fragmantation report. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, April 09, 2001 4:45 PM We're trying to determine which partitioned tables are good candidates for reorganization due to fragmentation. Anybody got any good scripts that would detect various kinds of fragmentation. Perhaps someone could point me in the direction of some on various web sites? Thanks in advance for your help. Cherie Machler Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K.Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Partition by month (NOT INCLUDING YEAR)
List, I am attempting to partition a table based on the month, not the month and the year. I want all January records to go into the January partition (even if the records are from January 1998,1999,2000, or 2001). Any January record from any year all goes into one partition, any February record from any year goes into the February partition, etc...) I tried the following code, but no luck. Ideas?? Thanks! -Fred S. CREATE TABLE MEETING_ROOM_USAGE ( SEQ_MEETING_ROOM_USAGE NUMBER(18) NOT NULL, POLL_ID NUMBER(10) NOT NULL, PROPERTY_ID NUMBER(8) NOT NULL, IP_ADDRESS VARCHAR2(15) NULL, MAC_ADDRESS VARCHAR2(17) NULL, ACCESS_CODE VARCHAR2(20) NULL, CHARGE NUMBER(7,2) NULL, DURATION NUMBER(9) NULL, USAGE_DATE DATE NULL, ROOM_NUMBER VARCHAR2(20) NULL, COLLECTION_DATE DATE NULL, CUSTOMER VARCHAR2(50) NULL, USER_NAME VARCHAR2(50) NULL, CONSTRAINT PK_MEETING_ROOM_USAGE PRIMARY KEY (SEQ_MEETING_ROOM_USAGE)) PARTITION BY RANGE (USAGE_DATE) (PARTITION JANUARY values less than (TO_CHAR('02','MM')) TABLESPACE MONTH1_USAGE_TS, PARTITION FEBRUARY values less than (TO_CHAR('03','MM')) TABLESPACE MONTH2_USAGE_TS, PARTITION MARCH values less than (TO_CHAR('04','MM')) TABLESPACE MONTH3_USAGE_TS, PARTITION APRIL values less than (TO_CHAR('05','MM')) TABLESPACE MONTH4_USAGE_TS, PARTITION MAY values less than (TO_CHAR('06','MM')) TABLESPACE MONTH5_USAGE_TS, PARTITION JUNE values less than (TO_CHAR('07','MM')) TABLESPACE MONTH6_USAGE_TS, PARTITION JULY values less than (TO_CHAR('08','MM')) TABLESPACE MONTH7_USAGE_TS, PARTITION AUGUST values less than (TO_CHAR('09','MM')) TABLESPACE MONTH8_USAGE_TS, PARTITION SEPTEMBER values less than (TO_CHAR('10','MM')) TABLESPACE MONTH9_USAGE_TS, PARTITION OCTOBER values less than (TO_CHAR('11','MM')) TABLESPACE MONTH10_USAGE_TS, PARTITION NOVEMBER values less than (TO_CHAR('12','MM')) TABLESPACE MONTH11_USAGE_TS, PARTITION DECEMBER values less than (maxvalue)) / _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred 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, include a line containing: UNSUB ORACLE-L (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 tuning sampling duration
When I took over the position of Oracle DBA I inherited a number of scripts, including some tuning scripts. Plus through this list and meta-link I have found a number of resources about tuning, What I am unsure about is when to capture the information required for tuning decisions The scripts I inherited are designed to run every 10 minutes. This produces a large amount of information. Which is okay, but is it over kill. Scripts I have found on Metalink appear to be designed to run once a day. Should I design a system that certain things are tracked every 10 min's, and ones that are collected at the end of the day, or capture information every 10 mins. I should note that our databases are most active from 8:00 am to 5:00 pm. Any tips, links, general advice would be appreciated. Thanks Darren Darren Browett P.EngThis message was transmitted Systems Admin/DBA using 100% recycled electrons Information and Communications Technology. City of Coquitlam P:(604) 927 - 3614 E:[EMAIL PROTECTED] - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: memory refresher
Kevin, When you say migration...I assume you're doing a data migration from some legacy to Oracle...and likely you're using DataMig to take data that's in the staging area ((source(Oracle)) and importing it into the target Oracle instance, yes? Yes, create a RBS called RBIG and size it appropriately. Are 70,000 records in one table or does the whole migration consist of 70,000 records in a multitude of tables? Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Wednesday, April 11, 2001 1:06 PM To: Multiple recipients of list ORACLE-L Hi all, If I am doing a migration of say 70 thousand records, isn't it a good idea to turn off all of my little rollback segments and turn on a couple of big rgs? And, how big do you guys think they should be if that is the case? I am trying to increase the performance of this migration, but it is not easy. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:Partition by month (NOT INCLUDING YEAR)
Fred, Somewhat of an old problem. You can't have a function call in the partition clause. What you'll need is to create a column for the month that becomes the partition key. Dick Goulet Reply Separator Author: "Fred Smith" [EMAIL PROTECTED] Date: 4/11/2001 8:40 AM List, I am attempting to partition a table based on the month, not the month and the year. I want all January records to go into the January partition (even if the records are from January 1998,1999,2000, or 2001). Any January record from any year all goes into one partition, any February record from any year goes into the February partition, etc...) I tried the following code, but no luck. Ideas?? Thanks! -Fred S. CREATE TABLE MEETING_ROOM_USAGE ( SEQ_MEETING_ROOM_USAGE NUMBER(18) NOT NULL, POLL_ID NUMBER(10) NOT NULL, PROPERTY_ID NUMBER(8) NOT NULL, IP_ADDRESS VARCHAR2(15) NULL, MAC_ADDRESS VARCHAR2(17) NULL, ACCESS_CODE VARCHAR2(20) NULL, CHARGE NUMBER(7,2) NULL, DURATION NUMBER(9) NULL, USAGE_DATE DATE NULL, ROOM_NUMBER VARCHAR2(20) NULL, COLLECTION_DATE DATE NULL, CUSTOMER VARCHAR2(50) NULL, USER_NAME VARCHAR2(50) NULL, CONSTRAINT PK_MEETING_ROOM_USAGE PRIMARY KEY (SEQ_MEETING_ROOM_USAGE)) PARTITION BY RANGE (USAGE_DATE) (PARTITION JANUARY values less than (TO_CHAR('02','MM')) TABLESPACE MONTH1_USAGE_TS, PARTITION FEBRUARY values less than (TO_CHAR('03','MM')) TABLESPACE MONTH2_USAGE_TS, PARTITION MARCH values less than (TO_CHAR('04','MM')) TABLESPACE MONTH3_USAGE_TS, PARTITION APRIL values less than (TO_CHAR('05','MM')) TABLESPACE MONTH4_USAGE_TS, PARTITION MAY values less than (TO_CHAR('06','MM')) TABLESPACE MONTH5_USAGE_TS, PARTITION JUNE values less than (TO_CHAR('07','MM')) TABLESPACE MONTH6_USAGE_TS, PARTITION JULY values less than (TO_CHAR('08','MM')) TABLESPACE MONTH7_USAGE_TS, PARTITION AUGUST values less than (TO_CHAR('09','MM')) TABLESPACE MONTH8_USAGE_TS, PARTITION SEPTEMBER values less than (TO_CHAR('10','MM')) TABLESPACE MONTH9_USAGE_TS, PARTITION OCTOBER values less than (TO_CHAR('11','MM')) TABLESPACE MONTH10_USAGE_TS, PARTITION NOVEMBER values less than (TO_CHAR('12','MM')) TABLESPACE MONTH11_USAGE_TS, PARTITION DECEMBER values less than (maxvalue)) / _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred 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, include a line containing: UNSUB ORACLE-L (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).
imp - limitation on number of tables?
Hi there, Is there a limitation on the number of tables you can specify in a import par file? Is this documented anywhere? Thanks, Jerry _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jerry C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
fwd [ODTUG] Listener Servlet White Paper
--- Forms 6i Patch 4: Forms Listener Servlet for Deployment of Forms on the Internet February 2001 Author: Regis Louis Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores, CA 94065 U.S.A. Worldwide Inquiries: Phone: +1.650.506.7000 Fax: +1.650.506.7200 www.oracle.com Oracle Corporation provides the software that powers the internet. Oracle is a registered trademark of Oracle Corporation. Various product and service names referenced herein may be trademarks of Oracle Corporation. All other product and service names mentioned may be trademarks of their respective owners. Copyright 2001 Oracle Corporation All rights reserved. --- On 11 Apr 2001, at 3:55, Duncan Mills wrote: Date sent: Wed, 11 Apr 2001 03:55:28 -0800 T o : Multiple recipients of list ODTUG-DEV2K-L O D T U G - D E V 2 K - L @ f a t c i t y . c o m F r o m : "Duncan Mills" d u n c a n . m i l l s @ o r a c l e . c o m Is now available on OTN: http://technet.oracle.com/doc.pdf/forms/p4_listenerservlet.pdf Regards Duncan Mills Oracle Forms Product Management -- ODTUG 2001 - Portal to Oracle Solutions is coming to San Diego, June 24-28! Visit the ODTUG website at www.odtug.com for conference details and highlights. Register before June 1st and save $100! -- Author: Duncan Mills INET: [EMAIL PROTECTED] ... -- 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).
RE: imp - limitation on number of tables?
I am not aware of any limitations. I have to use parfiles because the gui tool provided does have a max limit. It has a max limit not in terms of # of tables but length of statement created by Oracle to export or import tables. This was fixed in some 7.3 version but introduced the same code back. Rick -Original Message- From: Jerry C [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 2:25 PM To: Multiple recipients of list ORACLE-L Subject: imp - limitation on number of tables? Hi there, Is there a limitation on the number of tables you can specify in a import par file? Is this documented anywhere? Thanks, Jerry _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jerry C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Should each partition have it's own tablespace and datafile?
We have a 120 Gig datawarehouse that uses more than 100 date-based partitions. For financial and political reasons, we have run out of disk space to give this database as it continues in it's relentless growth. The developers have resigned themselves to purge out some of the old data and get rid of partitions that are more than two years old. We currently have about ten tablespaces that contain all of the data and indexes for this database. There is a small, medium, and large tablespace for data and for indexes plus some other specialized tablespaces by functionality. Anyway, dropping a couple dozen of these partitions is not going to be enough to free up some disk space for us. Instead we're going to have to export our data, drop the tablespaces, and recreate them as a smaller size and then reimport the data minus the dropped partitions. Since we're going to all of this work, I'm wondering if we should reorg these partitions by creating a tablespace for each partition and a single datafile for each tablespace. That way in the future, every time we want to drop a partition, it will be very easy to reclaim the disk space associated with that partition. I don't want to have to do these reorgs every month. How do most places physically lay out their partitions? What is the downside of having a datafile for each partition? Wasted space? Would a compromise be to assign six months worth of partitions to a single tablespace? We are currently on version 8.0.4 of Oracle on Sun Solaris 2.6 but we will be upgrading soon to 8.1.7. Looks like I may need to reorg this before we can upgrade as we are rapidly running out of room. Thanks, Cherie Machler Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: shell script to send mail
Raja, After sending the msg do amailx at the prompt. This should show you whether your message has been bounced or what. In case your message is bounced, you need torequest your Unix sysadmin to configure the mailx utilityfor you. Shaibal Viraj Luthra [EMAIL PROTECTED] wrote: Hello,This is the second time I am writing this message, dont know what happened where the last message went.Basically wanted to thank every one who ever responded, with this easy construct in the shell.But the problem, is that I sent like this, mailx -s "from the sco box" [EMAIL PROTECTED] msgwhere msg is a regular file and contains the string - this is a test onlyBut I have waited for a long time and it did not appear in the above address.Any ideas why it did not reach. I have looked at the man for mailx, and I have already checked the various files, like dead.letter etc. but of no use, it simply does not exist.Please help.Regards,Raja--On Tue, 10 Apr 2001 09:15:40 SHAIBAL TALUKDER wrote:Raja,If you have unix mail utility you can send mail form unix. At! ! the system prompt type -mailx -s "Subject" [EMAIL PROTECTED] msghope this helps.Shaibal Viraj Luthra <[EMAIL PROTECTED]>wrote: Paul,I dont need that software. I need the code to write in my software itself.rgds,raja--On Mon, 09 Apr 2001 21:10:52 Paul Drake wrote:check out tripwire ... http://sourceforge.net/projects/tripwire/Viraj Luthra wrote: Hello all, I need help. I need to write a shell script (aix box), when ever some loads a piece of software. thanks raja-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Paul Drake INET: [EMAIL PROTECTED]Fat City! ! Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing Lists-Do You Yahoo!?Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.Get 250 color business cards for FREE! at Lycos Mailhttp://mail.lycos.com/freemail/vistaprint_index.html-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Viraj LuthraINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe me! ! ssage BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yahoo!? Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.
/test - dumb dumber/ Re: error when creating a BIG FREAKING ATTACHMENT TO THE LIST
trying again, missing attachment 1st time??? word2000 doc renmaed w/ ".sql" extension /TEST/ BINARY ATTACHMENTS NOT TESTED IF NAMED WITH ".sql" FILE EXTENSION? Date sent:Tue, 10 Apr 2001 06:27:28 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From: [EMAIL PROTECTED] Subject: error when creating a base --0__=K4vD0otYX31qTIYWTP8zXD3R4VI6AyprM56NaK0KG46TUJy3pzPGxQBf Content-type: text/plain; charset=us-ascii Content-Disposition: inline while running the script cr0_base_ADX.sql, we get the error : cre_base_ADX.log... Any idea ??? AIX Version : 4.3.2.0 Oracle version : 7.2.3 Thanks !! L.A. (See attached file: cr0_base_ADX.sql)(See attached file: cre_base_ADX.log) --0__=K4vD0otYX31qTIYWTP8zXD3R4VI6AyprM56NaK0KG46TUJy3pzPGxQBf Content-type: application/octet-stream; name="cr0_base_ADX.sql" Content-Disposition: attachment; filename="cr0_base_ADX.sql" Content-Transfer-Encoding: base64 Y29ubmVjdCBpbnRlcm5hbApzZXQgZWNobyBvbgpzdGFydHVwIG5vbW91bnQgcGZpbGU9L2hvbWUv b3JhZG9uaXgvZGJzL2luaXRBRFhfMC5vcmEKY3JlYXRlIGRhdGFiYXNlIEFEWCAKICAgIG1heGlu c3RhbmNlcyAxCiAgICBtYXhsb2dmaWxlcyAgMTYKICAgIG1heGRhdGFmaWxlcyA1MAogICAgY2hh ... UkEtMDc0Mjk6IHNtc2dzZzogc2htZ2V0KCkgZmFpbGVkIHRvIGdldCBzZWdtZW50LgpJQk0gQUlY IFJJU0MgU3lzdGVtLzYwMDAgRXJyb3I6IDI6IE5vIHN1Y2ggZmlsZSBvciBkaXJlY3RvcnkKU1FM REJBPiBTUUxEQkE+IFNRTCpEQkEgY29tcGxldGUuCg== --0__=K4vD0otYX31qTIYWTP8zXD3R4VI6AyprM56NaK0KG46TUJy3pzPGxQBf-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] ... renamed-word2000.sql
RE: Should each partition have it's own tablespace and datafile?
Hi Cherie, I am in favor of one tablespace per partition. For availablity and maintenance purposes it certainly helps us in our environment. I have implemented this concept in our data mart database which is is now around 90GB. There are multiple datafiles per tablepace each representing an extent (~500 MB). We load data to this database once a month, so I am not too concerned with the checkpoint times etc. (due to a number of data files). There are 4 large tables with 10 partitions so far (one per year). Each table has 2-3 indexes, all locally partitioned. Again each in its own tablespace. Partitioning key is the 4 digit year. All tablespaces and partition names contain the 2 digit year for ease of understanding what's in them. Partitioned table data and partitioned index data is placed on physically separate storage devices. Since, all the data comes from other legacy (or otherwise, internal) systems, we do not have a partition for 'MAXVALUE', and that saves me a lot of work when adding new partitions for new years (did that for 2000 and 2001). Working very well for the last 2 years now, started out with 8.0 and recently upgraded to 8.1.7. All this was done as a parallel process and soon (next month) it will all be 'real' production with one more set of storage devices to split data and index further. HTH.. - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 2:06 PM To: Multiple recipients of list ORACLE-L Subject: Should each partition have it's own tablespace and datafile? We have a 120 Gig datawarehouse that uses more than 100 date-based partitions. For financial and political reasons, we have run out of disk space to give this database as it continues in it's relentless growth. The developers have resigned themselves to purge out some of the old data and get rid of partitions that are more than two years old. We currently have about ten tablespaces that contain all of the data and indexes for this database. There is a small, medium, and large tablespace for data and for indexes plus some other specialized tablespaces by functionality. Anyway, dropping a couple dozen of these partitions is not going to be enough to free up some disk space for us. Instead we're going to have to export our data, drop the tablespaces, and recreate them as a smaller size and then reimport the data minus the dropped partitions. Since we're going to all of this work, I'm wondering if we should reorg these partitions by creating a tablespace for each partition and a single datafile for each tablespace. That way in the future, every time we want to drop a partition, it will be very easy to reclaim the disk space associated with that partition. I don't want to have to do these reorgs every month. How do most places physically lay out their partitions? What is the downside of having a datafile for each partition? Wasted space? Would a compromise be to assign six months worth of partitions to a single tablespace? We are currently on version 8.0.4 of Oracle on Sun Solaris 2.6 but we will be upgrading soon to 8.1.7. Looks like I may need to reorg this before we can upgrade as we are rapidly running out of room. Thanks, Cherie Machler Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: imp - limitation on number of tables?
At one time, the size of a parfile could not exceed the db_block_size of the database. I'm not sure if the limitation still exists. - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, April 11, 2001 3:00 PM I am not aware of any limitations. I have to use parfiles because the gui tool provided does have a max limit. It has a max limit not in terms of # of tables but length of statement created by Oracle to export or import tables. This was fixed in some 7.3 version but introduced the same code back. Rick -Original Message- From: Jerry C [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 2:25 PM To: Multiple recipients of list ORACLE-L Subject: imp - limitation on number of tables? Hi there, Is there a limitation on the number of tables you can specify in a import par file? Is this documented anywhere? Thanks, Jerry _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jerry C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Should each partition have it's own tablespace and datafile?
In my experience, a separate tablespace per partition is advisable; you don't get the full benefit of partition management options otherwise. - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, April 11, 2001 3:05 PM We have a 120 Gig datawarehouse that uses more than 100 date-based partitions. For financial and political reasons, we have run out of disk space to give this database as it continues in it's relentless growth. The developers have resigned themselves to purge out some of the old data and get rid of partitions that are more than two years old. We currently have about ten tablespaces that contain all of the data and indexes for this database. There is a small, medium, and large tablespace for data and for indexes plus some other specialized tablespaces by functionality. Anyway, dropping a couple dozen of these partitions is not going to be enough to free up some disk space for us. Instead we're going to have to export our data, drop the tablespaces, and recreate them as a smaller size and then reimport the data minus the dropped partitions. Since we're going to all of this work, I'm wondering if we should reorg these partitions by creating a tablespace for each partition and a single datafile for each tablespace. That way in the future, every time we want to drop a partition, it will be very easy to reclaim the disk space associated with that partition. I don't want to have to do these reorgs every month. How do most places physically lay out their partitions? What is the downside of having a datafile for each partition? Wasted space? Would a compromise be to assign six months worth of partitions to a single tablespace? We are currently on version 8.0.4 of Oracle on Sun Solaris 2.6 but we will be upgrading soon to 8.1.7. Looks like I may need to reorg this before we can upgrade as we are rapidly running out of room. Thanks, Cherie Machler Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RMAN doubts
1. The database is running in NOARCHEVELOG mode : Oracle manual says that 'you can skip tablespaces, but skipped tablespace that has not been offline or read-only since its last backup will be lost if the database has to be restored from a backup.' Can we skip backing up of TEMP tablespace? In case recovery is required then instead of recovering 10GB, we could create it by SQL statements. 2. Will following command backup all the archved redo logs to tape and delete them from the LOG_ARCHIVE_DEST? run { allocate channel ch1 type 'SBT_TAPE'; backup archivelog all delete input; } Still more to come... TIA, -Rahul P.S. I have passed OCP 8 Backup and Recovery exam with score of 58/60. That's why probably I am having so many doubts. Was better ithout OCP ;-( -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Basic logon architecture for multiple apps in a db
O Esteemed and Wise Colleagues, (My first sending of this didn't seem to make it to the list... Knowing our mail server it may show up in a few weeks!) How do application (Forms or other) users access your tables? Do they logon as themselves? Do you switch their logon behind their backs to that of the app owner (like Oracle Apps does?) I'm wrestling with this now. The way I see it, I've got two choices, with several subchoices: 1. User logs in as self and accesses the tables either: a. via synonyms (to tables or to table API package), or b. via full table path qualification, i.e., GL.ACCOUNT or GL.ACCOUNT_API (package). 2. User logs in (knowingly or unknowingly via behind the scenes smoke-and-mirrors) as app owner, and accesses tables directly. Peronally, I much prefer the logging in as self route. It's easier to trace users, sessions, security, access, performance, etc. I also prefer using synonyms, since most application design environments - including Forms - don't fully qualify tables or views by default. The problem is that synonym names can conflict between applications. One solution is to prefix the app_short_name to the name of each table or view. I hate that. Another thought is to create synonyms dynamically as the user logs on to an application. That's no good if the user logs on to two apps at the same time. If you go with relogging in as the app owner, you somehow have to keep track of who the user really is (some common package variable, most likely) and then use that info as needed. That sounds like lots of extra code. So, how do YOUR users access your apps? Any ideas? I need guidance, and I'll really, truly, honestly, very much appreciate any you can send my way. TIA, Yosi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 doubts
If you are running in the NOARCHIVELOG mode, how do you have entries in the ACRH_LOG_DEST? What will you gain by issuing the command to "archive all" when you are not archiving? Am I missing something in the backup schema of things? ROR mm [EMAIL PROTECTED] 04/11/01 04:05PM 1. The database is running in NOARCHEVELOG mode : Oracle manual says that 'you can skip tablespaces, but skipped tablespace that has not been offline or read-only since its last backup will be lost if the database has to be restored from a backup.' Can we skip backing up of TEMP tablespace? In case recovery is required then instead of recovering 10GB, we could create it by SQL statements. 2. Will following command backup all the archved redo logs to tape and delete them from the LOG_ARCHIVE_DEST? run { allocate channel ch1 type 'SBT_TAPE'; backup archivelog all delete input; } Still more to come... TIA, -Rahul P.S. I have passed OCP 8 Backup and Recovery exam with score of 58/60. That's why probably I am having so many doubts. Was better ithout OCP ;-( -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re [30k]: /test - dumb dumber/ Re: error when creating a BIG FREAKING ATTACHMENT TO THE LIST
Jared, Has Bruce seen this issue? Looks like attached binary files that have their file extension changed to ".sql" will not be caught by the list's filters. regards, ep Received: from SpoolDir by DSS_486 (Mercury 1.46); 11 Apr 01 12:08:01 -0700 Return-path: [EMAIL PROTECTED] Received: from cliff.csus.edu (130.86.82.251) by sswdserver.sswd.csus.edu (Mercury 1.46) with ESMTP; 11 Apr 01 12:07:58 -0700 Received: from cliff.csus.edu (localhost [127.0.0.1]) by cliff.csus.edu with ESMTP id f3BJ7wC05609; Wed, 11 Apr 2001 12:07:58 -0700 (PDT) Received: from csus.edu (csus.edu [130.86.90.1]) by cliff.csus.edu with ESMTP id f3BJ7v105605; Wed, 11 Apr 2001 12:07:57 -0700 (PDT) Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.192.199]) by csus.edu with ESMTP id MAA24894; Wed, 11 Apr 2001 12:07:57 -0700 (PDT) Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id MAA07761; Wed, 11 Apr 2001 12:05:12 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b70/bab) via UUCP id 002E7446; Wed, 11 Apr 2001 11:11:19 -0800 Message-ID: [EMAIL PROTECTED] Date: Wed, 11 Apr 2001 11:11:19 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: "Eric D. Pierce" [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] From: "Eric D. Pierce" [EMAIL PROTECTED] Subject: /test - dumb dumber/ Re: error when creating a BIG FREAKING ATTACHMENT TO THE LIST Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-type: Multipart/Mixed; boundary=Message-Boundary-5637 X-PMFLAGS: 571998336 0 1 Y0B633.CNM --Message-Boundary-5637 Content-type: text/plain; charset=US-ASCII Content-description: Mail message body Content-Transfer-Encoding: 7BIT trying again, missing attachment 1st time??? word2000 doc renmaed w/ ".sql" extension /TEST/ BINARY ATTACHMENTS NOT TESTED IF NAMED WITH ".sql" FILE EXTENSION? Date sent: Tue, 10 Apr 2001 06:27:28 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:[EMAIL PROTECTED] Subject:error when creating a base --0__=K4vD0otYX31qTIYWTP8zXD3R4VI6AyprM56NaK0KG46TUJy3pzPGxQBf Content-type: text/plain; charset=us-ascii Content-Disposition: inline while running the script cr0_base_ADX.sql, we get the error : cre_base_ADX.log... Any idea ??? AIX Version : 4.3.2.0 Oracle version : 7.2.3 Thanks !! L.A. (See attached file: cr0_base_ADX.sql)(See attached file: cre_base_ADX.log) --0__=K4vD0otYX31qTIYWTP8zXD3R4VI6AyprM56NaK0KG46TUJy3pzPGxQBf Content-type: application/octet-stream; name="cr0_base_ADX.sql" Content-Disposition: attachment; filename="cr0_base_ADX.sql" Content-Transfer-Encoding: base64 Y29ubmVjdCBpbnRlcm5hbApzZXQgZWNobyBvbgpzdGFydHVwIG5vbW91bnQgcGZpbGU9L2 hvbWUv b3JhZG9uaXgvZGJzL2luaXRBRFhfMC5vcmEKY3JlYXRlIGRhdGFiYXNlIEFEWCAKICAgIG 1heGlu c3RhbmNlcyAxCiAgICBtYXhsb2dmaWxlcyAgMTYKICAgIG1heGRhdGFmaWxlcyA1MAogIC AgY2hh ... UkEtMDc0Mjk6IHNtc2dzZzogc2htZ2V0KCkgZmFpbGVkIHRvIGdldCBzZWdtZW50LgpJQk 0gQUlY IFJJU0MgU3lzdGVtLzYwMDAgRXJyb3I6IDI6IE5vIHN1Y2ggZmlsZSBvciBkaXJlY3Rvcn kKU1FM REJBPiBTUUxEQkE+IFNRTCpEQkEgY29tcGxldGUuCg== --0__=K4vD0otYX31qTIYWTP8zXD3R4VI6AyprM56NaK0KG46TUJy3pzPGxQBf-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] ... --Message-Boundary-5637 Content-type: Application/Octet-stream; name="renamed-word2000.sql"; type=Unknown Content-disposition: attachment; filename="renamed-word2000.sql" Content-Transfer-Encoding: BASE64 0M8R4KGxGuEAPgADAP7/CQAGAAABIQAA EAAAIwEAAAD+ACD/ ///spcEAVyAJBAAA8BK/EAAABAAA HQQAAA4AYmpiaqp5qnkJBBYAIgwAAMgTAQDIEwEAHQAA AAD//w8AAAD//w8AAAD//w8A AGwAAKgAqKgAqACo
Oracle Reports Server?
Oracle reports server keeps a log file that tells when a server engine is started and closed or if it can't be started etc. IIS keeps a log of what html page is accessed, and what action was taken by a web form. IE, action="/scripts/run.pl". What I need to know is if either IIS has a way to capture the data sent to the standard out by the html form, or if reports server has a way of gathering the name of the report run and when. Reports server 6.0 on NT accessed via rwcgi60.exe through IIS. Dan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dasko, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
index on table with 3 million rows ???
Hi all, I need to build an index on a table of 80 columns with 3 million rows. The index is on 8 columns. I got ORA-01630: max # extents (n) reached in temp segment in tablespace ARBOR_INDEX, so I add more index files and enlarge extents, now I have 2 index files of 1G each, and tablespace storage is: ALTER TABLESPACE ARBOR_INDEX DEFAULT STORAGE ( INITIAL 514K NEXT 514K MAXEXTENTS 4080 ); And I still got ORA0-1630. Should I continue to increase index file size and extents or there is other way around? The datafile contains that table's tablespace is only 1G. I didn't do exp, build index, imp since I believe for large amount of data, it's better to load the data first then build index. Any idea? Thank you. Leslie __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Quote Of The Day
not out of stock, out of print... they did list them but since they are out of print I didn't want to tease people with them :) From: Terry Ball [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Fwd: Quote Of The Day Date: Wed, 11 Apr 2001 05:15:56 -0800 Add a couple more to the list - the first and second in the series, Wizard's Bane and The Wizardry Compiled. These two are probably out of stock, so amazon wouldn't list them. Terry Rachel Carmichael wrote: Mall Purchase Night The Wiz Biz The Wizardry Quested The Wizardry Consulted The Wizardry Cursed no, I haven't read any of these. But my mom was a librarian and I know how to do research (amazon.com is a wonderful thing :) ) Rachel From: Terry Ball [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Fwd: Quote Of The Day Date: Tue, 10 Apr 2001 08:50:22 -0800 Rick Cook is a Fantasy writer. One of his series is about a coputer wizard who gets pulled into an alternate universe where magic works. And, in this case, it works by way of computer programs. Rick Cook says he is computer illiterate, but knows many people who work with computers. He has a lot of truisms in his books. (Can't for the life of me remember the title of any of them). I find them a good,. humorous read. Terry Jared Still wrote: I don't know who Rich Cook is, but I like him. ;) Jared - Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.--Rich Cook -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- 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: Terry Ball INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- 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)
Standby database : tips and tools
Hi ; I have to put a copy of database in "standby" mode, under Ora 7.3 , Soalris, with 100GB size. Anybody know some tips to share, or some tool like "Shareplex" , useful to replicate the DB ant ready to use on-line. Thanks in advance. Daniel. æ¬zǶ¨}ø©ND ±@Bm§ÿðà +iöªrºØh¬6§éBjjh©Þ°DM×j×¥yÊ¥êì¢v¥r¬V +r5ëp¢¹z»âqëçÎwó9ÔPó9ßÎtçT8'è®xæåÂ'µêçzÖqë,üÆ¢)à.+-±:Ã*.®Ç¥}úèØb²f¢)à+-±éÝjq +j)fzËëh.+-êî}«\Ü¢ièµá $ì¥éex(|¸¬´k«¹©Ý{azg¬±¨àØw%¹×)Þríj)â +I@ND º+¶§jg¨~f¢)à+-Ê°j{m¡·«zj/y×ë¢f(ºf²j[(±éݶ³Ü¢i×è®az¸§~æjبX¤z˱Êân)à
RE: index on table with 3 million rows ???
You have to add another datafile to index tablespace and also increase the temp tablespace size. -Original Message- Sent: Wednesday, April 11, 2001 4:55 PM To: Multiple recipients of list ORACLE-L Hi all, I need to build an index on a table of 80 columns with 3 million rows. The index is on 8 columns. I got ORA-01630: max # extents (n) reached in temp segment in tablespace ARBOR_INDEX, so I add more index files and enlarge extents, now I have 2 index files of 1G each, and tablespace storage is: ALTER TABLESPACE ARBOR_INDEX DEFAULT STORAGE ( INITIAL 514K NEXT 514K MAXEXTENTS 4080 ); And I still got ORA0-1630. Should I continue to increase index file size and extents or there is other way around? The datafile contains that table's tablespace is only 1G. I didn't do exp, build index, imp since I believe for large amount of data, it's better to load the data first then build index. Any idea? Thank you. Leslie __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: udaycb INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
select for update ???
Team, The developer has found a problem when using VB 6 sp4 on Oracle 7.3.4.0.1 and the "select for update" command. The sql will lock the row from others as expected. If there are no updates performed and the user exits the form the lock remains untill the session is ended. If the user updates the row and exits the form the lock is released. Question: How do the developers release to lock on the row if the user exits the form without updating the row?? Thanks, ROR mm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
purged data??
Hi Friends How can I calculate How much data is purged from a table?? TIA Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN doubts
Case 1 is NOARCHIVELOG. We have advanced replication so donot put databases in ARCHIVELOG. Case 2 is for different databases which are 24 x 7. Its in ARCHIVELOG mode - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, April 11, 2001 4:40 PM If you are running in the NOARCHIVELOG mode, how do you have entries in the ACRH_LOG_DEST? What will you gain by issuing the command to "archive all" when you are not archiving? Am I missing something in the backup schema of things? ROR mm [EMAIL PROTECTED] 04/11/01 04:05PM 1. The database is running in NOARCHEVELOG mode : Oracle manual says that 'you can skip tablespaces, but skipped tablespace that has not been offline or read-only since its last backup will be lost if the database has to be restored from a backup.' Can we skip backing up of TEMP tablespace? In case recovery is required then instead of recovering 10GB, we could create it by SQL statements. 2. Will following command backup all the archved redo logs to tape and delete them from the LOG_ARCHIVE_DEST? run { allocate channel ch1 type 'SBT_TAPE'; backup archivelog all delete input; } Still more to come... TIA, -Rahul P.S. I have passed OCP 8 Backup and Recovery exam with score of 58/60. That's why probably I am having so many doubts. Was better ithout OCP ;-( -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: select for update ???
How about a ROLLBACK when exiting if user hasdn't committed anything? Oracle Forms does this implicitly ... HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! -Original Message- Sent: Wednesday, April 11, 2001 5:31 PM To: Multiple recipients of list ORACLE-L Team, The developer has found a problem when using VB 6 sp4 on Oracle 7.3.4.0.1 and the "select for update" command. The sql will lock the row from others as expected. If there are no updates performed and the user exits the form the lock remains untill the session is ended. If the user updates the row and exits the form the lock is released. Question: How do the developers release to lock on the row if the user exits the form without updating the row?? Thanks, ROR mm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * 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 ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Temporarily Renaming the sgadefSID.dbf File
Steve, When I was on 7.3.4, I used this procedure every time I cloned, which was at least weekly. I never had a problem with Production while doing this. After I cloned the files, I would rename the file, bring up the cloned instances, and then name the file back to the original name. The file was only with the new name for just a few minutes. I was told by those around me that users on the production database could still process, just those signing on had to retry in a few minutes. Since usually cloned the test database farily early in the morning [around 6:30 am] , there were very few attempting to sign on. After I migrated to 8i, this "file renaming" wasn't required. HTH, Bill Gentry DBA Allina Health System Minneapolis, MN 55403 612-775-1190 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 10, 2001 3:35 PM Hi All, Trying to clone our PROD to a test database on the same machine for testing our 734--8i upgrade, and of course we're encountering the "can't-start-the-new-without-shutting-down-the-old" database problem (ie, ORA-9782 on the CREATE CONTROLFILE command). We've worked around this in the past by scheduling a time to bring down PROD. I know that this is the safest, most reliable way (besides NOT doing this on a production box...but I have no choice), but believe it or not, I actually saw a reference on a Metalink forum to rename the sgadefSID.dbf file, start up the new database, then rename the file to its original name. Obviously sgadef gets created at instance startup as a memory map, but it doesn't look like it's used for anything after that (it's certainly doesn't seem to be written to). I do know that you can get an octal dump of the file to determine the shared memory ID for whatever reason. Everything else I've heard/seen about this file has pretty much said DON'T TOUCH IT!!! But if the instance only uses it at instance startup, is there any harm in renaming it temporarily to get the other database up? If so...why? And have any of you tried renaming or deleting the file in your cloning (or other) efforts? Did it blow up, or work? TIA, Steve _ Steve Morrow IT/Tech Support University of South Florida phone: 813-974-5519 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Morrow, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Gentry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: index on table with 3 million rows ???
Hi, Leslie, 1. First of all, if you are on 8i, I'd strongly consider index compression CREATE INDEX INX ON TAB(N,M,...) COMPRESS COMPRESSION LEVEL. Depending on your data, I' set compression level up to 7. This would greatly reduce index size. 2. as soon as 514K*4080/300 approx gives 700 byte I wonder, do you actually have index entry this long? What is an average total length of those 8 fields? 2a. If no, I would check , maybe you have your storage set explicitely at your CREATE index clause. Change the STORAGE first. There is no good reason to have DEFAULT STORAGE with MAXEXTENTS 4080, better to set STORAGE manually for objects of this size. 2b. If yes - see 1 and than, if still need more space - add this space. Consider partitioning. Segments of 1Gb+ size are not very comfortable to handle. Best regards, Vadim Gorbounov Oracle DBA -Original Message- Sent: Wednesday, April 11, 2001 4:55 PM To: Multiple recipients of list ORACLE-L Hi all, I need to build an index on a table of 80 columns with 3 million rows. The index is on 8 columns. I got ORA-01630: max # extents (n) reached in temp segment in tablespace ARBOR_INDEX, so I add more index files and enlarge extents, now I have 2 index files of 1G each, and tablespace storage is: ALTER TABLESPACE ARBOR_INDEX DEFAULT STORAGE ( INITIAL 514K NEXT 514K MAXEXTENTS 4080 ); And I still got ORA0-1630. Should I continue to increase index file size and extents or there is other way around? The datafile contains that table's tablespace is only 1G. I didn't do exp, build index, imp since I believe for large amount of data, it's better to load the data first then build index. Any idea? Thank you. Leslie __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Basic logon architecture for multiple apps in a db
We have the users log in as themselves, because that was the only way to handle the permissions properly. We also use fully qualified table names rather than synonyms, though that was mostly because we have data split among several schemas using identical table names. We just make the table owner dynamic and swap in the proper name at runtime. Works much better than trying to handle swapping and redefining synonyms. At 12:40 PM 4/11/01 -0800, you wrote: O Esteemed and Wise Colleagues, (My first sending of this didn't seem to make it to the list... Knowing our mail server it may show up in a few weeks!) How do application (Forms or other) users access your tables? Do they logon as themselves? Do you switch their logon behind their backs to that of the app owner (like Oracle Apps does?) I'm wrestling with this now. The way I see it, I've got two choices, with several subchoices: 1. User logs in as self and accesses the tables either: a. via synonyms (to tables or to table API package), or b. via full table path qualification, i.e., GL.ACCOUNT or GL.ACCOUNT_API (package). 2. User logs in (knowingly or unknowingly via behind the scenes smoke-and-mirrors) as app owner, and accesses tables directly. Peronally, I much prefer the logging in as self route. It's easier to trace users, sessions, security, access, performance, etc. I also prefer using synonyms, since most application design environments - including Forms - don't fully qualify tables or views by default. The problem is that synonym names can conflict between applications. One solution is to prefix the app_short_name to the name of each table or view. I hate that. Another thought is to create synonyms dynamically as the user logs on to an application. That's no good if the user logs on to two apps at the same time. If you go with relogging in as the app owner, you somehow have to keep track of who the user really is (some common package variable, most likely) and then use that info as needed. That sounds like lots of extra code. So, how do YOUR users access your apps? Any ideas? I need guidance, and I'll really, truly, honestly, very much appreciate any you can send my way. TIA, Yosi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Regina Harter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Oracle9ias
Does m/c=machine and if so, yes. Just do it on different OH's. [EMAIL PROTECTED] 04/11/01 05:51PM Hi DBAs Can I install Db server and Oracle9iAS on same M/C. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: index on table with 3 million rows ???
Aren't you running out of extents because your initial and next extent size is so small? I would increase the extent size at least to the block size or a multiple of the block size. -Original Message- Sent: Wednesday, April 11, 2001 5:06 PM To: Multiple recipients of list ORACLE-L Hi, Leslie, 1. First of all, if you are on 8i, I'd strongly consider index compression CREATE INDEX INX ON TAB(N,M,...) COMPRESS COMPRESSION LEVEL. Depending on your data, I' set compression level up to 7. This would greatly reduce index size. 2. as soon as 514K*4080/300 approx gives 700 byte I wonder, do you actually have index entry this long? What is an average total length of those 8 fields? 2a. If no, I would check , maybe you have your storage set explicitely at your CREATE index clause. Change the STORAGE first. There is no good reason to have DEFAULT STORAGE with MAXEXTENTS 4080, better to set STORAGE manually for objects of this size. 2b. If yes - see 1 and than, if still need more space - add this space. Consider partitioning. Segments of 1Gb+ size are not very comfortable to handle. Best regards, Vadim Gorbounov Oracle DBA -Original Message- Sent: Wednesday, April 11, 2001 4:55 PM To: Multiple recipients of list ORACLE-L Hi all, I need to build an index on a table of 80 columns with 3 million rows. The index is on 8 columns. I got ORA-01630: max # extents (n) reached in temp segment in tablespace ARBOR_INDEX, so I add more index files and enlarge extents, now I have 2 index files of 1G each, and tablespace storage is: ALTER TABLESPACE ARBOR_INDEX DEFAULT STORAGE ( INITIAL 514K NEXT 514K MAXEXTENTS 4080 ); And I still got ORA0-1630. Should I continue to increase index file size and extents or there is other way around? The datafile contains that table's tablespace is only 1G. I didn't do exp, build index, imp since I believe for large amount of data, it's better to load the data first then build index. Any idea? Thank you. Leslie __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Oracle9ias
Seema: That's not a problem. --Kevin -Original Message- Sent: Wednesday, April 11, 2001 2:52 PM To: Multiple recipients of list ORACLE-L Hi DBAs Can I install Db server and Oracle9iAS on same M/C. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Tsay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Temporarily Renaming the sgadefSID.dbf File
Hi Steve, Yes, you MUST rename the sgadefPROD.dbf file while the CREATE CONTROLFILE command is issued, or you'll get that error on 7.3. This is fixed in 8.0 and up. The inability to do a daily hotbackup of our PROD db to TEST was a big enough problem for us that I logged a TAR. It was Oracle's solution (workaround) to rename the sgadef file. So, I figured my arse was covered in case of catastrophy. :) We were running a script daily that did a backup of PROD to TEST, renamed the sgadefPROD file, CREATE CONTROLFILE SET DATABASE "TEST" RESETLOGS, renamed the sgadefPROD file back, and attempted auto-recovery via RECOVER DATABASE USING BACKUP CONTROLFILE. Under 8, we're still doing the same, sans sgadef moves. Good luck! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Morrow, Steve [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 12:01 To: Multiple recipients of list ORACLE-L Subject: RE: Temporarily Renaming the sgadefSID.dbf File I appreciate the responses I've gotten. Jack, we're running 734 and 8i on four different Sun boxes (all running Solaris 8). Only one has given us any problems. Otherwise, we can clone away on the other three either by one: shutting down the source database, copy the source datafiles to the new target filesystem, making the necessary mods to the new init.ora and create-controfile script (including new db_name, new paths, etc), bringing up the new database, then the source database, or two: restoring a backup from the source database to the same machine but different filesystem, recreating the controlfile, and starting it up. We haven't encountered the ORA-9782 on either of these as far as I can remember. Why we have the problem on this one box I have absolutely no idea. For the "problem" box, we restore the hot backup files to another filesystem, copy and modify the init.ora of the source, backup the controlfile to trace (of the source) and modify this for the target (new db_name and everything). We shut down the source database, run the create-controlfile script against the new (with ORACLE_SID set to the new), then startup the source. No problem. If we keep the source database up, then the create-controlfile script does a STARTUP NOMOUNT, then proceeds to the CREATE CONTROLFILE, only to bomb with: CREATE CONTROLFILE SET DATABASE "DVL5" RESETLOGS ARCHIVELOG * ORA-01503: CREATE CONTROLFILE failed ORA-01565: error in identifying file '/u01/oradata/DVL5/system01.dbf' ORA-09782: sfifi: another instance has the same database mounted. We have actually gotten around this once by rcp'ing the restored files to one of the other boxes, creating the controlfile there...then shutting down the database and copying all the files back to the "problem" box. In this case, we were able to start the database just fine. But now we don't have the space on the "temp" box to hold all the datafiles, so this isn't an option. Hope this makes sense to somebody. Assuming that it *is* the presence of the sgadef.dbf file, this is why I've asked if I can work around the error by renaming the file for the duration of bringing the new database up. I understand that we won't have to worry about this anymore in 8i. Thanks again! Steve --- This message has been scanned for viruses with Trend Micro's Interscan VirusWall. -- 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).
Problem with database link
Hi there! I'm having a problem with database links here. I am on my SPEEDY database and want to create a link that points to another database called SAM. create database link SAM connect to user identified by pasword using 'SAM'; Then I try and issue that statement: select view_name from user_views@SAM * ERROR at line 2: ORA-02085: database link SAM.VIVONET.COM connects to SAM Where does our domain name appendix (vivonet.com) come from I looked in all the possible config files (e.g. sqlnet.ora etc.) and couldn't find anything. In both databases the init.ora parameter is set to global_names = true. Any idea? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Should each partition have it's own tablespace and
Hmmm, it depends on the situation. There are pros and cons in both, but certainly partitions should be in partitions-only tablespaces. Unless you can size the partitions with great accuracy, you would have to build in reasonably free-space in the TBS. If you have overdone this, you would have to come back and resize. This would be a very tedious way of managing 100 tablespaces. If you group the partitions in some logical manner, you can put them in the same TBS, and pool the free-space to allow for un-predicted growth, and minimise waste. I am unclear why exp/imp is going to free up more space than dropping partitions, unless its severely fragmented. Keeping to uniform extents will get rid of this problem. [EMAIL PROTECTED] 04/12/01 08:12AM Hi Cherie, I am in favor of one tablespace per partition. For availablity and maintenance purposes it certainly helps us in our environment. I have implemented this concept in our data mart database which is is now around 90GB. There are multiple datafiles per tablepace each representing an extent (~500 MB). We load data to this database once a month, so I am not too concerned with the checkpoint times etc. (due to a number of data files). There are 4 large tables with 10 partitions so far (one per year). Each table has 2-3 indexes, all locally partitioned. Again each in its own tablespace. Partitioning key is the 4 digit year. All tablespaces and partition names contain the 2 digit year for ease of understanding what's in them. Partitioned table data and partitioned index data is placed on physically separate storage devices. Since, all the data comes from other legacy (or otherwise, internal) systems, we do not have a partition for 'MAXVALUE', and that saves me a lot of work when adding new partitions for new years (did that for 2000 and 2001). Working very well for the last 2 years now, started out with 8.0 and recently upgraded to 8.1.7. All this was done as a parallel process and soon (next month) it will all be 'real' production with one more set of storage devices to split data and index further. HTH.. - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 2:06 PM To: Multiple recipients of list ORACLE-L Subject: Should each partition have it's own tablespace and datafile? We have a 120 Gig datawarehouse that uses more than 100 date-based partitions. For financial and political reasons, we have run out of disk space to give this database as it continues in it's relentless growth. The developers have resigned themselves to purge out some of the old data and get rid of partitions that are more than two years old. We currently have about ten tablespaces that contain all of the data and indexes for this database. There is a small, medium, and large tablespace for data and for indexes plus some other specialized tablespaces by functionality. Anyway, dropping a couple dozen of these partitions is not going to be enough to free up some disk space for us. Instead we're going to have to export our data, drop the tablespaces, and recreate them as a smaller size and then reimport the data minus the dropped partitions. Since we're going to all of this work, I'm wondering if we should reorg these partitions by creating a tablespace for each partition and a single datafile for each tablespace. That way in the future, every time we want to drop a partition, it will be very easy to reclaim the disk space associated with that partition. I don't want to have to do these reorgs every month. How do most places physically lay out their partitions? What is the downside of having a datafile for each partition? Wasted space? Would a compromise be to assign six months worth of partitions to a single tablespace? We are currently on version 8.0.4 of Oracle on Sun Solaris 2.6 but we will be upgrading soon to 8.1.7. Looks like I may need to reorg this before we can upgrade as we are rapidly running out of room. Thanks, Cherie Machler Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858)
How to get jobs under WinAT to run as Oracle
Hello, I am running several batch jobs against an 6.1.6.3.0 database on NT using the WinAT scheduler to schedule these jobs. Is it possible to set them up so to run as a particular user, oracle for example, so I don't have to embed passwords in my command files? Thanks. Bill Wagman Univ. of California at Davis Information Resources [EMAIL PROTECTED] (530) 754-6208 - I like to pick up hitchhikers. When they get in the car I say, 'Put on your seat belt. I want to try something. I saw it once in a cartoon, but I think I can do it.' - Steven Wright -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Wagman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DONE script enclosed: shell script to compare nos.
Hello every one, Thanks for the awk script sent before, I could not use ask as some sites dont have awk but have nawk, so my script will fail. So alternatively devised this shell script, which does the job:- #!/bin/sh olddir="7.04.03" olddir1="`echo $olddir| cut -c1 `" olddir2="`echo $olddir| cut -f2 -d"." `" olddir3="`echo $olddir| cut -f3 -d"." `" if [ "$olddir3" = "" ]; then olddir3=00 fi fullversion="$olddir1""$olddir2""$olddir3" VER="7.05" ver1="`echo $VER| cut -c1 `" ver2="`echo $VER| cut -f2 -d"." `" ver3="`echo $VER| cut -f3 -d"." `" if [ "$ver3" = "" ]; then ver3="00" # echo "The third version value is $ver3" fi fullver="$ver1""$ver2""$ver3" if [ "$fullversion" -gt "$fullver" ];then echo "The $olddir version is greater than $VER version" elif [ "$fullversion" -lt "$fullver" ];then echo "The $olddir version is less than $VER version" else echo "Both versions are equal" fi == Basically I strip away the release nos. like instead of accepting 7.04.03, I accept it as 70403 and then compare and output. Thanks for help. Regrads, Raja On Wed, 11 Apr 2001 02:30:36 lerobe - Lee Robertson wrote: Why not simply do the following passing two parameters to the script eg. call the script test.sh and call it so test.sh 2 1 This results in output "VAR1 is greater than VAR2" then test.sh 1 2 this results in output "VAR2 is greater than VAR1" Cheers. #!/bin/ksh VAR1=$1 VAR2=$2 if [ "$VAR1" -gt "$VAR2" ] then echo "VAR1 is greater than VAR2" else echo "VAR2 is greater than VAR1" fi -Original Message- Sent: 11 April 2001 10:01 To: Multiple recipients of list ORACLE-L Hi I'm sure there are better ways but awk does the trick echo $var1 $var2 | awk '{ if ( $1 $2 ) { print "1"} else { print"0" } }' cheers alex Hello, I need some help in comparing 2 nos. in a unix shell. 1) e.g var1="7.04.03" and var2="7.05" I want to test:- if [ "$var2" "$var1" ];then then $var2 version is greater than $var1" fi 2) 2nd condition is :- var1="7.04.03" var2="7.04.02" I want to test:- if [ "$var1" "$var2" ];then then $var1 version is greater than $var2" fi Can some one send me a code? How can I do the above in shell? Can you please help me, a seemingly simple one! Raja Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Apostolopoulos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Get 250 color business cards for FREE! at Lycos Mail
RE: 7.3.4 svrmgrl requiring password if called by root user
Thanks everyone who responded to my request. I am still unsure why svrmgrl would prompt for a password, but I was able to solve the problem by extracting my dump2 commands from the PERL script that was doing my regular backup. So now I have root's crontab call a new shell script, that first SUs to a backup user executes my PERL backup script, then finally, calls my newly created dumpall script as root. Allthough I felt my original solution was more elegant, this one actually works. We've all been there right? Thanks Again, Steve McClure -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, April 03, 2001 2:41 PM To: Multiple recipients of list ORACLE-L Subject:RE: 7.3.4 svrmgrl requiring password if called by root user Have you tried running the scripts as 'su - oracle -c script_name' from root? Or is this not possible with your current solution? Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: steve mcclure [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 3:23 PM To: Multiple recipients of list ORACLE-L Subject: 7.3.4 svrmgrl requiring password if called by root user My database backup scripts are failing when run by the root user. I have just had the requirment to add a dump of all filesystems to my regular database backup routine. Upon running my modified scripts as the root user, required for the dump, I am greeted by a request for a password in response to the connect internal command. I can duplicate this by simply running svrmgrl from a prompt as the root user. Again this is for Oracle 7.3.4 on DG/UX. We are not using OS authentication, and I svrmgrl does NOT require a password for the other OS users I have tried to use. I added the root user to the dba and oper groups in hopes that might solve my problem, but was still prompted for a password. Any help with this is appreciated. Thanks, Steve McClure __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: steve mcclure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DONE script enclosed: shell script to compare nos.
Hi Raja, I have not been following this thread until now, but the assumption that each minor point number will be two digits rather than one may not be valid. Also, if your objective is to do it entirely in the shell, consider using IFS to avoid the cut as follows. #!/bin/sh v1=$1; v2=$2 ifs="$IFS"; IFS=. set $v1; v1a=$1; v1b=$2; v1c=$3 set $v2; v2a=$1; v2b=$2; v2c=$3 IFS="$ifs" if [ "0$v1a" -eq "0$v2a" ] ; then if [ "0$v1b" -eq "0$v2b" ] ; then if [ "0$v1c" -eq "0$v2c" ] ; then echo "$v1 is the same as $v2" elif [ "0$v1c" -lt "0$v2c" ] ; then echo "$v1 is less than $v2" else echo "$v1 is greater than $v2" fi elif [ "0$v1b" -lt "0$v2b" ] ; then echo "$v1 is less than $v2" else echo "$v1 is greater than $v2" fi elif [ "0$v1a" -lt "0$v2a" ] ; then echo "$v1 is less than $v2" else echo "$v1 is greater than $v2" fi @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Thursday, 12 April 2001 11:55 To: Multiple recipients of list ORACLE-L Hello every one, Thanks for the awk script sent before, I could not use ask as some sites dont have awk but have nawk, so my script will fail. So alternatively devised this shell script, which does the job:- #!/bin/sh olddir="7.04.03" olddir1="`echo $olddir| cut -c1 `" olddir2="`echo $olddir| cut -f2 -d"." `" olddir3="`echo $olddir| cut -f3 -d"." `" if [ "$olddir3" = "" ]; then olddir3=00 fi fullversion="$olddir1""$olddir2""$olddir3" VER="7.05" ver1="`echo $VER| cut -c1 `" ver2="`echo $VER| cut -f2 -d"." `" ver3="`echo $VER| cut -f3 -d"." `" if [ "$ver3" = "" ]; then ver3="00" # echo "The third version value is $ver3" fi fullver="$ver1""$ver2""$ver3" if [ "$fullversion" -gt "$fullver" ];then echo "The $olddir version is greater than $VER version" elif [ "$fullversion" -lt "$fullver" ];then echo "The $olddir version is less than $VER version" else echo "Both versions are equal" fi == Basically I strip away the release nos. like instead of accepting 7.04.03, I accept it as 70403 and then compare and output. Thanks for help. Regrads, Raja On Wed, 11 Apr 2001 02:30:36 lerobe - Lee Robertson wrote: Why not simply do the following passing two parameters to the script eg. call the script test.sh and call it so test.sh 2 1 This results in output "VAR1 is greater than VAR2" then test.sh 1 2 this results in output "VAR2 is greater than VAR1" Cheers. #!/bin/ksh VAR1=$1 VAR2=$2 if [ "$VAR1" -gt "$VAR2" ] then echo "VAR1 is greater than VAR2" else echo "VAR2 is greater than VAR1" fi -Original Message- Sent: 11 April 2001 10:01 To: Multiple recipients of list ORACLE-L Hi I'm sure there are better ways but awk does the trick echo $var1 $var2 | awk '{ if ( $1 $2 ) { print "1"} else { print"0" } }' cheers alex Hello, I need some help in comparing 2 nos. in a unix shell. 1) e.g var1="7.04.03" and var2="7.05" I want to test:- if [ "$var2" "$var1" ];then then $var2 version is greater than $var1" fi 2) 2nd condition is :- var1="7.04.03" var2="7.04.02" I want to test:- if [ "$var1" "$var2" ];then then $var1 version is greater than $var2" fi Can some one send me a code? How can I do the above in shell? Can you please help me, a seemingly simple one! Raja Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Apostolopoulos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED]
Re: Oracle9ias
Hi, Yes u can install oracle 8i DB and 9iAS on the same machine. On Wed, 11 Apr 2001, Seema Singh wrote: Hi DBAs Can I install Db server and Oracle9iAS on same M/C. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: TARUN SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Open for suggestions:Oracle Unx Install
Hello every one, I have got a new PC, on which I have to install sco (unix) and on top of it, need to install oracle (oracle 8). Well guess what, I have not installed any of the above, so it will be fun. Any pointers, what I should be looking for and where can I read (apart from Oracle's release and installation notes). Now dont flame me, when I am asking for suggestions to install above, as I know I can do this, but asking for tips from you gurus before I start. I have to do this next week, so it will be happy reading over the easter break. Rgds, raja Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DONE script enclosed: shell script to compare nos.
Hi Raja, Yes, IFS stand for the "Internal Field Separator". It is a special shell variable in Bourne based shells. See the sh(1) man page for more information about it. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Thursday, 12 April 2001 14:01 To: Steve Adams Steve, This is another way of doing it, but for my purposes, the software minor release no. will always be, of the form nn, that is 01. In that case, the script will work, but the one that you have sent also works, I liked the concept of IFS, where can I read about that, it must be standing for I something Field Seperator? Did a man on vi, but would not give me that. I think I will look at some appendix or some thing. Rgds, Raja -- On Thu, 12 Apr 2001 12:27:16 Steve Adams wrote: Hi Raja, I have not been following this thread until now, but the assumption that each minor point number will be two digits rather than one may not be valid. Also, if your objective is to do it entirely in the shell, consider using IFS to avoid the cut as follows. #!/bin/sh v1=$1; v2=$2 ifs="$IFS"; IFS=. set $v1; v1a=$1; v1b=$2; v1c=$3 set $v2; v2a=$1; v2b=$2; v2c=$3 IFS="$ifs" if [ "0$v1a" -eq "0$v2a" ] ; then if [ "0$v1b" -eq "0$v2b" ] ; then if [ "0$v1c" -eq "0$v2c" ] ; then echo "$v1 is the same as $v2" elif [ "0$v1c" -lt "0$v2c" ] ; then echo "$v1 is less than $v2" else echo "$v1 is greater than $v2" fi elif [ "0$v1b" -lt "0$v2b" ] ; then echo "$v1 is less than $v2" else echo "$v1 is greater than $v2" fi elif [ "0$v1a" -lt "0$v2a" ] ; then echo "$v1 is less than $v2" else echo "$v1 is greater than $v2" fi @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- From: Viraj Luthra [mailto:[EMAIL PROTECTED]] Sent: Thursday, 12 April 2001 11:55 To: Multiple recipients of list ORACLE-L Subject: DONE script enclosed: shell script to compare nos. Hello every one, Thanks for the awk script sent before, I could not use ask as some sites dont have awk but have nawk, so my script will fail. So alternatively devised this shell script, which does the job:- #!/bin/sh olddir="7.04.03" olddir1="`echo $olddir| cut -c1 `" olddir2="`echo $olddir| cut -f2 -d"." `" olddir3="`echo $olddir| cut -f3 -d"." `" if [ "$olddir3" = "" ]; then olddir3=00 fi fullversion="$olddir1""$olddir2""$olddir3" VER="7.05" ver1="`echo $VER| cut -c1 `" ver2="`echo $VER| cut -f2 -d"." `" ver3="`echo $VER| cut -f3 -d"." `" if [ "$ver3" = "" ]; then ver3="00" # echo "The third version value is $ver3" fi fullver="$ver1""$ver2""$ver3" if [ "$fullversion" -gt "$fullver" ];then echo "The $olddir version is greater than $VER version" elif [ "$fullversion" -lt "$fullver" ];then echo "The $olddir version is less than $VER version" else echo "Both versions are equal" fi == Basically I strip away the release nos. like instead of accepting 7.04.03, I accept it as 70403 and then compare and output. Thanks for help. Regrads, Raja On Wed, 11 Apr 2001 02:30:36 lerobe - Lee Robertson wrote: Why not simply do the following passing two parameters to the script eg. call the script test.sh and call it so test.sh 2 1 This results in output "VAR1 is greater than VAR2" then test.sh 1 2 this results in output "VAR2 is greater than VAR1" Cheers. #!/bin/ksh VAR1=$1 VAR2=$2 if [ "$VAR1" -gt "$VAR2" ] then echo "VAR1 is greater than VAR2" else echo "VAR2 is greater than VAR1" fi -Original Message- Sent: 11 April 2001 10:01 To: Multiple recipients of list ORACLE-L Hi I'm sure there are better ways but awk does the trick echo $var1 $var2 | awk '{ if ( $1 $2 ) { print "1"} else { print"0" } }' cheers alex Hello, I need some help in comparing 2 nos. in a unix shell. 1) e.g var1="7.04.03" and var2="7.05" I want to test:- if [ "$var2" "$var1" ];then then $var2 version is greater than $var1" fi 2) 2nd condition is :- var1="7.04.03" var2="7.04.02" I want to test:- if [ "$var1" "$var2" ];then then $var1 version is greater than $var2" fi Can some one send me a code? How can I do the above in shell? Can you please help me, a seemingly simple one! Raja Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Apostolopoulos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing