Oracle 817 client on Windows 2003?

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

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 Cit

RE: SYS Privilege

r, 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: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Hi!!

your data immediately with cold 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]

RE: undotbs01.dbf just keeps growing

q.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 yourself from this mailing

RE: Rollback datafile size

Once the tx 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

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 h

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 C

RE: what is business intelligence?

data warehouses" to help users "mine" 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, Decembe

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

ing 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: [EMAIL PROTECTED] Fat City Network

RE: Documenting databases

data 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

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

you can learn from people who understand it well and can express it well, also. In my opinion, those names include C.J. 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

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

ited. 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: [EMAIL PROTECTED] Fat City Network Services-- 858-538-505

RE: Reducing rollback segment tablespace sizes

duce the chance 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 fro

RE: Reducing rollback segment tablespace sizes

still scattered 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

Reducing rollback segment tablespace sizes

t let 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

RE: Silly SQL Question

is 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 services -

RE: Stop using SYS, SYSTEM?

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: anyone take the 8i performance tuning ocp test?

: 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 RE

RE: ORA-4031 error help.

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

RE: Re: What happened to Howard Rogers ?

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: 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, 2

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

RE: Your new book

complish their goals. Their planes fly. I'm looking forward to Cary's book precisely because 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

RE: question on comments -sanity check

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

Duplicated posts

I'll refrain from sending any more posts until I'm sure the problem is resolved. Thank you all again for the 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-

RE: Performance tuning book

very much. 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,

RE: Performance tuning book

-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: RE: Data Modeling

or, 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: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego,

RE: Your new book

math, but it'll 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

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 841

Performance tuning book

'd be very 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 conf

RE: Performance tuning book

very much. 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,

RE: Your new book

math, but it'll 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

RE: RE: Data Modeling

or, 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: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego,

RE: Performance tuning book

-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: 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 841

Performance tuning book

'd be very 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 conf

Your new book

'd be very 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 conf

RE: Data Modeling

nderstand and is the basis of good data modeling. Some authors: C.J. Date Fabian Pascal 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 attac

RE: Passed Net8 OCP Exam

notified that any 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://ww

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.

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 ba