iling 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 infor
this right?
Thanks,
Ross
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ross Collado
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hostin
Hi,
How do I delete a file named --cart ?
Thanks,
Ross
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ross Collado
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web
b,
> sys.ts$t
> wheret.name = ''
> and a.ts# = t.ts#
> and a.ts# = b.ts#
> and a.file# = b.file#
> and (a.block# + a.length) = b.block#
> group by t.ts#;
>
> The purpose of the "LEAST(C
Hi,
For those like me still working on an Oracle 716 (hold the laughs), how do
we coalesce a tablespace?
Rgds,
Ross
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ross Collado
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
r3||'x'||
-- addr_rec.sub_dist||'x'||addr_rec.pcode);
end loop;
close cv;
exception
when others then
dbms_output.put_line(sqlcode||sqlerrm);
end by_key;
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ross Collado
INET: [
taining: 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: Ross Collado
INET: [EMAIL PROTECTED]
Fat City Network Services
-L FAQ: http://www.orafaq.net
--
Author: Ross Collado
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 yo
Rgds,
Ross
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ross Collado
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hostin
. You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ross Collado
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
Tue instead of Wed)
I man'd date, but it was no help.
Thanks for any help.
Barb
_
Do you Yahoo!?
U2 on <http://rd.yahoo.com/launch/mailsig/*http://launch.yahoo.com/u2>
LAUNCH - Exclusive medley & videos from Greatest Hits CD
--
Please see the official ORACLE-L FAQ: http://www.or
t; ps -ef | grep smon | grep -v grep | awk -F_ '{ print $3 }'
>
> Is one way of many to get your result.
>
>
>
>
>
> Ross Collado
ep|cut -c49- |awk -F_ '{ 'print $3 }'
>
> I replaced the first awk w/ cut. the -c option says to cut
> that output
> from position 49 to the end of the line. You may have to adjust the
> value from 49 to something else.
>
> That ought to work for you.
>
>
umber of fields in a ps -ef output is not consistent.
> As you can see
> I've just restarted RMAN and now it only has 8 fields as
> compared to 9 for
> the others.
>
> Any suggestions? Or another way of doing it?
> Using KSH on Solaris 8.
>
> Thanks.
> Ro
Browsing through my Sed and Awk book following up on Mark's lead, I came up
with this:
ps -ef|grep pmon|grep -v grep|awk '{ print $NF }'|awk -F_ '{ print $3 }'
TLDEV
TLQA
TLQAVAR
DBMON
RMAN
PRDINF
TLDVVAR
That'll do fine !
Thanks again.
Ross
> -----Original
7;{ print $3 }' -- parse the program name on the '_' and return
> the third field, the database name.
>
> Hope that helps,
>
> -Mark
>
> On Sun, 2002-10-27 at 20:43, Ross Collado wrote:
> >
> > Hi All,
> >
> > I want to feed m
s -ef output is not consistent. As you can see
I've just restarted RMAN and now it only has 8 fields as compared to 9 for
the others.
Any suggestions? Or another way of doing it?
Using KSH on Solaris 8.
Thanks.
Ross
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
> end ;
> /
>
> prompt
> prompt
> prompt
> set feed on
> undef 1 2
>
> -Original Message-
> Sent: Wednesday, October 16, 2002 10:39 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi All,
>
> It has previously been discussed i
uch of the 50M has data in it?
On 817.
Rgds,
Ross
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ross Collado
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hostin
list ORACLE-L
> > Subject: RE: UNIX OT: Strange Unix behavior
> >
> >
> > This directory might be under the control of the automount
> > daemon. If you
> > want locally managed home directories you need to remove
> > /home from the
> > automountd.
>
home from the
> automountd.
>
> Erik
>
> > -Original Message-
> > From: Ross Collado [SMTP:[EMAIL PROTECTED]]
> > Sent: Monday, August 26, 2002 3:58 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:UNIX OT: Strange Unix behavio
directory might be under the control of the automount
> daemon. If you
> want locally managed home directories you need to remove
> /home from the
> automountd.
>
> Erik
>
> > -Original Message-
> > From: Ross Collado [SMTP:[EMAIL PROTECTED]]
&g
rning chmod: WARNING:
can't change home
I find it very strange that root can't do this.
Has anyone experienced this before?
If so, how did you get around it?
Rgds,
Ross
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ross Collado
INET: [EMAIL PROTECTED]
F
like:
> #Column
> #This
> #
>
> How do I get rid of these 3?
>
> Rgds,
> Ross
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ross Collado
> INET: [EMAIL
Hi,
I have files like:
#Column
#This
#
How do I get rid of these 3?
Rgds,
Ross
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ross Collado
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
tag b_db_full
> filesperset 3
> format '/oracle1/oracle/admin/RMAN/backup/df/dfset_%s_%t.%d'
> database;
> execute script rel_all_disks;
> execute script archive_log_current;
> execute script backup_al_all;
> }
> ---
> ---
>
> Rgds,
> Ro
ot;
> what do you mean? are they run on BoxA or BoxB? If they are
> run on BoxA,
> then the backup files will be created on BoxA.
>
> Tom Mercadante
> Oracle Certified Professional
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ross Coll
gt; full
> > skip inaccessible
> > tag b_db_full
> > filesperset 3
> > format '/oracle1/oracle/admin/RMAN/backup/df/dfset_%s_%t.%d'
> > database;
> > execute script rel_all_disks;
> > execute script archive_log_current;
> > execute script
up/df/dfset_%s_%t.%d'
database;
execute script rel_all_disks;
execute script archive_log_current;
execute script backup_al_all;
}
---
---
Rgds,
Ross
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ross Collado
INET: [EMAIL PROTECTED]
Fat City Networ
sqlplus / < -Original Message-
> From: Ross Collado
> Sent: Wednesday, 24 July 2002 14:53
> To: Multiple recipients of list ORACLE-L
> Subject: Unix Q: ksh scripting
>
>
> Hi all,
> Can any of our Unix gurus here transform my script below to
> work properly?
&
hor: Ross Collado
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 a
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: Ros
logs where is it applying the transactions
to?
3. Since there is no '... offline drop' in this version, is there any other
way to get around this apart from completely recreating the standby?
Any input much appreciated.
Rgds,
Ross
--
Please see the official ORACLE-L FAQ: http://www.or
? Any direction would be appreciated.
Thanks
Stephen Andert
Scottsdale, Arizona
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ross Collado
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, Ca
; noresetlogs mode at this time .. however i have seen
> that it does not .. so here is the workaround ..
>
> SQL> alter database backup controlfile to trace;
> SQL> create controlf file ..< from ur trace>
> SQL> recover database; -- takes one sec to complete
> SQL> Al
TIA,
Ross
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ross Collado
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
-
--
Author: Ross Collado
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
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
Thanks. That's it.
> -Original Message-
> From: Jared Still [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 28 August 2001 12:15
> To: [EMAIL PROTECTED]; Ross Collado
> Subject: Re: OT:Unix Q
>
>
>
> do a 'man ssh-keygen'
>
> Jared
>
&
To all Unix gurus,
What's the command to generate an "identity.pub" file for use in ssh ?
Rgds,
Ross
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ross Collado
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538
anks,
Ross
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ross Collado
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mai
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: Ross Collado
INET: [EMAIL PROTECTED]
Fat City Ne
procedures as stated in the oracle installation
guide. my problem is when it comes to the step (pp 4-2 of the installation
guide) that says run the catrep.sql. where can i find this sql script?
thanks!
oracle newbie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ross
43 matches
Mail list logo
