Re: OCP 7.3 & 8 upgrade to 9i
Hi All, >From the Oracle Education Certification Page: http://www.oracle.com/education/certification/index.html?dba9i_upgrade.html Shows 4 possible tests: Oracle9i DBA OCP Upgrade Path Upgrade exams for Oracle7.3, Oracle8 and Oracle8i DBA OCPs. In order to make the process of staying current as an Oracle Certified technical professional, those already certified on previous releases of Oracle may upgrade to each future release by simply completing one migration exam. Listed below are the migration exams that are currently available to previously certified Oracle DBAs. Please review the listings below for more specific information. Generally, one exam is required for OCPs to upgrade to each new release of an Oracle DBA track. For example, one exam upgrades the Oracle7.3 credential to Oracle8, one exam upgrades the Oracle8 credential to Oracle8i, and one exam upgrades the Oracle8i credential to Oracle9i. Oracle7.3 and Oracle8 DBA OCPs now have another option to upgrade their DBA OCP credential directly to Oracle9i: Exam #1Z0-035 Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs. This exam will be available beginning October 2003. Select the exam title below to view the exam objectives. Upgrade Exam: Oracle7.3 and Oracle8 DBA OCPs to Oracle9i Exam #1Z0-035 Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs Available October 2003 Upgrade Exam: Oracle7.3 to Oracle8 DBA OCP Exam #1Z0-010 Oracle8 New Features for Administrators Upgrade Exam: Oracle8 to Oracle8i DBA OCP Exam #1Z0-020 Oracle8i New Features for Administrators Upgrade Exam: Oracle8i to Oracle9i DBA OCP Exam #1Z0-030 Oracle9i Database: New Features for Administrators Hope this helps, John [EMAIL PROTECTED] wrote: That sounds very interesting. I have an 7.3 OCP ( beta exams at OOW ), but don't have 8.0 or 8i. Being able to skip the 8/8i exams should make this attractive to many folks. Jared "Ron Rogers" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/06/2003 08:39 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: OCP 7.3 & 8 upgrade to 9i List, While looking at the Oracle Education site I located a link about the Paris OpenWorld this month and the OCP upgrades. In particular was the upgrade that by-passes the 8 to 8i step on the way to 9i. http://www.oracle.com/education/certification/news/index.html?oowexamcram2003.html "Upgrade Exam: Oracle7.3 and Oracle8 DBA OCPs to Oracle9i Exam #1Z0-035 Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs" Of the list members that attended Open World in San Francisco, was this available there also? I would like to have this test also available to the DBA's that can not attend an open world meeting. It could be a great help if it eliminates the cost of one test along the way to an upgrade of the OCP. It also raises the questions about the training. A normal new features course is 5 days in length and costs BIG BUCK$. This course is less than a day and cheap. What do they do give the answers and hope you remember them later in the day when you take the test? Ron -- 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).
Re: Oracle License for Training
You are WRONG! The Oracle Academic Initiative has 100's of members. In California there are more than 200. John [EMAIL PROTECTED] wrote: Quoting Markus Reger <[EMAIL PROTECTED]>: I have to manage MySQL and ORACLE for the web likewise. There seems to be a strong tendency towards MySQL if people newly enter the area of webpresence, students or profs doesn't make a difference. For web work. MySQL is very popular (Together with PHP). For everything else, Access is usually the intro if developing dektop apps. MS SQL if the intro is a bit higher end (non-desktop applications). DB2 is also an intro in some schools. You never see Oracle as the intro DB in any school (a real school as in University, College, High School not those $$$ making diploma mills).
Re: Oracle License for Training
Hi All, This conversation didn't start out in dealing with educational institutions, it started out as a group that wants to use it to make money. Oracle is making every effort to work with legitimate education institutions. The Oracle Academic Initiative does exactly what you describe. Institutions pay a small fee (500.00 I think) they are have access to ALL Oracle Software for use in instruction. They also have access to Oracle University Curriculum if desired. more information can be found at: http://oai.oracle.com Regards, John [EMAIL PROTECTED] wrote: Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>: Richard - How do you think the Oracle Education division would react to this proposal? ;-) Never underestimate the power of corporate politics. But seriously a large organization succeeds to the extent that it can look at the long-term good of the organization. Overall I think Oracle Corp. has a pretty good track record in this respect, and that has contributed to its excellent growth. Who knows, maybe Oracle will consider your idea. It seems that Microsoft has a different business model for education. I don't think Microsoft teaches any classes directly, but just certifies training organizations and instructors. The point here is to allow people easier access to Oracle knowledge, through courses you can pick up at your local community college. What Oracle is doing right now is stifling this.
Tkprof On Windows 9.0
Hi All, Go to metalink and download patch 2271678 to install tkprof on 9i Release 1. As was already mentioned this has been resolved in 9iR2. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ora NT DBA 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: Configuring back up in Oracle 9i
Yes, RMAN is included with 9i and YES the OEM console uses rman. John [EMAIL PROTECTED] wrote: It's already done, but error message isn't disappears. More question please, Does back up via Oracle Management Console is equivalent with RMAN ? Is RMAN include in Oracle 9i ? Rgrds, Sony -Original Message----- From: Ora NT DBA [SMTP:[EMAIL PROTECTED]] Sent: Saturday, January 25, 2003 11:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: Configuring back up in Oracle 9i Another common problem is that in Windows environments that the user on the node must be granted the "log on as batch" privilege . This is true even if they are in the admin group. John [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> wrote: look in your configuration->preferences->preferred credentials. you not only have to have the sys password set for 'target type=database' but you also have to have the proper password set for 'target type=node' (machine where your database is. chris -Original Message- From: Sony kristanto [ <mailto:[EMAIL PROTECTED]>] Sent: Friday, January 24, 2003 8:34 PM To: Multiple recipients of list ORACLE-L Subject: Configuring back up in Oracle 9i Hi listers, Can anyone in this list explain to me, how to back up my database ? I use Oracle 9i and I run back up via Oracle Management Console as SYS user and already setting its previlleges but after I follow all instructions in back up wizard, final result raise 'Authentication Error'. Pls show me clues how to solve this error. All comments and instructions would be very appreciated. Rgrds, Sony -- Please see the official ORACLE-L FAQ: <http://www.orafaq.net> -- Author: Sony kristanto INET: [EMAIL PROTECTED] <mailto:[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] <mailto:[EMAIL PROTECTED]> (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ora NT DBA 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: Configuring back up in Oracle 9i
Another common problem is that in Windows environments that the user on the node must be granted the "log on as batch" privilege . This is true even if they are in the admin group. John [EMAIL PROTECTED] wrote: RE: Configuring back up in Oracle 9i look in your configuration->preferences->preferred credentials. you not only have to have the sys password set for 'target type=database' but you also have to have the proper password set for 'target type=node' (machine where your database is. chris -Original Message- From: Sony kristanto [mailto:[EMAIL PROTECTED]] Sent: Friday, January 24, 2003 8:34 PM To: Multiple recipients of list ORACLE-L Subject: Configuring back up in Oracle 9i Hi listers, Can anyone in this list explain to me, how to back up my database ? I use Oracle 9i and I run back up via Oracle Management Console as SYS user and already setting its previlleges but after I follow all instructions in back up wizard, final result raise 'Authentication Error'. Pls show me clues how to solve this error. All comments and instructions would be very appreciated. Rgrds, Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto 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: CBO not using the index even though it is faster when hinted
What were the logical reads query + current during this same test. Physical reads could be different because the first query loaded the rows into memory. John [EMAIL PROTECTED] wrote: All the columns in the table are not null ... here is an interesting test I ran ... several Direct_Path_Write and Read waits with large elasped times are showing up in the 10046 trace data on this query due to the full table scan. Just deleted statistics on this and fwiw ... With Statistics = SELECT Statement Optimizer=Choose (Cost=225 ...) SORT (Order By) (Cost=225 ...) Table Access (Full) of 'table1' Physical Reads = 433 Without Statistics .. == SELECT Statement Optimizer=Choose Table Access (By Index Row) of 'table1 Index ( Full Scan ) of 'concatenated index' (Non-Unique) Physical Reads = 0 Mike -Original Message- Sent: Thursday, January 23, 2003 6:29 PM To: Multiple recipients of list ORACLE-L Anyone have any problems with the CBO not using a index when you know it is faster by forcing a hint ? I have set the following ... Solaris Oracle Version 8.1.7.4 block size = 8 DB_FILE_MULTIBLOCK_READ_COUNT = 8 mode = Choose also using Tim Gormans 90 and 50 values for the other optimizer parms. Select col1, col2, col3, blah1, blah2 from table order by col1, col2, col3; Concatenate index on col1, col2, col3. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ora NT DBA 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: simple question on DDL
Hi Rachel, Good point about the autonomous transactions. If I remember correctly that was new in 8i. My general theory on WHY questions is "That's the way they coded it!". They probably could have coded it differently, but they didn't. The important thing is that it is well documented how it works. If someone mixes ddl and dml they have no basis to complain about the result. John [EMAIL PROTECTED] wrote: remember this "functionality" of committing before a DDL statement has been around from the beginning. Autonomous transactions have not. It may simply be a case of Oracle not getting around to adding that change to the kernel code. Or, as Kirti quoted from Tom Kyte, that might just be the way they want it to work. --- Arup Nanda <[EMAIL PROTECTED]> wrote: Dan, If I may, essentially you are saying that changes to data dictionary tables have to be committed immediately regardless of the outcome of the transaction. For instance in the following code, starting with an empty table t1 step 1: insert into table t1 values row1 step 2: create table t2 step 3: insert into table t1 values row2 step 4: rollback At this point a select * from t1 will show only row1, since the ddl create table t2 has inserted a commit. However, the point is, my transaction should have been from step 1 through step 4, not fromn step 3 through 4. The DDL broke my txn at step 2 and another transaction started from there. The data dictionary tables were updated and they should be committed; but that commit could have been done via an "autonomous transaction", not in the same transaction the user issued. The more I think about it, I see no point why a DDL should insert a commit. This is different from saying that DDL itself may issue a commit to its seprate transaction to update the catalog. Any thoughts on that? Arup From: "Fink, Dan" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Wed, 22 Jan 2003 14:18:57 -0800 MIME-Version: 1.0 Received: from newsfeed.cts.com ([209.68.248.164]) by mc1-f3.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Wed, 22 Jan 2003 15:13:04 -0800 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id PAA16552;Wed, 22 Jan 2003 15:11:42 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00537F3B; Wed, 22 Jan 2003 14:18:57 -0800 Message-ID: <[EMAIL PROTECTED]> X-Comment: Oracle RDBMS Community Forum X-Sender: "Fink, Dan" <[EMAIL PROTECTED]> Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 22 Jan 2003 23:13:04.0174 (UTC) FILETIME=[D0E4CCE0:01C2C26B] Don't forget that extent allocation also affects the extent map for the segment and possibly the high water mark. The hwm can be set without allocating another extent and allocation of an extent may not alter the hwm (if you manually allocate an extent). If I deallocate space from an object, I will alter the rows in fet$ and uet$ but not update the hwm. Make sense? As for the ATOMICITY of the transaction, this is usually used to describe the changes to data of interest. I don't think it is used to describe any underlying data dictionary changes. Thus the answer is Yes (for 99% of the Oracle techies) and No (for the 1% of us who really like to know exactly what is going on under the covers). Thanks for a great question, it brought up a subject that I had never thought about. Yee-Haw! I learned someting today! Cheers, Dan -Original Message- Sent: Wednesday, January 22, 2003 2:04 PM To: Multiple recipients of list ORACLE-L Thanks Dan. The gist of your response was that all changes to the data dictionary are immediately commited. Seems to make sense to me. Maybe, thats one reason why one cannot free space below the high water mark. Coz changes to UET$ has been committed, even though the data was rolled back. I sent an email to one of my senior DBA friends, posing the same question, and he replied with a one liner "To make the transaction as ATOMIC as possible - They either run completely, or not at all". Now, does that mean the
Re: Truncate system tables.
Hi Tom, Nothing I would feel comfortable with. Be happy that it was new. I would recomend trashing it and starting over. John Terrian, Tom (Contractor) (DAASC) wrote: Message ummm...I just truncated all of the system tables in a new database (that's not good). No backups yet. Anyway to recover from this or do I have to recreate the database? Thanks, Tom Terrian
Re: Oracle 8i Certification Will Terminate When???
I went to the Oracle Certification page and looked at the NEWS and the FAQ. Both had mentions of the retirement of various tracks but neither mentioned the retirement of the 8i track. The abscense of an announcement on the official web site would indicate to me that it has not been announced yet. John Peter Barnett wrote: I have been looking at the Oracle web site for the termination date of Oracle 8i certification tests. There is nothing there. Only Oracle 8. Rumor has had it that there is a termination date. Does anyone have an authoritative answer? = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ 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.com -- Author: Ora NT DBA 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: 9i Lite
Hi Dennis, This is a completely separate product, it is designed for mobile devices like pda's etc. Regards, John DENNIS WILLIAMS wrote: Saira - I agree with OraCop, just ask questions here. My assumption is that there are few differences between Oracle Lite and other Oracle versions. I think it is based on the same Oracle code, with a few features removed. Here is the note from the FAQ for this list: http://www.orafaq.com/faqpol.htm#COMPAT If I am wrong and it is entirely different, I would appreciate knowing that. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 26, 2002 11:29 AM To: Multiple recipients of list ORACLE-L No one uses 9i Lite? Gurus, help me out!!! Saira -Original Message- Somani Sent: November 25, 2002 10:49 AM To: Multiple recipients of list ORACLE-L I wonder if there are any mailing lists out there for Oracle 9i Lite. Or for that matter, if any of you have used in the past or are using it now and would like to brainstorm once in a while on this topic. I struggle with its administration sometimes. If you can point me in a direction (other than the Oracle forums on their website), I would appreciate it. Thanks, Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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 FIND FREQUNT OBJECT ACCESS
Hi Seema, V$db_object_cache has a column called executions. John Seema Singh wrote: Hi How to check which are those functions/procedures/packages etc applications are using more frequntly? THx -Seema _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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: Get together at OOW
Maybe, "Can you hear me now" :-) oh wait that's someone else. Deshpande, Kirti wrote: Last year, most taxis and some buses in SFO downtown area were carrying the 'Unbreakable' logo. I wonder what would they be carrying this year 'Fixed, and Patched' or 'Newly Renovated' ;-) - Kirti -Original Message- Sent: Tuesday, October 22, 2002 5:14 AM To: Multiple recipients of list ORACLE-L Does anyone remember the days when there were non-Oracle people allowed to speak at OpenWorlds ? You know, there were actually presentations that didn't sound like you had accidentally dropped into a car-salesman's convention :-) Connor -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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: Where is output of analyze table ... validate structure cascade?
Hi Rick, It is in a special fixed view called index_stats. I call it special because it always has one line of information from the last index analyzed and is only viewable from your session. The next analyze will overwrite this information. John [EMAIL PROTECTED] wrote: Hi All, I did ANALYZE TABLE ... VALIDATE STRUCTURE CASCADE. MetaLink says output is in trace file in udump location. Well it is not. Does anyone know where Oracle does hide this info? The command did complete. Oracle 8.1.6 on WinNT Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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: No Nulls? (was: Warehouse design: snowflake vs
Sounds like they needed a business rule, enforced by a constraint saying the date of death must be less than or equal to sysdate :-). John Toepke, Kevin M wrote: I was once a consultant on a large Payroll project and ran into a case where someone had entered a date of death 1 year in advance (something like 8/17/1999 instead of 8/17/1998). I found it in the middle of November. Because of this, the person was still getting paid. I sent email to payroll, HR and my manager questioning this "planned death"! Shortly thereafter I left the project for about 3 months and when I came back the data hadn't been changed! -Original Message- Sent: Tuesday, October 15, 2002 10:04 AM To: Multiple recipients of list ORACLE-L See logical, isn't it!! *-) Dick Goulet Reply Separator Author: "Robson; Peter" <[EMAIL PROTECTED]> Date: 10/15/2002 2:43 AM Ho Ho Ho - never heard of companies with dead persons on the payroll? peter -Original Message- Sent: 14 October 2002 21:49 To: Multiple recipients of list ORACLE-L I'll agree with Igor. Actually my 'preferred' option would be to use their birth date + 80 years which is the generally accepted life expectancy of a human being. Lets face it, you aren't going to employ the guy/girl after their dead! And if their not dead by then, then sure as heck they'll be retired. Dick Goulet Reply Separator Author: "Igor Neyman" <[EMAIL PROTECTED]> Date: 10/14/2002 12:14 PM RE: No Nulls? (was: Warehouse design: snowflake vs star schemEND_EMPLOYEMENT date for still employed employees equals to "01/01/4000" (or any other pre-defined date in distant future). Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - From: Adams, Matthew (GECP, MABG, 088130) To: Multiple recipients of list ORACLE-L Sent: Monday, October 14, 2002 3:39 PM Subject: RE: No Nulls? (was: Warehouse design: snowflake vs star schem "No application that I can reasonably think of should use NULLS, except those pre-81 where there are obsolete columns." Everytime somebody says this to me, I ask them: How do you handle still employed employees in an EMPLOYEE table that contains a END_EMPLOYEMENT date column? What's your take? Matt Adams - GE Appliances - [EMAIL PROTECTED] Write a poem about a haircut! But lofty, noble, tragic, full of love, treachery, retribution, quiet heroism in the face of certain doom! Six lines, cleverly rhymed, and every word beginning with the letter s! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 2:29 PM To: Multiple recipients of list ORACLE-L Subject: Re:No Nulls? (was: Warehouse design: snowflake vs star schem Jesse, I'll refrain from personal comments, but on CJ's quote, he's correct. Nulls are an oddity. They cannot be true or false ( = NULL or != NULL), nor can they equal anything. They are in effect a third logical state of nothingness. You also have to code most applications with indicator variables to check for their existence. All in all a real pain in the backside. BUT, if you give me the possibility that nulls exist in the data I much prefer using them vs. many a third party solution of a single space. No application that I can reasonably think of should use NULLS, except those pre-81 where there are obsolete columns. Dick Goulet Reply Separator Author: "Jesse; Rich" <[EMAIL PROTECTED]> Date: 10/14/2002 9:33 AM On the link below is this quote from C.J.Date: "I don't want you to think that my SQL solution to your problem means I advocate the use of nulls. Nulls are a disaster." Of course, he doesn't expound upon it (probably not a need except for dummies like me). Anyone care to comment? (On the quote, not on my dumminess...) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: Robson, Peter [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 14, 2002 4:59 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Warehouse design: snowflake vs star schemas > > > Just for the record (and perhaps to confirm that there are > always two sides > to a story). Readers may like to see the article Chris Date > wrote to Ralph > Kemball on the subject of business rules and integrity constraints: > > http://www.dbdebunk.com/kimball1.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and
Re: No Nulls? (was: Warehouse design: snowflake vs star schem
Both would likely do FTS since at any given time more than 50% of your employees will be current (have an end date of 1/1/4000' making it very unlikely that the cbo would choose this index. The RBO, would, but it would likely degrade not improve your performance. John Grabowy, Chris wrote: Message Hmmm...but what about the index? Which is faster? select * from table where END_EMPLOYMENT IS NULL; OR select * from table where END_EMPLOYMENT = '01/01/4000'; I like NULL, but I am leaning towards Igor, and others, to agree upon and use a default value, or a "business sense" replacement value for NULL. I want to be able to take the awesome advantage of an index...versus FTS? Am I headed in the wrong direction?? Any other thoughts?? -Original Message- From: Fink, Dan[mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 4:49PM To: Multiple recipients of list ORACLE-L Subject: RE:No Nulls? (was: Warehouse design: snowflake vs star schem Theproblem I see with NO NULLS is that artificial data must be created, where thedata is truly not known. Whether you deal with NULLs or artificial data, youwill always have to code accordingly, so it is a wash. Igor's example isan good one. When I write an app to access the END_EMPLOYMENT date, Imust handle a date of '01/01/4000'. Or I can handle the NULL condition. As aperson who has had to support some very convoluted code, I'd rather deal withNULL. What if the employee record contained TERM_CODE? I would rather have thevalue NULL, meaning they have not been terminated rather than dealing withhard-coded or lookup values. -Original Message- From: Igor Neyman [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Subject: Re: No Nulls? (was: Warehouse design: snowflake vs star schem END_EMPLOYEMENT date for still employed employees equals to "01/01/4000" (or any other pre-defined date in distant future). Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - From:Adams, Matthew (GECP, MABG, 088130) To: Multiple recipients of listORACLE-L Sent: Monday, October 14, 2002 3:39PM Subject: RE: No Nulls? (was:Warehouse design: snowflake vs star schem "No application that I can reasonably think of should use NULLS, except those pre-81 where there are obsolete columns." Everytime somebody says this to me, I ask them: How do you handle still employed employees in an EMPLOYEEtable that contains a END_EMPLOYEMENT datecolumn? What's your take? Matt Adams - GE Appliances -[EMAIL PROTECTED] Write a poem about ahaircut! But lofty, noble, tragic, full of love, treachery, retribution, quiet heroism in the face of certain doom! Six lines, cleverly rhymed, and every word beginning with the letter s! -Original Message- From:[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 2:29 PM To: Multiple recipients of list ORACLE-L Subject: Re:No Nulls? (was: Warehouse design: snowflake vs starschem Jesse, I'll refrain from personal comments, but on CJ's quote, he's correct. Nulls arean oddity. They cannot be true or false ( = NULLor != NULL), nor can they equal anything. They are in effect a third logical state of nothingness. You also have to code mostapplications with indicator variables to check fortheir existence. All in all a real pain in the backside. BUT, if you give me the possibility that nullsexist in the data I much prefer using them vs.many a third party solution of a single space. No application that I can reasonably think of should use NULLS, exceptthose pre-81 where there are obsoletecolumns. Dick Goulet ReplySeparator Author: "Jesse;Rich" <[EMAIL PROTECTED]> Date: 10/14/2002 9:33 AM On the link below is this quote from C.J.Date: "I don't want you to think that my SQL solution to your
Re: Orace setting on NT
Hi Gene, You can set the tns_admin as a local environment variable, system environment variable or in the registry. John Gurelei wrote: >Hi . > >This is a very easy question. I'm usually working >with Oracle on UNIX, but today I need to connect >to a remote instance from my NT desktop. Is there an >equivalent to TNS_ADMIN varaiable in NT? ( I'm trying >to force Oracle to use a specific tnsnames.ora file >on my machine adn TNS_ADMIN variable is the way to >do it on UNIX.) > >thanks for any help >Gene > > >__ >Do you Yahoo!? >Faith Hill - Exclusive Performances, Videos & More >http://faith.yahoo.com > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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: remove & move a user
You may also possibly need to rebuild the indexes to a different tablespace. John Dennis M. Heisler wrote: >To remove a user: >drop user xxx cascade; > >To move a user to another tablespace: > Ensure user has enough quota on tablespace yyy > > Set user's default tablespace >alter user xxx default tablespace yyy; > > For each table owned by xxx, >alter table xxx.aaa move tablespace yyy; > > >Dennis > > >MURAT BALKAS wrote: > > >>Hi, >> >> what's the best method to >> >>1) remove a user absolutely. I want to remove the user's tables, indexes, >>... etc. >>2) move a user absolutely to another tablespace. >> >>Thanks, >> >>Murat >> >>-- >>Bu e-posta sadece yukarida isimleri belirtilen kisiler arasinda ozel >>haberlesme amacini tasimaktadir. Size yanlislikla ulasmissa lutfen mesaji >>geri gonderiniz ve sisteminizden siliniz. Rt.Net Internet Hizmetleri >>Pazarlama ve Ticaret A.S. bu mesajin icerigi ile ilgili olarak hic bir >>hukuksal sorumlulugu kabul etmez. >> >>This e-mail communication is intended for the private use of the persons >>named above. If you received this message in error, please immediately >>notify the sender and delete it from your system. Rt.Net Internet >>Hizmetleri Pazarlama ve Ticaret A.S. does not accept legal responsibility >>for the contents of this message. >>-- >> >>-- >>Please see the official ORACLE-L FAQ: http://www.orafaq.com >>-- >>Author: MURAT BALKAS >> 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: Ora NT DBA 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: Lost ofall redo logs
I agree, there is never a problem because you backed up redo log files. There could be a problem with inadvertently restoring them, covering up needed information in the current online redo logs. John [EMAIL PROTECTED] wrote: My long standing position on this is that you take backups so that Just incase something fails, you have the ability to recover. If something hasfailed, I want backups of EVERYTHING. I know I dont' need the redo logs,but I would feel awful silly if I needed them at some point but didn't backthem up because I "understood" backup and recovery principles.-Original Message-NahataSent: Friday, September 20, 2002 8:29 AMTo: Multiple recipients of list ORACLE-LI'm not an expert so pardon me if i'm wrong.Why to copy the log files in case of a cold backup if the instance wasshutdown cleanly(NOT ABORT)??The d/b will be consistent so we don't need the redo-log files, isn't it?Isn't it that the DB update all the Datafiles headers with the checkpointinformation at the time of CLEAN SHUTDOWN so redo-logs are not required forarestore from cold backup?Though no harm in taking the log files backup too but they are not reallyneeded?Regards,Naveen-Original Message-Sent: Friday, September 20, 2002 7:18 PMTo: Multiple recipients of list ORACLE-LWell, it didn't sound like he was using Rman (which does not backup redologs). So I assumed that he was/should be using a cold-backup strategy -which, if it were me, would backup the redo logs.Tom MercadanteOracle Certified Professional-Original Message-Sent: Friday, September 20, 2002 8:48 AMTo: Multiple recipients of list ORACLE-LTom, that statement will open a can of worms(like a religion following)about if/when to backup redo logs. :)joeMercadante, Thomas F wrote: I agree with you Joe.I would *never* use an undocumented parameter unless Oracle told me to (orunless I was testing something that I could recreate).Using these params on the advice of someone from this list is verydangerous.The larger question is, why are the redo logs not being backed up?Arun, you need to establish a backup policy *immediately* so that you arenot being put into this position again.Tom MercadanteOracle Certified Professional-Original Message-Sent: Thursday, September 19, 2002 7:48 AMTo: Multiple recipients of list ORACLE-LKG, doesn't anyone think not having a backup is a bad thing.You can go down that route if you wish but as I remember undocumentedparameters are best used with the assistance of OWS and not just used atwill.joeK Gopalakrishnan wrote: Arun:You are right. The original poster *clearly* saidLOST ALL REDO LOGSNO BACKUP.In the above situation, you have to open thedatabases using the some special tricks andI don't think you need to go back and referBAckup and Recovery Manuals (You can notfind anything for this situation, that isanother story)Those parameters will bring up the databaseif the database is cleanly shudowned (read:Shutdown Normal/Immediate) and you willhave to do some more tricks to get thedatabase up if it is crashed (read: shutdownABORT).I don't think it is a bad advice..YMMVKG-Original Message-ChakrapaniraoSent: Wednesday, September 18, 2002 11:08 PMTo: Multiple recipients of list ORACLE-LWell one I do want to make clear I have never tried to give bad advice topeople.Since the user in his mail had said that he does not have a ba ckup and does not have any online redo logs can you please let me know how else can heopen the database, when he said he does not have a back it assumes that hedoes not have a os backup and also the rman backup.This might be the undocumented thing but this Is the only way it worksAnd this had happened in one our case and the only way we could open thedatabase is to force open the database in a corrupt mode take an export and import back into the new database.If you still think I am trying to give a bad advice well sorry that I amgiving bad advices.-Original Message-Sent: Thursday, September 19, 2002 12:33 AMTo: Multiple recipients of list ORACLE-LArun, since WHEN has been using undocumented parameters the normal wayof doing things, I think you need to go back and lookup backup/recoveryconcepts.Feel free to read both user managed and RMAN backup recovery docs/scenarios. You are giving bad advice to people on the list who might be new.joeArun Chakrapanirao wrote: The only way u can open your database is to add a parameter fileas_allow_resetlogs_corruption=TRUE_corrupted_rollback_segments= TRUE_offline_rollback_segments=(the rollback segment names)activate the database and then immediately take an export of the wholedatabase.Create a new database and then import all the data to this new database.-Original Message-Sent: Wednesday, September 18
Re: Estat Bstat
Try running from svrmgr instead of from sqlplus. If you are using a version of oracle that does not have sqlplus you should be using statspack instead. John John [EMAIL PROTECTED] wrote: >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: Ora NT DBA 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: Moving data between tablespaces[Scanned]
Hi Karthik,
When you moved the table it caused any indexes on this table to be
marked as unusable. This
is because the rows in the table now have different rowid's. You will
need to rebuild the indexes
as well. They don't have to be moved to a different tablespace but they
will have to be rebuilt.
Hope this helps,
John
[EMAIL PROTECTED] wrote:
>Thomas / Amar,
>
>I moved the tables from SYSTEM to the DATA tablespace. But now I am getting the
>following error.
>"ORA-01502: index 'ETAIL_TEST_NEW.AGENT_PK' or partition of such index is in unusable
>state"
>Is it because of moving the table to a different tablespace or is it something else?
>TIA
>
>regards,
>Karthik
>
>-Original Message-
>Sent: Tuesday, September 17, 2002 6:13 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Karthik,
>
>Look at the ALTER TABLE {table_name} MOVE {tablespace}; command.
>
>It will do exactly what you want.
>
>You can also ALTER INDEX {index_name} REBUILD {tablespace} to move indexes.
>
>Hope this helps.
>
>Tom Mercadante
>Oracle Certified Professional
>
>
>-Original Message-
>Sent: Tuesday, September 17, 2002 4:58 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi All,
>
>Some of my tables are accidentally created in the SYSTEM tablespace.
>Is there any way to move the records and the table to some other tablespace?
>
>
>regards,
>Karthik
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ora NT DBA
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: SQLPlus was Oracle - "can you imagine" ;-)
ufi, user friendly interface. Boy I feel old now [EMAIL PROTECTED] wrote: >OK Keith, do you remember what the prompt was that SQL*Plus came up with back >them & what it stood for?? > >Dick Goulet > >Reply Separator >Author: Jan Pruner <[EMAIL PROTECTED]> >Date: 5/17/2002 8:03 AM > >Yes, I can. >4 years ago I was porting our product to MS SQL 6.5 platform. > >JP > >On Fri 17. May 2002 16:53, you wrote: > >>ever wonder why SQLPlus is so damn robost? It can do >>just about anything... in a messy and time consuming >>way sometimes, but it is rock solid. >> >>"About 15 years ago, Sqlplus WAS Oracle". Nothing >>else. Hard to imagine. An Oracle engine with nothing >>inside (just tables and indexes): >>no procedures, >>no packages, package body, functions >>no triggers >>no sequences (can you imagine... this came with V6) >>no ref constraints >>no 2-phase commit >>no snapshots, no snapshot logs >>no parallel server >>... >> >>can you imagine! and it was already the most powerful >>database server growing at >100% year over year (100% >>growth for 13 years in a row) >> >>I mean "can you imagine" SQLPLUS "was" ORACLEcan >>you in your wildest dreams imagine what this group >>would be like?... just SQLPLUS related issues "can >>you imagine"....;-) >> >>Keith >> >> >> >>__ >>Do You Yahoo!? >>LAUNCH - Your Yahoo! Music Experience >>http://launch.yahoo.com >> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: 8i OCP questions
Hi Rick, There is currently no announced date to retire the Oracle8i OCP test. When announced they typically give approximately one year before retirement. What do you mean by "time allowed between tests". John [EMAIL PROTECTED] wrote: >Hi, > >I cannot find any info on Oracle web site concerning time allowed between >test and plans to retire 8i OCP. >Does anyone know or have any links that may state if there is a time limit >betweeen test and whether Oracle >has plans to retire 8i certification. > >Thanks >Rick > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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: Can't Connect to DB
Hi Ken, Is your listener started?? That appears to be the case based on this message. Go to your services and see if the Oraclelistener service is started. If not then start this service and try to connect then. If you are getting an error when attempting to start the service you will need to go to the dos prompt to get a more meaningful error and attempt to start the service with the command lsnrctl start It will probably still not start but you should get a better error. Good luck, John Hough [EMAIL PROTECTED] wrote: Oracle 9i on XP Prof. DB is on a single PC. When I try to do a DB connection I get this error. Yesterday I created a second DB on my PC and was able to connect successfully to either of them. This morning I rebooted my PC and now I cannot connect. Any idea what the problem is? TIA, Ken Janusz, CPIM - ORA-12541: TNS:no listener Details: Building Oracle HOMES List HOME Name OraHome90 added to list. Found multiple homes, searching each HOMEx for valid PATH searching in SOFTWARE\ORACLE\HOME0 Oracle_Home found in SOFTWARE\ORACLE\HOME0 IS in system path! oci.dll found
Re: How to know if another database is running on the same machine?
Hi Dmit, When you connect to a database and look at v$database, it will only show you information about the current database. On win2k you should check the following: 1. go to the services panel and make sure you have services created and started for each database 2. from the dos prompt check the listener to make sure it is listening for each of these databases 3. assuming you are using tnsnames file check to make sure each of these databases are in the tnsnames file 4. from the dos prompt see if you can connect to each of these databases using the oracle_sid set oracle_sid=oemrep sqlplus user/password select * from v$database; exit set oracle_sid=mydata sqlplus user/password select * from v$database; exit If all of the above are ok, you should be able to connect using the listener as well. Good luck, John [EMAIL PROTECTED] wrote: >Hi! > >On my win2k server I configured two databases one for data (MYData) and the >other for EM Repository OEMREP. The tools do not seem to be able to connect >to the database having data. The error reported is that TNS couldn't >identify SID. > >The v$database shows only the OEMREP database (Could be because the other >one is not accessible or perhaps the view shows the one that is active). > >How do I know whether the other database is there or not and how to make it >accessible? > >TIA! > >Aleem > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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: Dangerous BUG in Oracle. Oracle Unbreakable ???
Hi Jason, This was reported two weeks ago on this list by Jonathan Lewis. A patch has already been released. John [EMAIL PROTECTED] wrote: >An dangerous bug has been reported in Oracle lastest >database which is supposed to be 'Unbreakable'. > >See >http://www.dbresources.com/modules.php?name=News&file=article&sid=94 > for details. > >Oracle9i Database Server could allow a remote attacker >with limited database privileges could create a SQL >query that uses the ANSI outer join syntax to gain >unauthorized access to restricted data.This major bug >follows a series of security holes found in Oracle 9i >in recent months. > >The Idea of Oracle providing our national ID card has >started giving me chills now. > > >__ >Do You Yahoo!? >Yahoo! Health - your guide to health and wellness >http://health.yahoo.com > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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: DB Config. Assistant
Hi Ken, When you run the database configuration assistant (DBCA) it asks you to provide the sid for the database. You should be able to see the service associated with this database by looking at the "services". Don't know ANY XP but the service should be named "OracleServiceSID". Check to make sure that this service is started. If not you will have to start this service before you can connect. Assuming that it is started you can connect from a dos window by typing set oracle_sid="yoursid" sqlplus system/manager from here you should be able to query the dd tables. John [EMAIL PROTECTED] wrote: 9i on XP Prof. on DELL PC (no network) I tried to use DBCA to create a DB on my PC. I have never used this tool before. It appeared to run OK with no errors. However, when I query the V$ views I don't see it and I cannot connect to it. I ran DBCA twice to create the DB and the second time I didn't get any error message saying the DB already existed. I don't know that I should since I have never used DBCA before. If there is anyone out there that have used this tool before please give me some insight into it. Thanks and have a good day, Ken Janusz, CPIM
Re: How to deinstall oracle 9i and leave 8i intact
Hi Rick, I would first shut down the 9i versions of the services for any database, listeners, intelligent agents, etc. Then using the installer I would deinstall all 9i software. Then using regedt32 I would remove the home key for the Oracle9i home. That should just about do it. John [EMAIL PROTECTED] wrote: What platform are you working on? Windows or Unix?-Joe--- [EMAIL PROTECTED] wrote: Reposting as I forgot to include a subject line on previous post.I have Oracle 8i with 4 instances and Oracle 9i with 1 instance.How can I just remove all of Oracle 9i without touching Oracle 8i?ThanksRick-- 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-5051San Diego, California-- Public Internet access / MailingLists To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).__Do You Yahoo!?Yahoo! Health - your guide to health and wellnesshttp://health.yahoo.com
Re: SQL help
HI K,
You didn't say whether you have (or want) a unique constraint on these
fields,
but if you did (or do) you may consider the use of the exceptions table to
identify which rows violate these constraints.
An example below:
SQL> create table junk (id varchar2(4), company varchar2(3),
2 country varchar2(2), status number);
Table created.
SQL> insert into junk values ('5521','ABC','US',1);
1 row created.
SQL> insert into junk values ('5521','ABC','US',-1);
1 row created.
SQL> insert into junk values ('8877','DEF','UK',0);
1 row created.
SQL> insert into junk values ('8877','DEF','UK',1);
1 row created.
SQL> commit;
SQL> alter table junk add constraint junk_unq unique (id,company,cou
alter table junk add constraint junk_unq unique (id,company,country)
*
ERROR at line 1:
ORA-02299: cannot validate (SCOTT.JUNK_UNQ) - duplicate keys found
u, we knew that :-)
run the script to create the exceptions table
and enable the constraint again using the exceptions clause
SQL> @c:\oracle\ora901\rdbms\admin\utlexcpt.sql
Table created.
SQL> alter table junk add constraint junk_unq unique (id,company,country)
2 exceptions into exceptions;
alter table junk add constraint junk_unq unique (id,company,country)
*
ERROR at line 1:
ORA-02299: cannot validate (SCOTT.JUNK_UNQ) - duplicate keys found
SQL> select * from exceptions;
ROW_ID OWNER TABLE_NAME
-- --
CONSTRAINT
--
AAAH4LAABAAAO+HAAA SCOTT JUNK
JUNK_UNQ
AAAH4LAABAAAO+HAAB SCOTT JUNK
JUNK_UNQ
AAAH4LAABAAAO+HAAC SCOTT JUNK
JUNK_UNQ
AAAH4LAABAAAO+HAAD SCOTT JUNK
JUNK_UNQ
We can now use this table to view which rows have duplicates and to
decide based
on your business rules which should be deleted.
SQL> select * from junk where rowid in
2 (select row_id from exceptions e where e.table_name='JUNK');
ID COM CO STATUS
--- -- --
5521 ABC US 1
5521 ABC US -1
8877 DEF UK 0
8877 DEF UK 1
Hope this helps,
John
[EMAIL PROTECTED] wrote:
> Hello all,
>
> I need some SQL help .. I have a table with containing duplicate
> records but because they have differents status they really are
> duplicate .. i need to find these .. here is an example of what the
> table contains :
>
> IDCompany Country Status
> 5521 ABC US 1
> 5521 ABC US -1
> 8877 DEF UK 0
> 8877 DEF UK 1
>
> I want to pull the records where all the columns are the same except
> for the status column .
>
> Any help is greatly apprecieted
>
> K
>
> _____________
> MSN Photos is the easiest way to share and print your photos:
> http://photos.msn.com/support/worldwide.aspx
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ora NT DBA
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: URGENT : contact phone of Oracle Support
http://www.oracle.com Under Services (on left side) .. Select Support Under Services Information (on right side) .. Select Contact Support Services You will then get the appropriate numbers you seek. John [EMAIL PROTECTED] wrote: >Could any of you send me the 1-800 no. and also the other phone no. for contacting >Oracle support. > >Thanks, >Ashoke > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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: RAC
Which reminds me of a joke I heard once. You know what the difference between a used car salesman and a computer salesman The used car salesman usually knows when he is lying! ba-dum-dum John [EMAIL PROTECTED] wrote: I agree with Scott's reply. Compaq may be able to claim the "only Tru RAC",but not the only true RAC"!I skipped the keynote/marketing stuff at IOUG-A Live! 2002, but I've seenthe "long version" of Compaq 's demo/propaganda on RAC and, to put itmildly, "they exaggerated - A LOT". I don't know what may have been said atany f their scheduled sessions at the conference, but...The business about (paraphrased) "other vendors' RAC implementations beinglike an HA cluster" is pure unadulterated rubbish. There is no constrainton any certified RAC configuration that would limit it to a single activenode. (This applies also to at least one extremely non-certifiedconfiguration - my personal sandbox). There were four technical people fromCompaq at the OPS/RAC roundtable (and one from HP). None made any suchpreposterous statements. In fact, one of the Compaq representatives saidthey are currently running RAC on Linux (not Tru64) on Compaq hardware.They did, of course, push Tru64 and its cluster file system.I can verify, from direct experience, that RAC on Linux CAN share a datafileon a raw device. I don't know what was actually said, but the statementattributed to Compaq about this is obviously nonsense. If RAC nodes canshare a raw device, they can share a datafile on the raw device. (BTW:Didn't HP also do a "Keynote session" and demo on RAC?) Perhaps the Compaqrepresentative was confused as to the distinction between an Oracle"datafile" and a filesystem "file".I know that there are currently production RAC systems on NT, Sun, HP, andCompaq - at least. IBM may be on the list also. I know of one small sitein the early stages of implementing RAC on a Dell RAC-certifiedconfiguration (Dell 6450 nodes running RedHat 7.1 SBE with an EMC FC4700array). It will likely go into production within 2-3 months.Don Grana man[certifiable OraSaurus]- Original Message -To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Thursday, April 18, 2002 7:38 AMJonathan, At the seminars I have attended it was pointed out that the :true RAC"is COMPAQ only. The seminar was hosted by Oracle/Compaq. Compaq RACallows multiple CPU's to mount and use/share the same datafiles in atrue RAC configuration. The drives including the os drive are on a SANand shared by the CPU's so knowledge is shared. It was pointed out thenew Linux RAC can only share a RAW device and not a datafile. I don'tknow if this is true as I have not tried it yet. The speaker at theseminar said that with other OS's a RAC is like a High Availability (HA)option, one CPU is doing nothing until the first one fails or you onlyrun different applications and datafiles on one CP U and otherapplications and datafiles on the second CPU. if one fails you have tomount the datafiles and switch applications to the active CPU. To use a true RAC you have to use Compaq and I think the market shareof the OS's are not True64, so there are probably not a lot of users ofRAC.RonROR mª¿ªm [EMAIL PROTECTED] 04/17/02 10:18PM >>> I was talking w/someone today, and we realized that neitherof us knows of anyone actually using RAC in production. Sonow I'm curious. Is anyone?Jonathan Gennick --- Brighten the corner where you aremailto:[EMAIL PROTECTED]http://Gennick.com * http://MichiganWaterfalls.com *http://ValleySpur.com--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Jonathan Gennick INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051San D iego, California-- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Ron Rogers INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California-- Public Internet access / Mailing Lists--- -To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: sql & isql
Hi all, Mks is probably referring to the iSQL*Plus tool available in Oracle9i. This is basically a web form that allows the user to type sql or sqlplus commands in the top window and see the results in the bottom window. It is clusser to sql*plus worksheet than the conventional sql*plus command line or gui. John [EMAIL PROTECTED] wrote: >Mks - "isql" is a Sybase and MS SQL tool, not Oracle. The following excerpt >may clarify this. The equivalent in Oracle is probably SQL*Plus. >Dennis Williams >DBA >Lifetouch, Inc. >[EMAIL PROTECTED] > > >A word about the isql tool >The database access tool provided with Microsoft SQL Server is Microsoft >isql. You must use Microsoft isql (or a compatible tool) to access the >Microsoft SQL Server database to execute some of the test scripts documented >in this Appendix. > >Although the name of the Microsoft isql tool is the same as the Sybase tool >called isql, the Sybase and Microsoft tools are not compatible. For example, >you cannot use the Sybase isql tool to access the Microsoft SQL Server data >server and you cannot use the Microsoft isql tool to access the Replication >Agent administration port. > >If you have both Sybase and Microsoft isql tools loaded on the same >computer, you may need to change an environment variable (possibly the path >variable) to avoid problems when you invoke one of the isql tools. > > >-Original Message- >Sent: Tuesday, April 16, 2002 1:18 AM >To: Multiple recipients of list ORACLE-L > > >Dear Gurus, > >Where can I get the difference between 'sql' and 'isql' in Oracle. I >shall be grateful if anyone please mention some differences. > >mks > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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: TKPROF?
I have heard two different ones, no idea if either is correct :-) trace kernel profiler transient kernel profiler John [EMAIL PROTECTED] wrote: >What does it stand for? Tool Kit Profiler??? > >tia, > >David Nemeth > >__ >Do You Yahoo!? >Yahoo! Tax Center - online filing with TurboTax >http://taxes.yahoo.com/ > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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: anyone see my DBA_AUDIT_TRAIL ??? (solved) bug or Architecture ?
You don't say which version you are using but some versions of 8 had a problem with desc and synonyms. Try desc sys.dba_audit_trail and see if that works. I know this was a problem in early 8.0 (8.03, 8.0.4) but thought it was fixed by 8i. John [EMAIL PROTECTED] wrote: >Hi, > >Is this characteristic of a bug or is the Oracle Architecture ? > >SQL> desc dba_audit_exists >ERROR: >ORA-24372: invalid object for describe > > >SQL> select count(*) from dba_audit_exists; > > COUNT(*) >-- > 0 > >SQL> desc dba_audit_exists > Name Null?Type > - > OS_USERNAMEVARCHAR2(255) > USERNAME VARCHAR2(30) > USERHOST VARCHAR2(128) > TERMINAL VARCHAR2(255) > TIMESTAMP NOT NULL DATE > OWNER VARCHAR2(30) > OBJ_NAME VARCHAR2(128) > ACTION_NAMEVARCHAR2(27) > NEW_OWNER VARCHAR2(30) > NEW_NAME VARCHAR2(128) > OBJ_PRIVILEGE VARCHAR2(16) > SYS_PRIVILEGE VARCHAR2(40) > GRANTEEVARCHAR2(30) > SESSIONID NOT NULL NUMBER > ENTRYID NOT NULL NUMBER > STATEMENTID NOT NULL NUMBER > RETURNCODENOT NULL NUMBER > > > >Sinardy > > >> -Original Message- >>From: Sinardy Xing >>Sent: 08 April 2002 11:41 >>Subject: anyone see my DBA_AUDIT_TRAIL ??? >> >>Hi guys, >> >>Please help me solved this >> >> >>SQL> show user >>USER is "SYS" >> >> >>SQL> select owner, object_name, object_type from all_objects where object_name = >'DBA_AUDIT_TRAIL'; >> >>OWNER OBJECT_NAMEOBJECT_TYPE >>-- -- -- >>SYSDBA_AUDIT_TRAILVIEW >>PUBLIC DBA_AUDIT_TRAILSYNONYM >> >> >>SQL> desc DBA_AUDIT_TRAIL >>ERROR: >>ORA-24372: invalid object for describe >> >> >>Why I can not describe my DBA_AUDIT_TRAIL ? >> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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: Cold NT backups
Since it is a "cold backup". The database is closed. Try using the copy command instread of the ocopy to see if this eliminates the problem. I don't expect that it will but if it does you can complain about a problem in ocopy and if not you can eliminate ocopy as the problem and start blaming Microsoft. John [EMAIL PROTECTED] wrote: >Group, >We are doing a cold backup to a remote server. I am using OCOPY that fails >intermittently with the following message: >OCOPY - Insufficient disk space on target drive >There is more than sufficient space on the drive to hold the file. I filed a >TAR and was told that the error message is generic in nature and they could >not tell me exactly what is failing. Can anyone PLEASE give me some >suggestions. The file is always SYSTEM01.DBF. All the rest of the files copy >across without a problem. >TIA >Al Rusnak >804-734-8453 >[EMAIL PROTECTED] > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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: Failed login attempts
Hi Bunyamin, All I can is that by following these exact steps I get it working! SQL> select username,action_name,returncode from dba_audit_trail; USERNAME ACTION_NAME RETURNCODE LOGOFF_TI -- --- -- - SYSTEM LOGON 0 SCOTT LOGON 1017 JIM LOGON 1017 16 rows selected In another window attempt to login a Bunyamin/dbaSYSTEM LOGOFF 0SCOTT LOGOFF 0SYSTEM LOGOFF 0SYSTEM LOGON0SCOTT LOGON 1017JIMLOGON 1017BUNYAMIN LOGON 101717 rows selectedAs far as I can tell this is working. The retuncode of 1017 indicatesunsuccessfull logins. John [EMAIL PROTECTED] wrote: I tried What you said . but still no rows returns from dba_audit_trailalthough failed login attempts occured.Bunyamin K. KaradenizOracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729The degree of normality in a databaseis inversely proportional to that of its DBA.- Original Message -To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>Sent: Thursday, March 21, 2002 3:48 PM 1. change the initializaion parameter audit_trail to be:audit_trail=dbshutdown and restart database2. connect to the database as a user that has the privilege "AUDITSYSTEM" and enteraudit session whenever not successfulat this point you can see these unsuccessful logins by monitoring thedba_audit_trail view.John[EMAIL PROTECTED] wrote: Hi all,Which is the best way to keep audit of failed login attempts to the oracle server -without turning on full audit?Thanking you,---+---+C.S Waibale SimonMTN-Uganda,Cell: +256 77-212655,http://mtn.co.ug+---+ --Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Ora NT DBA INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California-- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: refer to SYSDATE function in a CHECK constraint--doable?
HI Roy, As you have already figured out sysdate cannot be used in a constraint. John [EMAIL PROTECTED] wrote: >Greetings all, > >I've got a table with a date field on a 8.1.6.0 db. I'd like to constrain >the values entered into this field to be less than or equal to the date on >which the record was entered. I figured a table-level check constraint >would serve & so I ran: > >ALTER TABLE TLB_COPIES > ADD (CONSTRAINT TLBCPY_DATE_LAST_LABEL_CK CHECK (DATE_LAST_LABEL <= >SYSDATE) > EXCEPTIONS INTO COMN_EXCEPTIONS) > >And Oracle complained thus: > > ADD (CONSTRAINT TLBCPY_DATE_LAST_LABEL_CK CHECK (DATE_LAST_LABEL <= >SYSDATE) > * >ERROR at line 2: >ORA-02436: date or system variable wrongly specified in CHECK constraint > >I've also tried using TO_DATE(SYSDATE) after running accross that expression >in some code examples in the docs (does SYSDATE not return a date type?), >but get the same error. > >I've searched through metalink for this error, but everything I've found >deals with how you've got to to_date() a date literal (e.g., no implicit >conversions) and be sure to use a full four-digit year (as of 8.x I think). >But I'm not seeing anything that refers to the sysdate function--is it just >not allowed? I'm pretty sure you can use it as a DEFAULT... > >Thanks! > >-Roy > >Roy Pardee >Programmer/Analyst >SWFPAC Lockheed Martin IT >Extension 8487 > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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: Failed login attempts
1. change the initializaion parameter audit_trail to be: audit_trail=db shutdown and restart database 2. connect to the database as a user that has the privilege "AUDIT SYSTEM" and enter audit session whenever not successful at this point you can see these unsuccessful logins by monitoring the dba_audit_trail view. John [EMAIL PROTECTED] wrote: >Hi all, >Which is the best way to keep audit of failed login attempts to the oracle >server -without turning on full audit? >Thanking you, >--- >+---+ >C.S Waibale Simon >MTN-Uganda, >Cell: +256 77-212655,http://mtn.co.ug >+---+ > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Certification Upgrade 8 to 8i
Hi Manoj, Only the oracle8 exams are being retired in March of 2002. You can bet that the8i exams will be retired but not when :-). Typically the announcement is made far in advance. The official place to see these announcements is: http:/www.oracle.com/education/certification Best regards, John [EMAIL PROTECTED] wrote: >Dear all, > >I have Oracle8 DBA certification. > >To upgrade there is following exam. > >1Z0-020 ORACLE 8I: NEW FEATURES FOR ADMINISTRATORS > > >Oracle announced : Oracle8 OCP Track Retirement >As of March 31, 2002 > > >Do anyone of you know if they will >also retire >1Z0-020 ORACLE 8I: NEW FEATURES FOR ADMINISTRATORS >on March-31-2002? > >If that is the case I will have to >complete this exam by Mar-31-2002. > > >Please let me know. > >Also please advise me on good study material and >useful resources/links for this Upgrade Exam. > >Thanks >Manoj >Oracle7.3, Oracle8 OCP DBA >Chauncey Certified DBA > > > > > >__ >Do You Yahoo!? >Yahoo! Sports - live college hoops coverage >http://sports.yahoo.com/ > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO
You can call them whatever you like, nothing in the world will save the clueless person you describe below :-). You are correct in saying it is a training issue, I personally use hot and cold but think offline and online are just fine as well. The issue is that the mode "archive vs noarchivelog" of the database significantly effects the "recovery" of the database. One of my favorite dba's instructors used to say if you are not going to test that backup and recovery plan at least keep an updated resume :-). John [EMAIL PROTECTED] wrote: But my concern is this. Say a DBA has been doing cold, noarchivelog mode,backups for a year. Then, he gets this great idea (or direction) to put thedatabase in archivelog mode, but to still do cold (or offline) backups, soall he changes in his backup/recovery strategy is the backup of the archivedredo logs, notrealizing that there are some other considerations. He reads a book or two, and because they call them hot/cold oronline/offline, he figures that his backup really is the same and that hejust needs to also backup the archived redo logs (thus, he continues tobackup the online redo and control files). Now, he has a crash. Because ofhis mistaken ideas (with no help from what he has read really), he recoversthe control file and online redo logs as he would have for a regular coldbackup bad news, no? I'm just... concerned, that the term is nottechnically correct and could lead to issues. I guess this is an educationalissue that I'm thinking of, less of a practical issue for seniorDBA's who clearly understand the implications of archivelog vs.noarchivelog.RFRobert G. Freeman - Oracle8i OCPOracle DBA Technical LeadCSX Midtier Database AdministrationThe Cigarette Smoking Man: Anyone who can appease a man's conscience cantake his freedom away from him.-Original Message-Sent: Monday, March 18, 2002 12:50 PMTo: Multiple recipients of list ORACLE-LNOARCHIVELOG moHi Robert,Oracle University training uses the terms online and offline and points outthat online backups can only be made to databases that are in archivelogmode. Offline backups can be made to either archivelog or noarchivelogdatabases.John[EMAIL PROTECTED] wrote: Ok maybe you will think this is a silly thread, but I've wonderedabout this before...We (DBA's) use the terms hot and cold backups all the time. I wonder though, when we talk about cold backups if the terminology should not include themode of the backup:cold archivelog mode backupcold noarchivelog mode backupWhen we say "cold" backup, do we just assume it's NOARCHIVELOG mode...andenjoy the fact that we don't have to type or say as much...or should we bemore specific to help the junior DBA's (or perhaps even those out there whohave never really considered that there is a distinction between the two)out there? When books are written, I notice that they mostly just talk about hot and cold backups, assuming that the cold backup is in NOARCHIVELOGmode... what about the junior DBA who does a cold backup in ARCHIVELOG mode andfollows the standard cold backup procedure (backing up control files andredo logs) assuming that he can just recover them(granted, anyone should testtheir backup and recovery strategy, but this is a Jr. DBA!)Just thinking aloud... is it a silly question?Robert G. Freeman - Oracle8i OCPOracle DBA Technical LeadCSX Midtier Database AdministrationThe Cigarette Smoking Man: Anyone who can appease a man's conscience cantake his freedom away from him.
Re: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELOG mo
Hi Robert, Oracle University training uses the terms online and offline and points out that online backups can only be made to databases that are in archivelog mode. Offline backups can be made to either archivelog or noarchivelog databases. John [EMAIL PROTECTED] wrote: >Ok maybe you will think this is a silly thread, but I've wondered >about this before... > >We (DBA's) use the terms hot and cold backups all the time. I wonder though, >when we talk about cold backups if the terminology should not include the >mode of the backup: > >cold archivelog mode backup >cold noarchivelog mode backup > >When we say "cold" backup, do we just assume it's NOARCHIVELOG mode...and >enjoy the fact that we don't have to type or say as much...or should we be >more specific to help the junior DBA's (or perhaps even those out there who >have never really considered that there is a distinction between the two) >out there? When books are written, I notice that they mostly just talk about >hot and cold backups, assuming that the cold backup is in NOARCHIVELOG >mode... > >what about the junior DBA who does a cold backup in ARCHIVELOG mode and >follows the standard cold backup procedure (backing up control files and >redo logs) assuming that he can just recover them(granted, anyone should >test >their backup and recovery strategy, but this is a Jr. DBA!) > >Just thinking aloud... is it a silly question? > >Robert G. Freeman - Oracle8i OCP >Oracle DBA Technical Lead >CSX Midtier Database Administration > >The Cigarette Smoking Man: Anyone who can appease a man's conscience can >take his freedom away from him. > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Sql loader - schedule
Hi Roland, You could do this via the OEM job system. Or whatever batch scheduling system exists in your environment John [EMAIL PROTECTED] wrote: >Hallo, > >How is it possible to schedule an sql loader script, which is running on network(not >unix). Let us say this should run at 6 pm every day. >This sqlloader simply loads a textfile into a table in the database. > >Thanks in advance > >Roland > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle.exe taking too much physical ram
Hi Arslan, Without know anything else it would be difficult to diagnose exactly what to do. But from the size of the allocated SGA it appears that you need to reduce some of these parameters. >From v$sga you have 640 MB of database buffer cache 80 MB of shared pool and other things What else is running on this machine? Is it only a db server? It appears to me that you need to reduce the db_block_buffers parameter. To reduce paging and swapping at the os level. As I said at the beginning, this is only a guess based on very limited information. John [EMAIL PROTECTED] wrote: Hi gurus, My Production Box has 1Gb Ram with single 933Mhz PIII processor , though the db is not that big (4 GB), the oracle process is taking too much of memory, causing server to slow down on peak times of the day, and even after words, tonight, I looked up the memory which ORACLE.EXE has taken, its almost 900 MB, why is that so ??? The last restart was a month ago as far as I remember, is this an OPERATING SYSTEM tuning problem or database tuning is required? MY pagefile size is almost 2 GB, but the STATISTICS show that only 4-5 MB of physical memory is free, means the most of the physical memory is used in ORACLE processes, The sga size is following, SQL> select * from v$sga NAME VALUE -- Fixed Size 75804 Variable Size 90701824 Database Buffers 65536 Redo Buffers 77824 If db tuning is needed, from what point I should start, Also, I haven't analyzed the schemas from long, The occasion DEAD LOCK problems also show up, Can anybody shed some light, where the choke point is ??? Help and suggestions welcomed, Thanks in Advance, Arslan Zaheer Dar [EMAIL PROTECTED] Database Administrator Shaukat KhanumMemorial CancerHospital & Research Centre www.shaukatkhanum.org.pk + 92 (042) 5180725 - 34 Ext: 2323
Re: cannot find database in OEM ???
Hi Andrea, Have you stopped and restarted the Intelligent Agent? The databases are discovered and stored in the services.ora file when the agent is started? Your discovery actually "reads" this file. Best regards, John [EMAIL PROTECTED] wrote: >Hi all, > >I created one db and after OEM discovered node, that >db shows on navigator. I created another database, I >refreshed the node, the new db did NOT show; then I >deleted the old node, and did a discover again, but >the new db still did not show. Metalink suggests >refresh twice it will work, but it didn't work for me. > If I use Launch Standalone, all the db can be found, >but I have to use ManagementServer. What should I do? > >Thank you! OEM is a part of Oracle9i, on Win2000. > >Andrea > >__ >Do You Yahoo!? >Try FREE Yahoo! Mail - the world's greatest free email! >http://mail.yahoo.com/ > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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: Cost vs Rule
This shouldn't be a problem, hints just look like comments to other db's. John [EMAIL PROTECTED] wrote: not much - desire is to keep sql ANSI compliant due to cross-platform issues(want to be able to run the app on multiple db's)-Original Message-Sent: Thu, March 07, 2002 2:44 PMTo: Multiple recipients of list ORACLE-LHow much have you played with Oracle Hints???-Joe--- "Magaliff, Bill" <[EMAIL PROTECTED]> wrote: I work in a dev shop - most of the sql is canned and pretty basic. We'vebeen running CBO in all of our dev environments, but we have a fewlong txnsthat just take forever. At the request of some savvy developers, Iturnedon RBO, and it brought down execution times dramatically.I've been analyzing affected tables often (we do a lot of bulkload/unloadfor testing), and have played with partitioning and clustering,particularlyon one table that's just a dog. CBO will always do a FTS where RBOuses thePK to retrieve data.Where to go next? I've been unable to alter the costs dramaticallyenoughto make any real difference in execution time.thx-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Magaliff, Bill INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California-- Public Internet access / MailingLists To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).__Do You Yahoo!?Try FREE Yahoo! Mail - the world's greatest free email!http://mail.yahoo.com/
Re: row level lock
Hi Shishir, This is oracle's default behaviour. As you update , insert or delete a row oracle places a lock at the row level. John HOugh [EMAIL PROTECTED] wrote: HI list! I want to lock a table on row level ( not table level) . how do we pass the pass that value in syntax which will lock only those rows. plz make me understand by giving an example. thanx in advance.. Shishir Kumar Mishra Agni Software (P) Ltd., Bangalore-560055, India www.agnisoft.com
Re: FRAGMENTATION QUESTION?
Hi Seema, define what you mean when you say 6 are fragmented. John [EMAIL PROTECTED] wrote: > Hi > If one tablespace has 10 tables and 6 are fragmented table in that > particular tablespace.If I use COPY command to move data from one > server to another then is COPy command bring data with fragmented > tables data? > Thx > -Seema > > > > _ > Get your FREE download of MSN Explorer at > http://explorer.msn.com/intl.asp. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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: # of datafiles per tablespace
Hi Kathy, The only thing I can think of for your original question is a bad guess on the file size. They guessed 500 mb, ran out of file space, added a 50 mb file to the Tablespace, ran out again added 50 mb again. never ran out again. Reading other dba's minds is so much fun :-) John [EMAIL PROTECTED] wrote: That being said is there anything wrong with having one 4G datafile for a tablespace. I personally cannot think of any. Therewere the days when 2G was the limit but that sure isn't the caseanymore. The only thing I can think of is for backups. However, I am alwaysgoing to backup on at least the tablespace level so if I haveone file or multiple files I still need to get them all. I don'tknow if RMAN has some special feature that turns out it makes senseto backup just one data file of a tablespace that has multipledata files but I sure can't think of any good reason.I just randomly picked RBS but I am seeing the same case ondata tablespaces as well.-Original Message-CarmichaelSent: Monday, March 04, 2002 6:29 PMTo: Multiple recipients of list ORACLE-Lno reason. I can see creating multiple files under those conditionsonly because you want to keep files to a specif ic size.Now, I did once find that the rollback datafiles were a bottleneck on asystem I had. So we built TWO rollback tablespaces, with datafiles ondifferent mount points etc and the rollback segments divided betweenthe two tablespaces.cleared up that bottleneck like a dreamother than that though.. why?--- Kimberly Smith <[EMAIL PROTECTED]> wrote: OK, I know we had the debate already but lets have another go at it.Say you got a tablespace, lets call it RBS and its for rollbacks.Now, for what reason would you create a 500M file and 4 50M filesfor this puppy as opposed to just one file. I just cannot see thereasoningfor this at all. None. Natta. Zilch.So educate me please if someone out there knows a legit reason theywould do this.Lets assume for the sake of argument that disk size and mount pointsize is not a limitation. Space available to me on any one mountpointis unlimited.___Kimberly SmithPortland, OR[EMAIL PROTECTED]-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Kimberly Smith INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California-- Public Internet access / MailingListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). __Do You Yahoo!?Yahoo! Sports - sign up for Fantasy Baseballhttp://sports.yahoo.com
Re: TABLE SIZE?
This would be true if and only if you ignored block header space and ignored free space in blocks. What do you want to know The number of blocks under the high water mark? The total size of extents allocated to the table segment? The space allocated within those blocks? The total number of blocks allocated to the table? Any one of these could be answered none of them would be the answer you arrived at. John John [EMAIL PROTECTED] wrote: > Hi > If I have value num_rows and avg_row_len then can I know the size of > tables? > Table size(Bytes)=num_rows*avg_row_len > > Thx > -seema > > > _ > Join the world's largest e-mail service with MSN Hotmail. > http://www.hotmail.com > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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: Unused users for the last 30 and 60 days.
Hi That should work, I was using oracle 7 (so it wouldn't have worked then) at the time and we had varying levels that we had to deal with > 30 days we had to send an e-mail > 60 days we had to disable. This could be done with the account management features of 9 also . I don't believe the aging is that discriminating. But if you had one level and you were using 8, 8i or 9i I'm thinking I could get your idea to work as well. John [EMAIL PROTECTED] wrote: wouldn't it be easier to create a new profile or change the defaultprofile so that there was a password_life_time of 30 or 60 and then setthe grace period to a day or so and then check for users whose accountsare locked?--- Ora NT DBA <[EMAIL PROTECTED]> wrote: Hi Deepender,I know of know builtin oracle view that will tell you thisinfomation. At a formerjob we were required to disable accounts that had not been used inthe last 60days. It has been a little while since I worked there (7 years to be exact)butbasically this is what we did1. created a tablecalled dbs_user_info with the fields (username, create_date, last_login_date)2. copied the username and create field from dba_users into thefields, initially we set last_login_date to be = create;3. Turned on auditing in the init.ora and audited successful logins4. at night we went through the sys.aud$ table and for each userthat existed updated the last_login_date truncating sys.aud$ when done5. weekly ran a batch job that found all users that last_login_datewas > 30 daysBeginning in 8i it might be easier to do this with an after log in trigger rather than auditingHope this helps,Johnthat contained the username,[EMAIL PROTECTED] wrote: Hi All,I want to have report of all the users who has not used their Oracleusername for the last 30 and 60 days.Any views how can I get the report.Thanks,Deepender -- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Ora NT DBA INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California-- Public Internet access / MailingListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). __Do You Yahoo!?Yahoo! Greetings - Send FREE e-cards for every occasion!http://greetings.yahoo.com
Re: Clash of the DBs in eWeek
HI Igor,
All I meant was that I couldn't get to the article because sql server couldn't
except
more connections.
I have only "browsed" the article but found it interesting that the
db that was hard to use "dusted" all the ones that were "easy" when they
had no
help from "Oracle Experts".
John
[EMAIL PROTECTED] wrote:
Do you mean it was SQL Server DBAs tuning Oracle in this test, becausethat's what they are using for their web-site?Igor Neyman, OCP DBA[EMAIL PROTECTED]- Original Message -To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Thursday, February 28, 2002 1:58 PM
Interesting, I went to the web page and clicked on the link"Putting database performance to the test" and got the following messageCould not Connect to DB:[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does notexist or access denied.Oh well, maybe they were mad because they lost!John[EMAIL PROTECTED] wrote:
At first glance it looks like they could have done more to tune Oracle.Certain tables could have been cached (or buffer pools could have beenused). They're only using a 4K db block so it would have been nice to seetests with 8K and 16K db blocks. Sort area size may need tuning. I'd like
to
see some tkprof on the queries and see what the most expensive queries
are
in terms of CPU, I/O, and number of executions. It would be nice to seedatabase results on Linux... It would be cool to see what some focusedtuning efforts could do but who has time for that?Anyone have any other tuning suggestions for eWeek?Time for the tuning DBA guru's to shine. :-)-Original Message-Sent: Thursday, February 28, 2002 9:53 AMTo: Multiple recipients of list ORACLE-LAnybody happen to see the cover story on the 02/25/2002 iss of eWeek
titled
"Database Clash"?The pretty graphs say that their tests showed that Oracle and MySQL
rocked
the other DBs they tested (including MS SQueaL Server). So I
investigated.
I went to http://www.eweek.com/ and downloaded the "Online Exclusive:Download our configuration and tuning scripts".According to the Oracle setup docs in there, they're NOT using MTS andprocesses in init.ora is 150. So then how did they test for 1000"concurrent Web clients"?Anyone have a thought?Rich Jesse System/Database Administrator[EMAIL PROTECTED] Quad/Tech International, Sussex, WI
USA
--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Ora NT DBA INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California-- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: Unused users for the last 30 and 60 days.
Hi Deepender, I know of know builtin oracle view that will tell you this infomation. At a former job we were required to disable accounts that had not been used in the last 60 days. It has been a little while since I worked there (7 years to be exact) but basically this is what we did 1. created a tablecalled dbs_user_info with the fields (username, create_date, last_login_date) 2. copied the username and create field from dba_users into the fields, initially we set last_login_date to be = create; 3. Turned on auditing in the init.ora and audited successful logins 4. at night we went through the sys.aud$ table and for each user that existed updated the last_login_date truncating sys.aud$ when done 5. weekly ran a batch job that found all users that last_login_date was > 30 days Beginning in 8i it might be easier to do this with an after login trigger rather than auditing Hope this helps, John that contained the username, [EMAIL PROTECTED] wrote: >Hi All, > >I want to have report of all the users who has not used their Oracle >username for the last 30 and 60 days. >Any views how can I get the report. > >Thanks, >Deepender > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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: Clash of the DBs in eWeek
Interesting, I went to the web page and clicked on the link "Putting database performance to the test" and got the following message Could not Connect to DB: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. Oh well, maybe they were mad because they lost! John [EMAIL PROTECTED] wrote: >At first glance it looks like they could have done more to tune Oracle. >Certain tables could have been cached (or buffer pools could have been >used). They're only using a 4K db block so it would have been nice to see >tests with 8K and 16K db blocks. Sort area size may need tuning. I'd like to >see some tkprof on the queries and see what the most expensive queries are >in terms of CPU, I/O, and number of executions. It would be nice to see >database results on Linux... It would be cool to see what some focused >tuning efforts could do but who has time for that? > >Anyone have any other tuning suggestions for eWeek? > >Time for the tuning DBA guru's to shine. :-) > > > >-Original Message- >Sent: Thursday, February 28, 2002 9:53 AM >To: Multiple recipients of list ORACLE-L > > >Anybody happen to see the cover story on the 02/25/2002 iss of eWeek titled >"Database Clash"? > >The pretty graphs say that their tests showed that Oracle and MySQL rocked >the other DBs they tested (including MS SQueaL Server). So I investigated. >I went to http://www.eweek.com/ and downloaded the "Online Exclusive: >Download our configuration and tuning scripts". > >According to the Oracle setup docs in there, they're NOT using MTS and >processes in init.ora is 150. So then how did they test for 1000 >"concurrent Web clients"? > >Anyone have a thought? > > >Rich Jesse System/Database Administrator >[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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: MIGRATION
Hi Guri, If you don't have time to make a backup before moving a machine to a different site at least take the time to update your resume and put it in a safe location. Good Luck, John [EMAIL PROTECTED] wrote: >guri, > >If you don't have the time to get the cold backup to removable media, >you'll just have to accept the risk of the box being lost, stolen, or >destroyed in an accident. You can still reduce risks in other areas. > >I don't see what risk you are abating by making a cold backup to >another disk partition, unless that partition is on another physical >drive. A physical event that causes one file to be unreadable (such as >head damage) usually renders the entire disk unreadable, so you don't >gain much. If it's a different physical drive, at least you're >gaining the probability of one of them surviving the physical abuse. > >Chances are you'll be able to shut down the database, shut down the >OS, power down the machine, carry it to the new location, and power it >back up with no problem. Modern equipment is fairly robust. >Personally I'd treat it all like a carton of eggs just to be safer. > >The "how much extra precaution" you take should be based on what it will >cost you if the machine falls off the truck, never to be seen again. >One can justify the cost of the precautions as long as they are lower >than the cost of the loss. > >-rje > >g> I don't have machine to buildup the standby database.I don't have much time >g> to take cold backup also.I think if Can take cold backup on another disk >g> partition would be fine. >g> Any suggestion please? >g> Thx >g> guri > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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).
