You indicate, that you are specifying max_opencursors (I assume you mean
maxopencursors) and that your program program is written in Pro*C (or another
precompiler) Do remember, that maxopencursors only influences implicit
cursors in the precompiler and you must code explicit cursors
Hi,
We are in a process of selecting for a type of firewall. Any pros-n-cons?
Things to consider? Your preference/experience? Which one is difficult to
break over the other? Or would it be better to have both?
TIA!
Aleem
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
- Original Message -
From: [EMAIL PROTECTED]
anyone know knows any webpage where I can ask MsAccess
questions about error messages?
go to http://msdn.microsoft.com/newsgroups/topic.asp?url=/MSDN-FILES/028/201/008/topic.xml then choose Office Solutions Access
there are 20+
Hi All
I have a 2 tables which related to each other
Nemaster(primary key is Oid) and
Elements (Neid reference Oid)
Now I have to run following query
A) SELECT IPADDRESS FROM ELEMENTS WHERE NEID = (SELECT OID FROM
NEMASTER WHERE EID = ID);
I can run the above query as below
B) SELECT
Parameter that are defined as IN _are_ copied in. To avoid this and pass
data by reference, use NOCOPY. NOCOPY is a compiler directive witch may or
may not be followed by the compiler.
regards
Torben Holm
http://www.miracleas.dk
Khedr, Waleed writes:
So the answer is none of the above.
Robert,
If this was a test, and you know the answer,
please tell us what it was and how you got it.
(trade secrets need not be revealed, of course).
I thought I knew one way to find it, but the dump
command I want to use doesn't work on 9 !!
Using rather crude methods, some tests I have
just
My guess is that it should allocate 200 bytes.
If however PL/SQL variables Dynamic Memory Allocation then probably some
minimal as set by the PL/SQL Engine designers/programmers.
Aleem
-Original Message-
Sent: Wednesday, March 06, 2002 2:53 PM
To: Multiple recipients of list
Hi,
On which platform ?
On good solution is to have a firewall on each machine and a firewall
cluster in front of the production
Regards
Henrik
--
---
There's fun in being serious.
-- Wynton Marsalis
Henrik Ekenberg
Stripping??? I hope you meant striping, otherwise this discussion could be
taking a VERY unusual turn!
Paul
-Original Message-
Sent: 06 March 2002 01:38
To: Multiple recipients of list ORACLE-L
Kevin, let me introduce you to the world of stripping. Course, if
you are on old hardware
Our servers all are currently on LAN. We want Exchange to be accessible
through the Internet in April 2002 and Data Server around August 2002.
1- Data Server: Win 2k
2- MS Exchange Server 5.5, NT 4
3- PDC, NT 4
Aleem
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday,
Threads in Oracle on NT generally consume 1mb each
one. Therefore, Oracle provides an utility named as
ORASTACK executable name new stack size to change
this behavior.
Regards.
--- Reardon, Bruce (CALBBAY)
[EMAIL PROTECTED] wrote:
Sean,
I'm also interested in this and whilst I can't
provide
This was released yesterday:
http://otn.oracle.com/deploy/security/pdf/snmp_2002_alert.pdf
Oracle has fixed the potential vulnerability identified above in
patch/bug fix number 2224724.
===
Ray Stell [EMAIL PROTECTED] (540)
I activated a standby this morning and found that the archive
log number was reset back to 1. Could I have avoided this reset?
===
Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
--
Please see the official ORACLE-L
Can anyone supply a site or information about how to use Veritas software as it
applies to
databases?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Helen J Mitchell
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San
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)
Anybody wish to answer the following:
Why does this matter? Or is this an OCP exam question?
Personally, I fail to see the relevance.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, March 05, 2002 4:48 PM
To: Multiple recipients of list ORACLE-L
www.veritas.com
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Mitchell
Sent: Wednesday, March 06, 2002 5:03 AM
To: Multiple recipients of list ORACLE-L
Can anyone supply a site or information about how to use Veritas software as
it applies to
databases?
--
Initially is will be nothing unless test.col2 has a default value as
varchar2 structures are data_length followrd by actual string. The maximum
that p_in_one can have is 200 bytes thought due to its anchored definition.
The answer, none initially as it will be initializes to NULl value, then
You can handle ZERO_DIVIDE exception ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts,
Can anyone supply a site or information about how to use Veritas software as it
applies to
databases?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, March 06, 2002 6:03 AM
Can anyone supply a site or information about how to use
I believe that varchar2 is a null-terminated string (like in C). Varchar is the
string with the byte count at the beginning (like Pascal).
Jamadagni, Rajendra wrote:
Initially is will be nothing unless test.col2 has a default value as
varchar2 structures are data_length followrd by actual
I think it's an OCP - type question.
They ask questions like this, when in reality people just buy servers, and
if they need more space, they buy more disk...
.. .providing there aren't obvious problems with database design.
Does anyone really spend days figuring out the exact size of rows
Roland,
I highly recommend the ACCESS-L newsgroup.
http://www.lsoft.com/scripts/wl.exe?SL1=ACCESS-LH=PEACH.EASE.LSOFT.COM
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
I need to do a select based upon the time element in a date column.
i.e, eg where the time is greater than 14:00
Can anyone provide an example of how to do this?
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City
Varchar2 datatype is NOT null terminated in C or anywhere else that I can
think of. It is a 2 member structure one being the contents the other is
length of contents.
Rick
If it is an anomaly which is consuming
unexpected amounts of memory it may
be of interest to any site that is using a
lot of PL/SQL and is running into ORA-04030
errors on a regular basis.
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar - UK, April 3rd - 5th
Bear in mind that you cannot declare a procedure like this:
procedure blah(
pinvarchar2(200)
);
it has to be:
procedure blah(
pinvarchar2
);
So even though a declaration like Rob's
test.col_01%type
appears to tell Oracle that the parameter
is
Just curious - it's not like I'm trying to be mean or anything. I was just
wondering if this is an issue with certain types of applications. I
remember I had to worry about memory usage a *long* time ago when mainframe
systems only had limited core memory (anybody remember core memory?), and
From 9i DOC:Suppose a subprogram declares an IN
parameter, an OUT parameter, and an IN OUT parameter. When you call
the subprogram, the IN parameter is passed by reference. That is, a pointer to
the IN actualparameter is passed to the corresponding formal parameter. So,
both parameters
Of course: you have to justify the memory that your application is using.
There is a big difference between 200, 500, 2000 bytes.
Just kidding!
Regards,
Waleed
-Original Message-
Sent: Wednesday, March 06, 2002 10:08 AM
To: Multiple recipients of list ORACLE-L
Just curious - it's
This is NOT an OCP question, and there is a HUGE bit of relevance, and
it applies to something that we discovered in some legacy code here,
that applies directly to this question.
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette
Sorry and very good point. In this case, the question applies to OUT OR
IN OUT parameters.
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.
Hi,
? where to_char(date_field,'hh24mi') '1400'
or where to_number(to_char(date_field,'hh24mi')) 1400
Jack
John Dunn
Patrice,
Ahhh this is a think outside of the box type of question
has nothing to do with disk space... might have something to do
with having enough memory I suppose but given the answer
to this question, there are some nasty possibilities that might
well lurk that few have thought
One way would be the following
SELECT ...
FROM table
WHERE TO_NUMBER(TO_CHAR(date_field,'HHSS')) 1400;
Rick
John Dunn
This issue has some application specific application and possible
security implications (from a hacking point of view) I think.
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's
Hi -
We've encountered some problems with a Unix reboot and I'm trying to figure
out if we have any options other than copying all files back and doing a
full recovery.
The boot drive was bad on the machine (sun 2.6) and they unix sa replaced
it. When it came back up, all of the control files
Title: UTL_FILE is slow
Hi everybody,
We have a few applications that use utl_fiile to create rather large output files on a 8.1.6.0.0 database. The output via utl_file seems significantly slower than using spool. I see alot of other complaints on Metalink about utl_file in 8.1.6 being
post your script.
On Tue, 5 Mar 2002, Post, Ethan wrote:
Forgot something the call from inside the check_all_exfail.sh script looks
like this...
exfail.sh $EXFAIL_OPTIONS $ORACLE_SID
-Original Message-
Sent: Tuesday, March 05, 2002 10:23 PM
To: Multiple recipients of list
Jonathan,
I agree, but what I am implying (maybe a bit poorly) is that due to it's
anchored declaration, it will NEVER be longer than 200 bytes plus 2 for the
length. Initially it will still be 2 bytes plus a NULL string, unless the
column (to which it is anchored to) has a default value. Also,
By core memory do you mean the 18x18 blocks of doughnuts with the
wires in them that magnetized, read, or changed polarity of the
magnetization for zero or ones?
That was just a little before I was loading the boot strap loader with
the toggle switches on a computer. And a long time before the
On Wed, 6 Mar 2002, Ray Stell wrote:
I activated a standby this morning and found that the archive
log number was reset back to 1. Could I have avoided this reset?
If you are performing a planned failover, and you wish to convert the
presently running primary into the standby after the
Jonathan and all,
First, forgive me for not saying that I'd reveal the answer soon.
(probably Thursday). So please bear with me on that issue.
This is not designed to be an OCP type question, I do not think
you will find the answer documented anywhere as far as Oracle
is concerned (at least I
I am desinging a web base for user to open/update/close tickets using
oracle8i. My question is how do I setup to let user re-open a close ticket
for updating. I use SQL command delete to close ticket so the ticket
could not be re-open for updating. Please advise.
Thanks,
David
--
Please see
Do you have tape software such as Legato or NetBackup?
I have used it very successfully with both - makes backup and
recovery a breeze.
-Joe
--- Carle, William T (Bill), ALINF [EMAIL PROTECTED] wrote:
Hi,
I'm in the process of upgrading my database to 9i and I was
trying to decide
Rick,
don't you mean:
SELECT ...
FROM table
WHERE TO_NUMBER(TO_CHAR(date_field,'HH24SS')) 1400;
==
^^
:)
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, March 06, 2002 10:28
hmmm, the question of the day, a good one! I don't use it now but plan on using it.
The question is when :)
[EMAIL PROTECTED] 03/06/02 10:48AM
Hi,
I'm in the process of upgrading my database to 9i and I was trying to decide
whether I wanted to change my backup strategy to use RMAN. Do
Ethan --
As I understand it, your skip isn't working if there are multiple parameters
passed in, so that when you get your parameters and do your skip, you are
skipping one word and then the next parameter fails. If that is the case,
what you may want to do is parse out the multi-parameter
I've never tired this but could you ALTER DATABASE BACKUP CONTROLFILE TO
TRACE and then use that for a
CREATE CONTROLFILE?
If you don't have any data missing from your datafiles and all you need to
do is make your controlfiles current, this should do it.
i see my directory and i dont have any directory with this name net8/admin
;) what should i do?
You may have tnsname.ora under network/admin directory and another in
net8/admin directory. I think you will have only one listerner.ora file
under network/admin directory.
So make sure both
One of my first exposure to computers was as repairman on
a Univac computer which had a whopping 32K words of 30 bits
in each word containing only ferrite core memory. The program
was loaded from a 7-bit (2 octal digits, plus a parity bit)
magnetic tape drive. In such a system, every bit
I use it, I think it's great. Runs faster (if you multi-thread it), doesn't
put the tablespaces in hotbackup mode (doesn't freeze file header blocks),
and checks for corruption.
Tim Gorman has a good paper on his website (http://www.evdbt.com/) :
http://www.evdbt.com/TD_Rman.pdf
- Jerry
This is not true. the client does not communicate with the procedure. Oracle
shadow process does.
It's always a pointer.
regards,
Waleed
-Original Message-
Sent: Wednesday, March 06, 2002 11:58 AM
To: Multiple recipients of list ORACLE-L
I think we are talking at cross-purposes
I guess you need to include the minutes as well:
... to_number(to_char(date_field, HH24:MISS')) 14
otherwise the time 14:25:00 will not be greater than 1400
Witold
One way would be the following
SELECT ...
FROM table
WHERE TO_NUMBER(TO_CHAR(date_field,'HHSS')) 1400;
Rick
The problem is I am using getopt to process the switches...
while getopts :pg: option
do
case $option in
p) OPTION_p=Y ;;
g) GID=$OPTARG ;;
\?) print $OPTARG is not a valid argument. ; exit 0 ;;
esac
done
shift $(expr $OPTIND - 1)
After the shift, the $1 arg should be
Tom,
Ooops, Yes I did!!!
Thanks
Rick
Mercadante, Thomas F
Batman is experiencing some technical difficulty with his 'OnStar' service
;) Looks like Robin forgot to mail the payment... :(
Sorry, Jared... for the OT post..
-Original Message-
Sent: Tuesday, March 05, 2002 4:48 PM
To: Multiple recipients of list ORACLE-L
Riddle me
You should have flag on the ticket saying that ticket is closed, if you want
to reopen, a simple update would do the trick.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here
I use RMAN with veritas Netbackup and it is sweet. Recovery is ridiculously
easy: Even recovering to an alternative host (not as fast as cloning) is a
doddle and u can apply redo logs to the recovery to bring it up to current
time: All in all well worth the learning curve to set up
-
I am in the process of storing 32Mb image files into a 8.1.7 database, I
have set
pct_free to 0, but I left pct_used at 90 and the tablespace is locally
managed with a
uniform extent of 32Mb. The database has a db_block_size of 8k. I am
considering moving it
to 16k, as opposed to 32k, as it
What about the case where a client Pro*C
program (for example) has an embedded
anonymous pl/sql block which does:
begin
:local_target_variable := procedure xyz(:local_source_variable);
end;
You might also consider the warning that goes
with the NOCOPY option - to the effect that it
is not
Ethan, I had a similar problem when using the getopts
command when using it in conjuction with nohup and the
. I found by throwing ksh in the syntax everthing
worked. i.e. nohup ksh setup.ksh -a parameters
This may or may not work for you but it's worth a try.
Scott
--- Post, Ethan [EMAIL
The whole block gets transmitted to Oracle shadow process where it gets
executed there.
Sqlnet and the other layers take care of mapping host variables to Oracle
shadow process and the PGA.
There is no difference between your pro*C block and executing the same block
from sqlplus on your PC.
The
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
Just a thought - You can't install over Terminal Services Client. You must
be at a console. If you use Terminal Services, the install will appear to
complete properly, but the database will never work properly. Ran into
this on my first W2K install. Don't know if this helps, but you're
The correct answer is c, 4000 bytes, which is the defined max size
for a varchar2 in Oracle9i. This is what I was told directly last
week in a very lively discussion with two Oracle developers. So, Jonathan is
correct (and does that really surprise anyone?).
I have discovered that our
Come on Ramon, ever use OTN or read documentation?
See http://otn.oracle.com/docs/products/oracle8i/content.html ,
- scroll down until you find your platform and read the Installation
Guide and Release Notes.
They should also be on your CD.
-Joe
--- Ramon E. Estevez [EMAIL PROTECTED] wrote:
Hi
If one tablespace has 10 tables and 6 are fragmented table in that
particular tablespace.If I use COPY command to move data from one server to
another then is COPy command bring data with fragmented tables data?
Thx
-Seema
_
Solaris:
http://technet.oracle.com/docs/products/oracle8i/pdf/installguide_sun_817.pdf
Linux:
http://technet.oracle.com/docs/products/oracle8i/pdf/linux_installguide_817.pdf
HP-UX:
http://technet.oracle.com/docs/products/oracle8i/pdf/hp-ux_installguide_817.pdf
Ramon E. Estevez wrote:
I use it with 8i. We backup to disk.
What I like:
- Backups are faster.
- Backup files are smaller.
- Duplicating a test database from production is a breeze.
What I don't like:
- I find the report and list commands cumbersome. There have been numerous times that
I needed to go into the
It sounds like one of 2 things to me.
1) The disk partition(s) with your redo logs and control files were on the
root disk.
Bad idea.
2) The SA restored files other than just those needed for the root
filesystem.
Could be others, but that's what comes to mind.
Do you have control
Title: Message
That
wouldn't be a problem if anyone on the list had a few days to go over the
details, try TFM.
-Original Message-From: Ramon E. Estevez
[mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06,
2002 1:50 PMTo: Multiple recipients of list
ORACLE-LSubject:
So after the spam posting from RDC, I went and checked the features of
their Standby Wizard. Here are my findings. Note that I did not
use their product, but only read the manual, so they may not be as bad
as they appear from the manual.
From their user's manual it appears Standby Wizard:
-
No that did not work, thanks. I remember the command I am more specifically
looking for, it is a command that says to do expansion twice on a line,
anyone remember what this is?
basically if you have a variable that looks as follows
echo $FOO
-g dba apps
the double quotes will get exanded
Hi Seema,
define what you mean when you say 6 are fragmented.
John
[EMAIL PROTECTED] wrote:
Hi
If one tablespace has 10 tables and 6 are fragmented table in that
particular tablespace.If I use COPY command to move data from one
server to another then is COPy command bring data with
Exactly that . we don't know what the SA did, nor will he give us much
info. This will be pursued once we get all instances back up. We do have
the control files dumped to trace, but unfortunately, then it expects the
redo logs to be intact, which they are not. We are in the process of
Interesting,
Thank you
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient
Hi
Our university wants to set up a server that will provide groups
on campus with a standard set of services for web hosting, data
collection or whatever they want to do. As much as possible each
user should have their own isolated chunk of the server.
An Oracle database will sit in the
Thanks John,
I followed the steps told by you and It is really helpful to get the
required output.
Regds
deepender
I hope Oracle developers know
what they are talking about!How does this work:create or replace
procedure blah_blah ( p_in_one in out test.col_2%type )
as begin null; p_in_one :=
rpad('0',5000,'0'); end;
declare rr varchar2(5000); begin
blah_blah(rr); dbms_output.put_line(length(rr));
Jeremiah,
Thanks for the review. I did not realize we had been spammed, again!
Dick Goulet
Reply Separator
Author: Jeremiah Wilton [EMAIL PROTECTED]
Date: 3/6/2002 11:16 AM
So after the spam posting from RDC, I went and checked the features
Bruce:
You are correct in that you do not need a database to store the topology.
Instead it stores the topology in cache or using a replication-type
feature. Here is a white paper I wrote on setting up names. Hope this
helps.
IOUG Paper 103.doc
Thank You
Stephen P. Karniotis
Technical
AH HA!
just remembered it, eval
Let's see if this works!
-Original Message-
Sent: Wednesday, March 06, 2002 1:23 PM
To: Multiple recipients of list ORACLE-L
No that did not work, thanks. I remember the command I am more specifically
looking for, it is a command that says to do
go to
http://technet.oracle.com/docs/products/oracle8i/content.htmland
chose the flavor of Unix you like.
-Original Message-From: Ramon E. Estevez
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, March 06,
2002 1:50 PMTo: Multiple recipients of list
ORACLE-LSubject: Installation
It works because PL/SQL will internally reallocate memory as required. This
has to do with
non Oracle code (e.g. Pro*C) interfacing with Oracle code.
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can
And that is because PL/SQL "varchar2" type (used to
describe PL/SQL variables)hasdifferent max length (32767)then
database "varchar2" type (used to describe table columns), which is
4000.
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Khedr,
Waleed
Thanks to all that tried to help, that fixed it.
Surrounded the call from script A to script B with eval and it expands the
line the way I needed it.
eval exfail.sh $EXFAIL_OPTIONS $SID
Thanks,
Ethan
-Original Message-
Sent: Wednesday, March 06, 2002 1:23 PM
To: Multiple recipients of
On 9.0.1.2 the output is
5000
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building
Seema,
If you COPY the datafiles at the OS level then you are getting an
exact image of the datafile. The same for the RMAN copy command. If you
use SQL insert ,, select type of copying data from one server to
another then the data will fill the extents and eliminate fragmentation.
It will not
Bill - I'll take the contrarian stand, just so you see the cons as well as
the pros. I notice you say my database as in singular. If you truly are
responsible for a single database, I would argue that RMAN may be more than
you want to bite off. Most of us DBAs are paid as professional skeptics,
As far as I remember, the size of the host variable is part of the
parameters when you define or bind your variables. In any case, it's
true with OCI. Which means that when Oracle copies the data into your
variable, it's bounded. You may have truncated values, perhaps, but then
it's just a matter
eval foo.sh $FOO
Should do the trick...
--
James Morle
Scale Abilities, Ltd
http://www.scaleabilities.co.uk
Author of Scaling Oracle8i - Building Highly Scalable OLTP System
Architectures
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of
Post, Ethan
Ok here is my two cents:
First you asked what is the size of the parameter in PL/SQL procedure, and
we said it's not fixed size it's variable size depending on the returned
data.
Everybody knows that, so it's not 2000 or 4000.
Then you came and said you do not mean PL/SQL but you mean Pro*C.
Hi All!
I'm trying recovery TEST database from hot backup.
I create database with a couple tables. Make couple log switches to generate redo log
files (basically it's generate 3 redo log files: arch.log1_15.dbf
, arch.log1_16.dbf, arch.log1_17.dbf).
Then I run hot backup and backup all dbf
oh yeah, you just had to check the email address it came from ...when
the email matches the website address, I presume spam
--- [EMAIL PROTECTED] wrote:
Jeremiah,
Thanks for the review. I did not realize we had been spammed,
again!
Dick Goulet
Reply
Jeremiah,
Thanks for a useful and insightful response to that unapproved commercial.
Jared
Jeremiah Wilton [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/06/02 11:16 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Review? He just slaughtered the product!!! And hung it out to dry...
If the company is monitoring this list, they will quickly realize that
spamming was a mistake.
Which I am assuming was Jeremiah's intent all along...
--- [EMAIL PROTECTED] wrote:
Jeremiah,
Thanks for the review.
Greg,
How did you do your hot backup? Did you do the following for each
tablespace?:
alter tablespace tbsname begin backup;
!cp datafile1
alter tablespace tbsname end backup;
Mike
From: Greg Faktor [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Post, Ethan wrote:
AH HA!
just remembered it, eval
Let's see if this works!
Ethan,
It's a bit of fudging, but what you could also do is use another
separator than a space (eg : as in dba:apps) and then use cut or awk to
slice the argument.
--
Regards,
Stephane Faroult
Oriole Ltd
Genesis of a DBA Universe
In the beginning was the disk array, and all was empty
and raw, and UNIX moved over the face of the platters.
And the DBA said: Let there be Oracle. And there was
Oracle. And the environmental variables were set and
the disks were striped and mirrored and the OFA was
1 - 100 of 133 matches
Mail list logo