Oracle 817 client on Windows 2003?

to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: SYS Privilege

by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: SYS Privilege

. The sys as sysdba password will now be ginger. In the User Name: field of the SQL*Plus login screen, type: sys/[EMAIL PROTECTED] as sysdba of course substituting the name of your DB and your own password. HTH Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120

RE: Hi!!

backups, then move on to using RMAN for full backups. Then move on to incremental backups. I hope that helps. Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] This e-mail, including

RE: undotbs01.dbf just keeps growing

-- Author: Michael Milligan 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

Rollback datafile size

? The datafile is 4.6 GB but the segments are small, so all that space is wasted. Any help would be appreciated. I'm trying to read up more, but have found nothing about what to do when shrink won't work. Thanks, Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120

RE: Rollback datafile size

appropriately. Don't go to small or you run the risk of transactions failing due to unable to extend errors. Daniel Fink Michael Milligan wrote: The datafile for our rollback segments gre huge because of an improper setting. Even setting optimal and shrink, etc., won't help because the segments

RE: Rollback datafile size

is complete, the status will change to 'Offline'. If a query is running and needs undo entries from an offline (including pending) rbs, it will fail with a 1555. Daniel Michael Milligan wrote: Daniel, Thank-you very much for your clear answer. Very helpful. When a RBS is taken off-line, does

RE: what is business intelligence?

the database for important information and trends. HTH, Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] -Original Message- Sent: Friday, December 19, 2003 3:10 PM To: Multiple recipients of list

RE: Documenting databases

dictionary automatically to update your app. You would only have to manually update the non-Oracle information. Mike Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] This e-mail, including attachments, may

RE: Re[2]: char is going away?

by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: Any articles/books that take relational theory and make it en

by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: Any articles/books that take relational theory and make it

. Date, Hugh Darwen, Fabian Pascal, and a number of others. HTH Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 19, 2003 2:35 PM To: Multiple recipients

RE: Silly SQL Question

dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan INET

Reducing rollback segment tablespace sizes

me resize it at all (it has extents scattered throughout). Anyone know how I go about shrinking it? Do I have to create a new tablespace/datafile, then drop the old one? TIA, Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058

RE: Reducing rollback segment tablespace sizes

throughout the tablespace, preventing me from resizing the datafile. Thanks, Mike -Original Message- Sent: Monday, November 17, 2003 2:44 PM To: Multiple recipients of list ORACLE-L Michael Milligan wrote: I have a client where rollback segments were set up RBS01-RBS05, all in a tablespace

RE: Reducing rollback segment tablespace sizes

of a 1555. Daniel Fink Michael Milligan wrote: I have a client where rollback segments were set up RBS01-RBS05, all in a tablespace called RBS. The person who set it up set %INCREASE at 50%. Well, I shrank the segments to themselves down to less than 500MB total from 4.6GB! But in using ALTER

RE: anyone take the 8i performance tuning ocp test?

-- Author: Michael Milligan 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

RE: Stop using SYS, SYSTEM?

: http://www.orafaq.net -- Author: Michael Milligan 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

RE: ORA-4031 error help.

ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Boolean dates...

So that's what you call trivia about trivia? :-) Actually, that is really interesting. Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 23, 2003 10:55

RE: Your new book

Cary, Is Mike Tanner's book Practical Queuing Analysis good in your opinion? Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 22, 2003 11:54 PM

RE: Re: What happened to Howard Rogers ?

this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: question on comments -sanity check

by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: Your new book

of the reasons you mentioned. Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only

RE: Data Modeling

Sharon Allen many others as well. HTH, Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only

Performance tuning book

interested in your own assessment. What did you try to accomplish with this book? TIA, Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] This e-mail, including attachments, may include confidential

RE: Performance tuning book

Sorry to double post. It didn't show up on the board and after about an hour I thought there was a problem. Of course as soon as I posted again, they both showed up! I'll be more patient next time. Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801

RE: RE: Data Modeling

notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Your new book

be good for me anyway. Thanks again for taking the time to write that great review, Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] This e-mail, including attachments, may include confidential

Performance tuning book

interested in your own assessment. What did you try to accomplish with this book? TIA, Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] This e-mail, including attachments, may include confidential

RE: Performance tuning book

Sorry to double post. It didn't show up on the board and after about an hour I thought there was a problem. Of course as soon as I posted again, they both showed up! I'll be more patient next time. Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801

RE: Your new book

be good for me anyway. Thanks again for taking the time to write that great review, Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] This e-mail, including attachments, may include confidential

RE: RE: Data Modeling

notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Performance tuning book

. I'll be buying it tonight. Thanks again, Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used

Duplicated posts

om sending any more posts until I'm sure the problem isresolved. Thank you all again forthe great posts about Cary's book and data modeling. Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] T

RE: Passed Net8 OCP Exam

: http://www.orafaq.net -- Author: Michael Milligan 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

RE: Tools to Execute Stored Procedures in Debug Mode !

PL/SQL Developer from allround automations is the best, hands down. Go to http://www.allroundautomations.com for a trial. It's only $150 and it's a whole, integrated PL/SQL development environment. Fantastic program. HTH, Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake

RE: A quick note

Welcome back! Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 08, 2003 4:34 AM To: Multiple recipients of list ORACLE-L Hi everyone, I'm back