Re: ORA-03113 with dbms_output and sysdate

). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Modify init.ora

Title: Message Yes, the process parameter will be increased to the value you changed. The Init.ora, parameter file, is used anytime you start your DB. Probably you should check the parameters for the SGA. Luck -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: Controlling Users Logons

information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Multiple Listeners

://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

RE: login trigger

Title: Message CREATE OR REPLACE TRIGGER sys.XXX_onlogon AFTER LOGON ON DATABASE DECLARE USUARIOW VARCHAR2(25) := ''; COMPUTADORAW VARCHAR2(25) := ''; BEGIN SELECT OSUSER, MACHINE INTO USUARIOW, COMPUTADORAW FROM V$SESSION WHERE AUDSID = USERENV('SESSIONID'); INSERT INTO

Re: Install Oracle 8i on Windows XP?

a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat

Re: extremely high number of executions

of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

Re: Free ware databases: which are worth the money?

: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list

Re: Replication

). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Replication

tks - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 02, 2002 11:39 AM The application will be developped in ASP, the deployed version would juste be a lighter version of the main application. --- Ramon E. Estevez [EMAIL

Re: Procedure Execution time

ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Re: RMAN example scripts

Thanks Joe. - Original Message - From: JOE TESTA To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 14, 2002 9:58 AM Subject: RMAN example scripts http://www.oracle-dba.com/rman joe

Re: Simple question on logging..

://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself

Re: PL/SQL Editor

FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

Re: Great SQL Tuning Book

containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network

Re: Great SQL Tuning Book

containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network

Question about database and service name

instance name is unique, it can't be changed. So how can I create several services names for one DB. Or is just a trick in the TNSNAMES.ORA and LISTENER.ORA files. Please can anyone give some light in that, I am totally confused !!! Ramon E. Estevez[EMAIL PROTECTED]809-565-3121

Re: Question about database and service name

confused !!! Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul

Oracle 9.2 - MS PROXY 2.0

of you throw some light about my problem. TIA Ramon E. Estevez[EMAIL PROTECTED]809-565-3121

Listener load balance

= C:\Oracle\Ora8I) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME = C:\Oracle\Ora8I) (SID_NAME = ORCL) ) ) TIA, Ramon E. Estevez[EMAIL PROTECTED]809-565-3121

Re: Listener load balance

HOSTNAME of 'myserver' would tell you which. Since you have the same hostname on the listener, both ports would currently be using the same IP address. Did you setup DNS so that the cards share a Hostname ? -Original Message-From: Ramon E. Estevez [mailto:[EMAIL

Re: cobol-oracle

also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Re: Listener load balance

)) This way the clients will use both address. Yechiel AdarMehish - Original Message - From: Ramon E. Estevez To: Multiple recipients of list ORACLE-L Sent: Tuesday, September 17, 2002 10:19 PM Subject: Re: Listener load balance Tks Kevin

Re: Listener load balance

: Ramon E. Estevez To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 18, 2002 5:33 PM Subject: Re: Listener load balance TKS Yechiel for your help, Two more questions. Is there any way I can find out which one of the 2

Re: so when did you switch from NT to unix for oracle

company. Ramon E. Estevez - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 23, 2002 5:19 PM Steven, not quite, I dont run NT anywhere, exclusively linux both on laptop and at home. (feel free to see the headers in this email). I'm

Re: Reducing datafile size

ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Password Expire

Hi list, Scenario HP-UX Oracle Enterprise Edition 8.1.7.1.0 I have 2 instances in the same box. I expire the password in both of them to change them when the user connect to the DB thru forms and in one instance it works and in the other doesn't. The tests are performed from the same

Re: Reducing datafile size

, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL

Re: How to move 200 GB db from prod to dev?

Title: How to move 200 GB db from prod to dev? Helmut, I have just done it right this morning. Not that big but worked. Pasos para Clonar Bases de Datos 1-) Take a cold backup of the Origen DB- Preferiblemente frio 2-) Take a backup of the controlfile of the originDB 3-) Copy all

Archiving in OPS

about it will be very appreciated. TIA Ramon E. Estevez[EMAIL PROTECTED]809-565-3121

