RE: Forms - as sysdba

Hi I don't have 9i to test, but I believe you might be able to set O7_DICTIONARY_ACCESSIBILITY = TRUE in init.ora and then you should be able to connect as sys without specifying sysdba. This might be suitable for the upgrade - certainly test it out on a test system first. Regarding the

Re: Nature of Oracle-l has changed

Yes I would say that most of the topics have been more in line with operational issues. I think RMAN has probably had a higher hit in the conversation counter and that i guess is due to more DBA's flirting with it in there environment, Roberts book probably helps. Since I am fortunate enough

Re: Collaboration Suite

Actually I'm a bit surprised, that OCS works that well for you. My impression about Oracle products is that Oracle Server is the only Oracle server-type product which may work out-of-the-box. I've worked with iAS since v.2 and yes, E-Business suite as well. The worst experiences are with IFS

Re: question on how to retrive document

Ok, in that case it's nice - you can index your BFILEs and retrieve them using other methods such NFS or webserver accessing files directly Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 22, 2003 12:34 AM Yes, context

RE: Making my firts job

Hi!! I am making my firts job and I have some problems calculating the correct = time to lauch the job. I have the next procedure: CREATE OR REPLACE PROCEDURE SP_SOH_HAND AS BEGIN INSERT INTO TB_ICTRANSX select COMPANY, LOCATION,ITEM,SOH_QTY,AVERAGE_COST,= SYSDATE-1, UPDATE_TIME from iTEMLOC

RE: Online Document for Windows XP Home edition Severity 3

Title: Message Try copying the contents of the CD to a directory on your hard drive. Search for all instances of symcjit.dll in that directory and below and rename them to symcjit.dll.old. Then run setup from the directory on your hard drive. Gudmundur -Original Message-From:

Re: Forms - as sysdba

Robo wrote: Hi all, I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys. There are 3 boxes for username, password and database. Does anyone know if/how is it possible? Yes, you could do this by creating an ON-LOGON trigger. But this is a really, really bad idea. Scott Lamb --

RE: Online Document for Windows XP Home edition Severity 3

Title: Message If you have reached a point where you could press the Install/DeInstall button, it means that you dont have any problem with your Java installation/settings. Try to troubleshoot in other areas. Also, update the Forum with your success story once you are done. ~Venu

AW: RH not-so-Advanced 2.1 and new hardware

Hi Rich ! Most of the NICs are NE2000 compatible. This means that you could run your NIC by using the module 'ne2k-pci.o' in '/lib/modules/$KERNEL_VERSION/kernel/drivers/net'. (on RH9 or RG AS2.1) I am using this module at home to run my RT8139 NIC under RHAS 2.1 HTH. Milen -Ursprüngliche

RE: Online Document for Windows XP Home edition Severity 3

Title: Message Sinardy, I've installed the Oracle docs simply by copying all the directories from the CD to my hard drive - no need to perform an installation. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message-From: Gudmundur Bjarni Josepsson

RE: Making my firts job

