Importing LOB segments
Hi there, I have been importin 2gig of LOBs and it is extremely slow, is there any way how to speed up this process... rgds jbHöstrusk och grå moln - köp en resa till solen på Yahoo! Resor
Software Owner for Oracle8 and Oracle9
Hi all, We have currently a debate ongoing on the Unix side about the issue of having 1 Oracle software owner for both Oracle 8 and 9 versus having a new software owner for 9. What comments you have, w hat might be advantages and disadvantages using one or two users... Thank you in advance, Rgds JoshuaYahoo! Mail - Gratis: 6 MB lagringsutrymme, spamfilter och virusscan
Oracle RMAN (OmniBack) Backup Encryption
Hi all, I have a "weird" question. Do you have any experience how to encrypt the backup. Let's say I have following backup method in use: RMAN on UNIX box. I will use online backup and copy the backup set(s) either to the disk or the tape using OmniBack. How I can encrypt the backup sets either to the disks or to direct to the tape using OmniBack. Do you have any similar setups... Thank you in advance, JoshuaGå före i kön och få din sajt värderad på nolltid med Yahoo! Express
Automate an update
Hi all, I need help in order to create a following "mechanism". I have a table where is a column called window_open and it has two values 'Y' and 'N' Now I need to automate the update a single row based on following rules: If time is between 08:00-16:00 the value on that window_open column should be 'Y' during other period the value should be 'N'. How can I do this and automate the task... Thanks in advance, JoshuaGå före i kön och få din sajt värderad på nolltid med Yahoo! Express
Oracle Server / W2K
Hi all, what might be the best configuration for OLTP database if you have following "components": DL380 2*1.4ghz, 2GB Mem, 6*16GB 15k Disks... And what is the correct flag for Optimize Performance for Applications or Background Processes... TIA Joshua _ Gå före i kön och få din sajt värderad på nolltid med Yahoo! Express Se mer på: http://se.docs.yahoo.com/info/express/help/index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Joshua=20Becker?= 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).
_filesystemio_options=setall
Hi all, has anyone checked this, is it worth to try or test... >_filesystemio_options=setall rgds JoshuaGå före i kön och få din sajt värderad på nolltid med Yahoo! Express
Performance review for
Hi all, I wonder gathering a document template in order to do some db auditing. I was wondering if anyone has a good document or a list of issues or good links what to put into performance review list. Thanks in advance, JoshuaGå före i kön och få din sajt värderad på nolltid med Yahoo! Express
lsnrctl -utility, passing password in a command file
Hi all, is there any way how to start password protected listener from certain .bat file. I am using Windows NT and I don't know how to pass a password to lsnrctl -utility when I am doing like this lsnrctl reload PASSWORD. All tips are welcome... Rgds, Kalle _ Gå före i kön och få din sajt värderad på nolltid med Yahoo! Express Se mer på: http://se.docs.yahoo.com/info/express/help/index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Joshua=20Becker?= 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).
Metilinx -product!
Is anyone using this product, could I please hear your comments and thoughts. Is there other links than this http://www.metilinx.com/default.cfm rgds Joshua _ Gå före i kön och få din sajt värderad på nolltid med Yahoo! Express Se mer på: http://se.docs.yahoo.com/info/express/help/index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Joshua=20Becker?= 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).
Oracle Audit for Failure Logins
Hi all, could someone give me an example how could I set up auditing on for failure logins. Thank you in advance, God Bless innocent people in Iraq and let the Imperialists get out there ASAP. Rgds JoshuaGå före i kön och få din sajt värderad på nolltid med Yahoo! Express
Oracle Expert Fails
Hi all, I noticed an interesting error, I tried to use Oracle Expert in order to tune my database but it won't go further after noticing some temporary tables, and actually Expert asked to delete those objects. Is that normal behaviour or a bug. Rgds, JoshuaGå före i kön och få din sajt värderad på nolltid med Yahoo! Express
Space or Memory Leak
Hi all, In case you face some space or memory leak problems, how you can see the problem on OS side, I mean does it load more CPU utilization or Memory... Rgds, JoshuaGå före i kön och få din sajt värderad på nolltid med Yahoo! Express
NLS_COMP=ANSI and NLS_SORT=GENERIC_BASELETTER
Hi, I need to do some sorts with Scandinavian characters and I need to setthese parameters NLS_COMP=ANSI and NLS_SORT=GENERIC_BASELETTER Where do I put these because I am using and application and WebLogic iscalling some programns which are actually using that sorts... Any ideas would be apreciated... TIAKalleGå före i kön och få din sajt värderad på nolltid med Yahoo! Express
DB design principles
Hi all, I need gather some principles for good db design. Do you happen to have any or do you good links where I could check some white papers etc... rgds _ Gratis e-mail resten av livet på www.yahoo.se/mail Busenkelt! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Joshua=20Becker?= 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).
Oracle 9i 32bit and 64bit on the same server
Hi all, I have a following problem I hope you could help me: I have an UNIX box (Solaris8) where I have installed 9iRel2 64 bit software, also I have created two instances using that 64 bit version. Now we are also having an application which needs 32 bit 9i client software on the same server. The user who owns this application also needs every now and then shutdown and start the instances. How I should configure the profile of this application user. I have an oracle -account who "owns" the instances and the application user is also in dba -group. Thank you in advance, JoshuaGratis e-mail resten av livet på: www.yahoo.se/mail Busenkelt!
NLS_LANG settings on MetaFrame
Hi all, I have a following problem. I have a MetaFrame -environment where I need to support to different character sets. Database is UTF8 format. Now I need to support for some users Russian Character Set and some users West European Character set. How I can define in Metaframe "user based" character set when the default nls_lang is in registry... Thank you in advance... Joshua _ Gratis e-mail resten av livet på www.yahoo.se/mail Busenkelt! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Joshua=20Becker?= 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).
Listener problem ....
Hi all, I am wondering is there something wrong with my listener settings. I mean when I type LSNRCTL> servicesConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test01u)(PORT=1521)))Services Summary...Service "TEST2" has 2 instance(s). Instance "TEST2", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER Instance "TEST2", status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:1 refused:0 state:ready LOCAL SERVERService "TEST1" has 2 instance(s). Instance "TEST1", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER Instance "TEST1", status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 state:ready LOCAL SERVERService "TEST3" has 2 instance(s). Instance "TEST3", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER Instance "TEST3", status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 state:ready LOCAL SERVER Why it shows service has 2 instances? I am using Sun Solaris with Oracle 8.1.7 and 9.2. rgds, JoshuaGratis e-mail resten av livet på: www.yahoo.se/mail Busenkelt!
RMAN with OmniBack on NT
Hi all, do you have good papers or good links where I can read "detailed" information concerning how to setup rman with omniback on nt. I am also very delighted to hear your comments concerning this set-up Rgds and thanks, JoshuaGratis e-mail resten av livet på: www.yahoo.se/mail Busenkelt!
Urgent: Trigger problem...
Could someone help me with this. I have a trigger in one table and the trigger should do one unix -command (tclsh). However I am facing following problem... OS return value: the Permission (java.io.FilePermission /usr/local/ActiveTcl/bin/tclsh execute) has not been granted to TEST. The PL/SQL to grant this is dbms_java.grant_permission( 'TEST', 'SYS:java.io.FilePermission', '/usr/local/ActiveTcl/bin/tclsh', 'execute' ) I ran the dbms_java.grant_permission pl/sql and it went through succesfully, however I am facing same problem... Any ideas, I am using 9iRel2... Thanx, Joshua _ Gratis e-mail resten av livet på www.yahoo.se/mail Busenkelt! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Joshua=20Becker?= 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).
IMP-00098: Internal Error: impccr2
Hi all, I received quite interesting error during import. I am trying to put the dump from 8.1.6 database to 9i rel2 database on win2k server. The export dump was done with WE8ISO8859P1 character set and the target db is with UTF8 character set... Do you have any idea, or should I contact oracle support! Rgds, JoshuaGratis e-mail resten av livet på: www.yahoo.se/mail Busenkelt!
Connections with WebLogic (5.1) and Oracle 8.1.7 on Solaris
Hi all, we are facing strange problems with our environment. we are using weblogic and solaris8 with 8.1.7.3. It seems that somehow amount of cumulative connections is getting extremely high and it seems that WL is doing db connection each time user clicks the aplication. Is there any parameter on oracle side causing this. We have tested this with two similar environment and other seems to work ok and other does generate these connections but we do not find any reason for the different behaviour... Any ideas... Rgds, Joshua _ Gratis e-mail resten av livet på www.yahoo.se/mail Busenkelt! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Joshua=20Becker?= 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).
Storage Recommendations
Hi all, does anyone know a good site or have good white papers or presentations concerning physical storage recommendation for different size Oracle databases... and also for different platforms (Win2000 and HP-UX and Sun Solaris...) I would be VERY grateful for all information :-) Thank you very much in advance Joshua _ Gratis e-mail resten av livet på www.yahoo.se/mail Busenkelt! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Joshua=20Becker?= 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).
Index Oracle-l
INDEX ORACLE-L _ Gratis e-mail resten av livet på www.yahoo.se/mail Busenkelt! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Joshua=20Becker?= 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).