Clone DB

First of all, Tks to all the reply about this topic 3 weeks ago. Trying to clone a DB I am getting an ORA-01503 CREATE CONTROLFILE failed ORA-01159 file is not from same database as previous files ORA-01110 data file 7: 'C:\ORACLE\ORADATA\VTAS\DATOS' TIA Ramon E. Estevez[EMAIL

Re: Archiving in OPS

. Note that if an instance fails, any of the surviving instances can and will archive logs on behalf of the failed instance to the local instances archive destination. Bill --- Ramon E. Estevez [EMAIL PROTECTED] wrote: Hi list, Scenario OPS 2 nodes, Oracle 8.1.7, AIX. (New

nmi.log

Hi list, This file has grown up to 800MB. It has a lot of errors about Oracle Bequeath NT Protocol Adapter Fatal NI connect error 12640 . Can I erased that file ? How do I stop writing to it or stop the error ? TIA, Ramon E. Estevez[EMAIL PROTECTED]809-565-3121

Re: sequence question

Bigp Remember that when you issue sequence.nextval you are incrementing one value and eitheryour process function corrector not that number is used. But, the more important is that if your system crash or you issue an SHUTDOWN ABORT you will loose the sequence numbers cached. Also you can

Re: sequence question

numbers after an import/export? -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]Sent: Friday, June 14, 2002 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: Re: sequence question Bigp Remember that when you issue

Re: sequence question

what do you mean about losing numbers after an import/export? -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]Sent: Friday, June 14, 2002 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: Re: sequence question Bigp

Re: Free buffer requested

, enqueue requests 25035, redo writer latching time 0 Data 1 volume stripe of 2 disk Index 1 volume stripe of 2 disk -- differents RBS 1 disk apart Temp 1 disk apart What parameter should I check ? TIA Ramon E. Estevez -- Please see the official

Re: Free buffer requested

requested 28938, enqueue requests 25035, redo writer latching time 0 Data 1 volume stripe of 2 disk Index 1 volume stripe of 2 disk -- differents RBS 1 disk apart Temp 1 disk apart What parameter should I check ? TIA Ramon E. Estevez

Re: Free buffer requested

-- differents RBS 1 disk apart Temp 1 disk apart What parameter should I check ? TIA Ramon E. Estevez -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network

Re: Log file synch / direct path writes

also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Re: Log file synch / direct path writes

subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Log file synch / direct path writes

-0800, Ramon E. Estevez [EMAIL PROTECTED] said: What implications can cause having a big log buffer. You want to check the tip from Steve Adams to understand how log buffer works and the implications of a big log buffer http://www.ixora.com.au/tips/tuning/log_buffer_size.htm Hope

Re: Log file synch / direct path writes

://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself

Re: V9.2 SGA

command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Re: recording SQLPlus activity

FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

Re: V9.2 SGA

