RE: APPEND hint (Was: Which is faster??)

Hi Yong, I don't think that's right. Try it on a table with no indexes, and dump the redo and undo blocks afterwards. My tests show that there is no row level redo (layer 11) except against the data dictionary tables for space management, regardless of whether the table or tablespace is defined

Best Practice ?

For Analyze of Tables on a Oracle 817 Database on Cluster with OPS ? Should the Tables be Analyzed OR Not ? This is a Application with More OLTP than Batch ( Banking Product ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED]

Re: Deleting alert_sid.log while db is running?

Even if you "rm" the file, it will still be consuming disk space until the file is closed (when the DB comes down). The down side is that you will no longer be able to see any new entries. I'm not sure what the results will be if you cp /dev/null alert_SID.log HTH HAND!

RE: SQL Loader Help in 8.1.6

Thanks, I got that work out now. It's an option (direct=true) in the control file in 8.1.6 was missing. But I still don't understand that 8.0.5 will be able to compile without this option. I'm running 8.0.5 on my local machine, but 8.1.6 is remote on a UNIX box. Will these different environment

Re: Ora Apps Loggin In Issue

On Sun, 25 Mar 2001, Olson, David wrote: Any clues as to what might be causing this. Everything worked just fine before the SP1 upgrade. You just answered your own question. - Redmondware. Do you have a pressing need to have the latest MS aii browser? If not, go back to the earlier,

RE: Transporting Database

If its giving the message " Insufficient Priviledges" then try copying the init.ora file again from the source to the server where r u wan't to create a database. If u wan't to edit the init.ora file to change some parameters, use edit, never use notepad to edit the init.ora file. Opening

RE: Parallel Query Option

Rodney, this will help you get started. I tried it and it works great! http://www.oracle.com/oramag/code/tips2000/index.html?101600.html Prakash -Original Message- Sent: Thursday, February 01, 2001 1:48 PM To: Multiple recipients of list ORACLE-L Listers, I'm looking for

RE: Single Code Table or Separate Code tables dilemma

comp.databases.oracle.server (Was: Re: DBMS_REPAIR package usage)

Hi, Murali, You don't subscribe to a newsgroup such as comp.databases.oracle.server as you do to a mailing list. If your company has a news (NNTP) server, configure your browser to user it and type the URL news:comp.databases.oracle.server to read/post messages. Most companies use "news" or