RE: SYSDBA privilege with ORAPWD utility

Tom , I set REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE, gave the same name to the pw file as suggested by you (though it was not mentioned anyewhere) and tried; but still it's not working. I can't figure out what can be the problem. Pls help. Chetan > -- > From: Mercadante, Thomas

Spooling data containing Umlaut character (DB characterset UTF8)

Hi, We are trying to extract the data from the oracle database 8.1.7. which contains special characters like umlaut. The Characterset of Oracle db is UTF8 and the Character set at Client side is AMERICAN_AMERICA.UTF8. While we spool the data from the Oracle db an extra space (byte) is added i

RE: SQL help

If you don't want to apply criteria to the first part to see if data from the second part is returned, you can avoid it by using an analytic function. Ok, the examples below might look a little complex, but basically you have your UNION ALL in the inner most in-line view. In the in-line view enclo

Optimizing Oracle by Jonathan Lewis coming to Ann Arbor, MI on Nov.

Announcing: Optimizing Oracle -- Performance by Design, by Jonathan Lewis Jonathan Lewis is planning to hold his Optimizing Oracle seminar in the Ann Arbor, MI area. This is a three-day, intensive seminar aimed at DBAs and senior developers and designers. Jonathan Lewis,

Re: Oracle FailOver Solutions

Gabriel, I have a paper on this topic on my website (http://www.EvDBT.com/papers.htm) entitled "Choosing Among High-Availability Architectures in Oracle", which was presented at IOUG-A "Live 2001" and elsewhere. It was slightly out-dated with Oracle8i and is thus pathetically out-dated with feat

Re: Misinformation Ranting

Bad as your experience is, be grateful you weren't confronted with this beauty in the one-world of JD Edwards: >> At they're having wonderful problems. But what >> really started this is a detail from their recommendations that you >> missed last year: in there they suggest that you cou

Re: How to convert SQLSERVER DBS to ORACLE DBs

At 09:03 PM 9/12/2002, you wrote: >Hi >I want to convert SQLSERVER DBs to ORACLE DBs? HOw to convert DBs it? >To import objects I have created one scripts but how to import data into >ORACLE DBs. There's a utility that Oracle puts out called the Oracle Migration Toolkit which does this more or

How to convert SQLSERVER DBS to ORACLE DBs

Hi I want to convert SQLSERVER DBs to ORACLE DBs? HOw to convert DBs it? To import objects I have created one scripts but how to import data into ORACLE DBs. Thx -Seema _ MSN Photos is the easiest way to share and print your photo

RE: Another Character Set Problem

Scott, 1) I have to agree with Oracle's statement that you need to have a UTF8 database to handle Chinese and Japanese characters. These characters require multi-byte encoding to be stored and therefore a UTF8 database is the way to go. 2) I am not sure "where" the Chinese and Japanese characte

RE: ORA-04031

Also check out Metalink note 146599.1 which is on diagnosing ora-4031 errors. This has helped me. Also you can consider adding an event in your init.ora file like "4031 trace name errorstack level 3" This will dump an errorstack when the 4031 error occurs - this can be interpreted by Oracle su

RE: Recover an unrecoverable database

If I recall the original problem, you have a backup of the datafiles, and redologs, but no controlfiles. In that case, just specify all the datafiles and redologs (that are in the backup) in the "create controlfile..." statement. The order does not matter, nor is the list required to be comp

RE: Does analyze table lock the tables

> Prior to Oracle ver 9 , yes.It is an exclusive lock ...Oracle > 9 has ONLINE > option which allows DML while analyzing table... Mohammed, Have to differ with you on this - ANALYZE may place a DDL lock, but not a DML lock. This would have otherwise severely restricted concurrency. Should be e

Re: oracle sysdate problem ??

Leslie, Hint #1: Try 'mm/dd/yy hh:mi:ss am' for your format string. Hint #2: 'mm' is month, 'mi' is minutes. Hint #3: As September is the 9th month, I think your output makes sense. ;-) (I remember making this mistake, oh, probably more than 10 years ago, on version 6. Some things never chan