exam and take the test on mid july. joe Ramon E. Estevez wrote: Joe, what happened with your weekly tip about 9i ? Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 24, 2002 9:58 PM For those who dont know(and might

Active sql

is actually running something in the DB. TIA Ramon E. Estevez[EMAIL PROTECTED]809-565-3121

Re: Active sql

is running actually. I checked in V$SQLTEXT, V$SQLAREA joined with V$SESSION and could get the statement, the user but this process had already finished, it was just in the SGA. What I want to know is who is actually running something in the DB. TIA Ramon E. Estevez [EMAIL PROTECTED] 809-565

Re: Reset Sequence code

Nice trick Joe !!! - Original Message - From: JOE TESTA To: Multiple recipients of list ORACLE-L Sent: Friday, July 05, 2002 8:48 AM Subject: Reset Sequence code NO, you dont need to DROPthe sequence, here is demo code i used to reset a sequence(this

Copy

, is it obligatory ? TIA, Ramon E. Estevez[EMAIL PROTECTED]809-565-3121

Re: Copy

: Copy I checked the docs for 8.1.6 and 9.0.1. I think that the copy command is new in 9i. make sure that you are logged on to 9i sqlplus when you issue this command. Yechiel AdarMehish - Original Message - From: Ramon E. Estevez To: Multiple

Re: Copy

: I checked the docs for 8.1.6 and 9.0.1. I think that the copy command is new in 9i. make sure that you are logged on to 9i sqlplus when you issue this command. Yechiel Adar Mehish - Original Message - From: Ramon E. Estevez To: Multiple recipients of list ORACLE-L

Re: Increase size of REDO log

may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: runInstaller -- Linux help?

ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Active sql

checked in V$SQLTEXT, V$SQLAREA joined with V$SESSION and could get the statement, the user but this process had already finished, it was just in the SGA. What I want to know is who is actually running something in the DB. TIA Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121

Re: Active sql

but this process had already finished, it was just in the SGA. What I want to know is who is actually running something in the DB. TIA Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

Re: How to?

may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Re: Where is Oracle 9.2 init.ora?

: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send

Re: Where is Oracle 9.2 init.ora?

. - Kirti -Original Message- From: Ramon E. Estevez [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 2:58 PM To: Multiple recipients of list ORACLE-L Subject: Re: Where is Oracle 9.2 init.ora? Hi Kirti I have something to add to the topic. I could edit the spfile with VI

Re: RE: dblink problem ( ORA-02019)

of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E

Re: Import Error

). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Currval and buffer gets

Title: RE: Currval and buffer gets Waleed, Kevin, Jonathan, Alexander 8.1.7.0 on Windows 2000 run time using view x$dual in centiseconds=494run time using table dual in centiseconds=896run time using direct := in centiseconds=1007 Ramon -Original Message-From: [EMAIL PROTECTED]

Buffer in Import

Does the parameter buffer in the import refers to bytes or number of rows ? Kind of confuse. I think it refers to the number of rows. buffer=5 --- is that 5 bytes, or 5 rows TIA Ramon

RE: Buffer in Import

-Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]Sent: 25 April 2002 15:39To: Multiple recipients of list ORACLE-LSubject: Buffer in Import Does the parameter buffer in the import refers to bytes or number of rows ? Kind

RE: Buffer in Import

-Original Message- Sent: Thursday, April 25, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Subject:Re: Buffer in Import I 2nd that, bytes. [EMAIL PROTECTED] 04/25/02 12:03PM I believe that it refers to bytes. --- Ramon E. Estevez [EMAIL PROTECTED] wrote: Does

RE: pl/sql is INTERPRETED?

of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E

RE: 9i Release 2 features/fixes

-- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

Clone Database

I have to refresh a development database every day with the production DB. The size of the DB is 70GB and import last like 7 hours. Does anyone in the list has the steps to clone a database, not using import. TIA Ramon E. Estevez

RE: data dictionary View about jobs

of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E

RE: moving from unix to NT

ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

FW: Oracle Configuration in SCO

Hi list, I am returning tothe unix environment after 5 years of happily point and click in NT. Never used Oracle in this unix, so I need your advice for installing Oracle 8.1.7 inSco Open Server 5.05 andconfiguration or distribution of database files(redo log files, rbs, temporary, etc)

Installation in Unix

Come on list, need your help, never deal with oracle in unix before. Any link, document or something to help me to install Oracle 8.1.7 in unix. Ramon

RE: row level lock

Shishir, When you make the select statement at the end add the clause FOR UPDATE SELECT FIELD1, FIELD2 FROM TABLE WHERE FIELD1 = 40 FOR UPDATE Luck, -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of ShishirSent: Thursday, 07 March, 2002

Errors in Alert Log - 12571

Hi List, Checking the alert log file I found this error ARC2: Completed archiving log# 3 seq# 736Mon Mar 11 07:46:18 2002Thread 1 advanced to log sequence 738Mon Mar 11 07:46:18 2002ARC1: Beginning to archive log# 2 seq# 737Mon Mar 11 07:46:18 2002 Current log# 1 seq# 738 mem# 0:

RE: row level lock

Shishir, When you make the select statement at the end add the clause FOR UPDATE SELECT FIELD1, FIELD2 FROM TABLE WHERE FIELD1 = 40 FOR UPDATE Luck, -Original Message- Sent: Thursday, 07 March, 2002 10:03 AM To: Multiple recipients of list ORACLE-L HI list! I want

RE: Oracle Log Miner Question

Title: Message Enterprise Manager -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of [EMAIL PROTECTED]Sent: Tuesday, November 26, 2002 10:44 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle Log Miner QuestionDear All, Does

Help with Query

-1414-BR147 147 DESCRIPCION UNO Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121

Feliz Navidad

Title: Message Hi lists Happy holidays from the warm Dominican Republic. Thanks for all your help throught the year. Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121

Internet Site

Title: Message I got this from this site www.diccionarios.com Warning: OCISessionBegin: ORA-00020: maximum number of processes (150) exceeded in /usr/sunone/webserver/docs/diccionarios/classic/include/sql.inc on line 106Interesting. Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121

RE: Update NT to 2000 Server

of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Count(*) last 30 seconds

is 8MB, version 9.2.0.1.0 in Windows 2000. Where should I start looking ??? TIA Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121

RE: Count(*) last 30 seconds

KoivuTired, Tired, Tired. Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 11

RE: Count(*) last 30 seconds

Title: Message Hermant, Sergey The table has 13 columns, the PK is formed for the first 11. There is no deletion nor update, just inserts in the table. I had truncated the tables sometimes testing the procedure that load the rows. This is the result with an auto trace.

RE: Count(*) last 30 seconds

TIA Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat Ci

RE: Count(*) last 30 seconds

of 128 MB. The block size is 8MB, version 9.2.0.1.0 in Windows 2000. Where should I start looking ??? TIA Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 Hemant K Chitale My web site page

RE: When were Locally Managed Tablespaces introduced?

') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ramon E. Estevez INET: [EMAIL

RE: DBMS_JOB : Can submit but does not execute

ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- 858

RE: Question about log files

Theoperating systemfiles are deleted too, when an Oracle Managed logfile grup or member is dropped. HTH. Arup Nanda - Original Message - From: Ramon E. Estevez To: Multiple recipients of list ORACLE-L Sent: Wednesday, February 19, 2003 9:59 AM

RE: Where is the sql stored for a stored procedure?

information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Replication

, but can't open a TAR. Is there any recommendation that you can give him to check. Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121

RE: Replication

the exact error it fails on. HTH. Arup Nanda - Original Message - From: Ramon E. Estevez To: Multiple recipients of list ORACLE-L Sent: Friday, February 21, 2003 8:19 AM Subject: Replication I was asked of a problem

Listener

= 125.115.100.10)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 125.115.100.11)(PORT = 1526)) ) (CONNECT_DATA = (SERVICE_NAME = ORCL) ) ) Any suggestions, comments will be appreciated. TIA Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121

