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 as NOLOGGING. The undo is correspondingly trivial. However, if there are indexes then you get lots of index redo (layer 10) and corresponding undo. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Sunday, 25 March 2001 15:18 To: Multiple recipients of list ORACLE-L Hi, Connor, The append hint to insert does not disable generating rollback info. It does stop redo generation for a nologging table. Yong Huang [EMAIL PROTECTED] you wrote: If you're on 8.0 or higher, try insert /*+ APPEND */ into table select * from other_table; where "table" is defined as nologging. Then you won't hit either redo logs or rollback segments..Its the equivalent of a sqlldr direct load hth connor __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: yong huang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams 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).
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] 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: 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! == Guang Mei wrote: Hi: I have a oracle db (oracle 8.0.5 on Sun Unix) whose alert_sid.log size is too large. I want to delete it. Can I just simply do "rm alert_sid.log" without shuting down the db, assuming there is no "writting" going on to the file at that moment? I usually do shutdown, delete alert log file, and then startup db again. But this is a 24*7 db and can not be shutdown. TIA. _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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 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 matters?
Wendy
"Aponte, Tony" [EMAIL PROTECTED] wrote:
Is your mainframe using EBCDIC? If so there is a translation table that explains what the "}" translates into. The sign of the field is trailing (E.I.. at the end of the field for non-Cobolers)
These indicate that the sign of the number is negative.
}=0
R=9
Q=8
P=7
O=6
N=5
M=4
L=-
K=-
J=1
These are for positive numbers:
{=0
A=1
B=2
C=3
D=4
E=5
F=6
G=7
H=8
I=9
The example you mentioned (00}) is really all zeroes. A value of 1023A really equals 10231.An example of a negative number would be 112233R which equals -1122339. The Utilities manual might have a sample of how to convert external numbers with trailing signs. You could also code a function to do translation and return the resulting number. Then you can use it in the SqlLdr control file.
Tony Aponte
-Original Message-From: Wendy Y [mailto:[EMAIL PROTECTED]]Sent: Friday, March 23, 2001 2:47 PMTo: Multiple recipients of list ORACLE-LSubject: SQL Loader Help in 8.1.6
Dear Experts:
This does not make any sense to me, can you help me out?
I have a control file to interpret the mainframe data and then write to my table in Oracle Database.
The mainframe data looks like "0}", The table is designed as Number(10,2), The control file use zoned(10,2).
All these combination will work fine on Oracle 7.3/8.0.5, but will fail on 8.1.6. (the message said: rejected on XXX field)
If I modify table as Varchar2(10), it will work, but the data format is not the way I want. the format should be "0.00" when it's 0, instead of "0". Also "+" or "-" should be able to display. How can I make this work in 8.1.6?
Here are part of the control file:
LOAD DATAREPLACEINTO TABLE C_FINANCIAL (CONSOLI_ID POSITION(001:003) CHAR,
TAX_CREDIT_AMT POSITION(177:186) zoned(10, 2), QTY_ORIGINAL POSITION(187:196) zoned(10),... )
Thanks
Wendy
Do You Yahoo!?Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.Do You Yahoo!?
Yahoo! Mail Personal Address -
Get email at your own domain with Yahoo! Mail.
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, working version. Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron 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: 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 init.ora file in notepad might corrupt the init.ora. Arvind --- "Jefferson, Dean" [EMAIL PROTECTED] wrote: I've done this many times on NT, by shuting down the source database, copying ALL database files to the new server, creating an instance with the same SID on the target server and just openning it up and running it. Here is the statement I use to create the instance. Note that I set the internal password to "manager", I think the default is "oracle": oradim -new -sid TEST -intpwd manager -startmode auto -pfile E:\Oradata\TESTdb\pfiles\initTEST.ora The trick is that the directory structure where any and all database files are stored must be identical on the source and target servers. Otherwise you must play around with telling Oracle that the datafile that used to be here is now there... HTH, Dean Jefferson Database Administrator State of Wisconsin Office of Commissioner of Insurance [EMAIL PROTECTED] -Original Message- From: Yuzie [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 3:41 AM To: Multiple recipients of list ORACLE-L Subject: Transporting Database Dear DBAs, I have 2 NT servers, Oracle8 (8.0.5) Server has been installed on each of them. One server has a database and no database on another. Is it possible to move or duplicate a database from one servwer to another? Based on my conceptual understanding, this will work, but I it failed when I tried. Therefore, I need your confirmation. What I have tried is: 1. Copy physical control files and initialization parameter file. 2. Run ORADIM and all services are started. Problem: I can not connect internal. Actually, I want to try to create an instance, startup nomount, and use the init file/control file. But I can not go further because I can not login to the instance as internal or sys. Sorry, crossposting. Thnx lots Yuzzie N. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yuzie INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jefferson, Dean 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). __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arvind Aggarwal 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: 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 documentation on the PQO. I have scanned through my Oracle Press books and some of the Online Documentation at MetaLink. What they offer is a piece here and a piece there interspersed in Parallel Server topics. I am NOT running OPS, but would like to implement PQ on a couple of my largest tables. Do any of you know of a concise altogether reference on the PQO that I can get or download? TIA Rodd Holman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Holman, Rodney INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bala, Prakash 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: 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 "snews" as the news server name. Try: telnet news 119 help quit to find out. Or ask your Help Desk. If your company does not have a news server, read Question 2 at http://groups.google.com/googlegroups/help.html. I use news.interbulletin.com currently. If you insist on using a public news server instead of a Web gateway, www.jammed.com/~newzbot/sorted-speed.html does a fairly good job on listing public servers, which come and go at their will. To use one of them, type the URL news://[the IP of the server]/comp.databases.oracle.server in your browser. News readers don't use these URLs. Yong Huang [EMAIL PROTECTED] you wrote: How does one subscribe to this ? Murali Vallath Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Sat, 24 Mar 2001 05:05:21 -0800 Hi, Winnie, How did you find the file# to be 9 (unless you messed with your original error message)? I suggest you post your message to news:comp.databases.oracle.server (or http://news.interbulletin.com/cgi-bin/ibwrn/post/comp.databases.oracle.server if your company doesn't have a news server). Hopefully it will attract... __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: yong huang 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).