RE: ORA-04031

X$KSMLRU is the free list chunks. On Thu, 2002-09-12 at 17:03, Jesse, Rich wrote: > As one who has been there, I can sympathize. I had a TAR open for months > going back and forth with Oracle Support. The entire problem boiled down to > the fact that Oracle Corporation does not have a supported

Re: oracle sysdate problem ??

Your format is asking for the month instead of the minutes > > Hi all, > > I did a select sysdate from dual, and got 04:09:39 pm, > but my machine system time is 4:47pm, which is right. > > SQL> select to_char(sysdate,'mm/dd/yy hh:mm:ss am') ^^ shoul

oracle sysdate problem ??

Hi all, I did a select sysdate from dual, and got 04:09:39 pm, but my machine system time is 4:47pm, which is right. SQL> select to_char(sysdate,'mm/dd/yy hh:mm:ss am') from dual; TO_CHAR(SYSDATE,'MM/ 09/12/02 04:09:39 pm How did Oracle get the time? What needs to be set

RE: SQL help

Title: RE: SQL help Rick,     Is this in SQL*Plus? If so, use the COLUMN command to populate the column headings with the information you want. You can populate a variable with SYSDATE and use that in the column heading.   Dan -Original Message-From: Jamadagni, Rajendra [mailto:[

Fwd: ORA 4021 when .fmb - it's a bug

For the archives: From another list, found out there is a known bug: It's a known problem with Forms 6 vs Oracle9i. See Oracle MetaLink bug number 2052790. It hasn't been updated since February but it references bug 2166890 which I cannot access. DDL COMMAND HANGS IN SQL*PLUS IF THE TABLE IS U

RE: recovery question - I know I am missing something

I ended up giving it one of the log files but they all said stale so it took me a couple of tries. Thanks! Kathy -Original Message- Sent: Thursday, September 12, 2002 11:38 AM To: Multiple recipients of list ORACLE-L Database 8.1.7 Cloning a database that was brought down using sh

RE: SQL help

Title: RE: SQL help Not tested but select sysdate, 'test1','test2' from dual where exists ( your union clause) union your_union_clause Raj __ Rajendra Jamadagni      MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any

RE: Satisfied customer

> > Sorry about the lack of photo's. :) > > There's already some errata. sigh... Maybe you can upload to your website ;-> Enquiring minds want to know. bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Networ

Re:RE: * Oracle 11i DBA position in Wisconsin..

OY, sounds like FUN, sign me up!! EY Yup *-) Dick Goulet Reply Separator Author: "Jesse; Rich" <[EMAIL PROTECTED]> Date: 9/12/2002 12:58 PM Why yes I can: "M-cow" Actually, the Dells area (Baraboo is a few miles south) is pretty nice if yo

SQL help

Hi DBAs, I have a query something like SELECT sysdate,'txt1','txt2' FROM dual UNION SELECT date1,txtfield1,txtfield2 FROM t1,t2,...,tn WHERE ... ; The output would be one header record from the first select then the data from the second select. If there are no records selected in second sel

Re: OT - LDAP

Hi, One good book (red) is http://publib-b.boulder.ibm.com/Redbooks.nsf/9445fa5b416f6e32852569ae006bb65f/912ecdc5d22172a68625662800797758?OpenDocument&Highlight=0,ldap happy readings :) Regards Henrik --- Stephane Faroult <[EMAIL PROTECTED]> wrote: > Andrey Bronfin wrote: > > > > Dea

RE: Shutdown and startup processes

Thanks Stephane! As you alluded to, ideally, I want it to work automatically even when I do manual shutdown/startup via svrmgrl etc. I will explore your suggestion of triggers/external function etc. Willie -Original Message- Sent: Thursday, September 12, 2002 2:44 PM To: Multiple recip

simple replication script

Anyone got a script or scripts for setting up VERY SIMPLE replication(one master site, one snapshot site) in 8.1.7? Including those pesky dblinks? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services--

RE: * Oracle 11i DBA position in Wisconsin..

Why yes I can: "M-cow" Actually, the Dells area (Baraboo is a few miles south) is pretty nice if you're an outdoorsy-type. Or if you just like to live in or near a town that's one big waterpark (including the largest waterpark in the USA). It's about 40 minutes from Madison and 5 minute

RE: RE: Decode

Dick, But is was a fun tool to program in! It was so string in that it (at the time) was the only tool that could interface with OS files, Oracle, and produce output at the same time. We bought it instead of RPT and RPF. I almost had a heart-attack when Oracle classes showed us those POC and s

RE: Shutdown and startup processes

Thanks Dennis! I may have to do it as you suggested. I was hoping there was a way to automatically shutdown/startup Unix script if I shutdown Oracle via srvmgrl command line prompt. For instance, if I executed 'shutdown immediate', this would invoke command behind the scene to stop the process

RE: recovery question - I know I am missing something

Kathy, > Let me clarify a bit. I cloned the database from coldbackup . > > I opened the database fine, but I goofed up the name. I > shutdown the database, it hung so I > did a shutdown abort and forgot to open it up normally before > I tried to rename the database. > > I don't have any ar

RE: Decode

Well, if we're going to be picky :) select chr(84)||chr(104)||chr(97) ||chr(110)||chr(107)||chr(32) ||chr(71)||chr(111)||chr(100) ||chr(101)||chr(115)||chr(115) ||chr(33) from dual > > Jared, didn't you mean: > > select > chr(84)||ch

RE: ORA-04031

As one who has been there, I can sympathize. I had a TAR open for months going back and forth with Oracle Support. The entire problem boiled down to the fact that Oracle Corporation does not have a supported method ("supported" is the key word) to query the free chunks of the shared pool to dete

Re: problems creating a context index

Make sure you're LISTENER and tnsnames.ora have "PLSExtProc" set-up. I have a separate listener for PLSExtProc: listener.ora LISTENER_PLS = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EX

RE: Rowid

Actually, if a row is migrated it keeps the same ROWID it has before the update. HTH DC - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, September 12, 2002 3:03 PM > Dan, > > I think there is a difference between "migrated" and "moved".

RE: Oracle FailOver Solutions

Hi Dennis, at this moment I dont have users making conections directly to the DB, only the application connects to the DB, so the users access only the application and I'd have to shutdown the app first of all.. I think that something like the first option is what I need.. Gabriel --- DENNIS WI

Re: * Oracle 11i DBA position in Wisconsin..

Can you say moo-cow. This is most likely http://www.foremostfarms.com/aboutus/contacts/contact.asp, and if so, I think they have been trying to fill it for about 9 months. H, wonder why?

RE: recovery question - I know I am missing something

select * from v$logfile. Specify the current logfile. >From: Kathy Duret <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: recovery question - I know I am missing something >Date: Thu, 12 Sep 2002 11:08:33 -0800 > >Let me

Re:RE: Decode

Tom, I regret to say that SQR is still running around. SOD awful piece of crap that should have dies along with RPT and RPF. PeopleSoft makes a lot of use of it & it is a REAL performance boat anchor. Dick Goulet Reply Separator Author: "Mercadante;

Re: OT - LDAP

Andrey Bronfin wrote: > > Dear friends! > I have no idea in LDAP , but have been assigned to find out how much time it > takes to do a LDAP update operation? > Anyone got any clue ? > Thanks a lot in advance vor your help ! > BTW, Can you please also recommend some LDAP intro readings . >

Re: ORA-04031

its 8.1.7.4 >From: "Mark J. Bobak" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: ORA-04031 >Date: Wed, 11 Sep 2002 21:08:18 -0800 > >Um, version? (To at least 4 places, please!) > >On the off change you are on 8.1.7.

RE: recovery question - I know I am missing something

Let me clarify a bit. I cloned the database from coldbackup . I opened the database fine, but I goofed up the name. I shutdown the database, it hung so I did a shutdown abort and forgot to open it up normally before I tried to rename the database. I don't have any archive files created by t

Re: Shutdown and startup processes

Townsend Willie wrote: > > Gurus, > > I need to implement a process to startup/shutdown a PeopleSoft Unix batch > scheduler job whenever the Oracle instance is shutdown or started back up. > Does anyone know of a way to tie this process to an Oracle Instance to get > invoked at shutdown/startup

RE: Rowid

Tom, I completely agree with your point. It is one of those semantic issues that always seems to cause so many problems ('Do what I meant, not what I said'). So, Yechiel, did you mean move as in migrate or move as in recreation of the row? Dan -Original Message- Sent: Thursday, S

RE: ORA-04031

I agree with Mark on this. I had this problem on a 8.1.7.0 and it was solved after the upgrade. (8.1.7.3) If you're already above 8.1.7.3, the problem could be fragmentation. Are you having any contention in the shared pool latch? greetings DC - Original Message - To: Multiple recipien

Re: Index table last update?

"O'Neill, Sean" wrote: > > > From: "Stephane Faroult"<[EMAIL PROTECTED]> > > Date: Wed, 11 Sep 2002 11:24:50 UT > > Subject: RE: Index table last update? > > > >>- Original Message - > >>From: "O'Neill, Sean" <[EMAIL PROTECTED]> > >>Sent: Wed, 11 Sep 2002 03:13:21 > >>Is there a way to de

RE: Shutdown and startup processes

Willie - At our site we have a Unix startup and shutdown script tied into the system startup/shutdown scripts. You could use the same mechanism.   Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 12, 2002 1:13

RE: Decode

Title: RE: Decode Raj,   I know SQR.  Bought it when it was being peddled by Sql Solutions.  Great tool!  Somehow, it never got marketed correctly.  I had heard that at one point, Oracle "almost" bought it, and was going to position it as one of its products.  But that boat has sailed.   Tom

RE: recovery question - I know I am missing something

I think you need the online redo log file that was current when you did shutdown abort. This is provided it was not recycled! Waleed -Original Message- Sent: Thursday, September 12, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Database 8.1.7 Cloning a database that was broug

RE: recovery question - I know I am missing something

What I do and have just done a couple of days ago is copy your latest redo log into the suggested name below '/u07/oracle/testdb/8.1.7/dbs/arch1_1.dbf' and do your recover again. Worked fine for me HTH Lee -Original Message- Sent: 12 September 2002 19:38 To: Multiple recipients of lis

Re:recovery question - I know I am missing something

For some reason it would appear that you don't have the complete set of online redo logs. Dick Goulet Reply Separator Author: Kathy Duret <[EMAIL PROTECTED]> Date: 9/12/2002 10:38 AM Database 8.1.7 Cloning a database that was brought down using shu

Shutdown and startup processes

Gurus, I need to implement a process to startup/shutdown a PeopleSoft Unix batch scheduler job whenever the Oracle instance is shutdown or started back up. Does anyone know of a way to tie this process to an Oracle Instance to get invoked at shutdown/startup time? Willie Townsend Alverno Inform

RE: Decode

Title: RE: Decode Wait till you see some of the SQL that we run ... it is dynamic sql used within SQR (a reporting tool). Compared to that, this is production quality. Raj __ Rajendra Jamadagni      MIS, ESPN Inc. Rajendra dot Jamada

recovery question - I know I am missing something

Database 8.1.7 Cloning a database that was brought down using shutdown abort. I know I have done this before and I can't remember what I had to do to resolve this. STARTUP NOMOUNT CREATE CONTROLFILE SET DATABASE "TEST" RESETLOGS

RE: Rowid

Dan, I think there is a difference between "migrated" and "moved". Migrated in my mind refers to a split row - because an update could not fit in the same block as the record. Moved in my mind means deleted and re-created, or performed because of an "Alter Table {} Move Tablespace" command. To

RE: Oracle FailOver Solutions

Gabriel - Are you just talking about failing the database over to a hot standby database, and the users would have to be notified to log off and log on the standby, or are you thinking about automatically failing their connections over as well? The latter depends on what access methods they use.

RE: Recover an unrecoverable database

Dan - When you say "recreate a control file" are you meaning the CREATE CONTROLFILE statement? If so, then in answer to that specific issue, the order of the datafiles does not matter. I do this regularly to create test databases and I've never worried about making the order the same. I have even

Re: Does analyze table lock the tables

Prior to Oracle ver 9 , yes.It is an exclusive lock ...Oracle 9 has ONLINE option which allows DML while analyzing table... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Thu, 12 Sep 2002 06:33:29 -0800 Hi DBAs, I would like to a

RE: Rowid

Actually, the rowid will not change when a row is migrated. The original rowid is preserved (for indexing purposes) with a pointer to the new row. The rowid referenced by functions will be the original rowid. I performed a test about a year ago that covered this scenario. I found that when you re

Stress Testing Peoplesoft App

Anybody have experience with stress testing software for Peoplesoft? Links, thoughts, comments etc... Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-50

Oracle FailOver Solutions

Hi List, I have to make a presentation to the company's CEO about several strategies to implement a FailOver for an Oracle Server, this is the environment: DB Server: Sun Enterprise 3500 Solaris 5.7 with an A1000 StoreEdge Array (0+1), Oracle 8.0.6 EE App Server: Sun Enterprise 3500 Solaris 5.

RE: Decode

here's a decode that should *NEVER* be put into production! :) -Original Message- Sent: Thursday, September 12, 2002 12:18 PM To: Multiple recipients of list ORACLE-L Beware...nasty sql below select decode((select deptno from dept where upper(loc) = upper('&vloc')), <-- expression

RE: Recover an unrecoverable database

I've tried several approaches to the recovery. So far, no success. I have a feeling that this is a truly unrecoverable db (without having Oracle Field Support use their magic). The main problem (in my mind) is that the current database physical structure (files and sizes) does not match the backu

RE: Does analyze table lock the tables

Rick: I've had problems trying to "slip in" an analyze on an index during production hours. Our on-line users will see timeouts if the analyze is lengthy. I assume analyze table will cause the same problem. I decided to prove my case by analyzing a table and the looking for locks. I didn't see

RE: Decode

Beware...nasty sql below select decode((select deptno from dept where upper(loc) = upper('&vloc')), <-- expression (select deptno from dept where loc = 'NEW YORK'), <-- value1 (select count(*) from emp where deptno = 10), <-- return1 (select deptno from d

Re: Does analyze table lock the tables

Update to posting: Apparently locks preventing DML are only place if using validate structure. Rick Rick_Cale@team

RE: problems creating a context index

Check on MetaLink note: 147362.1; also extproc might have been deleted (see Security Alert 29) inka -Original Message- Sent: Thursday, September 12, 2002 10:33 AM To: Multiple recipients of list ORACLE-L Hello All; I am being plagued with an error I can't get my hands around when I tr

Re: Decode

Good example! ;=) Thanks, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, September 11, 2002 3:38 PM > select decode(new_job_loc,'Vermont','TAKE IT','LEAVE IT') from dual; > > Waleed > > -Original Message- > Sent: Wed

RE: Decode

Jared, didn't you mean: select chr(84)||chr(104)||chr(97) ||chr(110)||chr(107)||chr(32) ||chr(71)||chr(111)||chr(100) ||chr(33) from dual Just being picky... :D Rich Jesse System/Database Administrator [EMAIL PROTECTE

Tools to query DB and present results in a Graphical format

Are there any simple tools to query a database [SQLServer or Oracle] and present the results in a Graphical format --- e.g. the database could contain HelpDesk Call logs and a display could be an Ageing Report or Call Rate. Hemant K Chitale Now using Eudora Email. Try it ! My home page is :

RE: mixed case text

Initcap? What about: abc garage at&t Mcneil and McNeil Sivan Rabinovitz <[EMAIL PROTECTED]>@fatcity.com on 09/12/2002 03:33:18 AM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Do you know initcap

OT - LDAP

Dear friends! I have no idea in LDAP , but have been assigned to find out how much time it takes to do a LDAP update operation? Anyone got any clue ? Thanks a lot in advance vor your help ! BTW, Can you please also recommend some LDAP intro readings . cheers. DBAndrey * 03-9254520 * 05

Re:mixed case text

IMHO, I prefer to use both, mixed case text for reports, etc. and upper case text for searches, etc. What's a few more characters in the db when it keeps everyone happy :) Gene >>> [EMAIL PROTECTED] 09/12/02 10:18AM >>> Steve, From one dinosaur to another, let them have mixed case. Dick

RE: View Locks

One DBA to rule them all, One DBA to define them One DBA to kill sessions and replaceable parameters bind them. -Original Message- Mladen Sent: 11 September 2002 16:14 To: Multiple recipients of list ORACLE-L How are you going to kill another session without a DBA role? A command like

Re:Timeout while obtaining an oracle connection lock

Grant, ColdFusion does not use Oracle natively, but through ODBC. I have seen this in the past and it's an ODBC setting that's causing the problem. Find out what ODBC driver their using. Look for a timeout setting, I know that DataDirect driver has one on the general panel. Dick Goulet _

Does analyze table lock the tables

Hi DBAs, I would like to analyze a few tables in production. My question does it prevent any type of access i.e.,apply locks? If so I can wait to do it off hours. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Netw

RE: Timeout while obtaining an oracle connection lock

Grant - I have never encountered this one in Oracle. Are you receiving an Oracle error number? It makes me wonder if it is a Cold Fusion message. Have you received it outside of Cold Fusion? Check the Oracle logs, alert_log, dump files, trace files. Check to see if there is a timeout parameter in

RE: mixed case text

Title: RE: mixed case text SELECT INITCAP('mccoy') "McCoy" FROM DUAL; McCoy - Mccoy Better hope your name isn't Hatfield! (Alluding to the famous Hatfield-McCoy feud in the USA a few years ago). Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-62

Re:Recover an unrecoverable database

God morning Dan, I prefer to read the morning mail, especially from here, before posting an answer just in case someone else has the same idea. But in this case I saw a close one, but not the exact one. Where you've got a problem here is that you've lost the damned control file. In that ca

RE: mixed case text

Steve, I agree with what everyone said here. The data should be stored as the user enters it. I regularly add additional columns to database table that will take a name field, upper-case it and remove all punctuation for sorting purposes. I do this with a database trigger, so applications do n

FW: Destination address unreachable

Geraldo, Thanks for the advice. It's interesting that the Migration manual states something like the only difference between 32 and 16 bit is the PL/SQL compiled code - there is no difference in the data files. Since it all gets recompiled anyway, I was wondering why we could not go directly to

problems creating a context index

Hello All; I am being plagued with an error I can't get my hands around when I try to recreate a context index. The index existed previously, but when I tried to sync new data I got an error, then I attempted rebuilding the index from scratch and got the same error (see below). I checked the $O

Re: Index table last update?

Use auditing, or include timestamp column in your table. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, September 12, 2002 6:53 AM > > From: "Stephane Faroult"<[EMAIL PROTECTED]> > > Date: Wed

RE: SQL Query tuning help

Thank you Stephane! Your final idea of FIRST_ROWS as a winner! Oracle slapped the data back in just a second. Thanks everyone for the ideas to try.   Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 10, 2002 3:4

Re: mixed case text

The initcap function can work pretty well in a lot of cases but those exceptions can be major. I remember there being discussions on this list about how does one handle names starting with Mc or Mac. At the time the original post came in I was dealing with some strings that included the degrees MD

RE: test - please ignore

Somebody say something???   peter -Original Message-From: Yechiel Adar [mailto:[EMAIL PROTECTED]]Sent: 12 September 2002 14:54To: Multiple recipients of list ORACLE-LSubject: Re: test - please ignore NO   Yechiel AdarMehish - Original Message - From:

Re:mixed case text

Steve, From one dinosaur to another, let them have mixed case. Dick Goulet Reply Separator Author: "Steve McClure" <[EMAIL PROTECTED]> Date: 9/11/2002 5:38 PM I just had a heated, well perhaps not heated, but certainly adversarial discussion wi

Re: View Locks

You are not, but you can call his highness and then HE can kill the sessions. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, September 11, 2002 5:13 PM > How are you going to kill another session without a DBA role?

Re: snapshot of a remote snapshot without pk

On Mon, Sep 09, 2002 at 09:53:26AM -0800, Ray Stell wrote: > Since I can't make a snapshot of a remote partition (this is really > what I wanted in the first place), I make a snapshot on the remote > machine first and then snapshot the remote snapshot. -- snapshot of a snapshot is unsupported pr

Re: Timeout while obtaining an oracle connection lock

Check out the number of processes init.ora parameter against open connections. You may have run out of available processes.   Yechiel AdarMehish - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Thursday, September 12, 2002 2:4

RE: mixed case text

Well said, Philip. I have always used mixed case for the actual data stored in the database and have never encountered a problem, except the index issue you mention, and as you say, function-based indexes cure this problem. If you uppercase the data on storage and rely on initcap to replicate t

Re: test - please ignore

NO   Yechiel AdarMehish - Original Message - From: Farnsworth, Dave To: Multiple recipients of list ORACLE-L Sent: Monday, September 09, 2002 5:18 PM Subject: RE: test - please ignore Can you hear me now   Good   ;o) -Original Me

Re: Another Character Set Problem

Scott, You can only use the alter database command to move from one character set that is a strict superset of your current character set. You can find lists of superset relationships on Metalink. Search on something like character set conversion and superset or UTF8 and WE8ISO8859P1. You p

RE: Satisfied customer

Jarad, Has there been a second printing already? I don't see the first two errata you mention in my copy. The third one wasn't there, but your notes just say it "may" need to be added, not that it "will". :) PAX, John P Weatherman Database Administrator Replacements Ltd. -Original Mess

Re: SYSDBA privilege with ORAPWD utility

Hello Chetan I think that you need to have administrator permission on the NT domain to be able to logon as sysdba. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, September 11, 2002 2:38 PM > Hi List , > > I have O

RE: User-defined functions in WHEN clause of a trigger

Title: RE: User-defined functions in WHEN clause of a trigger Rich, Remove the when clause from trigger definition and put it inside. CREATE OR REPLACE TRIGGER my_trigger BEFORE UPDATE ON my_table FOR EACH ROW BEGIN   If my_function = some_value then do_something_meaningful;   end if;

Another Character Set Problem

We are currently having a character set problem. We have a third-party product that is used for on-line courses (Prometheus from Blackboard, Inc.). The character set that the instance was created with was US7ASCII. The vendor says it should be WE8ISO8859P1, but we need to support Chinese an

Re: RMAN backup to remote dir. - how ?

Use map network drive on your target machine and define the drive as a directory on your recovery machine. I mean: map drive K on the target machine as f:\backup on the recovery machine. Then backup to drive K. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACL

Re: Restoring RMAN backups to different host ......solved

If I remember correctly netbackup can restore oracle DB only to the original machine. By setting this environment variable you trick it to think that this is the original machine. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: F

Re: Satisfied customer

Murphy's law expansion for writers: When a writer receive his new book from print, he will always open it in the place with the worst errata. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, September 12, 2002 4:08 AM

Re: Rowid

When the row is moved to another block. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, September 12, 2002 5:28 AM > what are the cases for a rowid to be changed ? > > Regards, > Prakash. > > > -- > Please see th

  1   2   >