Re: update statement ???

You have to issue the following command: UPDATE cli_branches SET brch_name = REPLACE(brch_name, ' (NO PHONE #S)'); regards, Mauricio Vélez Janet Linsy [EMAIL PROTECTED] wrote: Hi all,I need to update a column (brch_name) to be without(NO PHONE #S) string. So 3954 will be Denver, 3955will

long time to kill a session

connections faster? Regards,Mauricio Vélez Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard

Change dedicated server to shared server

Hi Can somebody tell me the steps for changingmy serverconfiguration from dedicated server to shared server? Thanks Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard

Oracle8i and oracle9i in the same machine

Hi everybody I have been running oracle817 since long time on WindowsNTNow I installed Oracle9i on the same machine and I cannot use both at the same time. How can I resolve this problem regards, Mauricio Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing

blob on import and export

Hello everybody I have the following questions: How can I use a full export without blob? Or How can I use a full import without blob? Regards, Mauricio Vélez Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing

Obtain SQL Statement from audit

on my table? Regards, Mauricio Vélez Do you Yahoo!? Yahoo! Photos - Get your photo on the big screen in Times Square

Re: Obtain SQL Statement from audit

. Hope this helps. Arup - Original Message - From: Mauricio Vélez To: Multiple recipients of list ORACLE-L Sent: Monday, December 29, 2003 1:39 PM Subject: Obtain SQL Statement from audit Hello everybody I am auditing select statements on one table, so I put the initialization

Problem with changing Dedicated Server to Shared Server

change both to shared server, the users can’t connect to the second I changed. I proved with Oracle 9i on Windows NT and the same problem exists. How can I resolve this? Regards Mauricio Vélez Do you Yahoo!? Find out what made the Top Yahoo! Searches of 2003

Difference on ArchiveLog

’t understand why this difference occurs. The database I’m working on is oracle 8i and I’is on Windows NT. Regards Mauricio Vélez Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes

Difference on ArchiveLog

3G of archive daily. I think I’ts not logical that archive size change. The database I'm working on is oracle 9i and I'is on Windows NT. Regards Mauricio Vélez Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes

Difference on ArchiveLog (I'm rewriting the question)

3G of archive daily. I think I’ts not logical that archive size change. The database I'm working on is oracle 9i and I'is on Windows NT. Regards Mauricio Vélez Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes

Re: Re: Difference on ArchiveLog (I'm rewriting the question)

real sizes of datafiles is 13G. I thinkIt not should be happennig, because the archive generation shouldn't be dependent on redolog size. But in this case yes (Could be an Oracle 9i bug?). Regards Mauricio Vélez Tanel Poder [EMAIL PROTECTED] wrote: Is your system overloaded e.g

problem with log version

' In the Oracle Documentation The solution to the error ora-00331 is to recover the databaseusing the old software. The problem is tha I don't have the old software. Is there a way to change the log version or what can I do? Regards, Mauricio Vélez Do you Yahoo!? Yahoo! Hotjobs: Enter the "Si

Jobs are not working

Vélez Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it!

Re: Jobs are not working

I issued commit and job_queue_processes = 4 job_queue_interval = 10 in init_SID.ora file so I don't know why the jobs are not working regards, Mauricio Vélez [EMAIL PROTECTED] wrote: A COMMIT is required after "submitting" the job.job_queue_processes = 4 === Must be greater

Views for a table

Hi everybody I have the following question How can I querya table's views? For example I have the table students and I want to know the views related to this table. Thanks, Mauricio Vélez Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it!

RE: Jobs are not working

The Jobs are not broken I haven't resolve this yet, alljobswork fineon one database buton the other not. How can I resolve this? Mauricio Vélez "Goulet, Dick" [EMAIL PROTECTED] wrote: Are the jobs "broken"?? Dick GouletSenior Oracle DBAOracle Certified 8i DBA -

Problem with jobs

Hi, This is the situation: I'm woriking on NT and there are two 8i databases on itOne database can execute jobs normally, but the other one not execute anyjob. I proved submitting the same procedure to both databases and worked on thefirst one but not on the second one. If I manually execute

column session_info appear empty on logminer

CAMBIO" = 2697,88, "MENSAJE" = 'AUTORI ZADO EL PAGO CON UN NOMBRE', " CLAVE" = NULL, "TELEFONO1" = ' 4118035', "TELEFONO2" = NULL, "PAGADO" = 'S', "ACTUALIZADO" = 'N', "ACTIVADO" = 'S', "OBSE RVACIONES" = 'SE AUT P

Re: Starting Database from OEM 9.2 gives ORA-12500 Failed to start a dedicated ....

, thenyou have toassign one listener port for each database. hope this helps Mauricio Vélez Oracle DBA Dharminder Softhome [EMAIL PROTECTED] wrote: Hey all,Following is the environment.Windows 2000Oracle Enterprise 9.2,OEM 9.2I have two 9.2 database installed on my system. OEM is configured