Re: Unix Client Install

Hi Charlie, Isn't that with 8i and up only? Upgrades should be fine anyway as you would normally install in different home anyway. If I remember correctly only patches go wrong. Jack

RE: PERL PROGRAMMING

Hi Naren, This URL could be of some help to you. http://www.cs.cmu.edu/htbin/perl-man Regds, Uma -Original Message- Sent: Thursday, August 09, 2001 1:25 AM To: Multiple recipients of list ORACLE-L Hi gurus, We have Lot of PERL scripts. (Previous DBA). I am newby to perl . please s

RE: closing DB on NT with a scheduled BATCH FILE

Jared, Just out of curiosity I am asking ( May be I am missing something) How does it matter whether the command file is on C drive or D/E (other) drives? Some other things I would suggest is 1. Generate a logfile for every command file (including one in schedular)

RE: O/S copies of datafiles

Hi, What is the size of the database?If it is less than 4 or 5 GB better go for exp/imp. There are various factors, first of all can u afford to shutdown the prod instance if so how long? yes it is possible to copy the datafiles at OS level and up the DB on test machine. Regds, Uma -Origi

RE: Unix Client Install

But it is stored, by default, under the oracle account's home directory (together with the OUI and jre). I haven't tried it, but maybe you could copy those as well? I would guess that the paths to all of these bits would have to be the same on both machines. YMMV David Lord -Original Messa

RE: PERL PROGRAMMING

Hoe about www.perl.com http://www.perl.com/pub/q/documentation Rajesh -Original Message- Sent: Thursday, August 09, 2001 1:25 AM To: Multiple recipients of list ORACLE-L Hi gurus, We have Lot of PERL scripts. (Previous DBA). I am newby to perl . please suggest sites , to start. TIA

data migration from access to oracle.

Hi Guru's, Can anybody tell me how to convert access data to oracle using ODBC (DSN). I am able to do this but after migration I got all table & cloumn names in small case. How to get data converted in Capital. Thanks, Prashant S. Bhangale Sr. Support Executive, Rolta India Ltd. -- Ple

table lock problem?

Hi all, I had a developer come to me yesterday and tell me his session had hung, and sure enough it had, he was executing an INSERT into a table with 5 columns. Oracle was just sitting there, but all the other sessions logged into the database were fine. I got the SQL out of the SQL Area and ran

(Fwd) trojan cleaner utilities [windows client]

--- Forwarded message follows --- ... |>How good is MooSoft's The Cleaner recommended on Earthlink's site? | If I were only going to have one Anti-Trojan then it would be | BOClean -- combined with a good firewall like Norton, Tiny PF or | ZoneAlarm: http://www.nsclean.com/boclean.html

Re: closing DB on NT with a scheduled BATCH FILE