DBMS_SHARED_POOL

Title: Message Which one is the substituion procedure for DBMS_SHARED_POOL in 9i ? Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121

Error pinning PKS in shared pool

: Encountered the symbol "DBMS_SHARED_POOL" when expecting one of the following: := . ( @ % ; tia Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121

DBMS

Title: Message I erased the exec clause and it worked. Sorry and tks Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121

RE: Error pinning PKS in shared pool

('BUSCA_SECUENCIA'); END; / Ramon E. Estevez wrote: Sorry, new DB and hadn't execute the Dbmspool.sql script. CREATE OR REPLACE TRIGGER PAQUETES_MEMORIA AFTER STARTUP ON DATABASE BEGIN exec immediate dbms_shared_pool.keep('DBMS_ALERT'); exec immediate dbms_shared_pool.keep('DBMS_DDL

RE: Oracle Performance Tuning Exam

information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: DEFAULT ROLE ALL

Title: Message That all the roles that the user has assigned get enabled when he logs on. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Edouard DormidontovSent: Wednesday, March 12, 2003 8:39 AMTo: Multiple recipients of list

RE: Force to use a tablespace

of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ramon E

RE: inline views

What I remember from an old post regarding this issue, You don't have to create another object, view, to workaround your requirement. Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- VIVEK_SHARMA Sent: Friday, June 06, 2003 8:10 AM To: Multiple recipients of list

  1   2   >