RE: Veritas Backup Question
If you have the room, I would suggest doing a daily export of the database until you get all the problems ironed out with Netbackup. Especially if you are trying to do incremental backups. That way you will at least have something to restore with if you find out your Netbackup plan wasn't working. Also, don't trust any backup plan until you have backed it up every which way AND restored it using the backups. I export every day and then run the export through WinZip to save space. I keep the export around for at least a week. Good Luck! R. Smith -Original Message- Sent: Thursday, January 15, 2004 11:50 AM To: Multiple recipients of list ORACLE-L Teresita, You've gotten some good comments...even a quick tutorial on backups. My recommendation to you (especially if you don't have any backups at all) is that until you're more familiar with the tools you have that you should initially avoid the complexities of incremental backups and immediately arrange for a regular "cold" (database down) backup. Minimally this should include all datafiles, control files, online redologs, and archived redologs (you didn't say whether or not you are in archivelog mode). But don't stop with these files. Check documentation CD. It will have a section on backup and recovery. Kip |Hi!! |My name is Tere Castro I am from Mexico I am not a DBA, I uses ORacle |just to make queries, funtions some updates and create indexes or |tables, that all. |Now I am in a little difficult situation, here we have a DBA that do |not have much experience. He has been working with Veritas NetBackup |4.5 for Windows for three moths with out results. We still can not |make a backup of our data bases. The situation is that because of that |my boss make me work with him in this task, of course I don't know |anything about the issue and my priority for tomorrow is to make and |investigation of how other people make their backups with Veritas. |Our DBA explain us that it was a way that he saw in a book, first make a |complete backup of our databases on Sunday then from Monday thru Wednesday |made a incremental backup, then from Thursday thru Saturday make another |incremental backup, but this one will be done from the last incremental |backup of Wednesday to the day we are. |- |--- |--- | - | -- | -- | Complete backup |1 2 34567 |1-Monday |7- Sunday |I am really lost in this task because the person that is suppose to |teach about Veritas is really reluctant , but my boss what results. If |any one can help me telling was is the better way to do a backup using |Veritas that will be great. I also need to learn Veritas so if you have |any page or document that can help I will appreciate it. We really need |to make this work because in the last weeks we are having troubles with |our server, with out explication it gets crushes. I am using Oracle |9.2.0.2 in a Windows Server with Windows 2000 SP3 and |And the veritas is VERITAS NetBackup 4.5 for Windows in a Windows Server |with Windows 2000 SP4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Any way to syncronize sequences between database?
When doing a partial data refresh, using export/import, is there any way to synchronize "Sequences" between the two databases? Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Export / Import Question
That would require effort and planning on their part. Ron -Original Message- Sent: Friday, January 09, 2004 11:05 AM To: Multiple recipients of list ORACLE-L Ron - You may want to ask yourself what you're getting into. My preference is that the developers be creating scripts to make their procedure, function, trigger changes, along with detailed instructions for installing them. I make my counteroffer that I will recover a copy of the production database from backup from them. Then they can run their scripts just like they or I am going to in production. On the other hand, if you have a lot of time on your hands, the challenge of just refreshing the data, disabling/reenabling constraints may amuse you for an afternoon. Just kidding, sort of. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 8:09 AM To: Multiple recipients of list ORACLE-L I have a user who want to refresh only the DATA in a test database with DATA from the production database. He does not want to replace any procedures, functions, triggers, etc... My question is, if I do a full or user level export, then turn around and do a full or user level import with IGNORE=Y (after truncating the tables) will the procedures, functions, triggers be replaced anyway? I have a feeling they will. If so, is there any way to prevent this? Thanks! R Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Export / Import Question
I have a user who want to refresh only the DATA in a test database with DATA from the production database. He does not want to replace any procedures, functions, triggers, etc... My question is, if I do a full or user level export, then turn around and do a full or user level import with IGNORE=Y (after truncating the tables) will the procedures, functions, triggers be replaced anyway? I have a feeling they will. If so, is there any way to prevent this? Thanks! R Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to refresh
Thanks! I'll try it. Ron -Original Message- Sent: Tuesday, December 16, 2003 9:44 AM To: Multiple recipients of list ORACLE-L Here is a sample of the script I run to disable FK constraints: declare lTables DBMS_SQL.VARCHAR2_TABLE; lConstraints DBMS_SQL.VARCHAR2_TABLE; nJ BINARY_INTEGER; BEGIN SELECT table_name, constraint_name BULK COLLECT INTO lTables, lConstraints FROM user_constraints WHERE owner = 'IPN_DBA' AND constraint_type = 'R'; FOR nJ IN 1..lTables.COUNT LOOP DBMS_OUTPUT.PUT_LINE(lTables(nJ) || ': ' || lConstraints(nJ)); -- just for logging EXECUTE IMMEDIATE 'ALTER TABLE ' || lTables(nJ) || ' MODIFY CONSTRAINT ' || lConstraints(nJ) || ' DISABLE'; END LOOP; END; / Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Smith, Ron L. Sent: Tuesday, December 16, 2003 10:25 AM To: Multiple recipients of list ORACLE-L Seems like last time I tried to disable constraints Oracle complained and wouldn't let me due to dependant objects or something. Ron -Original Message- Sent: Tuesday, December 16, 2003 9:15 AM To: Multiple recipients of list ORACLE-L You can always disable triggers and constraints in existing schema before running import (and then, enable them after import is done). Also, specify "CONSTRAINTS=N" and "TRIGGERS=N" when exporting. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Smith, Ron L. Sent: Tuesday, December 16, 2003 9:55 AM To: Multiple recipients of list ORACLE-L I need to do a refresh of a test database using production data. We use import for this. In the past we have always dropped the schemas (4 or 5), recreated the schemas, and then did a full import with ignore=n. This time the user does not want to lose any of the new functions and procedures that are in test, but not in prod. Instead, they would like to just refresh the table data. Last time we tried this we had all kinds of trouble with functions, triggers, constraints, etc... and ended up doing a full import. Is there a tried and true way to just refresh the table data without losing anything else and without having all the problems with triggers and constraints? Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net
RE: How to refresh
Seems like last time I tried to disable constraints Oracle complained and wouldn't let me due to dependant objects or something. Ron -Original Message- Sent: Tuesday, December 16, 2003 9:15 AM To: Multiple recipients of list ORACLE-L You can always disable triggers and constraints in existing schema before running import (and then, enable them after import is done). Also, specify "CONSTRAINTS=N" and "TRIGGERS=N" when exporting. Igor Neyman, OCP DBA [EMAIL PROTECTED] -----Original Message- Smith, Ron L. Sent: Tuesday, December 16, 2003 9:55 AM To: Multiple recipients of list ORACLE-L I need to do a refresh of a test database using production data. We use import for this. In the past we have always dropped the schemas (4 or 5), recreated the schemas, and then did a full import with ignore=n. This time the user does not want to lose any of the new functions and procedures that are in test, but not in prod. Instead, they would like to just refresh the table data. Last time we tried this we had all kinds of trouble with functions, triggers, constraints, etc... and ended up doing a full import. Is there a tried and true way to just refresh the table data without losing anything else and without having all the problems with triggers and constraints? Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to refresh
Like I said. There are new packages, procedures, functions, etc... in TEST that we do not want to lose. Ron -Original Message- Sent: Tuesday, December 16, 2003 9:04 AM To: Multiple recipients of list ORACLE-L Ron - You should consider refreshing the instance by cloning your production database. This way you get an exact replica in all respects, and you can test your backup as a bonus. If you are interested in this method, tell us how you backup your production database. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 16, 2003 8:55 AM To: Multiple recipients of list ORACLE-L I need to do a refresh of a test database using production data. We use import for this. In the past we have always dropped the schemas (4 or 5), recreated the schemas, and then did a full import with ignore=n. This time the user does not want to lose any of the new functions and procedures that are in test, but not in prod. Instead, they would like to just refresh the table data. Last time we tried this we had all kinds of trouble with functions, triggers, constraints, etc... and ended up doing a full import. Is there a tried and true way to just refresh the table data without losing anything else and without having all the problems with triggers and constraints? Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to refresh
I need to do a refresh of a test database using production data. We use import for this. In the past we have always dropped the schemas (4 or 5), recreated the schemas, and then did a full import with ignore=n. This time the user does not want to lose any of the new functions and procedures that are in test, but not in prod. Instead, they would like to just refresh the table data. Last time we tried this we had all kinds of trouble with functions, triggers, constraints, etc... and ended up doing a full import. Is there a tried and true way to just refresh the table data without losing anything else and without having all the problems with triggers and constraints? Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: unix question
The following statement will delete all files older than 5 days: find . -name 'files_you_want_to_delete*.log' -mtime +5 -exec rm {} \; To test it, change the name of the file name and change the 'rm' to 'ls'. It should just list the files older than 5 days. That way you know it is working. Ron Smith -Original Message- Sent: Wednesday, November 19, 2003 3:10 PM To: Multiple recipients of list ORACLE-L USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE. COUNT=`ls -lrt /|wc -l` if [ $COUNT -ge 4 ] ; then find -name -mtime +4 -exec rm -f {} \; fi USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE. HTH, Bambi. -Original Message- Sent: Wednesday, November 19, 2003 2:21 PM To: Multiple recipients of list ORACLE-L I want to store some files. I make a new copy every night. I want to archive it back 4 days. So after 4 days, I want to delete the old copy. How do I do this? However, if i miss a nightly batch and have less than 4 copies, I do not want to delete any? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL Query
:09 PM To: Multiple recipients of list ORACLE-L Bambi, Your second query is wrong because all extents in a tablespace don't necessarily belong to the same datafile. Try the query without the aggregate functions and the GROUP BY, and you'll understand your mistake. HTH, SF "Bellow, Bambi" wrote: > > Friends -- > > Why would these two queries return different results? > > This query works. > > SQL> l > 1 select > a.tablespace_name,megs_allocated,megs_used,round(megs_used/b.megs_alloca ted, > 2)*100 pct > 2 from (select tablespace_name,sum(bytes)/(1024*1024) megs_used > 3 from dba_extents group by tablespace_name) a, > 4 (select tablespace_name,sum(bytes)/(1024*1024) megs_allocated > 5 from dba_data_files group by tablespace_name) b > 6 where a.tablespace_name=b.tablespace_name > 7* and a.tablespace_name='NAUAT' > SQL> / > > TABLESPACE_NAMEMEGS_ALLOCATED MEGS_USEDPCT > -- -- -- -- > NAUAT22924.25 11509 50 > > This query does not work > > 1 select a.tablespace_name,sum(b.bytes)/(1024*1024) megs_allocated, > 2 sum(a.bytes)/(1024*1024) megs_used, > 3 round(sum(a.bytes)/sum(b.bytes),4)*100 pct > 4 from dba_extents a, dba_data_files b > 5 where a.tablespace_name=b.tablespace_name > 6 and a.tablespace_name='NAUAT' > 7* group by a.tablespace_name,b.tablespace_name > SQL> / > > TABLESPACE_NAMEMEGS_ALLOCATED MEGS_USEDPCT > -- -- -- -- > NAUAT 31773010.5 23018.07 > > Bambi. > -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Stop using SYS, SYSTEM?
Where we work, there is one DBA responsible for each database. Each DBA is responsible for dozens of databases, servers, and applications. The only time another DBA is in one of my databases is when I am out of the office and can't get to a phone line or network connection. We never use SYS but it was included in the audit so I included it in the question. We still have to use SYS and SYSTEM for database creates, full exports, imports, etc...The only thing I can see creating a dummy SYSTEM account would do is to add one more userid and dozens of new passwords to the database and more work for an already short handed staff. Ron Smith -Original Message- Sent: Wednesday, November 12, 2003 3:59 PM To: Multiple recipients of list ORACLE-L Hi Ron, I just starte to write an answer to agree with your auditor based on accountability and i saw Arup's answer come through so I have deleted my answer and just say i concur whole heartedly with Arup. I also conduct oracle security audits and i suggest to clients not to use SYS or SYSTEM for day to day work. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Stop using SYS, SYSTEM?
We are being asked by Auditing to stop using the SYS, and SYSTEM accounts. They would like for us to create an Oracle Role with the same permissions a SYS and SYSTEM, then grant the role to each of the DBA's. Don't ask me why. Nothing is being audited in 99% of the databases. They just say it in a paper some where so they said we shouldn't use it. This seems like it would cause lots of problems with exports, imports, installs, etc... Has anyone had to deal with this type of request? Any potential problems with making the change? Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Valid Oracle Passwords
Can anyone tell me the requirements and characters for a valid Oracle password. I have looked through the Oracle 8i documentation CD and I can't seem to find anything. Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DBA Support Database
I was thinking about putting together a database that contains a list of DBAs, servers, databases, and applications. The database would be used by the Helpdesk and Management to see who is responsible for a given application or database when problems occur. I thought I would check first and see if anyone has already designed such a database and might be willing to share it. Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database just stops
Title: Message Thanks for the replies. The server admin fessed up and said he had bounced the server a few times to do some software installs. Thanks! Ron -Original Message-From: Stephane Paquette [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 14, 2003 4:10 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Database just stops If the archive destination is full then for sure the database will stop but it will not crash. It's probably a bug, you should probably go to 8.1.7.4. Talking about database stop, I just did an audit at a client site, during my spare time. The top 3 SQL: The first one was run 20 times per second and has 1280 gets The second one was run 14 times per minute and each execution has 78091 gets The third one was run 1 per minute and each execution has 965637 gets. The database was really stopped !!! Of course the application vendor was talking about adding more hardware ... Stephane -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Oracle-LSent: 14 octobre, 2003 16:40To: Multiple recipients of list ORACLE-LSubject: Re: Database just stops When you mean by "stops" - do u mean you are not able to connect any more from sql*net ? or even the current sessions hang ? Are you running this in archivelog mode ? Is it possible that the database is in archivelog more and the archiver is not running ? Babu - Original Message - From: Smith, Ron L. To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 14, 2003 3:14 PM Subject: Database just stops I have an Oracle 8.1.7.0 database running on an MS2000 server. A few times a day the database just stops running for no reason. There are no messages in the alert or trace logs. Nothing in the Event logs. It just stops. When I restart the database it goes through crash recovery but comes up fine. Anyone have any ideas? Thanks! Ron Smith
Database just stops
Title: Message I have an Oracle 8.1.7.0 database running on an MS2000 server. A few times a day the database just stops running for no reason. There are no messages in the alert or trace logs. Nothing in the Event logs. It just stops. When I restart the database it goes through crash recovery but comes up fine. Anyone have any ideas? Thanks! Ron Smith
RE: Help with a scripting problem
Never mind. The error was related to another problem with the script. Thanks! Ron -Original Message- Sent: Wednesday, October 08, 2003 5:24 PM To: Multiple recipients of list ORACLE-L Try using double quotes: select 'host "c:\program files\resource kit\robocopy" f:\oracle\oradata\llbot1\archive\ e:\BACKUP\llbot1\HOT\arch /Move;' from dual; Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Smith, Ron L. Sent: Wednesday, October 08, 2003 5:05 PM To: Multiple recipients of list ORACLE-L Sorry, this is what I am trying to run. But again, it barfs on the 'program files' portion of the script. I have tried with and without quotes. set heading off; set feedback off; set linesize 1000; spool e:\BACKUP\llbot1\scripts\ARC_PLUS2.sql; select 'spool e:\BACKUP\llbot1\HOT\log\ARC_BACKUP.LOG2;' from dual; select 'alter system switch logfile;' from dual; select 'alter system switch logfile;' from dual; select 'alter system switch logfile;' from dual; select 'alter system archive log stop;' from dual; select 'host c:\program files\resource kit\robocopy f:\oracle\oradata\llbot1\archive\ e:\BACKUP\llbot1\HOT\arch /Move;' from dual; select 'host mkdir f:\oracle\oradata\llbot1\archive;' from dual; select 'alter system archive log start;' from dual; select 'exit;' from dual; spool off; exit; Thanks! Ron -Original Message- Sent: Wednesday, October 08, 2003 3:57 PM To: [EMAIL PROTECTED]; Smith, Ron L. Ron, First of all, is echo a SQL*Plis command? Secondly, I think this will do what you want: select 'host "c:\program files\resource kit\robocopy"' from dual; as long as what you want is to execute the robocopy program from the SQL*Plus prompt. If you want to do something else, clarify your intentions on the list. Stephen >>> [EMAIL PROTECTED] 10/08/03 04:34PM >>> I am trying to issue the following command in SQL*PLUS but it doesn't like the space between 'program' and 'files'. Can anyone tell me how to get around this? echo select 'host c:\program files\resource kit\robocopy;' from dual; Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help with a scripting problem
Sorry, this is what I am trying to run. But again, it barfs on the 'program files' portion of the script. I have tried with and without quotes. set heading off; set feedback off; set linesize 1000; spool e:\BACKUP\llbot1\scripts\ARC_PLUS2.sql; select 'spool e:\BACKUP\llbot1\HOT\log\ARC_BACKUP.LOG2;' from dual; select 'alter system switch logfile;' from dual; select 'alter system switch logfile;' from dual; select 'alter system switch logfile;' from dual; select 'alter system archive log stop;' from dual; select 'host c:\program files\resource kit\robocopy f:\oracle\oradata\llbot1\archive\ e:\BACKUP\llbot1\HOT\arch /Move;' from dual; select 'host mkdir f:\oracle\oradata\llbot1\archive;' from dual; select 'alter system archive log start;' from dual; select 'exit;' from dual; spool off; exit; Thanks! Ron -----Original Message- Sent: Wednesday, October 08, 2003 3:57 PM To: [EMAIL PROTECTED]; Smith, Ron L. Ron, First of all, is echo a SQL*Plis command? Secondly, I think this will do what you want: select 'host "c:\program files\resource kit\robocopy"' from dual; as long as what you want is to execute the robocopy program from the SQL*Plus prompt. If you want to do something else, clarify your intentions on the list. Stephen >>> [EMAIL PROTECTED] 10/08/03 04:34PM >>> I am trying to issue the following command in SQL*PLUS but it doesn't like the space between 'program' and 'files'. Can anyone tell me how to get around this? echo select 'host c:\program files\resource kit\robocopy;' from dual; Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Help with a scripting problem
Title: Message I am trying to issue the following command in SQL*PLUS but it doesn't like the space between 'program' and 'files'. Can anyone tell me how to get around this? echo select 'host c:\program files\resource kit\robocopy;' from dual; Thanks! Ron Smith
nt script
I am trying to test a hot backup script I downloaded from one of the Oracle sites. Everything works great but there is one statement that backs up the control file to a specific file. I can't get the command interpreter to handle it properly. The script is generating a SQL script which is then executed from within SQL*PLUS. The command contains a file name that must be enclosed in quotes. I can't seem to get the system to pass the quotes properly. Can anyone help? Sample code: set BKP_CONTROL="'d:\backup\PRACTICE\HOT\control\controlfile.ctl'" echo dbms_output.put_line(' alter database backup controlfile to '^|^|%BKP_CONTROL%^|^|' REUSE '); >>%HFILE% Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RMAN Problem
I am trying to learn RMAN using the Oracle Backup & Recovery 101 book. I keep running into the error below. ORA-01102 cannot mount database in EXCLUSIVE mode This is on an NT server. I can't see that the database is already up. Never had this problem before. Any ideas? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-600
Title: Message This is on an old 7.3.4 database. I can't find the same error on Metalink. Anybody have any ideas what might be the cause? ORA-00600: internal error code, arguments: [17114], [1074346728], [], [], [], [], [], [] Ron Smith
RE: Database Cloning
Thank you! I thought I was going to have to quit drinking. Or drink more. Ron -Original Message- Sent: Monday, September 15, 2003 4:30 PM To: Multiple recipients of list ORACLE-L >Your belief was wrong. Actually, the belief was correct for some versions of oracle and some platforms. Case in point was Oracle 7 on an HP server. The source must be down in order to bring up the clone and recreate the control file. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] om To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Re: Database Cloning .com 09/15/2003 02:39 PM Please respond to ORACLE-L "Smith, Ron L." wrote: > > Whenever we clone a database on the same server we have always had the > understanding that the original database must be down until the new > database is renamed by running the control file script. > > I am going through the Oracle Recovery 101 book in an effort to > understand RMAN and one chapters in the book is cloning a database on > the same server. I just went through the steps to create a clone of a > hot database. I created the new database on the same server with a > new name while the original database was up and running. I had no > problems. Was our belief that the original database had to be down, > incorrect, or was this just a restriction of older version like 7.3.4? > > Thanks! > Ron Smith Ron, When you clone a database, you start with : 1) changing db_name in the init.ora file and most paths 2) defining a new ORACLE_SID and renaming init.ora accordingly 3) starting the instance without mounting it - your init.ora file is opened and read. Where do you want anything to interact (badly) with an existing database? You have allocated some shared memory, have started a few processes and read a file. Big deal. Your belief was wrong. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Database Cloning
Whenever we clone a database on the same server we have always had the understanding that the original database must be down until the new database is renamed by running the control file script. I am going through the Oracle Recovery 101 book in an effort to understand RMAN and one chapters in the book is cloning a database on the same server. I just went through the steps to create a clone of a hot database. I created the new database on the same server with a new name while the original database was up and running. I had no problems. Was our belief that the original database had to be down, incorrect, or was this just a restriction of older version like 7.3.4? Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle and Perl
Worked Great! Thanks! Ron -Original Message- Sent: Tuesday, September 09, 2003 9:09 AM To: Multiple recipients of list ORACLE-L Hi, Ron my $ORA_SID = $ENV{'ORACLE_SID'} my ORAC_HOME = $ENV{'ORACLE_HOME'} should siffice ;) HTH. Milen -Ursprüngliche Nachricht----- Von: Smith, Ron L. [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 9. September 2003 15:39 An: Multiple recipients of list ORACLE-L Betreff: Oracle and Perl Can anyone tell me how to pick up the $ORACLE_SID or $ORACLE_HOME from within a Perl script? Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle and Perl
Can anyone tell me how to pick up the $ORACLE_SID or $ORACLE_HOME from within a Perl script? Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle on Win2000
Title: Message Be careful using Terminal Server. If you are running batch jobs, the variables like ORACLE_SID and ORACLE_HOME don't always get picked up correctly by the batch job. I have spent hours trying to debug a script run with Terminal Server, then switch to VNC and it works fine. Ron Smith -Original Message-From: Branimir Petrovic [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 4:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle on Win2000 Windows Terminal services that comes with Windows (in Control Panel, Add/Remove Programs, Add/Remove Windows Components, then install Windows Terminal Client on admin PC). Bigger hassle to install and configure, but a LOT better performer than PCAnywhere or VNC (other two "usual suspects" for remoting unremoteable). Branimir -Original Message-From: Bala Regupathy [mailto:[EMAIL PROTECTED]Sent: September 3, 2003 1:44 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle on Win2000 First time I have got to maintain Oracle databases on Win 2000 server. What tools do you guys use to get to the server to admin oracle databases ? Thanks, Bala.
ROW_ID Hint
I have a vendor application that is running slow. I looked at the code through a product called SQLab and found that most of the code has a ROW_ID hint coded in it. My understanding is that this hint will prevent the code from using indexes even though the tables and indexes are analyzed. I modified the Oracle startup parameters to use optimizer mode = FIRST_ROWS which favors indexes. Now when I run the application the response time is much better. I am thinking this may be a good fix but is there any kind of program logic I could be screwing up by using FIRST_ROWS? Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Export 8.1.7 - Import 7.3.4
I need to export the data from an Oracle 8.1.7 database HPUX 64 and import it back into an old 7.3.4 HPUX 32 database. The 7.3.4 import doesn't like the 8.1.7 export file. Any ideas? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Poor performance after moving Extempore database from 7.3.4 to 8.1.7
The old and new versions were both set to CHOOSE. Both are analyzed. Are you saying 8.1.7 handles this differently? Thanks! Ron -Original Message- Sent: Monday, August 11, 2003 3:04 PM To: Multiple recipients of list ORACLE-L to 8.1.7 RBO, CBO, the old story. If you plan to continue using 8.1.7 for a While, then set the parameter OPTIMIZER_MODE to RULE. Your performance will be normal again and programmers will be able to override the parameter By specifying any hint except /*+ RULE */. Before switching to CBO, please read the article about the intelligent life in the optimizer. The article itself is a good one (thanks, Tim) but reading the book from JL (Jonathan Lewis, not Jeniffer Lopez) wouldn't hurt, either. -- Mladen Gogala Oracle DBA -Original Message- Smith, Ron L. Sent: Monday, August 11, 2003 3:14 PM To: Multiple recipients of list ORACLE-L 8.1.7 We recently upgraded an application (Extempore) database from Oracle 7.3.4 to 8.1.7. The clients say the test database, still on Oracle 7.3.4 is much faster than the production database, now on 8.1.7. The server is newer and faster on the production database. The Oracle init parameters are pretty much identical. When I access the database through SQL*PLUS or TOAD, the response is instantaneous. The app uses an ODBC connection which is also 8.1.7. I have tried attaching the tables in MS Access through ODBC. This too is instantaneous. Any ideas? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Poor performance after moving Extempore database from 7.3.4 to 8.1.7
Can you give me starting values to try in the optimizer parameters? Ron -Original Message- Sent: Monday, August 11, 2003 3:44 PM To: Multiple recipients of list ORACLE-L to 8.1.7 Yes it does. 8i has parameters optimizer_index_cost_adj and optimizer_index_caching, which don't exist in 7.3. And these parameters' default values aren't optimal. Also, when testing your app, be sure that you're comparing oranges with oranges, e.g. if your app uses bind variables but your sqlplus test doesn't, the comparision is quite pointless... Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, August 11, 2003 11:24 PM 8.1.7 > The old and new versions were both set to CHOOSE. Both are analyzed. > Are you saying 8.1.7 handles this differently? > > Thanks! > Ron > > -Original Message- > Sent: Monday, August 11, 2003 3:04 PM > To: Multiple recipients of list ORACLE-L > to 8.1.7 > > > RBO, CBO, the old story. If you plan to continue using 8.1.7 for a > While, then set the parameter OPTIMIZER_MODE to RULE. Your performance > will be normal again and programmers will be able to override the > parameter By specifying any hint except /*+ RULE */. Before switching > to CBO, please read the article about the intelligent life in the > optimizer. The article itself is a good one (thanks, Tim) but reading > the book from JL (Jonathan > Lewis, not Jeniffer Lopez) wouldn't hurt, either. > > -- > Mladen Gogala > Oracle DBA > > > > -Original Message- > Smith, Ron L. > Sent: Monday, August 11, 2003 3:14 PM > To: Multiple recipients of list ORACLE-L > 8.1.7 > > > > We recently upgraded an application (Extempore) database from Oracle > 7.3.4 to 8.1.7. The clients say the test database, still on Oracle > 7.3.4 is much faster than the production database, now on 8.1.7. The > server is newer and faster on the production database. The Oracle > init parameters are pretty much identical. > > When I access the database through SQL*PLUS or TOAD, the response is > instantaneous. The app uses an ODBC connection which is also 8.1.7. > I have tried attaching the tables in MS Access through ODBC. This too > is instantaneous. > > Any ideas? > > Ron Smith > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Smith, Ron L. > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L (or the > name of mailing list you want to be removed from). You may also send > the HELP command for other information (like subscribing). > > > Note: > This message is for the named person's use only. It may contain > confidential, proprietary or legally privileged information. No > confidentiality or privilege is waived or lost by any mistransmission. > If you receive this message in error, please immediately delete it and > all copies of it from your system, destroy any hard copies > of it and notify the sender. You must not, directly or > indirectly, use, disclose, distribute, print, or copy > any part of this message if you are not the intended > recipient. Wang Trading LLC and any of its subsidiaries > each reserve the right to monitor all e-mail > communications through its networks. > > Any views expressed in this message are those of the individual > sender, except where the message states otherwise and the sender is > authorized to state them to be the views of any such entity. > - > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L (or the > name of mailing list you want to be removed from). You may also send > the HELP command for other information (like subscribing). > -- > Please see t
RE: ODBC Problem with @ sign
Title: Message Is anyone aware of a problem with the 8.1.7 Client ODBC driver handling the '@' sign? Ron Smith
Semaphore problem
Has anyone ever seen an error like: ERROR: rbusy(SEMOP) (13; Permission denied) There is no Oracle error associated with it. Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Poor performance after moving Extempore database from 7.3.4 to 8.1.7
We recently upgraded an application (Extempore) database from Oracle 7.3.4 to 8.1.7. The clients say the test database, still on Oracle 7.3.4 is much faster than the production database, now on 8.1.7. The server is newer and faster on the production database. The Oracle init parameters are pretty much identical. When I access the database through SQL*PLUS or TOAD, the response is instantaneous. The app uses an ODBC connection which is also 8.1.7. I have tried attaching the tables in MS Access through ODBC. This too is instantaneous. Any ideas? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ODBC Problem with @ sign
Title: Message Is anyone aware of a problem with the 8.1.7 Client ODBC driver handling the '@' sign? Ron Smith
RE: Move selected tables
Thanks for all the info and various ways to handle this. I was kinda hoping there was a magic tables=( abc_% ) parameter for export that I didn't know about. I think I'll use the SQL generating SQL idea. Sounds like the quickest way. Thanks again! Ron -Original Message- Sent: Monday, August 04, 2003 12:04 PM To: Multiple recipients of list ORACLE-L You've gotten several suggestions for how to move the data - let me mention some of the caveats. We went from one big shared schema to several smaller schemas, which is what led to issue 3 below. If that's not what you're doing, you may not have this problem. We've done some of this, and here are some of the issues we've run into. 1) make sure your referential integrity is maintained. If you are moving a parent or child table, you'll have to drop and recreate any foreign keys. export/import makes this somewhat easier than 'create as select *', but not trivial. It's easier if you move both parents and children in the same export set (assuming they're all being moved). 2) make sure the data doesn't change while you're moving the tables. What we've done in some cases is open an SQLPlus window, lock the tables, then do the export/import in a different shell. 3) make sure any code finds the correct tables. We've created private synonyms for the tables in the new locations as an interim solution. There is a little overhead associated with resolving synonyms while parsing queries but it doesn't seem to be a problem for us. The down side is that there is not much incentive for developers to point to the correct tables, and there's no good way to keep someone from referring to the old schema when they should be using the new schema. Some on this list will say this is a matter of DBA discipline: at any rate it is a matter of management discipline, and the DBA's ability to do anything about it depends on how much control they have over introduction of new code. Good luck, -Chris > -Original Message- > From: Smith, Ron L. [mailto:[EMAIL PROTECTED] > Sent: Monday, August 04, 2003 12:14 PM > To: Multiple recipients of list ORACLE-L > Subject: Move selected tables > > > I need to move selected tables from one schema to another > schema within > the same database. The tables I need to move all start with the same > prefix (abc_sometablename). Say there are 200 tables out of > 1000 that I > want to move. Is there an easy way to do this? > > Thanks! > Ron > -- LEGAL NOTICE: Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sarnowski, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Move selected tables
I need to move selected tables from one schema to another schema within the same database. The tables I need to move all start with the same prefix (abc_sometablename). Say there are 200 tables out of 1000 that I want to move. Is there an easy way to do this? Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Redo Logs Problem
Title: Message This may have already been asked, but is it possible there is a datafile in backup mode even though a backup is not running? -Original Message-From: Whittle Jerome Contr NCI [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 10:24 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Redo Logs Problem >> This has suddenly started from the last 1 week without any changes to Database Configuration or any other system settings (as per client). Clients lie. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Munish Bajaj [SMTP:[EMAIL PROTECTED] Hi Listers, One of my remote Clients is facing a problem with Redo Logs. The Redo Logs and the Archive logs in turn have suddenly started to generate at an alarming Rate. This has suddenly started from the last 1 week without any changes to Database Configuration or any other system settings (as per client). Can anyone please help me and let me know all the reasons that could be responsible for this behavior. Any Help from u will be appreciated. Regards Munish Bajaj
RE: HELP! Index Debate!
Thank you very much for the detailed info! Ron -Original Message- Sent: Thursday, July 31, 2003 5:09 PM To: Multiple recipients of list ORACLE-L Provided we are talking cost based optimizer, then the order of the predicates in the where clause does not matter - except under very rare conditions to break a tie. Nor is the order of the predicates in the where clause related to the order of the columns in the index. The only thing that matters is which columns of the index are present in the where clause and what is their relative position in the index. It's probably best explained with an example: index on c1, c2, c3, c4, ... where clause: c1 = ... and c2 = ... index can be used c2 = ... and c1 = ... index can be used c1 = ... and c3 = ... index can be used, but only c1 = portion of index since c2 is not in a predicate, here an index on c1, c3, c2, ... would be better, then both c1= and c3= can be used. c2 = ... and ...index can not be used (not until Oracle 9); but index on c2, ... could be used c1 = ... and c2 = ... and c3 > ... and c4 = index can be used, but only the c1=, c2= and c3 > portion since the inequality breaks the chain; an index on c1, c2, c4, c3 (or c2, c1, c4, c3 or c4, c1, c2, c3 etc ) could use all predicates on the index. as long as the leading columns are present in the where clause with an equal predicate, the index can be used. The first omission or non-equal predicate breaks the chain and only the part of the index up to that column can be used. Oracle is built around composite (or compound) indexes. Except for bitmap indexes it does not easily use more than one index for the same table access. The optimizer is slowly learning to use more than one index, but it's still rare. And yes, you can determine how many and which predicates are used for the index access, but you need to run a CBO trace to find out. At 12:34 PM 7/31/2003 -0800, you wrote: >Please help resolve this dispute. >We have a query that runs over 5 hours. Sections of the query are >listed below. > >The table QOH_DAY_FACT table had only on index and that was on the >TIME_ID column. I propose adding an index with PROD_ID, WHS_ID, >LOT_ID, WHS_LOC, TIME_ID and QUALITY_ID. My test shows the runtime was >reduced to about 1.5 hours. > >The developer said all the columns in the index except PROD_ID were >being ignored. He says there should be six separate indexes, one for >each column before Oracle will use them. > >Also, does the order of the columns in the index have to match the >order of the columns in the WHERE CLAUS or is it more important to >match the WHERE CLAUS to the data content (least number of rows first)? > >I will be running more tests, but I would like some input on this if >anyone has an opinion. > >Thanks! >Ron > > >select T1."COUNTRY_NAME" "c1" > , T2."PRODTN_PROC_NAME" "c2" > , T2."PLANT_NAME" "c3" > , T1."WHS_NAME" "c4" > , T1."WHS_CMPLX_NAME" "c5" > , T3."WHS_LOC_NAME" "c6" > , T4."GRADE_DESC" "c7" > , T4."PACK_DESC" "c8" > , T5."FULL_DT" "c9" > , T6."QOH_MT" "c10"... > >from "DWMART"."DISTRIB_FCLTY_DIM" T1 > , "DWMART"."MFG_FCLTY_DIM" T2 > , "DWMART"."DISTRIB_LOC_DIM" T3 > , "DWMART"."TIME_DIM" T5 > , "DWMART"."QUALITY_DIM" T7 > , "DWMART"."QOH_DAY_FACT" T6 > , "DWMART"."PROD_DIM" T4 >where T6."PROD_ID"=T4."PROD_ID"(+) >and T6."WHS_ID"=T1."WHS_ID" >and T6."LOT_ID"=T2."LOT_ID" >and T6."WHS_LOC_ID"=T3."WHS_LOC_ID" >and T6."TIME_ID"=T5."TIME_ID" >and T6."QUALITY_ID"=T7."QUALITY_ID" >order by "c9" asc >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Smith, Ron L. > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com >San Diego, California-- Mailing list and web hosting services >- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the >message BODY, include a line containing: UNSUB ORACLE-L (or the name of >mailing list you want to be removed from). You may also send the HELP >command for other information (like subscribing). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DB
RE: HELP! Index Debate!
Title: Message Yes, the first column on each table is the column referenced in the SQL. They all have indexes on the first column. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 3:59 PMTo: Multiple recipients of list ORACLE-LSubject: RE: HELP! Index Debate! do you have corresponding indexes on referenced columns on T1-5 tables ?? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Smith, Ron L. [mailto:[EMAIL PROTECTED]Sent: Thursday, July 31, 2003 4:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: HELP! Index Debate! No answer for that. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 3:44 PMTo: Multiple recipients of list ORACLE-LSubject: RE: HELP! Index Debate! How does one know that only one column is being used in an index and others are being ignored ... ?? This is new to me. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Smith, Ron L. [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 31, 2003 4:34 PM To: Multiple recipients of list ORACLE-L Subject: RE: HELP! Index Debate! Please help resolve this dispute. We have a query that runs over 5 hours. Sections of the query are listed below. The table QOH_DAY_FACT table had only on index and that was on the TIME_ID column. I propose adding an index with PROD_ID, WHS_ID, LOT_ID, WHS_LOC, TIME_ID and QUALITY_ID. My test shows the runtime was reduced to about 1.5 hours. The developer said all the columns in the index except PROD_ID were being ignored. He says there should be six separate indexes, one for each column before Oracle will use them. Also, does the order of the columns in the index have to match the order of the columns in the WHERE CLAUS or is it more important to match the WHERE CLAUS to the data content (least number of rows first)? I will be running more tests, but I would like some input on this if anyone has an opinion. Thanks! Ron select T1."COUNTRY_NAME" "c1" , T2."PRODTN_PROC_NAME" "c2" , T2."PLANT_NAME" "c3" , T1."WHS_NAME" "c4" , T1."WHS_CMPLX_NAME" "c5" , T3."WHS_LOC_NAME" "c6" , T4."GRADE_DESC" "c7" , T4."PACK_DESC" "c8" , T5."FULL_DT" "c9" , T6."QOH_MT" "c10"... from "DWMART"."DISTRIB_FCLTY_DIM" T1 , "DWMART"."MFG_FCLTY_DIM" T2 , "DWMART"."DISTRIB_LOC_DIM" T3 , "DWMART"."TIME_DIM" T5 , "DWMART"."QUALITY_DIM" T7 , "DWMART"."QOH_DAY_FACT" T6 , "DWMART"."PROD_DIM" T4 where T6."PROD_ID"=T4."PROD_ID"(+) and T6."WHS_ID"=T1."WHS_ID" and T6."LOT_ID"=T2."LOT_ID" and T6."WHS_LOC_ID"=T3."WHS_LOC_ID" and T6."TIME_ID"=T5."TIME_ID" and T6."QUALITY_ID"=T7."QUALITY_ID" order by "c9" asc -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: HELP! Index Debate!
Title: Message No answer for that. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 3:44 PMTo: Multiple recipients of list ORACLE-LSubject: RE: HELP! Index Debate! How does one know that only one column is being used in an index and others are being ignored ... ?? This is new to me. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Smith, Ron L. [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 31, 2003 4:34 PM To: Multiple recipients of list ORACLE-L Subject: RE: HELP! Index Debate! Please help resolve this dispute. We have a query that runs over 5 hours. Sections of the query are listed below. The table QOH_DAY_FACT table had only on index and that was on the TIME_ID column. I propose adding an index with PROD_ID, WHS_ID, LOT_ID, WHS_LOC, TIME_ID and QUALITY_ID. My test shows the runtime was reduced to about 1.5 hours. The developer said all the columns in the index except PROD_ID were being ignored. He says there should be six separate indexes, one for each column before Oracle will use them. Also, does the order of the columns in the index have to match the order of the columns in the WHERE CLAUS or is it more important to match the WHERE CLAUS to the data content (least number of rows first)? I will be running more tests, but I would like some input on this if anyone has an opinion. Thanks! Ron select T1."COUNTRY_NAME" "c1" , T2."PRODTN_PROC_NAME" "c2" , T2."PLANT_NAME" "c3" , T1."WHS_NAME" "c4" , T1."WHS_CMPLX_NAME" "c5" , T3."WHS_LOC_NAME" "c6" , T4."GRADE_DESC" "c7" , T4."PACK_DESC" "c8" , T5."FULL_DT" "c9" , T6."QOH_MT" "c10"... from "DWMART"."DISTRIB_FCLTY_DIM" T1 , "DWMART"."MFG_FCLTY_DIM" T2 , "DWMART"."DISTRIB_LOC_DIM" T3 , "DWMART"."TIME_DIM" T5 , "DWMART"."QUALITY_DIM" T7 , "DWMART"."QOH_DAY_FACT" T6 , "DWMART"."PROD_DIM" T4 where T6."PROD_ID"=T4."PROD_ID"(+) and T6."WHS_ID"=T1."WHS_ID" and T6."LOT_ID"=T2."LOT_ID" and T6."WHS_LOC_ID"=T3."WHS_LOC_ID" and T6."TIME_ID"=T5."TIME_ID" and T6."QUALITY_ID"=T7."QUALITY_ID" order by "c9" asc -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: HELP! Index Debate!
Please help resolve this dispute. We have a query that runs over 5 hours. Sections of the query are listed below. The table QOH_DAY_FACT table had only on index and that was on the TIME_ID column. I propose adding an index with PROD_ID, WHS_ID, LOT_ID, WHS_LOC, TIME_ID and QUALITY_ID. My test shows the runtime was reduced to about 1.5 hours. The developer said all the columns in the index except PROD_ID were being ignored. He says there should be six separate indexes, one for each column before Oracle will use them. Also, does the order of the columns in the index have to match the order of the columns in the WHERE CLAUS or is it more important to match the WHERE CLAUS to the data content (least number of rows first)? I will be running more tests, but I would like some input on this if anyone has an opinion. Thanks! Ron select T1."COUNTRY_NAME" "c1" , T2."PRODTN_PROC_NAME" "c2" , T2."PLANT_NAME" "c3" , T1."WHS_NAME" "c4" , T1."WHS_CMPLX_NAME" "c5" , T3."WHS_LOC_NAME" "c6" , T4."GRADE_DESC" "c7" , T4."PACK_DESC" "c8" , T5."FULL_DT" "c9" , T6."QOH_MT" "c10"... from "DWMART"."DISTRIB_FCLTY_DIM" T1 , "DWMART"."MFG_FCLTY_DIM" T2 , "DWMART"."DISTRIB_LOC_DIM" T3 , "DWMART"."TIME_DIM" T5 , "DWMART"."QUALITY_DIM" T7 , "DWMART"."QOH_DAY_FACT" T6 , "DWMART"."PROD_DIM" T4 where T6."PROD_ID"=T4."PROD_ID"(+) and T6."WHS_ID"=T1."WHS_ID" and T6."LOT_ID"=T2."LOT_ID" and T6."WHS_LOC_ID"=T3."WHS_LOC_ID" and T6."TIME_ID"=T5."TIME_ID" and T6."QUALITY_ID"=T7."QUALITY_ID" order by "c9" asc -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle to MSSQL conversion?
- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L (or the > > name of mailing list you want to be removed from). You may also > > send the HELP command for other information (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Gudmundur Bjarni Josepsson > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L (or the > name of mailing list you want to be removed from). You may also send > the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Boivin, Patrice J > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L (or the > name of mailing list you want to be removed from). You may also send > the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
HELP! Index Debate!
Please help resolve this dispute. We have a query that runs over 5 hours. Sections of the query are listed below. The table QOH_DAY_FACT table had only on index and that was on the TIME_ID column. I propose adding an index with PROD_ID, WHS_ID, LOT_ID, WHS_LOC, TIME_ID and QUALITY_ID. My test shows the runtime was reduced to about 1.5 hours. The developer said all the columns in the index except PROD_ID were being ignored. He says there should be six separate indexes, one for each column before Oracle will use them. Also, does the order of the columns in the index have to match the order of the columns in the WHERE CLAUS or is it more important to match the WHERE CLAUS to the data content (least number of rows first)? I will be running more tests, but I would like some input on this if anyone has an opinion. Thanks! Ron select T1."COUNTRY_NAME" "c1" , T2."PRODTN_PROC_NAME" "c2" , T2."PLANT_NAME" "c3" , T1."WHS_NAME" "c4" , T1."WHS_CMPLX_NAME" "c5" , T3."WHS_LOC_NAME" "c6" , T4."GRADE_DESC" "c7" , T4."PACK_DESC" "c8" , T5."FULL_DT" "c9" , T6."QOH_MT" "c10"... from "DWMART"."DISTRIB_FCLTY_DIM" T1 , "DWMART"."MFG_FCLTY_DIM" T2 , "DWMART"."DISTRIB_LOC_DIM" T3 , "DWMART"."TIME_DIM" T5 , "DWMART"."QUALITY_DIM" T7 , "DWMART"."QOH_DAY_FACT" T6 , "DWMART"."PROD_DIM" T4 where T6."PROD_ID"=T4."PROD_ID"(+) and T6."WHS_ID"=T1."WHS_ID" and T6."LOT_ID"=T2."LOT_ID" and T6."WHS_LOC_ID"=T3."WHS_LOC_ID" and T6."TIME_ID"=T5."TIME_ID" and T6."QUALITY_ID"=T7."QUALITY_ID" order by "c9" asc -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Oracle Snapshot Too Old during programatic load
Yep, all at once. All inserts I believe. -Original Message- Sent: Monday, July 28, 2003 12:44 PM To: Multiple recipients of list ORACLE-L well does the load process happen serially or are you breaking it into pieces and doing it at once? by load I take it to mean insert update delete create index. correct? > > From: "Smith, Ron L." <[EMAIL PROTECTED]> > Date: 2003/07/28 Mon PM 01:24:23 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Oracle Snapshot Too Old during programatic load > > The index is not set up with nologging. I can build the index after > the load with no problem. There is no other activity in the database > during the load process. > > Thanks! > Ron > > -Original Message- > Sent: Monday, July 28, 2003 11:34 AM > To: Multiple recipients of list ORACLE-L > > > HUH?? > > Ron, >Is your index set up as NOLOGGING? Could you perform the load and > then add the index without having the error? Is there any other > activity on the server at the time the load is being performed? Ron > > > >>> [EMAIL PROTECTED] 07/28/03 12:24PM >>> > Try to give this index initial sufficient space so that it does not > autoextend the extents. > > -ak > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, July 28, 2003 9:09 AM > > > > I asked this last week, but I have a little more info this week. > > > > I have a table that gets programmatically loaded each night. The > table > > needs to have an index added for reporting purposes. However, when > I > > add the index to the table in the TEST database I start getting > Snapshot > > Too Old errors. I added 25% more space to the RBS tablespace but it > > didn't do any good. I also tried reducing the frequency of commits > as > > suggested in Oracle papers but I still get the same error. If I > remove > > the index, the load works fine. > > > > Any ideas? > > > > Thanks! > > Ron Smith > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Smith, Ron L. > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting > services > > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L (or the > > name of mailing list you want to be removed from). You may also send > > the HELP command for other information (like subscribing). > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: AK > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L (or the > name of mailing list you want to be removed from). You may also send > the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Ron Rogers > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > --------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L (or the > name of mailing list you want to be removed from). You may also send > the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Smith, Ron L. > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E
RE: Oracle Snapshot Too Old during programatic load
The index is not set up with nologging. I can build the index after the load with no problem. There is no other activity in the database during the load process. Thanks! Ron -Original Message- Sent: Monday, July 28, 2003 11:34 AM To: Multiple recipients of list ORACLE-L HUH?? Ron, Is your index set up as NOLOGGING? Could you perform the load and then add the index without having the error? Is there any other activity on the server at the time the load is being performed? Ron >>> [EMAIL PROTECTED] 07/28/03 12:24PM >>> Try to give this index initial sufficient space so that it does not autoextend the extents. -ak - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 28, 2003 9:09 AM > I asked this last week, but I have a little more info this week. > > I have a table that gets programmatically loaded each night. The table > needs to have an index added for reporting purposes. However, when I > add the index to the table in the TEST database I start getting Snapshot > Too Old errors. I added 25% more space to the RBS tablespace but it > didn't do any good. I also tried reducing the frequency of commits as > suggested in Oracle papers but I still get the same error. If I remove > the index, the load works fine. > > Any ideas? > > Thanks! > Ron Smith > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Smith, Ron L. > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L (or the > name of mailing list you want to be removed from). You may also send > the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: AK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Snapshot Too Old during programatic load
That's just sidestepping the problem. I agree it is an easy fix but there should be a way to diagnose and correct the problem. I have done everything suggested in the Oracle papers but nothing seems to work. There must be something I am missing. Thanks! Ron -Original Message- Sent: Monday, July 28, 2003 11:19 AM To: Multiple recipients of list ORACLE-L Smith, Ron L. scribbled on the wall in glitter crayon: > I asked this last week, but I have a little more info this week. > > I have a table that gets programmatically loaded each night. The > table needs to have an index added for reporting purposes. However, > when I add the index to the table in the TEST database I start getting > Snapshot Too Old errors. I added 25% more space to the RBS tablespace > but it didn't do any good. I also tried reducing the frequency of > commits as suggested in Oracle papers but I still get the same error. > If I remove the index, the load works fine. > > Any ideas? create the index after the load?;-) that's easily done or am i missing something? -- Bill "Shrek" Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] Science is a wonderful thing if one does not have to earn one's living at it. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Snapshot Too Old during programatic load
I asked this last week, but I have a little more info this week. I have a table that gets programmatically loaded each night. The table needs to have an index added for reporting purposes. However, when I add the index to the table in the TEST database I start getting Snapshot Too Old errors. I added 25% more space to the RBS tablespace but it didn't do any good. I also tried reducing the frequency of commits as suggested in Oracle papers but I still get the same error. If I remove the index, the load works fine. Any ideas? Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Update through a DBLink
One of or developers is work on a routine that will trigger a procedure that will use a dblink to update a table on another database. It seems like I remember that something about a problem with procedures, dblinks, updates? Does anyone remember anything about that? Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Please help with ORA-01555 Snapshot too old
They are both processing the same data, the same way. -Original Message- Sent: Tuesday, July 22, 2003 10:15 AM To: Multiple recipients of list ORACLE-L Ron I'm guessing that one of the loads receives the ORA-01555 and the other doesn't. Does the load commit occasionally? There are some pretty good papers on Metalink for this error. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 22, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Help! I have a production and a test database, both with 3000mg RBS tablespaces with two datafiles. Both have db_block_buffers set at 1000. The only difference is the production db has 7 rollback segments and the test db has 8. The rollback segments are sized at 50mg each on both databases. The problem is, at night when the batch load is running (by itself), the load fails with a ORA-01555. The data is the same on both loads. Nothing else is going on in the database during the load. Any ideas? Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Please help with ORA-01555 Snapshot too old
Title: Message Help! I have a production and a test database, both with 3000mg RBS tablespaces with two datafiles. Both have db_block_buffers set at 1000. The only difference is the production db has 7 rollback segments and the test db has 8. The rollback segments are sized at 50mg each on both databases. The problem is, at night when the batch load is running (by itself), the load fails with a ORA-01555. The data is the same on both loads. Nothing else is going on in the database during the load. Any ideas? Ron
RMAN & SQL Backtrack
Title: Message We have been using SQL Backtrack for backup and recovery for about 6 years now. We are being pressured to start using RMAN because it is free. Makes sense but I am wondering about reliability, complexity, learning curve, etc... Has anyone had experience with both products or anyone new to RMAN that can give me an idea of what to expect? Thanks! Ron If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you.
RE: nt script
dev8\_psprcsrvlog\ -s -m*.log > > > > -d+0 -c"CMD /c type > > > > d:[EMAIL PROTECTED]|findstr ORA-03113" if > > > > errorlevel 1 goto run_proc echo 'there is a match' > > > > > > > > if errorlevel 0 goto end > > > > echo 'there is no match' > > > > > > > > :run_proc > > > > d:\start_proc.bat > > > > goto end > > > > > > > > :end > > > > -- > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > > -- > > > > Author: Joan Hsieh > > > > INET: [EMAIL PROTECTED] > > > > > > > > Fat City Network Services-- 858-538-5051 > > http://www.fatcity.com > > > > San Diego, California-- Mailing list and web > > hosting services > > > > > > > > > > - > > > > To REMOVE yourself from this mailing list, send an E-Mail > > > > message > > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > > > > and in the message BODY, include a line containing: UNSUB > > > > ORACLE-L (or the name of mailing list you want to be removed > > > > from). You may also send the HELP command for other > > > > information (like subscribing). > > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Bob Metelsky > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > > San Diego, California-- Mailing list and web > > hosting services > > > > > > > - > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and > > > in the message BODY, include a line containing: UNSUB ORACLE-L (or > > > the name of mailing list you want to be removed from). You may > > also send > > > the HELP command for other information (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Joan Hsieh > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > > and in the message BODY, include a line containing: UNSUB > > ORACLE-L (or the name of mailing list you want to be removed > > from). You may also send the HELP command for other > > information (like subscribing). > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Bob Metelsky > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L (or the > name of mailing list you want to be removed from). You may also send > the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 7.3.4 on Win2000
Title: Message I need to load SQL Loader 7.3.4 on a Win2000 server. All I have is ORacle 7.3.4 for NT. Does anyone know if it will load and run ok without messing up something? Is there a CD for 7.3.4 on Win2000? Thanks! Ron If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you.
Read SQL Server from Oracle
I need to be able to read SQL Server tables from an Oracle procedure. Can anyone point me in the right direction for info? Ron Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Retreiving data from SQL Server
Can anyone give me an example of an SQL statement that will retrieve data from SQL Server. What is the best way to do this? Thanks! Ron Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Export Long Dies with no error
I am running an Oracle 8.1.7 export on a 2G table which contains a Long column. The export runs for several hours and then just dies with no error anywhere. I tried to use direct=y but I get an error about character sets. Any ideas? Thanks! Ron Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: another chance for 9i CDs - Beware!
I purchased this CD-ROM last week and I must say the quality of the copy is very poor. The graphics are poor and the sound is so low you can hardly hear it. I emailed them about the quality but they did not bother to reply. Just thought I would let you all know. Ron -Original Message- [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 11:13 AM To: [EMAIL PROTECTED] Hello, Because of strong demand from our customere, we've had more Oracle9i training CDs duplicated. This CD-ROM includes training that will teach and prepare you for the Oracle9i OCA Track which includes the following two exams: > Introduction to Oracle9i SQL > Oracle9i DBA Fundamentals I Since we are in the last week of March, I'm going to include 2 FREE BONUSES to anyone who places their order before midnight on Monday (March 31st). 1. Free Shipping to Anywhere in the World. 2. Free Access to Our Oracle Certified Mentors. I'll provide you the secret URL to our Mentor Forum and Chat Rooms so that you can get all your Oracle questions answered. To order your Oracle9i OCA CD-ROM set, and get the 2 Free Bonuses NOW, click the link below: http://www.webcontactpro.net/app/adtrack.asp?AdID=1978 If the above link is still 'Live', you're in luck. As soon as this new inventory of CDs have been sold, I'll be taking the page down. You can also call my associate Miranda at 888-320-4775 or 732-333-1112 Option #1 to order by phone. All the best, Ed Haskins, OCP OraKnowledge, Inc. 732.333.1115 P.S. To take advantage of the 2 FREE BONUSES mentioned above, you must order by Monday (March 31st) PLEASE DO NOT REPLY TO THIS MESSAGE. Your reply would be automatically deleted from the system. If you no longer wish to receive communication from us: http://www.webcontactpro.net/app/r.asp?ID=212087&ARID=0 To update your contact information: http://www.webcontactpro.net/app/r.asp?c=1&ID=212087 If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Query through database link gets lost
I have a monitoring script that polls and monitors all the databases through a database link. If someone happens to shutdown or delete a database, the SQL connection through the database link just seems to hang forever and screws everything up. Can someone tell me how to set a time limit on the calling server so the connection will time out? I already have SQLNET.EXPIRE_TIME = 60 set in the sqlnet.ora but it doesn't appear to help. Thanks! Ron Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Import data only into existing schema
I need to be able to refresh the data in the tables belonging to out test database without destroying, changing, or adding any other type of database object. The data will come from the production database. I am having a problem specifically with triggers. I don't want to add, change or delete any of the triggers in the test environment. If I do an import with the fromuser option it imports the triggers. This also happens with the tables option of import. Any ideas? Ron SMith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Disable / enable constraints
I need to truncate and import data into several schemas. The tables have lots of constraints. I can produce a script to disable and enable the contriants but I would like to know more about the constraint_type field in dba_constraints and what are all the SYS_ contraints? Should I disable all constraints for a schema before the import or only certain types? Thanks! Ron If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: shared tnsnames.ora
Below is the end of my own tnsnames.ora located on my PC. There is a common network tnsnames.ora on a network share located on my 'R' drive. The network version has all the permanent databases defined in it. I can add any temporary or new test servers to my copy of tnsnames.ora and still get to all the permanent entries when ever I need to. Works great! R. Smith test.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = someserver) (Port = 1521) ) ) (CONNECT_DATA = (SID=test) ) ) ifile=r:\tnsnames.ora -Original Message- Sent: Thursday, February 27, 2003 2:24 PM To: Multiple recipients of list ORACLE-L Use Oracle Names. Easy to setup/maintain. never touch a client config again. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] ine.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: shared tnsnames.ora 02/27/2003 12:56 PM Please respond to ORACLE-L I am looking for info on how you support a large number of PCs (200+) and keep each ones tnsnames.ora file in sync. It seems that most people do not touch them. Some try to modify them and when new databases are created, the tnsnames.ora files must be changes as well. It seems to be that a shared tnsnames.ora file on a network drive may work. I remember a thread awhile back about the order of resolution (home directory, then OH/network/admin .). Again, I am asking about people using the Oracle client to connect to 15+ databases (v7.3.4 - 9.0.x) on 10+ different servers. I have just started to think about this and posted here before I started my MetaLink search. TIA for any info. JF John Fedock "K" Line America, Inc. www.kline.com ( 804.327. * [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Skill Sets - This may be a dumb question
Title: Message We are told pretty often by management that DBA's are 'dime a dozen' and we need to be more than 'just DBA's' to keep our jobs. On the other hand we are hiring contractors that know Peoplesoft Admin and paying them big bucks. Same with Data Warehouse people. They are in demand. I am afraid repetative technical skills are on their way to being farmed out to outside contract companies that just 'keep the lights on'. You may be better off in the new position. -Original Message-From: Ruth Gramolini [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 1:59 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Skill Sets - This may be a dumb question Lisa, Do you like the job? Do you think it has a future? Will it give you time with your husband and new baby? If you answer yes to 3, than it's a good job. Don't worry about your skill sets, if you are flexable that will count for alot. Ruth - Original Message - From: Koivu, Lisa To: Multiple recipients of list ORACLE-L Sent: Tuesday, February 25, 2003 11:34 AM Subject: Skill Sets - This may be a dumb question Hello everyone, Well I've been "reassigned". I was responsible for the completely messed up Peoplesoft Oracle/AIX environment but management here decided that it was more important to separate a husband and wife that both work in the same department, and assigned one of them to be primary support in this environment instead of me. (sshh: The new person who is primary doesn't know a thing about Unix.) My primary job is now suppossed to be data modeling and data warehouse/mart design, moving on into Problematica (er, Informatica) development into a Sql Server database. I will not be the admin on the Sql Server database. My new boss referred to this as "database architecture". ?? What? They have already decided what they want done and just want someone to take the pretty pictures and implement them with unrealistic deadlines. The main reason why I am upset is because it seems to me that data modeling is such a "soft" skill. I am concerned about keeping my skills up to date and keeping my hands in an Oracle environment, whether it's a mess or not. Seems to me that data modeling alone isn't something that can land you a new job or really spiff up your resume. I think that having a finite list of skills (Oracle, Unix, Windows 2000, Erwin, Project, crap like that) is more what employers search for, and is what HR depts can easily deal with. Am I wrong? This job pays well and working for a huge company has it's benefits, if you can deal with the bureaucracy similar to what is described in the 1st paragraph. And I know in this market I am just lucky to have a job. And please tell me if I'm whining. I may just need a KITA. Who knows anymore... Lisa Koivu Oracle Drink Beer Again Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 "The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments."-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you.
8.1.7 Instance not creating an SGADEF file
I have an 8.1.7 Oracle instance on a server that does not create an SGADEF file when it is started up. There are no errors in the log or trace files. As a result of this file not being created, I cannot connect to the database from a remote client. I get an error that says the instance is not running. I can connect to the instance from SVRMGRL on while logged onto the server. Any ideas why the file would not get created? Thanks! Ron Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: common listener
How about just a 'Reload' insead of stop and start? Much faster. Ron Smith -Original Message- Sent: Monday, February 10, 2003 8:04 AM To: Multiple recipients of list ORACLE-L Srinivas Stopping the listener does not affect existing connections, but only users that are trying to connect. Therefore you can modify the listener.ora file, then stop and start the listener without affecting your users. I would recommend that you avoid doing this when a lot of your users are logging in, like the first thing in the morning. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, February 10, 2003 6:04 AM To: Multiple recipients of list ORACLE-L Hi DBA's I have a common listener setup for 4 database on a server. i.e. listener.ora is listening to 4 different databases on the server (port numbers are different for each DB). is there a way to stop services for only 1 database (I mean if I stop listener, it stops connections for all databases) Thnaks in advance, Srinivas __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help with a truncate command in a procedure
Title: Message Thanks for the help! Ron -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 5:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Help with a truncate command in a procedure (pant pant) Will I be the first to say that you need to use dynamic SQL? dbms_sql package in Oracle version < 8.1 execute immediate in Oracle version >= 8.1 -Original Message- From: Smith, Ron L. [mailto:[EMAIL PROTECTED]] I am not a coder but I received this from one of our developers. I can't find anything about this anywhere. Can someone tell me how to make the truncate work? Thanks! R.Smith In a DB procedure, I wanted to include the following SQL: BEGIN TRUNCATE TABLE LOT837_GLOBAL_TBL_KMG; END; Error messages: PLS-00103: Encountered the symbol "TABLE" when expecting one of the following: := . ( @ % ; The symbol ":= was inserted before "TABLE" to continue. (It does not like it, if you take out TABLE, either.) So, I had to settle for the following SQL: BEGIN DELETE LOT837_GLOBAL_TBL_KMG; END; Do you know why I can not use the TRUNCATE command? If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you.
Help with a truncate command in a procedure
Title: Help with a truncate command in a procedure I am not a coder but I received this from one of our developers. I can't find anything about this anywhere. Can someone tell me how to make the truncate work? Thanks! R.Smith In a DB procedure, I wanted to include the following SQL: BEGIN TRUNCATE TABLE LOT837_GLOBAL_TBL_KMG; END; Error messages: PLS-00103: Encountered the symbol "TABLE" when expecting one of the following: := . ( @ % ; The symbol ":= was inserted before "TABLE" to continue. (It does not like it, if you take out TABLE, either.) So, I had to settle for the following SQL: BEGIN DELETE LOT837_GLOBAL_TBL_KMG; END; Do you know why I can not use the TRUNCATE command? If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you.
SQL*NET timeout with database link
If I try to connect to a database from server a to server b using sqlplus and a database link and that database does not exist the connection attempt seems to hang. Is there a way to set the timeout so it will not hang? R. Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQLPLUS Timeout
I am doing queries to other servers / databases through a database link. If the database is down sqlplus sometime hangs for a period of time. Can I set a timeout on my query to prevent this? R.Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Check for all numeric in a column
Title: Message What is the easiest / best way to check for a valid numeric value in a column? R. Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you.
RMAN or SQLBacktrack?
We have been using SQLBacktrack to backup our databases on Unix and NT for several years. We have been VERY please with the product. We have a mixture of Oracle 8.1.7 and 7.3.4 databases. We are being pushed to use RMAN because it is free. Does anyone have any experience with both and be willing to share their experiences? Thanks! R. Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Strange processes showing up
I just notice these ora_ixxx_sid processes on my server. Does anyone have an idea what they are? They didn't used to be there. oracle 18249 1 0 16:07:35 ?0:00 ora_i106_cdwprd oracle 10664 1 0 15:36:38 ?0:00 ora_snp3_cdwprd oracle 10650 1 0 15:36:37 ?0:00 ora_ckpt_cdwprd oracle 10786 10783 1 15:37:14 ?1:01 oraclecdwprd (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)) ) oracle 18243 1 0 16:07:34 ?0:00 ora_i103_cdwprd oracle 10646 1 0 15:36:37 ?0:00 ora_dbw0_cdwprd oracle 18267 1 0 16:07:36 ?0:00 ora_i10e_cdwprd oracle 18265 1 0 16:07:35 ?0:00 ora_i10d_cdwprd oracle 18255 1 0 16:07:35 ?0:00 ora_i108_cdwprd oracle 10648 1 0 15:36:37 ?0:01 ora_lgwr_cdwprd oracle 18251 1 0 16:07:35 ?0:00 ora_i107_cdwprd oracle 10656 1 0 15:36:37 ?0:00 ora_reco_cdwprd oracle 10662 1 0 15:36:37 ?0:00 ora_snp2_cdwprd oracle 18271 1 0 16:07:36 ?0:00 ora_i10g_cdwprd oracle 18269 1 0 16:07:36 ?0:00 ora_i10f_cdwprd oracle 18263 1 0 16:07:35 ?0:00 ora_i10c_cdwprd oracle 14655 1 20 15:53:45 ?6:54 oraclecdwprd (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ))) oracle 18241 1 0 16:07:34 ?0:00 ora_i102_cdwprd oracle 10658 1 0 15:36:37 ?0:00 ora_snp0_cdwprd oracle 18247 1 0 16:07:35 ?0:00 ora_i105_cdwprd oracle 22069 22016 0 16:23:29 pts/50:00 grep cdwprd oracle 18261 1 0 16:07:35 ?0:00 ora_i10b_cdwprd oracle 10642 1 0 15:36:37 ?0:00 ora_pmon_cdwprd oracle 10654 1 0 15:36:37 ?0:00 ora_smon_cdwprd oracle 10660 1 0 15:36:37 ?0:00 ora_snp1_cdwprd oracle 18245 1 0 16:07:34 ?0:00 ora_i104_cdwprd oracle 18321 1 0 16:07:44 ?0:02 oraclecdwprd (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ))) oracle 18259 1 0 16:07:35 ?0:00 ora_i10a_cdwprd oracle 18257 1 0 16:07:35 ?0:00 ora_i109_cdwprd oracle 10683 1 0 15:36:42 ?0:03 ora_i201_cdwprd oracle 18237 1 0 16:07:34 ?0:00 ora_i101_cdwprd R.Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Financials - Help!
Is there a forum for Oracle Financials questions? I am doing backup support on Oracle Financials and I don't know anything about the product. The /tmp file on Unix has filled with a couple of very large temp files. I need a way to tie the files back to a process and hopefully a client. Can anyone help? Thanks! R.Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database Verification
We had a corrupt index block which caused an ORA-600 which was not noticed and eventually brought down the database. We do lots of checks now. (d) All of the above. R. Smith -Original Message- Sent: Friday, January 17, 2003 8:19 AM To: Multiple recipients of list ORACLE-L (d) All of the above i) Export to /dev/null will go through all the fields of all the tables, all the rows, but will not scan indexes ii) Dbverify will scan for block corruptions but not logical corruptions. iii) Analyze will check for table-index logical corruption. Practically, you could just do an export to /dev/null and make sure the table data is correct. Index can be rebuilt, so it's not as important. HTH. Arup - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, January 17, 2003 7:28 AM > I am considering the appropriate way to do database corruption > prevention. > > Should I use one or more of the following as a proactive measure ? > a) Export > b) DBVerify > c) Analyze table validate structure cascade > > Any advice ? > > Thanks, > > PH > > > ___ > i-Urban Free 60MB Email Box, register NOW http://www.i-urban.com.hk > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Pui Ho Chan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L (or the > name of mailing list you want to be removed from). You may also send > the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database Verification
I would do all three. A good backup stategy is only good if you read all your data all the time. You can have corrupt data that doesn't get read and doesn't cause a problem for weeks, month, years. By that time you have no backup that does not contain corrupt data. Export to a null file to speed things up a little, just keep the log file. DBVerify is very useful. R.Smith -Original Message- Sent: Friday, January 17, 2003 7:59 AM To: Multiple recipients of list ORACLE-L >I am considering the appropriate way to do database >corruption prevention. > >Should I use one or more of the following as a >proactive measure ? > a) Export > b) DBVerify > c) Analyze table validate structure >cascade > >Any advice ? > >Thanks, > >PH > Pui Ho, The only way you can be 'proactive' concerning corruption is to have a sound backup strategy - if you really feel nervous about your hardware, first change it, and then use archive logging and the rest; export is a bad solution, because it will be long to restore. By definition, a corruption doesn't give any warning (it's even worth than earthquakes). If you want to be very reactive, set something to regularly scan your alert.log file. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Unix Max Extent Script
Title: Message Here is what we run. It is part of a group of scripts we run every 15 minutes that monitor all the databases. The script will either send a page or an email, depending on how it is called. The command to run the script (cron every 15 minutes): nextext.sh prod zrls1 > /dev/null 2>&1 The nextext.sh Unix script: #! /bin/sh -x# DBA MONITORING SCRIPTS# **## Author: Ron Smith# Date: 06/18/98# Funtion: Checks for objects that cannot allocate next# extent.## **## CHANGE HISTORY## DATE WHO Reason for Change # 06/18/98 Ron Smith New Prog ## **## FUNCTION ## This script calls nextext.sql.# The function of this script is to report database objects that# cannot allocate the next extent in the tablespace.# If an object is found that cannot be extended, an error file# is created and a page is sent to the DBA.## If an error file already exists, the script exits without any# action. The DBA should delete the error file when the problem# is resolved. Another script should be scheduled to run daily# to delete the error file so the DBA is paged at least once a# day if the condition continues.## If the id of the DBA is a Zid, a page will be sent. If the# id of the DBA is an email address (determined by looking for# an "@" ) , an EMAIL will be sent.## **## PREREQUISITES## The OPS$ORACLE user must exist in the instance. This can be# created by running the opsuer.sql script in SQLPLUS while# logged on as SYSTEM.## The cdmonitoring script must exist in the home/oracle# directory.## **## RUN SYNTAX## nextext.sh (sid) (oncall dba)### ** # cd to the monitoring script directory. $HOME/cdmonitoring.sh ORACLE_SID=$1export ORACLE_SIDDBA=$2export DBAATCNT=`echo $DBA | grep @ | wc -l`export ATCNTEMAIL=$3export EMAIL ORACLE_HOME=`grep "^$ORACLE_SID:" /etc/oratab | head -1 | cut -d: -f2`export ORACLE_HOMEPATH=$ORACLE_HOME/bin:/usr/local/bin:$PATH:.export PATH # Delete the old list file if it exists if [ -f nextext_$ORACLE_SID.lst ] then rm nextext_$ORACLE_SID.lstfi # Check to see if an error file exists. If it does get out. if [ -f nextext_$ORACLE_SID.err ]then echo 'Error file nextext_'$ORACLE_SID'.err exists - will exit now' exitfi # If sending to EMAIL address, run sql with headings on if [ "$ATCNT" -gt "0" ] then sqlplus / @nextext.sql on else sqlplus / @nextext.sql offfi # If there is anything in the lst file then send a message if [ -s nextext_$ORACLE_SID.lst ] then echo "-DBA- Cannot Alloc Next Ext " > nextext_$ORACLE_SID.err echo "SID=" $ORACLE_SID " " >> nextext_$ORACLE_SID.err cat nextext_$ORACLE_SID.lst >> nextext_$ORACLE_SID.err if [ "$ATCNT" -gt "0" ] then echo "email sent" elm -s "-DBA- Warning! $ORACLE_SID Next Extent Warning" $DBA < nextext_$ORACLE_SID.err else LC=`cat nextext_$ORACLE_SID.lst | sed -e 's/ */ /g' | wc -c` echo $LC if [ "$LC" -gt "160" ] then echo "Too many errors to send. Check nextext_$ORACLE_SID.lst" >> nextext_$ORACLE_SID.err else cat nextext_$ORACLE_SID.lst >> nextext_$ORACLE_SID.err fi echo "page sent" pager $DBA "`cat nextext_$ORACLE_SID.err`" fifi The nextext.sql script: set linesize 80set feedback offset verify onset heading &1column owner format a10column tablespace_name format a15column table_name format a15column index_name format a15column next_extent format 999,999,990column ord_col noprint spool nextext_$ORACLE_SID.lst select /*+ RULE */owner, tablespace_name, table_name, 1 ord_col,'' index_name, next_extent/1024 next_extentfrom all_tables atwhere owner like upper('%') and next_extent > (select max(a.bytes) largest from dba_free_space a where a.tablespace_name = at.tablespace_name )unionselect /*+ RULE */owner, tablespace_name, table_name, 2 ord_col, index_name, next_extent/1024 next_extentfrom all_indexes aiwhere owner like upper('%') and next_extent > ( select max(a.bytes) largest from dba_free_space a
RE: Orawomen
his mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Faking an ORA-600
If you don't mind messing up a datafile, you could copy junk over an index datafile. Then use the index in a query. We had a corrupt index that always generated an ORA-600. R. Smith -Original Message- Sent: Thursday, December 19, 2002 3:39 PM To: Multiple recipients of list ORACLE-L "Ball, Terry" wrote: > > We are trying to test out monitoring software (on a test database at > 8.1.6.3). We have been able to generate most of the errors that we > want to monitor for, but have been unable to generate an ORA-600. > Does anyone have a way of doing this? > > TIA. > > Terry Ball, DBA > Birch Telecom > Work: 816-300-1335 > FAX: 816-300-1800 > Terry, Depends on how you do it. If it's by checking the alert log file, I presume that something such as execute sys.dbms_system.kdswrt(3, 'Errors in file blablah.trc:') execute sys.dbms_system.kdswrt(3, 'ORA-00600: internal error code, arguments: [], [FAKED], [], [], []') should look alarming enough. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Where's that last archive log?
We do disaster recovery tests from time to time with a limited set of backups. We make an educated quess as to the time to recover but it doesn't always work. If I give Oracle a point in time to recover and then run out of archive logs how do I tell Oracle that that's all I have and recover with what is available? I have tried recover until cancel but Oracle always seems to need another archive log. It usually says the System file needs to be recovered. If I have all the archive logs it works fine. R.Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Any way to script or document jobs defined to the NT/MS2000 T
Do you map the other computers Scheduled Task drive to make the copy? I tried just copy and past between two sessions and it didn't like that. Ron -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 1:55 PM To: Multiple recipients of list ORACLE-L Task Ron, Saw your memo and fooled around with Task Scheduler a bit. All it is is Windows Explorer pointed at the Scheduled Tasks folder in Control Panel. To back up your Scheduled Tasks, simply single click on one or more of them (or use the Edit / Select All menu item, then de-select Add Scheduled Task), then choose the Edit / Copy To Folder menu item. A single *.job file is created for each Scheduled Task in the target folder. You can then copy those files into another Server's or PC's Scheduled Tasks folder in Control Panel. Those copied-in Scheduled Tasks then appear in the target's Task Scheduler with all their info. Glad you brought this up, since we have a Win2k server with LOTS of Scheduled Tasks. Now I know how to back them up. I just now followed the above procedure and now have all the Scheduled Tasks from that server in my own Task Scheduler on my PC. Jack C. Applewhite Database Administrator Austin Independent School District Austin, Texas 512.414.9715 (wk) 512.935.5929 (pager) [EMAIL PROTECTED] "Smith, Ron L." To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]<[EMAIL PROTECTED]> om> cc: Sent by: Subject: Any way to script or document jobs [EMAIL PROTECTED]defined to the NT/MS2000 Task om 12/05/2002 08:24 AM Please respond to ORACLE-L We have started using the NT/MS2000 Task Scheduler instead of the 'AT' command to schedule jobs. I am concerned that if we lose the server we would lose the schedule and have to figure out how and When all the batch jobs were scheduled. Does anyone know a way to script or otherwise document jobs defined to the Task Scheduler? R. Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Any way to script or document jobs defined to the NT/MS2000 Task
We have started using the NT/MS2000 Task Scheduler instead of the 'AT' command to schedule jobs. I am concerned that if we lose the server we would lose the schedule and have to figure out how and When all the batch jobs were scheduled. Does anyone know a way to script or otherwise document jobs defined to the Task Scheduler? R. Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 7.3.4 on MS2000
I am trying to install Oracle 7.3.4 on a MS2000 machine. I need the loader utilities to run against an old instance of Oracle Financials. I am getting a "obackup.vrf OS_ERROR". I have done this before and I did not get the error. Can anyone help? R. Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Batch SQLPLUS on Win 2000
We recently upgraded our Oracle server from NT to 2000. I have a batch script that runs SQLPLUS that no longer works. Like a good DBA I always included ORACLE_HOME and ORACLE_SID set command in each script. Now the script woll only run if I remove the ORACLE_HOME and ORACLE_SID set commands. There is only one sid on this server right now but that could change any time. Can anyone tell me what changed with Win 2000 and how to specify ORACLE_HOME and ORACLE_SID in Win 2000? Thanks! R. Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Record count within a procedure
Within an update or load procedure, is there any way to return the transaction count for the number of rows affected? Kind of like the Feedback / NoFeedback option of SQL*PLUS? Thanks! R. Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: RE: Backups
You must be using an old version. Been there done that. Works! Ron PS: Also works on NT! -Original Message- Sent: Thursday, October 03, 2002 4:11 PM To: Multiple recipients of list ORACLE-L Unless: You do a point in time recovery, find out you were given the wrong time, and try to do it again. Not so simple, can't be done from the SQL*Bactrack menu. Jared "Smith, Ron L." <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/03/2002 01:26 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: RE: RE: Backups SQL Backtrack and Netbackup! No manual tracking. Restores couldn't be simpler. R. Smith -Original Message- Sent: Thursday, October 03, 2002 3:04 PM To: Multiple recipients of list ORACLE-L Richard, Distateful is being nice. Try down right horrifying is a more appriopriate description. Been There, Done that, now have three Unix SA's who handle it. Life is so grand!! Dick Goulet Reply Separator Author: "Markham; Richard" <[EMAIL PROTECTED]> Date: 10/3/2002 10:53 AM Yes I personally run Veritas Netbackup for both cold and RMAN. A fiber SAN has its added benefits as well =). I have never really explored the implications of these other utilities. My head filled with many distasteful visuals. Yes, I agree with you and I realize that I am spoiled . -Original Message- Sent: Thursday, October 03, 2002 1:38 PM To: Markham; Richard; Multiple recipients of list ORACLE-L I've used cpio, dd, and fbackup to do hot and cold backups before, but never again. With those utilities the burden of keeping track of what is on which tape rests with you and normally a stubby pencil & pad of paper because you know what won't be available when you need to do a recovery. They do work be assured, but the administrative overhead is just not worth it anymore, even for a small shop. Get a copy of Veritas or OmniBack or some other software package that does library management for you and preferably integrates with RMAN. Life can be so much easier!! Dick Goulet Reply Separator Author: "Markham; Richard" <[EMAIL PROTECTED]> Date: 10/3/2002 10:03 AM It would be interesting to see how you would explain how either cp or dd (which know nothing of archive log mode, or the concept of hot backup, itself, none the less) is going to keep things consistent, when these utilities themselves are for point in time operations. -Original Message- Sent: Thursday, October 03, 2002 12:18 PM To: Multiple recipients of list ORACLE-L This doesn't sound right. Put the database in hot backup mode, backup (whether using cp to a staging point like the poster here is doing or straight to tape using dd or dump or some other utility), come out of hot backup mode. Why wouldn't you be able to recover? John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, October 03, 2002 10:18 AM To: Multiple recipients of list ORACLE-L If you want to be able to use any OS backup for restore/recovery that database must be closed when you do the backup. If it is not, you won't be able to recover. Just a thot, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, October 03, 2002 9:08 AM Robyn, We used the DD method on pre 7.1 oracle with RAW devices. It worked fine except that it used a lot of tape dumping a raw device when only a small portion was used. Using a dd command to place a copy of the data on tape should not be a problem if a restoral is needed. The dd function is just another OS method of copying data to a tape. I don't know for sure but I think there might be some issues about transportability of the dd tape. Other users will know about the transportability issues. Ron ROR mª¿ªm >>> [EMAIL PROTECTED] 10/02/02 08:08PM >>> Hello, I need some info about backups. I am working on a customer site, and have implemented both exports and hot backups. Both jobs copy to a separate mount point, and a job scripted by another individual then moves the files to tape. Here's the problem - he's using a dd command, primarily because it provides a succinct output he can email to non-technicals. The file system is built on a 12 disk A1000 array. We've provided him with a ufsdump script, but he's doesn't want to use it. Can the system be recovered from this tape? Has anyone ever relied on a dd for a daily backup method? The system is Oracle 9i on Solaris 8. Robyn -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robyn Anderson Sands INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 htt
RE: RE: RE: Backups
ssage BODY, include a line containing: UNSUB ORACLE-L (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"; TARGET="_blank">http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com"; TARGET="_blank">http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com"; TARGET="_blank">http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com"; TARGET="_blank">http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com"; TARGET="_blank">http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com"; TARGET="_blank">http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Performance monitoring
Right On! -Original Message- Sent: Wednesday, October 02, 2002 4:18 PM To: Multiple recipients of list ORACLE-L The ten most important performance items to monitor are your ten most important business transactions. Period, end of story. If you want to provide an intelligent response, monitor how long they take and provide a weekly report, noting any changes. Ratios and wait events are just diagnostic tools -- when business transactions become slow you use them to find where the problem is. Anyone who asks you to monitor ten internal things, such as ratios or wait events, and no more than just ten because they only want the ten most important, is simply uneducated and unexperienced, since these things are of no importantance if the system is running fast enough for the users, and besides there are way more than ten important things like this. However, they may also be very smart, since a good manager may be wise to start by getting a handle on the ten most important things. Probably, you want to be taking statspack snapshots every hour just to have a baseline, so just DO THAT and give the statspack report to the manager once a week -- and make them happy by picking out ten items you consider important and running a yellow highlighter over them. Have a cover page that compares the current value of the ten items with the same items four weeks ago -- so you are monitoring them. That's fast, easy and smart, it makes your manager happy and you'll have your eye on the ball too. But don't forget that the most important thing to monitor is reality. Your coolest move is to have the manager pull the users into a meeting and get them to identify the ten business transactions that are most important to them. Find out if any are too slow. Find out if anything is too slow. Monitor that. Tune that. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL Backtrack Reports
Yes, I am looking for something that reports sid start stop for every backup recorded either in the log file or in the oracatalog. Ron -Original Message- Sent: Wednesday, October 02, 2002 12:23 PM To: Multiple recipients of list ORACLE-L Do you want to parse the log file and only report the backup start and stop times? If so, that's a really tall order. What we do is run SQL Backtrack from a shell script that reports start and stop time and emails success/failure for each instance. --- "Smith, Ron L." <[EMAIL PROTECTED]> wrote: > If anyone out there is using SQL Backtrack to backup > Oracle I am looking for > a home grown reporting > script that will give me start and stop times for > all the backups on the log > file. > > Thanks! > R. Smith > -- > 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 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQL Backtrack Reports
If anyone out there is using SQL Backtrack to backup Oracle I am looking for a home grown reporting script that will give me start and stop times for all the backups on the log file. Thanks! R. Smith -- 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: quckways to find block corruption
Beware, we had a corrupt block in an index. Big deal you say!? Every time the client used the index the database would crash! Not good. We now do exports, and dbverify. But they don't catch bad index blocks. We also learned to check the alertlog a couple of times a day. R. Smith -Original Message- Sent: Monday, September 23, 2002 4:48 PM To: Multiple recipients of list ORACLE-L FWIW I like to do full exports in the middle of the night just for this reason as a hot backup wont cut it. If you find a corrupt block you can fix it using either a PL/SQL or PRO*C rountine that can be found on Metalink. Search for corrupt blocks. Mike -Original Message- Sent: Monday, September 23, 2002 3:03 AM To: Multiple recipients of list ORACLE-L Hello all, DB: 8i OS: solaris 2.7 can somebody post me reply for this. is there any quick way to find which datablocks are corrupted in my oracle database . ( other than dbverify and rman backup. ) b'coz we have BCV backup already implemented and we cannot do a dbv every week for 500 gig production database . thanks in advance, srinivas __ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Estat Bstat
I am trying to run utlbstat and utlestat for the first time. The output is not formatted very well. Does anyone have a cleaner version? R. Smith -- 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FW: Problem upgrading Oracle 8.1.7 on MS2000
I am trying to upgrade Oracle 8.1.7 on MS2000 to patchset 8.1.7.4.1. I keep getting a message that says a component that the installer needs to update is busy. It would be too easy to tell me what it is. I have stopped everything related to Oracle but I still get the message. Can anyone tell me what else I should stop? Is there a log file that tells me what it is trying to do? Thanks! R. Smith -- 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).
Problem upgrading Oracle 8.1.7 on MS2000
I am trying to upgrade Oracle 8.1.7 on MS2000 to patchset 8.1.7.4.1. I keep getting a message that says a component that the installer needs to update is busy. It would be too easy to tell me what it is. I have stopped everything related to Oracle but I still get the message. Can anyone tell me what else I should stop? Is there a log file that tells me what it is trying to do? Thanks! R. Smith -- 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: RE: Pls respond...: URGENT
Is it possible there is a full analyze running on the database? You said you did a reorg this weekend. If you bounced it 4 times it could be going through backout and recovery. Either one would keep it pretty busy. R. Smith -Original Message- Sent: Tuesday, September 03, 2002 4:08 PM To: Multiple recipients of list ORACLE-L My database okay, its slow, I can't do much work, too much waitingI want to bring as normal processing... >From: "Fink, Dan" <[EMAIL PROTECTED]> >To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> >Subject: RE: Pls respond...: URGENT >Date: Tue, 3 Sep 2002 13:58:02 -0600 > >Peter, > What is the problem? What you are asking is not clear, which could >be one reason you are not getting a response. Try restating the issue with >exactly what the condition of the db is (up or down), what errors are being >reported, etc. > >Dan Fink > >-Original Message- >From: Peter R [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, September 03, 2002 2:33 PM >To: Multiple recipients of list ORACLE-L >Subject: Pls respond...: URGENT > > > > > > >Hi Friends, > > > >My all background processors accessing same file system, I did some reorg > >this weekend, But I shut down database like 4 times...all processors are > >waitingAny help will be highly appreicated!!! > > > > > >oracle@baan1 $ ps -ef|grep 14816 > > oracle 14816 1 2 13:59:00 - 0:49 ora_dbwr_baanIV > > oracle 80572 18974 2 14:27:27 pts/1 0:00 grep 14816 > >oracle@baan1 $ ps -ef|grep 15336 > > oracle 15336 1 0 13:59:00 - 0:12 ora_lgwr_baanIV > > oracle 83158 18974 2 14:27:55 pts/1 0:00 grep 15336 > >oracle@baan1 $ ps -ef|grep 17644 > > oracle 17644 1 0 13:59:00 - 0:16 ora_smon_baanIV > > oracle 85890 18974 2 14:28:21 pts/1 0:00 grep 17644 > >oracle@baan1 $ ps -ef|grep 18164 > > oracle 18164 1 0 13:59:00 - 0:03 ora_db01_baanIV > > oracle 84380 18974 1 14:28:44 pts/1 0:00 grep 18164 > > > >Thanks > >peter. > > > >_ > >Join the world's largest e-mail service with MSN Hotmail. > >http://www.hotmail.com > > > > > > > >Oracle documentation is here: > >http://tahiti.oracle.com/pls/tahiti/tahiti.homepage > >To unsubscribe: send a blank email to [EMAIL PROTECTED] > >To subscribe: send a blank email to [EMAIL PROTECTED] > >Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > >Tell yer mates about http://www.farAwayJobs.com > >By using this list you agree to these > >terms:http://www.lazydba.com/legal.html > > > > >_ >Send and receive Hotmail on your mobile device: http://mobile.msn.com > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Peter R > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
Pro*C error after install
I am getting the following error after installing Pro*C on an existing 8.1.7 instance. Can anyone help? <mailto:oracle@cdwtst> oracle@cdwtst:> make -f demo_proc.mk sample1 /usr/ccs/bin/make -f /u001/app/oracle/product/8.1.7/precomp/demo/proc/demo_proc.mk OBJS=sample1.o EXE=sample1 build cc -xO2 -Xa -xstrconst -xF -mr -xarch=v8 -xcache=16/32/1:1024/64/1 -xchip=ultra -D_REENTRANT -K PIC -DPRECOMP -I. -I/u 001/app/oracle/product/8.1.7/precomp/public -I/u001/app/oracle/product/8.1.7/rdbms/public -I/u001/app/oracle/product/8.1.7/r dbms/demo -I/u001/app/oracle/product/8.1.7/plsql/public -I/u001/app/oracle/product/8.1.7/network/public -DSLMXMX_ENABLE -DSL TS_ENABLE -D_SVID_GETTOD-c sample1.c /usr/ucb/cc: language optional software package not installed *** Error code 1 make: Fatal error: Command failed for target `sample1.o' Current working directory /u001/app/oracle/product/8.1.7/precomp/demo/proc *** Error code 1 make: Fatal error: Command failed for target `sample1' R Smith -- 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).
Install Pro*C
Someone forgot to install Pro*C on our 8.1.7 Sun server. I need to install it. Is there anything that needs to be done after I run the installer? Thanks! R Smith -- 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).
Nologging and redo generation
Can I use the nologging option on simple inert and deletes to eliminate rollback problems and redo generation? Ron S. -- 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: SAN
TED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Tim Gorman > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: It took more than an hour to update 10,000 records
I was wondering how many rows are in the table being updated? Do you have an index on the columns in the where clause? Could be doing a full table scan to find all the rows. Also, if there a lot of indexes on the table it could add a lot of time to the update. Ron S. -Original Message- Sent: Tuesday, August 13, 2002 12:55 PM To: Multiple recipients of list ORACLE-L Hmm... are there any triggers on the table that fire? 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: Tuesday, August 13, 2002 1:37 PM To: Multiple recipients of list ORACLE-L Do you have a unique index on nxx_id, npa_id, and lata_id? Waleed -Original Message- Sent: Tuesday, August 13, 2002 12:25 PM To: Multiple recipients of list ORACLE-L Hi all, I write a script to update 10,000 records in my database and noticed it took more than an hour to update 10,000 records. The script just includes 10,000 SQL update commands as shown below. Is the time too long to update 10,000 records? Is it a way to improve the update task to run faster. Please advise. *** A portion of my update script is shown below: update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 206 and npa_id = 201 and lata_id = 224; update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 207 and npa_id = 201 and lata_id = 224; Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
What Oracle versions are supported on MS2000?
Can anyone tell me what Oracle versions are supported on MS2000? Ron Smith -- 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).