Simple: TRUNC(SYSDATE) + 1 + 1/60/60/24 TRUNC(SYSDATE) is midnight today. +1 is midnight tomorrow. +1/60/60/24 is one second past midnight- 1/60th of a minute, which is 1/60th of an hour, which is 1/24th of a day. -Original Message-From: Teresita Castro [mailto:[EMAIL

Oracle 9i versus MS SQL 2K w.r.t. Performance

Need to give a presentation on Oracle 9i versus MS SQL Server 2K with respect to Performance primarily . Any Docs , Links ? Thanks

Re: Row level security and latch waits - LONG email...

- Original Message - Policy function: DPA42HP92.DP_PREDICATE_FUNCTION_PKG.DP_PREDICATE_FUNCTION RLS view : SELECT CURRENCY,CURRENCY_CODE,CURRENCY_DESC,CURRENCY_KEY FROM DPA42HP9 2.DPR70_CURRENCY_D DPR70_CURRENCY_D WHERE (CURRENCY_CODE in (select value_ v from

Re: Nature of Oracle-l has changed

Jared, I agree that the development has declined at a lot of sites. We are a VB shop and damagement has decided to outsource the hosting of our reports database and the web based development of the application to access the reports database. I soon will go from a 84 GIG database to a 5 GIG

RE: SharePlex info

Title: Message Tony, My question was inspired by belief that SharePlex does log mining on the source DB and hence do not send unnecessary data over the network. Apparently, this is not the case. I didn't want to compare SharePlex to logical standby cause I know that logical standby

Business Rules approach to design?

I know this is big in the ODTUG circles. Has anyone used this approach to design databases? Seems promising. Though the hardest part would be in convincing the 'i just want to code' folks to adapt it. I havent really read that much into it. It also appears that the level of skill and

RE: Oracle 9i memory Leaks and other errors

anyone helppp -Original Message- Sent: Thursday 21 August 2003 07:59 To: Multiple recipients of list ORACLE-L -Original Message- Sent: Monday 18 August 2003 06:36 To: '[EMAIL PROTECTED]' Hi Can anyone help me with Oracle 9i database - ie 9.2.0.3 where there are issues

RE: RH not-so-Advanced 2.1 and new hardware

Thanks for the suggestion! Since our RAC tests have two main goals -- to test RAC functionality and to test it on RH AS 2.1 -- I've temporarily given up on AS 2.1 and installed RH9 instead. Of course with the newer kernel and more mods included, it installed easily without a problem. I'll be

OT: Mysql PHP list

Title: OT: Mysql PHP list Hi, Does anybody know a good list for questions about PHP in combination with Mysql (and oracle) TIA Jack

+++ Oracle + RAID +++++++++

Dear Friends, I have read some book to know about Oracle on RAID. I better idea about various RAIDs. But Implementing Oracle on RAID , I am not much clear. My understaning is 1. All files on RAID 1 +0 ( because its good in IO rates, better protective ) 2. Read only TS on RAID 5.(because its

UNIX and Oracle

Dear Friends, Any good article to explain the above subject, SHARED Memory Sema phores on SUN / LINUX for Oracle. I just know what is shared memory , sema phores are. But never involved practically much. Please also send me some typical configurations , with explanation(if possible ) Please

RE: Oracle 9i memory Leaks and other errors

You can find the interesting information on http://www.metalink.com -- Mladen Gogala Oracle DBA -Original Message- Bhavesh Lala Sent: Friday, August 22, 2003 10:09 AM To: Multiple recipients of list ORACLE-L anyone helppp -Original Message- Sent: Thursday 21 August

RE: Nature of Oracle-l has changed

That's why my post on historic tables and views seem lonely ;-) Stephane -Original Message- Jared Still Sent: Friday, August 22, 2003 2:19 AM To: Multiple recipients of list ORACLE-L Has anyone else noticed? Not so long ago, we saw quite a few more questions about such things as

Re: OT: Mysql PHP list

Jack, if you've got some specific questions shoot them my way, i'm doing php/mysql development right now for dynamic web pages. joe Jack van Zanen wrote: Hi, Does anybody know a good list for questions about PHP in combination with Mysql (and oracle) TIA Jack -- Joseph S Testa Chief

RE: Business Rules approach to design?

I have a growing respect for the business rules approach to system design. For instance, entities and relationships as drawn in a traditional entity/relationship (E/R) diagram are representations of business rules about what data your system will read, update, store and write and how various

Re: Collaboration Suite

switch back to regular fileserver which I now know should be used for serving files anyway. In the future of course, 'regular' file servers will actually be running on top of a database. SQL Server if your file server happens to be of the M$ variety. Will SysAdmins also need to be DBA's? ;)

Re: Business Rules approach to design?

And I thank you. :) On Fri, 2003-08-22 at 06:49, [EMAIL PROTECTED] wrote: I know this is big in the ODTUG circles. Has anyone used this approach to design databases? Seems promising. Though the hardest part would be in convincing the 'i just want to code' folks to adapt it. I havent

Exact fetch

Hallo, anyon who can tell me whatthis mean`? I get it while I am trying to load some data in some tables? ORA-01422: exact fetch re turns more than requested number of rows Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

RE: Oracle 9i memory Leaks and other errors

I have tried there and they just have a patch but not much other info which can help -Original Message- Sent: Friday 22 August 2003 04:20 To: Multiple recipients of list ORACLE-L You can find the interesting information on http://www.metalink.com -- Mladen Gogala Oracle DBA

RE: Exact fetch

Title: RE: Exact fetch it means Exact fetch returns more than requested number of rows, nothing more, nothing less. HTH Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are

RE: Exact fetch

What does the load procedure look like? AFAIK this means that a select into returns more than one row in the subquery, which would indicate use of PL/SQL Any triggers etc..?? Jack -Original Message- Sent: Friday, August 22, 2003 4:45 PM To: Multiple recipients of list ORACLE-L

Re: Oracle 9i versus MS SQL 2K w.r.t. Performance

The Yukon Database Try this link http://www.oracle.com/features/insider/index.html?1101_db_yukonlate.htmland http://www.oracle.com/ip/deploy/database/oracle9i/db_sqlpartners.html Alessandro Guimarães - Original Message - From: VIVEK_SHARMA To: Multiple recipients of list

Re: Exact fetch

7:24-sherlock:ts01:jkstill-0 oerr ora 1422 01422, 0, exact fetch returns more than requested number of rows // *Cause: The number specified in exact fetch is less than the rows returned. // *Action: Rewrite the query or change number of rows requested 07:25:43 sherlock - [EMAIL PROTECTED]

Partitions in RH AS 2.1

Title: Partitions in RH AS 2.1 Hi list, New in linux. I configured a RAID 0 in a Dell Server and installed RH AS 2.1. Now as a result I have a /dev/sda4 of 200 GB. I used fdisk and made 3 partitions that became /dev/sda9, /dev/sda10, /dev/sda11. Now I want to make the file systems and

Re: RE: Business Rules approach to design?

i head paul dorsey(from dulcian) speak last night. he was talking about a business rules repository modeller that his company has called 'BRIM' supposed it will generate the bulk of the code for you. anyone ever work with that? From: John Flack [EMAIL PROTECTED] Date: 2003/08/22 Fri AM

Oracle on RAID - Thanks

To whomever posted the link to Gaja's paper Implementing RAID on Oracle - thank you. I previously had printed and passed this article on to my system administrator -- no reaction. But yesterday he was building our new Sun system with all the latest features, and was so excited about the paper that

RE: Oracle 9i memory Leaks and other errors

Are you sure it is a memory leak or is it problem with program design? What are the error messeges? Bit tough to provide any feedback with the minimal information you have provided. Brad O. -Original Message- Sent: Friday, August 22, 2003 9:09 AM To: Multiple recipients of list

HP-UX 11/9iR2/Processes

Hi Everyone: I've noticed a new type of background process in my 9iR2 databases. It's name is ora_j00n_SID. Does anyone know what this process is? Any links to Docs? Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL

RE: Oracle 9i versus MS SQL 2K w.r.t. Performance

Vivek - This subject has been discussed on this list from time to time. You can go to Google and search for Oracle-L SQL Server and variations to pull up previous discussions. Awhile back eWeek magazine did an extensive benchmark. It is a little date, but make sure you re-read that for insights.

RE: Nature of Oracle-l has changed

There is another thing happening: companies are more and more relying on canned, off the shelf applications, in a hope to become compliant with present standards. That has dramatically cut down the number of needed developers, because if you don't have to develop your general ledger, payroll, CRM

RE: Nature of Oracle-l has changed

Jared, Yes, the nature of the list has changed, so have the times. While development work here is not slowing, the direction that we're going in has changed. Oracle's development tools are just about history here replaced by PeopleSlop and JAVA. Also I've spent a significant amount

RE: Nature of Oracle-l has changed

OK, who let Chicken Little out of his room?? As someone at a location that is doing a lot of third party application buying, yes we in some ways are crane operators and mechanics. But then comes the fun of integrating the data from that new application into the remainder of the

RE: Nature of Oracle-l has changed

It also seems that once the big canned application are up and running, companies are outsourcing more and more the operations. Those canned applications need to be integrated and that's the best and last place where DBA and dev people can be today, in the BI place. Here, in the architecture

Re: HP-UX 11/9iR2/Processes

It is the snp equivalent ...in 9i rel2 there is a job coordinator process and based on the job_queue_processes parameter ...that many jnnn processes. Murali.

RE: (long) Design question, historic and views

Hi! To answer your original question about the design DW transport, there is too much to write to answer it completely. There's too many different ways to do the task. I'll try to give you a reply from my past experience with OLTP- DW transfer (from up to 800GB OLTP systems to 2-3TB DWs). 1)

AW: Nature of Oracle-l has changed

Hi Stephane Looks like I missed that post amongst all the very technical ones ;). I'm working on a development project now (social security), which includes heavy modelling, especially in the arena of historical data etc. So, it looks like I have to go back and browse the archive for your

RE: RE: Nature of Oracle-l has changed

Mladen, There is another thing happening: companies are more and more relying on canned, off the shelf applications, in a hope to become compliant with present standards. That has dramatically cut down the number of needed developers, because if you don't have to develop your general ledger,

AW: Nature of Oracle-l has changed

Hi Mladen I guess you summarized the whole drama of IT today pretty well. I'm already VERY concerned about the near future (esp. as a former developer, now more DBA/Data Manager guy). What's left to do, or to concentrate on, when development will be shipped to elsewhere and DBAing means Hey Joe,

RE: Forms - as sysdba

Title: RE: Forms - as sysdba What about granting sysdba priviledge to yourself? then you could do everything sys could do! my 0.02 Luis -Original Message-From: Suhen Pather [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 6:19 PMTo: Multiple recipients of list

time/date granularity

Hi, Is there a way for me to get the time of a particular sysdate past the granularity of one second? Thanks! Josh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Josh Collier INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: Making my firts job

Thanks !! A friend of mine give an example of how to do a procedure that runs a job: CREATE OR REPLACE PROCEDURE lanza_job IS jobno number; instno number; begin dbms_job.submit( jobno, 'SP_SOH_HAND;', TRUNC(SYSDATE) + 1/60/60/24 ,'TRUNC(SYSDATE) + 1 + 1/60/60/24 '); commit; END

ADMIN: Collaboration Suite mailing list?

Hi group -- I've been toying with starting a new mailing list for Oracle Collaboration Suite (OCS) users and administrators. It's a fairly new product and I haven't seen any mailing lists other than what is on OTN, so there might be a need. I realize that participation might be low as the

RE: RE: Nature of Oracle-l has changed

There is another problem with canned applications. The damanagement has to make a choice to either bend the business to match the application of bend the application to match the business. From my point of view, the latter is happening more than the former. Also, as a side note, I

RE:OT:UNIX: Anyway to run this in the background and return to ca

Title: RE:OT:UNIX: Anyway to run this in the background and return to calling process $ORACLE_HOME/bin/sqlplus / as sysdba EOD select .. exit EOD echo this is a test ps -ef|grep sqlplus I wish to put that into a unix command but at the same time run it in the background and return

RE: time/date granularity

Josh - Which Oracle version? I think 9i has provision for this. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, August 22, 2003 12:20 PM To: Multiple recipients of list ORACLE-L Hi, Is there a way for me to get the time of a

RE: Nature of Oracle-l has changed

Do you see outsourcing orientation to the canned products in Germany? I imagined that Siemens, Software AG, MBB (Airbus) and some other companies must be doing heavy development there, and that, given the language barrier, the supply for the off the shelf products is not as good as here in the

RE: Nature of Oracle-l has changed

Well...I made the transition from development to DBA when we initially got SAP'd (1993) partly because it looked interesting, partly because I was the only one on the development staff who bothered to dig into the technical end of things and...partly because management at the time had this

RE: time/date granularity

Title: RE: time/date granularity if you are pre 9i you can get up to 100th of a second using dbms_utility.get_time(). in post 9i, you can use systimestamp which will give you a microsecond if you wish. Raj

RE: OT:UNIX: Anyway to run this in the background and return to c

Title: RE:OT:UNIX: Anyway to run this in the background and return to calling process Never mind I got it. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Friday, August 22, 2003 1:25 PMTo: Multiple recipients of list ORACLE-LSubject:

RE: time/date granularity

Sorry I left out the important thing: 9i rel 2. Thanks. -Original Message- Sent: Friday, August 22, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Josh - Which Oracle version? I think 9i has provision for this. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL

RE: time/date granularity

Title: RE: time/date granularity The issue at hand is this: There is a column, setup_date that is populated by a trigger with sysdate after insert. Now the developers want to know if there is a way they can get the time of this date to a granularity of 10ths or 100ths of a second. If I

RE: OT:UNIX: Anyway to run this in the background and return to ca

Title: Message #!/usr/bin/perluse strict;use bytes;my $pid=0;if (!defined ($pid=fork())) { die "Problem with cutlery:$!\n"}elsif ($pid) { print "Do stuff here\n"; waitpid($pid,0); print "Cutlery is back\n"; }else { open(SPY,"ps -ef|grep sqlplus|"); while (SPY) { print;} } --Mladen

RE: time/date granularity

Title: RE: time/date granularity Josh, sysdate has the granularity of a second only. You might want to add a new column for fractional seconds or change the column datatype to systimestamp; if you create new column, you can just add the fractional part as follows ... create or replace

Re: time/date granularity

Title: RE: time/date granularity You can't even store sub second precision values in date datatype. Use timestamp instead (9i) or some custom format. In 8i you can have a java class which returns you date with high enough precision. Tanel. - Original Message - From: Josh

Kerberos OKINIT , OKLIST, ORA-12699

I'm trying to get Kerberos authentication to work. I am not using LDAP at all. I just want to authenticate with Kerberos. Kerberos itself is working fine. kinit and klist work as expected. I had our security admin create a service principle. Does there have to be one per machine or one

RE: Nature of Oracle-l has changed

I believe the mantra needs to be evolve and prosper, stagnate and die. I've been thinking along much the same lines. Jared Goulet, Dick [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/22/2003 09:09 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L

RE: (long) Design question, historic and views

Thanks for sharing. It may have been 'back in the 8.0 days', but is nonetheless a clever process. Streams and Logminer may be available now, but I like the elegance of the dual partition exchange. Jared Tanel Poder [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/22/2003 09:34 AM Please

RE: Kerberos OKINIT , OKLIST, ORA-12699

With kerberos, you shouldn't do identified externally, you should do identified globally. And yes, gooey tools are just for wimps. Real programmers use ed. -- Mladen Gogala Oracle DBA -Original Message- MacGregor, Ian A. Sent: Friday, August 22, 2003 3:14 PM To: Multiple recipients of

ADMIN: Warning about virus threats this week

Hello everyone -- As you undoubtedly know, the Internet has been slammed this week and last week with mass mailings, intrusions, worms and viruses. More are on their way. Fat City has seen a huge increase in the number of spoofed messages coming into our systems. In fact, more than three

RE: RE: Nature of Oracle-l has changed

Well, I wanted to add my .2 Cents here. Custom development projects have shrunk over the past year because companies are tired of the maintenance issues associated with custom applications. More organizations are shifting their efforts towards implementing canned solutions and taking the bite, as

RE: (long) Design question, historic and views

Hi, Thanks for the info. Our site is way smaller, the ODS will be around 30G of raw data. So partitionning is out of the question here (I've used the one partition table trick to use the exchange feature before on a bigger db). Management is even considering DB2 for all the BI initiatives since

SharePlex info

Title: Message You are correct in the first place. SharePlex works as you describe, it mines the log and sends only the absolute minimum to reassemble the transaction on the target. It doesn't send SQL. The target side processes take the data and rebuild a SQL statement from the DDL

RE: Forms - as sysdba

Hi Bruce, this is EXACTLY what I needed, great! Many thanks =RP= Hi I don't have 9i to test, but I believe you might be able to set O7_DICTIONARY_ACCESSIBILITY = TRUE in init.ora and then you should be able to connect as sys without specifying sysdba. This might be suitable for the

RE: OT:UNIX: Anyway to run this in the background and return to c

Title: Message Thanks, Hmmm perl... Well, I came up with a loop using while and a ps -ef|grep $pid command but this looks interesting. -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Friday, August 22, 2003 2:04 PMTo: Multiple recipients of list

convert number to word ???

Hi, Is there a function that can conver number to word? ef: 100 is ONE HUNDRED, 2003 is TWO THOUSAND AND THREE. Thank you in advanced!!! __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see

RE: Nature of Oracle-l has changed

Title: Message I'm planning on doing #4 next fall. Look out Mississippi State, here I come! Kevin Toepke -Original Message-From: Odland, Brad [mailto:[EMAIL PROTECTED] Sent: Friday, August 22, 2003 5:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Nature of

RE: Nature of Oracle-l has changed

We are in the middle of a development revolution here. It is being driven by a desire to allow greater access to the Peoplesoft databases. The Peoplesoft folks want to continue using those tools. But the folks that are responsible for the application server which will connect to Psoft want

Re: ADMIN: Warning about virus threats this week

Thanks for staying on top of this Bruce. Jared Bruce A. Bergman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/22/2003 12:39 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:ADMIN: Warning about virus

RE: OT:UNIX: Anyway to run this in the background and return to ca

Title: Message Errrm -this script doesn't dowhat I think you're trying to do.Perl starts, it forks a child process, the parent process "does abunch of stuff", but the child process only runs ps once. S, you end up with azombie child process (until the parent is donewith its

Re: convert number to word ???

some where I got this create or replace function spell_number( p_number in number ) return varchar2 as type myArray is table of varchar2(255); l_str myArray := myArray( '', ' thousand ', ' million ', ' billion ', ' trillion ', ' quadrillion ', ' quintillion ', ' sextillion ', '

RE: OT:UNIX: Anyway to run this in the background and return to ca

Title: Message No, I just wanted to demonstrate thefork mechanism in perl. The proper way to handle stuff would be to call exit at the end of the child process, which would clean things up properly and not leave za zombie lying around. And yes, "ps -ef" is executed only once, when the SPY

RE: Kerberos OKINIT , OKLIST, ORA-12699

I'm using externally because I am not using a directory service. Ian -Original Message- Sent: Friday, August 22, 2003 12:42 PM To: Multiple recipients of list ORACLE-L With kerberos, you shouldn't do identified externally, you should do identified globally. And yes, gooey tools are

RE: convert number to word ???

You can find perl module doing that at: http://www.bayview.com/software/perl.shtml -- Mladen Gogala Oracle DBA -Original Message- Andrea Oracle Sent: Friday, August 22, 2003 5:19 PM To: Multiple recipients of list ORACLE-L Hi, Is there a function that can conver number to word?

Re: convert number to word ???

I got this off of metalink: select to_char( to_date( 1, 'J' ), 'jsp' ) from dual; SQLselect to_char( to_date( 123,'J'), 'jsp') from dual; TO_CHAR(TO_DATE(123,'J') -- one hundred twenty-three SQLselect to_char( to_date( 123,'J'), 'Jsp') from dual;

Re: convert number to word ???

SELECT TO_CHAR(TO_DATE(2003,'J'),'JSP') FROM DUAL; TO_CHAR(TO_DATE(20 -- TWO THOUSAND THREE - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 22, 2003 4:19 PM Hi, Is there a function that can conver number to word?

RE: OT:UNIX: Anyway to run this in the background and return to ca

Title: Message Oh, I see - okay, I just misunderstood what was being demonstrated. You can't simply call exit at the end of a child execution, however - you must either terminate the parent process or call wait(), waitpid(), etc. exit() will leave a zombie until the parent waits() for a

Re: ADMIN: Warning about virus threats this week

I think its a GREAT IDEA! Thank you for maintaining this list and keeping it virus free, well almost :). Other lists, I belong to are slamming me w/ the SOBig virus. Gene [EMAIL PROTECTED] 08/22/03 03:39PM Hello everyone --As you undoubtedly know, the Internet has been slammed this week and

Re: ADMIN: Warning about virus threats this week

Bruce A. Bergman wrote: Hello everyone -- As you undoubtedly know, the Internet has been slammed this week and last week with mass mailings, intrusions, worms and viruses. More are on their way. Fat City has seen a huge increase in the number of spoofed messages coming into our systems. In

RE: Oracle World anyone?

All, I having taken on co-ordinating the Oracle-l listers get-together at OOW this year (Sep 7-11). So far, I have Jonathan Gennick, Matt Adams, Brian McGraw, Gerardo Molina and self. If any of you are considering a visit to the Bay area at that time - OOW or otherwise - you are welcome to

RE: Oracle World anyone?

I will be there too and looking forward to seeing everyone again. -Ari Ari Kaplan CEO, Expand Beyond www.XB.com Worldwide Leader in Mobile Software for IT Management Maximize Performance and Productivity Beyond the Desktop e| [EMAIL

RE: convert number to word ???

-Original Message- AK Sent: Friday, August 22, 2003 3:09 PM To: Multiple recipients of list ORACLE-L some where I got this create or replace function spell_number( p_number in number ) return varchar2 . . . That is the same routine i was directed to a few months back when I asked

Re: convert number to word ???

This trick is rather limited, as it runs out of steam at amounts somewhat greater than my salary. Best go to asktom.oracle.com for this, I recall seeing a rather good one there that had much higher limits. Jared Shannon St. Dennis [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/22/2003

RE: OT:UNIX: Anyway to run this in the background and return to ca

Here's a rather standard way of doing a fork in Perl. Also a nice little daemon. Works very well for Oracle utilities. Jared package Daemon; use strict; use Carp; use POSIX; sub daemon { my($tries, $pid, $sess_id); { if ($pid = fork) { exit 0 } # exit parent if (defined($pid

Recover 8.1.7 DB with _allow_resetlogs_corruption

8.1.7.0 on HP-UX. Another DBA (really, it wasn't me) forgot which server he was on and deleted the RBS tablespace datafile and all the archived redo logs - on different mount points - of our Production Financials database. No time for the whys of that story or why we don't mirror our archived

9iR2, grant select on a column (without using views) using RLS

list, i'm ikn the process of designing security for a highly sensitive schema for a bank, plan: have multiple oracle users, and use roles, and grant minimum required privs, all the user/role/privs management coded in the application (with in turn would create the db role and user etc)

Replication options Was: SharePlex info

Hi there In the past few weeks, there have been lots of discussion about HA, data replication and using Shareplex, dataguard, Streams, logical physical standby. As most of you have found out each has it own pros and cons. You also need two sets of Database licences and Shareplex licences. Then