1. Create Batch file startdb.bat containts of startdb.bat --- SVRMGRL @c:\yourdirectory\startup.sql 2. create startup.sql containts of startup.sql connect internal/***; startup exclusive open; 3. Create Batch file stopdb.bat containts of stopdb.bat

OT (Fwd) Re: IE v5.5 cleaner???

(follow up to the windows security & virus thread) (from a former intel/microsoft employee I know) --- Forwarded message follows --- ... > At 22:00 08-08-01 -0700, Eric D. Pierce wrote: > >Did someone post a reference to a cleaner utility for IE v5.5?? ... [response:] > ... wasted spa

RE: SGA info.

Hermanto which version of oracle u r running?Just see following output SVRMGR> connect internal; Connected. SVRMGR> select sum(value) from v$sga; SUM(VALUE) -- 1033101472 1 row selected. SVRMGR> select sum(bytes) from v$sgastat; SUM(BYTES) -- 1033044248 1 row selected. SVRMGR> show

Re: index status

In what view do you see that information?. - Mensaje original - De: "orclbabu" <[EMAIL PROTECTED]> Fecha: Miércoles, Agosto 8, 2001 7:09 pm Asunto: index status > All > > What does index status = ' > I have a bunch of Indexes that have a index_status of > Babu > -- > Please see the of

RE: Redo Generation - Excessive ?

NOTE - SQL Run AFTER Completion of Batch Processing Run BUT Before the Bouncing of Database :- SQL> column value format 999,999,990 SQL> select a.name,b.value 2 from v$statname a,v$sysstat b 3 where a.statistic# = b.statistic# 4 and a.name like '%redo%' 5 / NAME VALUE --

RE: closing DB on NT with a scheduled BATCH FILE

or use oradim... oradimxx.exe -shutdown -sid -usrpwd -shuttype inst -shutmode i oradimxx.exe -startup -sid -usrpwd -starttype inst -pfile .ora> -Original Message- Sent: Thursday, August 09, 2001 12:45 PM To: Multiple recipients of list ORACLE-L 1. Create Batch file startdb.bat cont

RE: Unix Client Install - OraInventory

Actually, on my original install, it went one level up from ORACLE_HOME - e.g, ORACLE_HOME was /dsk001/app/oracle/product/8.1.7; the OraInventory,oui,jre went into /dsk001/app/oracle/product - one level up. Since that's where I tarred/untarred to on the new machine, I should have the installer

Extent's datafile.

DBAs I manually allocated extents of a table to different datafiles. Which performance views will give information relating extents and datafiles? Cheers Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Servi

Recall: Extent's datafile.

Raj Gopalan would like to recall the message, "Extent's datafile.". -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Interne

V$LOGFILE

Hi listers, Issuing a select * from v$logfile I found that the status of several of redologs is STALE. What does this mean? How can I solve it? Thanks in advance! Saludos, Veronica Levin Enriquez Administrador AIX Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://w

Copying table with LONG column

Does someone know how to copy a table with a long column? Export/Import works, but I like to do it with SQL. TIA Volker Schön E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker INET: [EMAIL PROTECTED]

RE: V$LOGFILE

Title: RE: V$LOGFILE Hi Veronica, Did you recently create new redolog groups?  This means the logs have not been used yet.  Force a couple of log switches and you will see their status change. HTH Lisa Koivu Cognos Admin/Developer/Designer/Stuff/Etc. and DBA Ft. Lauderdale, FL, USA

OT:I was thrown out of the list

Hi,    I did not receive a mail for two days, I started smelling rat and sent a test mail to the list. I was told I am not a member. Is it some revamping happening or I was thrown out because did people start receiving viruses from my id ??? list administrator please help jared bruce ple

RE: data migration from access to oracle.

You really shouldn't have done that. You will need to drop the tables and ensure you enclose the table names is double quotes. drop table "Foo"; The best way to do this is create the tables manually in Oracle with the correct Oracle data types. A bit tedious but you will get the best results t

OT: List slow today?

Other than during IOUG-A, I haven't seen this few messages.  Is my mail server eating messages or is it just a slow day?   Stephen

RE: List slow today?

Stephen,   I am seeing the same problem. I went to the fatcity site (http://www.fatcity.com/ListGuru/login.php) to see what was being posted, and quite a few messages have been sent to the list. But very few have made it to my machine. Things have started to pick up a tad in the last hour or

Re: Fwd: RE: RAID or NOT to RAID?

Paul, and that RH is not certified for 9i last i checked, :( although that doesnt stop some of us :) joe Paul Drake wrote: > > Hi all. > I've been disconnected for awhile - found myself out in Nebraska. > Installing 81715/Win2000 on a new Dell PowerEdge 2500. > Only had 6 drives on 1 IO channel

Re: Recall: Extent's datafile.

message has been successfully recalled.     >>> [EMAIL PROTECTED] 08/09/01 12:44PM >>>Raj Gopalan would like to recall the message, "Extent's  datafile.".-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Raj Gopalan  INET: [EMAIL PROTECTED]Fat City Network Services   

SOLVED: Copying table with LONG column (using copy getting ORA-01

Works for me: set buffer 10 use the sqplus on dos..ie. sqlplus.exe Thanks to Ashish Volker Schön E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Schoen Volker Gesendet: Donnerstag, 9. August 2001 12:50 An: LazyDBA.com Discussion Betreff:

RE: Copying table with LONG column

Title: RE: Copying table with LONG column Use the copy command.  That's one way. Lisa Koivu Ft. Lauderdale, FL, USA -Original Message- From:   Schoen Volker [SMTP:[EMAIL PROTECTED]] Sent:   Thursday, August 09, 2001 12:45 PM To: Multiple recipients of list ORACLE-L Subject:   

RE: Optimizer Mode......how to choose the right one?

Increase the "sort_area_size" parameter in the init.ora file to have more memory to play with. It is much quickere as it uses RAM, rather than a hard disk, but then again, your server might not have enough RAM to spare. -Original Message- Sent: Tuesday, August 07, 2001 1:43 PM To: Multi

RE: Extent's datafile.

select de.segment_name,de.bytes,ddf.file_name from dba_extents de, dba_data_files ddf where de.file_id=ddf.file_id and segment_name='MYTABLE' -Original Message- Sent: Thursday, August 09, 2001 12:45 PM To: Multiple recipients of list ORACLE-L DBAs I manually allocated extents of a tab

Re: OT:I was thrown out of the list

it was cozur anoviceOracle Certifiable DBBS   joe>>> [EMAIL PROTECTED] 08/09/01 12:44PM >>> Hi,    I did not receive a mail for two days, I started smelling rat and sent a test mail to the list. I was told I am not a member. Is it some revamping happening or I was thrown out because did peo

Re: OT:I was thrown out of the list

I got a an e-mail announcing I was now a member of the "BOUNCED-L LIST". I sort of figured somebody was playing games (didn't like my questions/answers/comments?) and resubscribed (you lucky folks). David A. Barbour Oracle DBA, OCP AISD 512-414-1002

RE: O/S copies of datafiles

normal shutdown! -Original Message- Sent: Thursday, August 09, 2001 12:21 PM To: Multiple recipients of list ORACLE-L Yes, what this is doing is the same as restoring from a cold backup. If the machines are the same, you can just shutdown Oracle and copy data files, control files, redo

Oracle 8.1.7 client install on Win2K.

List, I have just got my hands on a shiny new P4 1.3 gig box with Win2K pro. I installed the Java 1.3.0_01 JRE, and tried to start up the 8.1.7 for NT Oracle install to install the client software (this was downloaded from technet BTW). The splash screen runs - but when going for the install (the

RE: List slow today?

Yeah I noticed that too, I thought my mail server was dead or something!! KK -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Stephen AndertSent: Thursday, August 09, 2001 3:16 PMTo: Multiple recipients of list ORACLE-LSubject: OT: List slow t

Re: PERL PROGRAMMING

Naren, The "PERL cookbook" is a good book to refer to. raja - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, August 09, 2001 6:50 PM > Hoe about www.perl.com > > http://www.perl.com/pub/q/documentation > > Rajesh > -Original Mes

RE: table lock problem?

did you select * from v$lock...for his sid? -Original Message- Sent: Thursday, August 09, 2001 12:45 PM To: Multiple recipients of list ORACLE-L Hi all, I had a developer come to me yesterday and tell me his session had hung, and sure enough it had, he was executing an INSERT into a ta

RE: Unix Client Install

One thing to remember to do, if you take this route is to make sure that you relink the Oracle binary. If you do not, you can get some interesting library problems. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 09, 2001 3:50 AM > To:

RE: OT:I was thrown out of the list

Oh man that was low! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent: Thursday, August 09, 2001 4:16 PMTo: Multiple recipients of list ORACLE-LSubject: Re: OT:I was thrown out of the list it was cozur anoviceOracle Cer

RE: O/S copies of datafiles

How about giving it a try? I'm a DBA, not a soothsayer and to give a definite answer, I'd need minute details like OS on each box, with version, what are you copying and how are you copying it. As of now, I can tell you only one thing: Idis redibis nunquam in bello peribis (commas are missing on p

RE: List slow today?

I think all the people with Oracle problems took the day off. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Stephen Andert [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 09, 2001 4:16 PM To: Multiple recipie

OTRE: age discrimination in IT industry

and/or if you are an idiot, slow learner, or have low iq. I qualify for all of the above, so I barely made it through the index, even powered by bran. :) regards, ep principal data janitor www.BSALERT.org (bombastic, serendipitous alliance of legubrious, enigmatic research technicians) > ---

Re: Optimizer Mode......how to choose the right one?

Title: Message Does the order of tables also make a difference with a RULE hint?   Steven HaasOpus Consultants, LLC - Original Message - From: Christopher Spence To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 08, 2001 12:15 PM Subject: RE: Opt

stored procedure errors

Hi Gurus, I am creating a stored procedure using the below code. The procedure gets created successfully. But while executing the procedure I am getting below errors: ERROR at line 1: ORA-00907: missing right parenthesis ORA-06512: at "SCOTT.CREATE_RATEDOUTPUT", line 5 ORA-06512: at line 1 CRE

RE: O/S copies of datafiles

Just be sure that if you copy your listener.ora file from the first box you change the hostname! Otherwise you'll risk shutting down the listener on the original box. -Original Message- Sent: Thursday, August 09, 2001 12:21 PM To: Multiple recipients of list ORACLE-L Yes, what this is

Re: closing DB on NT with a scheduled BATCH FILE

Does the owner of the batch job have "Log on as a batch job" permissions? This is generally necessary for scheduled batch jobs on NT/2K. hth Chuck - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, August 08, 2001 8:45 PM > > > Because

Re: Some doubts)

break out the concepts manual and start reading.   joe   >>> [EMAIL PROTECTED] 08/08/01 10:25PM >>>Hello gurus,I need some help here. I am trying to get some understanding of the following:- (Pardon my stupidity, if you can call this)1. What are chained rows?2. What is index/table partitioni

re: Designer 2000 install on Linux

If you saw my other post, it looks like designer is only on NT/Win. If you can dual boot your system, you should be able to get both the database and designer working on NT or Win2000. http://www.odtug.com has an email list (free, even to non-members) for designer. also for JAVA, develop, etc. A

RE: List slow today?

Possibly related?    "UUNET is experiencing a major outage in the North East part of the country.  UUNET reports there is another major fiber cut in Baltimore."    -Original Message-From: Larry Elkins [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 09, 2001 4:03 PMTo: Multiple rec

Oracle8i eBoot Camp

Does anyone have any experience with the Oracle8i eBoot Camp put on by OraKnowledge? Thanks, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, C

Oracle 8.1.7 client install on Win2K.

List, I have just got my hands on a shiny new P4 1.3 gig box with Win2K pro. I installed the Java 1.3.0_01 JRE, and tried to start up the 8.1.7 for NT Oracle install to install the client software (this was downloaded from technet BTW). The splash screen runs - but when going for the install (the

RE: Fwd: RE: RAID or NOT to RAID?

Now that's a post :) "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton S

RE: Optimizer Mode......how to choose the right one?

Title: Message Only if you hit a tie with the rank of predicates.   "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence  OCP  MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-57

OT:I was thrown out of the list

LOL!!   Oh goshwhat happened to the Good Old Days, when people had names?   I mean, should I call myself  "Dusty Old Sack of Shit DBA" ?       thanks for a laugh Joe. -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 09, 2001 4:16 PMTo:

OT Dorothy Parker :)

I would like to apologise to anyone that was offended by the topic. I would also would like to apologise to anyone that was offended by the above apology. I would also like to apologise to anyone that might have been offended by the implication that males can't be wh*res. I would also would lik

Re: Fwd: RE: RAID or NOT to RAID?

Thanks for the enlightenment. What is the performance difference, from an Oracle database standpoint, between RAID 0+1 and RAID 1+0? Unfortunately one cannot change the configuration on Government Furnished Equipment without a bit of a hassle. In a more perfect world, of course, but in real lif

Re: OT Dorothy Parker :)

Scott Shafer wrote: > Eric, > > > If anyone is offended that easily, they need to get a helmet, because > their life sucks - and will continue to suck until they butch up a bit. > Political Correctness allows the weak-minded to exert control over a > society that they otherwise could not handle.

RE: List slow today?

Let's face it. The only decent operating system was TRS-DOS. :o Just doing my part! --Michael -Original Message- Sent: Thursday, August 09, 2001 4:22 PM To: Multiple recipients of list ORACLE-L how about this:   unix sucks.   that ought to generate a little bit of traffic.   hth.   P

FW: karma - DBD module

Listers, Have any of you got Karma up and running on HP-UX 11.0 against 8.1.7.x EE? I have sent an email back asking my friend for more details on the problems he is seeing, but it would be helpful in the meantime to at least know if others have been successful. See his question below. Regards,

REVISIT: FK Constraint naming.

Hi List, A few weeks ago somebody sent a message to the list about the naming of FK constraints to something other than the system generated names. I have come across a pretty nifty script that will do this for you automatically - check it out: http://searchdatabase.techtarget.com/tip/0,289483,s

REVISIT: FK Constraint naming.

Hi List, A few weeks ago somebody sent a message to the list about the naming of FK constraints to something other than the system generated names. I have come across a pretty nifty script that will do this for you automatically - check it out: http://searchdatabase.techtarget.com/tip/0,289483,s

OT: Klipsh

Title: OT: Klipsh OMG the Klipsh computer setup is killer!  Just replaced my JBL Pro-Logic setup with it, and this was $100 cheaper than when I bought my JBL 3 years ago.  Highly worth it for anyone gaming/music. Just figured I would mention it ;) "Do not criticize someone until you walked

RE: OT:I was thrown out of the list

lighten up.   joe   >>> John Lewis <[EMAIL PROTECTED]> 08/09/01 04:16PM >>> Was this really necessary? -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 09, 2001 1:16 PMTo: Multiple recipients of list ORACLE-LSubject: Re: OT:I was thrown out

RE: PERL PROGRAMMING

Highly recommend O'Reilly's Perl Library, You can get the entire thing on a single cd for around $65. I have all the books, even though I don't use Perl often. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their

Re: Fwd: RE: RAID or NOT to RAID?

h Paaauuul! Can you give a quick explication of how many drives/mount-points are advised, in terms of recovery issues, for the OS (NT/Win2k), Oracle software, database files, etc.? (is there something about this in Sean O'Neill's NT standards document?) thanks, ep

ADMIN: List status, bounces, archives

Yes, the lists were down virtually all night (Pacific time). I had been doing some work on the server around midnight and maybe an hour after I called it quits, the server locked up. Sorry for the span of silence and the ensuing rush of E-mail that is *still* being sent out. All should be well

Password_verify_function in 8.1.6 doesn't allow ALTER USER IDENTI

I found plenty of angry people with my problem on Metalink forums, but no one that got an answer from Oracle. We still have a number of people connecting to Oracle via Powerbuilder applications. We want to use a password_verify_function but we'll be upgrading 8.1.6 soon, and the ALTER USER xxx I

RE: completely off-topic question...

Main things I noticed were: jumpers became sweaters u was removed from words like colour Philosopher's Stone became the Sorcerer's Stone Of course I only read the first two books... -Original Message- Sent: Thursday, August 09, 2001 2:50 AM To: Multiple recipients of list ORACLE-L Ho

RE: I was thrown out of the list

it works 4 me cozweerall Oracle Certifiable DOSSDBAs   --Michael-Original Message-From: Mohan, Ross [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 09, 2001 4:41 PMTo: Multiple recipients of list ORACLE-LSubject: OT:I was thrown out of the list LOL!!   Oh goshwhat happe

RE: backup, recovery web site ?

> I saw a backup & recovery web site a while ago. That > site devotes to B & R and it claims it has the most > knowledge on B&R topic. I cannot find it anymore. > www.backupcentral.com John. This message is intended only for the use of the person(s) (the "intended recipient (s)") to whom

Re: V$LOGFILE

Use following couple of times till your stale staus is changed alter system switch logfile / MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Thu, 09 Aug 2001 10:41:06 -0800 Hi listers, Issuing a select * from v$logfile I found t

OT ADMIN: List status, bounces, archives

Bruce, could you bounce me for a day, for...oh, say, foul language, outdated information, unsuitably patriarchal grammar...something...anything. But...then againdon't. I don't want to miss any of this! ;-) Ross -Original Message- Sent: Thursday, August 09, 2001 5:46 PM To: Multi

RE: Unix Client Install

Hmm, could one do this onto a different version of UNIX and just relink the software? -Original Message- Sent: Wednesday, August 08, 2001 10:01 PM To: Multiple recipients of list ORACLE-L well, um, that's how I will install oracle (same version obviously) on second and third machines.

RE: stored procedure errors

What is the extra comma doing before the CONSTRAINT RatedCDROut_PK ?? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD

Re: OT Dorothy Parker :)

Eric, If anyone is offended that easily, they need to get a helmet, because their life sucks - and will continue to suck until they butch up a bit. Political Correctness allows the weak-minded to exert control over a society that they otherwise could not handle... Scott Shafer San Antonio, TX

RE: OT Dorothy Parker :)

ROFL!!! G*damn, the best laugh all day! -Original Message- Sent: Thursday, August 09, 2001 4:15 PM To: Multiple recipients of list ORACLE-L I would like to apologise to anyone that was offended by the topic. I would also would like to apologise to anyone that was offended by the above

Re[2]: OT Dorothy Parker :)

OY VAY, I must of missed a good one!! Thank God! Dick Goulet Thought for the day: Never be afraid to try something new. Remember that a lone amateur built the Ark. A large group of professionals built the Titanic. Reply Separator Author: "Thater; Willi

FW: karma

Listers, I'm relaying something from a friend. This is a follow-up to an earlier email where he had problems with DBD. He got that squared away and is now seeing the following when starting Karma. Anyone have ideas? Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 Larry, I found it in

RE: OT:I was thrown out of the list

No, but as Garrison Keillor said recently,   Why would any comedian give up such a laugh? It would be like not milking a cow. You lose the milk and it irritates the cow. -Original Message-From: John Lewis [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 09, 2001 5:21 PMTo:

RE: stored procedure errors

Title: RE: stored procedure errors Ranganath, Your dynamic statement is missing a paren somewhere, that's why it compiles without error.  Dig through your statement, you'll find where the paren is missing (it'll be within your quotes HTH Lisa Koivu Headache Queen and DBA Ft. Lauderdale, FL

Is there any place(except AUDIT LOG) to see the activities

Greetings, I like to know if there is any view or place in Oracle where we can see who has dropped an oracle user or did some other activities in the datbase. My understanding is that such auditing can be done by turning on the AUDITING. But our auditing is not on and we need to find out who h

RE: I was thrown out of the list

LOLhhehehehehe, that was good work.  well I am off, gonna go melt onto the Garden State Parkway oven!!! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: Thursday, August 09, 2001 4:41 PMTo: Multiple recipients of list ORA

RE: List slow today?

Maybe that last upgrade of Oracle fixed all the problems and we can dispand this group, DBA's are no longer needed :) We can concentrate on NT sucks :) Arich Henneman Not Oracle Certified >>> [EMAIL PROTECTED] 08/09/01 12:51PM >>> I think all the people with Oracle problems took the day off. :

RE: OT:I was thrown out of the list

Was this really necessary? -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 09, 2001 1:16 PMTo: Multiple recipients of list ORACLE-LSubject: Re: OT:I was thrown out of the list it was cozur anoviceOracle Certifiable DBBS   joe>

Oracle DBA Needed in Cleveland, Ohio..

This Biotechnology Client in the Cleveland Ohio area, needs an Oracle DBA to join its' I.T. staff. * Candidates local to the Greater Cleveland area only will be considered. This is a full time staff position so no sub-contractors or third parties please. Please do not call or send a resume if y

RE: Fwd: RE: RAID or NOT to RAID?

There is significant differences due to the fact of 1+0 you have 2 raid 1 (which generally have -15% hit in performance on writes but increased throughput on reads). Raid 0+1 you have a single raid 1 stripe, so your write performance suffers 50% less than that of Raid 1+0. Which I would say (ne

Re: import fails with referentail integrity constraint violation

you can rerun import with ignore=n. On Wed, 8 Aug 2001, Harvinder Singh wrote: > Hi, > > In our application one of our table name t_acc_usage refer to table_name > t_usage > now the problem is whenever i try to do full database import from dump the > import > always try to import t_ac

RE: RE: RAID or NOT to RAID?

Hi DBA's: I've been researching this issue as well. All the expert advice seems to point to using RAID 1+0 for OLTP implementations and RAID 5 for DSS (Read-Only) implementations. I also found out that you can use raw partitions on NT as well. Does anyone have experience with setting up raw par

RE: List slow today?

no ... they were just laid off Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message- Sent: Thursday, August 09, 2001

Re: PERL PROGRAMMING

I have found www.perlmonks.com to be a very helpful site. They will help you with any questions you have. "SAMS Teach Yourself Perl in 24 hours" (ISBN 0-672-31773-7)is a painless way to learn perl. Have fun with perl. Kevin Hedger >Hi gurus, > >We have Lot of PERL scripts. (Previous DBA).

RE: CODE to trap an update statement in PL*SQL that updates 0

Todd, Check out the PL/SQL guide under "Using Cursor Attributes". http://www.oradoc.com/ora817/appdev.817/a77069/05_ora.htm#42685 >-Original Message- >From: Thompson, Todd [mailto:[EMAIL PROTECTED]] >Sent: Thursday, August 09, 2001 3:56 PM >To: Multiple recipients of list ORACLE-L >Sub

Re: OT: Klipsh

OK, what's a Klipsh? --Scott > Christopher Spence wrote: > > OMG the Klipsh computer setup is killer! Just replaced my JBL > Pro-Logic setup with it, and this was $100 cheaper than when I bought > my JBL 3 years ago. Highly worth it for anyone gaming/music. > > Just figured I would mentio

Re: Whatever became of "ORAC"

Here's the latest version 1.2. It looks like it hasn't been updated since May 2000, but newer than the tux.org site. http://sourceforge.net/projects/perldbadmin/ -Brian -- Brian Haas Oracle DBA [EMAIL PROTECTED] www.musiciansfriend.com On Mon, 6 Aug 2001, Orr, Steve wrote: >Date: Mon, 06 Au

Re: Fwd: RE: RAID or NOT to RAID?

(Please critique the following) NT/Win2k RAID background: http://www.ultratech-llc.com/KB/?File=RAID.TXT (linked from http://www.ultratech-llc.com/KB/?File=!Contents.TXT ) ---excerpt--- ... * DATABASE TYPE SERVER ... assuming 6-10 drives total {Low Space Requirements or Smal

RE: CODE to trap an update statement in PL*SQL that updates 0

I just reviewed the link I sent you and I might not have provided enough information. That section of the documents discusses explicit cursors but the is an implicit cursor called SQL which you can use to access the attributes of the last DML statement you ran. SQL> create table test (x number

Re: OT:I was thrown out of the list

How about "Rusty Old..."? Then you could keep "ROSS"-DBA for short. Scott Shafer San Antonio, TX LOL!! Oh goshwhat happened to the Good Old Days, when people had names? I mean, should I call myself "Dusty Old Sack of Shit DBA" ? ___

autoextent??

Hi Friends Which data dictionary view will tell, Whether my tablespace datafiles are AUTOEXENTD OR NOT?? Thanks Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official

RE: OT Dorothy Parker :)

We did that about 8 months ago. 'They' promised my load would not increase. Hah! I'm looking for another position now. Problem is, it's a tight market. -Original Message- Sent: Thursday, August 09, 2001 3:36 PM To: Multiple recipients of list ORACLE-L Congratulations on your survival

RE: List slow today?

if Unix Sucks then what must Windows do .. And besides .. If Unix Sucks ... it sucks The Best ... None of this half-assed suckedness. (a word ??) -Original Message- Sent: Thursday, August 09, 2001 3:51 PM To: Multiple recipients of list ORACLE-L Le

  1   2   >