:$ORACLE_
H
OME/rdbms/jlib:$ORACLE_HOME/network/jlib:.:$ORACLE_HOME/JRE
Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994
-Original Message-
Joe Testa
Sent: Tuesday, September 16, 2003 2:05 PM
To: Multiple recipients of list ORACLE-L
your path could still be pointing elsewhere first and not the
That was it.
Thanks a lot to everybody that answer, thanks to you I learn something
new every day.
[EMAIL PROTECTED] bin]$ $ORACLE_HOME/bin/rman
Recovery Manager: Release 8.1.7.4.0 - Production
RMAN>
Tks.
Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994
-Original Message-
Ta
ED]
SQL*Plus: Release 8.1.7.0.0 - Production on Tue Sep 16 10:42:15 2003
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production
SQL>
Ramon E
[EMAIL PROTECTED] bin]$ rman
[EMAIL PROTECTED] bin]$ rman rman/[EMAIL PROTECTED]
rman: can't open rman/[EMAIL PROTECTED]
[EMAIL PROTECTED] bin]$
Please any help would be appreciated.
Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994
-Original Message-
Joe Testa
Sent: Tuesday, Septemb
ROTECTED][EMAIL PROTECTED]
oracle]$
TIA
Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ruth
GramoliniSent: Tuesday, September 16, 2003 8:54 AMTo:
Multiple recipients of list ORAC
Title: Configuring RMAN
Hi list,
I am implementing RMAN in an RH AS 2.1 environment on Oracle 8.1.7 and at the prompt
When using rman catalog rman/[EMAIL PROTECTED]
I get rman: can't open catalog
I recreated the password file and the same error.
TIA,
Ramon E. Estevez
[
integer 0
optimizer_index_caching integer 90
optimizer_index_cost_adj integer 30
Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994
-Original Message-
Wolfgang Breitling
Sent: Wednesday, September 10, 2003 9:10 PM
To: Multiple recipients of list ORACLE-L
INDEX ROWID) OF 'TCON_TRANSA'
610884 INDEX (RANGE SCAN) OF 'FK_CF02CON_TSA' (NON-UNIQUE)
0 TABLE ACCESS (BY INDEX ROWID) OF 'TCON_DESTRAN'
395942 INDEX (UNIQUE SCAN) OF 'CP01CON_DST' (UNIQUE)
TIA
Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994
icult.
Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994
Title: DBAssist hangs
Hi list,
I installed 8.1.7 on RH AS 2.1, applied 8.1.7.4 patch, the glibc patch and when trying to create a
DB dbassist hangs.
TIA
Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994
mount the partitions and haven't been able to do it.
Any help would be appreciated.
TIA
Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994
What about this
SELECT 'CREATE TABLE NEWUSER.'||TABLE_NAME ||' TABLESPACE NEWTBS AS
SELECT * FROM '||TABLE_NAME ||';'
FROM USER_TABLES
WHERE
TABLE_NAME LIKE 'ABC_%'
/
Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994
-Original Message---
I would say 4.
Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994
-Original Message-
Senthil Kumar
Sent: Wednesday, July 30, 2003 1:20 PM
To: Multiple recipients of list ORACLE-L
Hi all,
What is the correct answer for this?
Q> If you have 2 redo log groups with 4 members each,
108 consistent gets
0 physical reads
0 redo size
245 bytes sent via SQL*Net to client
981 bytes received via SQL*Net from client
3 SQL*Net roundtrips to/from client
2 sorts (memory)
0 sorts (disk)
1 rows proce
There's a new feature in 9i that can remove the os file also
Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994
-Original Message-
Jose Luis Delgado
Sent: Tuesday, July 01, 2003 5:13 PM
To: Multiple recipients of list ORACLE-L
It dissappered from the data dict...
but it should exi
of the procedure and
the only thing that
Was waiting was SQL NET TO CLIENT MESSAGE.
Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994
-Original Message-
Stephane Faroult
Sent: Friday, June 27, 2003 6:15 PM
To: Multiple recipients of list ORACLE-L
Ramon,
This is not a strange case at
vDebito := 0;
vCredito := 0;
when others then
null;
end;
vSaldo :=nvl (vSaldo,0) + (nvl(vSaldoAnt,0) + nvl(vDebito,0) -
nvl(vCredito,0)) ;
end loop;
return vSaldo ;
end;
/
Ramon E. Estevez
[EMAIL PROTEC
I would go with A and C
Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994
-Original Message-
CP
Sent: Friday, June 13, 2003 6:15 PM
To: Multiple recipients of list ORACLE-L
I think, it should c: (The ability to rename a tablespace).
Thanks
CP
[EMAIL PROTECTED] wrote:
> Robert
>
That's it. I ran it again and everything ok.
Tks
Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994
-Original Message-
Richard Ji
Sent: Friday, June 06, 2003 8:54 PM
To: Multiple recipients of list ORACLE-L
Did you re-run the glibc stub patch after applying 8.1.7.4?
Ri
Platform suse linux professional 7.2
Sorry :-(
Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994
-Original Message-
Sent: Friday, June 06, 2003 7:14 PM
To: 'DBA List ([EMAIL PROTECTED])'
Hi list,
I installed the patch 8.1.7.4 and now when trying to start the instance
I get
Hi list,
I installed the patch 8.1.7.4 and now when trying to start the instance
I get ORA-03113 after like 1 minute.
I followed the steps in the readme file of the patch.
TIA,
Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
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
Hi list,
I have to develop an interface to allow another company, with 60
offices, to make some kind of transactions in my system with my clients.
I am thinking of using Forms9i.
What should I consider ?
Any comments would be highly appreciated.
TIA,
Ramon E. Estevez
[EMAIL PROTECTED]
809-535
Ah!
The old trick of the symjitc.dll. It's working now.
Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994
-Original Message-
Estevez
Sent: Saturday, May 31, 2003 3:20 PM
To: Multiple recipients of list ORACLE-L
Hi list,
I'm trying to install 9IAS 1.0.2.2 in a W2000 SP3 b
Hi list,
I'm trying to install 9IAS 1.0.2.2 in a W2000 SP3 but nothing comes up
when clicking the setup button.
Checked in metalink and nothing related to it.
TIA
Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
ng 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
--
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 ORACLE-LSu
e 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: DENNIS WILLIAMS
INET: [
d_pool.keep('DBMS_UTILITY');
dbms_shared_pool.keep('STANDARD');
dbms_shared_pool.keep('BUSCA_SECUENCIA');
END;
/
> "Ramon E. Estevez" wrote:
>
> Sorry, new DB and hadn't execute the Dbmspool.sql script.
>
> CREATE OR REPLACE TRIGGER PAQUET
Title: Message
I erased the exec
clause and it worked.
Sorry and
tks
Ramon E.
Estevez
[EMAIL PROTECTED]
809-565-3121
'STANDARD'); exec
immediate dbms_shared_pool.keep('BUSCA_SECUENCIA');END;
I am getting this
error, tried with users SYS and SYSTEM
12/11 PLS-00103: Encountered the symbol
"DBMS_SHARED_POOL" when
expecting one of the
following: := . ( @ %
;
tia
Ramon E.
Estevez
[EMAIL PROTECTED]
809-565-3121
Title: Message
Which one is the
substituion procedure for DBMS_SHARED_POOL in 9i ?
Ramon E.
Estevez
[EMAIL PROTECTED]
809-565-3121
) (ADDRESS = (PROTOCOL =
TCP)(HOST = 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
e 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 in a
ecked
metalink, 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
LP
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://www.fatcity.com
San Diego, California-- Mailing list and
The operating system files 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
using OMF feature.
What happens when drop the log file group if using the OMF feature, the
files will be deleted
also ???
TIA
Ramon E. Estevez
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
809-565-3121
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
feature.
What happens when
drop the log file group if using the OMF feature, the files will be deleted
also
???
TIA
Ramon E.
Estevez
[EMAIL PROTECTED]
809-565-3121
from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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 (
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
--
Auth
0.
Where should I start looking ???
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
xagerated.
The TBS is LMT with a Uniform size 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]
30 seconds. The table has 1,466,196 records and were loaded with a
batch process, so they are in a countinous space. I consider that time
exagerated. The TBS is LMT
with a Uniform size of 128 MB. The block size is 8MB, version 9.2.0.1.0 in Windows
2000. Where should I start
rows.
Lisa
Koivu Tired, 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: Tu
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
tGuru') 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
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
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
12345AA1414-TT-1414-BR
3
1414-TT-1414-BR147
147
DESCRIPCION UNO
Ramon E.
Estevez
[EMAIL PROTECTED]
809-565-3121
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 anyb
Mkb, think about the JOE considerations !!
-Original Message-
Sent: Wednesday, October 30, 2002 5:19 PM
To: Multiple recipients of list ORACLE-L
Ramon,
Thank you. I like the ideas in this trigger. I will
certainly try this.
mkb
--- "Ramon E. Estevez" <[EMAIL PROTECTED]
thing owned by SYS will NOT be exported, refer to #1.
3. Create a new userid to store those kinds of objects so during an
export it will be picked up and refer to #1. :)
joe
Ramon E. Estevez wrote:
>Hi, mkb
>
>I made this one, hope it works for you as it did for me.
>
>It validates
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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 ot
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 SYSTEM.CONTROL_
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 list and web
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. Estevez
INET
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 PRO
ork Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -----
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PR
-
From:
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
otocol=TCP,host=new network card
address,port=1526))
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
ED] (note EXACT spelling 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 t
C:\Oracle\Ora8I) (SID_NAME =
ORCL) ) )
TIA,
Ramon E. Estevez[EMAIL PROTECTED]809-565-3121
ORCL) ) )
TIA,
Ramon E. Estevez[EMAIL PROTECTED]809-565-3121
Can anyone of you throw some light about my
problem.
TIA
Ramon E. Estevez[EMAIL PROTECTED]809-565-3121
r implemented it and am not sure how it's done.
>
> --- "Ramon E. Estevez" <[EMAIL PROTECTED]> wrote:
> > Hi list,
> >
> > Reading the OU manuals Oracle 9i DBA Fundamentals II , in chapter 2
> > page 12, found
> >
> > 1-) An oracle database is
far as I understand, the DB 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[
---
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be
---
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be
her 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 Lists
B 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: [E
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
l message
> to: [EMAIL PROTECTED] (note EXACT spelling 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).
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.
>
ine 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 PROTE
ou 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-5051
Sa
5051
> San Diego, California-- Public Internet access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you
ru') 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
ego, California-- Public Internet access / Mailing Lists
> --------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
&g
s another bug with SPFILE.
>
> - 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
:
> > > Subject:RE: Where is Oracle 9.2 init.ora?
> > >
> > >
> > > You DBA's must be drunk.
> > >
> > > Spfiles are in binary format and if you open it in a text editor, all
> > you
> > > see
> > >
ing 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:/
, 13) AND
> > > p.kglpnhdl = o.kglhdadr AND
> > > s.addr = p.kglpnses
> > > ORDER BY 1, 2, 3
> > > /
> > >
> > >
> > > Courtsy of Steve Adams.
> > >
> > > Raj
> > >
Inc.
> >
> > QOTD: Any clod can have facts, but having an opinion is an art!
> >
> > -Original Message-
> > Sent: Wednesday, July 03, 2002 11:39 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi gurus,
> >
> > Is t
). You may
> > also send the HELP command for other information (like subscribing).
>
>
> __
> Do You Yahoo!?
> Sign up for SBC Yahoo! Dial - First Month Free
> http://sbc.yahoo.com
> --
> Please see the official ORACLE-L FAQ:
essage 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. Estevez
> >
> > Hi list,
> >
> > I am trying to copy one table from a DB 9.0.1 on Linux RH to a DB
> > 8.1.7 on NT using this statement
> >
> > COPY FROM RAMON@ORLNX TO RAMON@IBOR CREATE DATBAL_TMP USING SELECT
> > * FROM DATOS_BALANCES;
&
Subject: 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 AdarMehish
- Original Message -
From:
Ramon E. Estevez
To: Multiple
obligatory ?
TIA,
Ramon E. Estevez[EMAIL PROTECTED]809-565-3121
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 DROP the sequence, here is demo code i used to
reset a sequence(this reset
atement or procedure or package 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 runnin
actually running something in
the DB.
TIA
Ramon E. Estevez[EMAIL PROTECTED]809-565-3121
i get thru studying for 9i upgrade
> 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: "Multipl
-
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling 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)
gt;
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joe Testa
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
.com
> > --
> > Author: Jared Still
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > ---
;
> On Mon, 24 Jun 2002 09:28:21 -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 imp
e official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Jared Still
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling 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 (l
1 - 100 of 130 matches
Mail list logo