Hi
consistent gets are when the SQL needs the data in consistent mode i.e not the current
data. SELECT statements contribute to consistent gets (read from the RBS). DML
normally contribute to db block gets, but say an UPDATE based on a search criterion --
will contribute to consistent gets.
If
you want to reduce your consistent gets, you can reduce your sga size
-Original Message-From: Sultan Syed
[mailto:[EMAIL PROTECTED]Sent: 08 October 2003 14:14To:
Multiple recipients of list ORACLE-LSubject: consistent
gets
Hi,
What does the meaning for this
:)
-Original Message-
Sent: 08 October 2003 09:54
To: Multiple recipients of list ORACLE-L
did you just want to see it in an alert.log? or are you working with a
dump?
joe
Vergara, Michael (TEM) wrote:
Ok...strange request time. I want to test a script that I found
on the DBA
ora-600 may result your db down or crash
-Original Message-
Sent: 08 October 2003 10:09
To: Multiple recipients of list ORACLE-L
I want the DB to see and act on an ORA-00600, not just record
one in the alertSID.log
Thanks,
Mike
-Original Message-
Sent: Tuesday, October 07,
Thankz Mladen Govindan.
I do have Velpuri's book besides me.
let me go thro' it once again.
Regards,
Scott.
__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
--
Please see the official ORACLE-L FAQ:
How about...
declare
ora600 exception;
pragma exception_init(ora600, -600);
begin
raise ora600;
end;
/
show errors;
HTH
--
David Lord
-Original Message-
From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]
Sent: 08 October 2003 02:14
To: Multiple recipients of list
Hi,
Consistent gets means the blocks oracle have to visit , it means the real cost of
the SQL.(consisteng gets + db block gets)
Reduce SGA size has nothing to do with Consistent gets.
TO reduce consistent gets, only Tune the SQL or create proper index etc can help.
Zhu Chao.
Dbms_system.ksdwrt(2,'ORA-600: This is a test error message')
Writes a message to the alert log
Change the 2 into a 1 writes to trace file and 3 (I think writes to both)
Jack
-Original Message-
Sent: Wednesday, October 08, 2003 10:25 AM
To: Multiple recipients of list ORACLE-L
yeah rite, i just test u
-Original Message-
Sent: 08 October 2003 16:29
To: Multiple recipients of list ORACLE-L
Hi,
Consistent gets means the blocks oracle have to visit , it means the real cost of
the SQL.(consisteng gets + db block gets)
Reduce SGA size has nothing to do
Without wishing to start another Cary's Fabled Book thread, I've got my
copy of 10G Features on order.
BTW I should mention I found Cary's book in Leeds at the weekend and it is,
as trailed in this very group, a beauty.
Cheers,
Mike
-Original Message-
Sent: 07 October 2003 21:39
To:
Perhaps a flashback query would help???
-Original Message-
Wolfgang Breitling
Sent: Tuesday, October 07, 2003 5:55 PM
To: Multiple recipients of list ORACLE-L
Unfortunately it's not my ability to see into the future, but an
inability
to see all of the past.
Now what was that I was
I didn't ask for a comment, just a suggestion...or a hint...off the record.
Don't worry Raj, I'll stop by Mr. Freeman's house with a keg...soon he'll be
commenting a lot. If that doesn't work then I'll threaten to call him a SQL Server
DBA...
-Original Message-
Sent: Tuesday, October
You point out something that I've found most developers/DBAs don't
do... actually sit with the end user to see what the problem is.
This happens at the design end as well. I have seen way too many user
friendly applications that aren't, because the programmer wrote it for
someone at his/her
Does anyone have more info on this?
http://www.infoworld.com/article/03/10/07/HNoraclesmb_1.html
--
Dwayne Cox
Corporate DBA
Info Tech, Inc.
5700 SW 34th Street, Suite 1235
Gainesville, FL 32608
email: [EMAIL PROTECTED]
phone: 352.381.4521 fax: 352.381.
--
Please see the official ORACLE-L
Title: RE: Desupport of RBO
Chris,
Yes, thank you very much!
In a
way it will be simpler to have only one optimizer mode to take into
consideration. We will be able to analyze the whole database and leave it
at that.
I
assume that dbms_stats.gather_database_stats is smart enough to make
2 of the projects Ive been on I have not had any contact with clients. I wasnt even
allowed to speak to them. It all had to go through product managers, or the prime
contractor.
Its nice when your able to speak to your customer, but sometimes your not allowed to.
Ive been attacked by the
Title: Message
DEST_DIR=your_desination_directory
SOURCE_DIR=your_source_directory
for
file in `ls $SOURCE_DIR`
do
fn=basename $file
if [ ! -f $DEST_DIR/$fn ]
then
cp $file $DEST_DIR/$fn
fi
done
Hope
it helps.
Allan
-Original Message-From: Sujatha Madan
[mailto:[EMAIL
Title: RE: RE: Cary's Book - new topic
Cary,
We are doing exactly that on one of our databases. After hearing _few_complaints that DB is slow (code is not), we enabled trace at level 12 for power users. Now every AM my job is to analyze 20+ trace files that I get and report back.
Once we
go to metalink and check out trace analyzer. ITs a new tool for analyzing 10046
traces. Has ALOT more detail than tkprof. Major improvement. Its on metalink.
From: Jamadagni, Rajendra [EMAIL PROTECTED]
Date: 2003/10/08 Wed AM 09:14:25 EDT
To: Multiple recipients of list ORACLE-L [EMAIL
Title: RE: RE: Cary's Book - new topic
Or you can look into getting the Hotsos Profiler It would definitely be money well spent!
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 08, 2003 8:50 AM
To: Multiple recipients of list ORACLE-L
Mladen,
Not if you don't use micro$ mail clients!!
cheers
Pete
In article [EMAIL PROTECTED], Mladen Gogala
[EMAIL PROTECTED] writes
No problem! Just open any email entitled Latest security patch from
MIcrosoft and you'll execute an .exe file.
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web
Welcome to MY world :-(
Basically, we need to get a Volkswagen to run faster than a Ferrari.
-Original Message-
Sent: 2003-10-07 4:29 PM
To: Multiple recipients of list ORACLE-L
I went to IBM's web site (http://www-1.ibm.com/servers/eserver/zseries/os/)
and found OS/390 -
Hi everyone,
I'm back in the land of the living after spending a year on a DB2 EEE
project. I've just started working on a 9i RAC solution so the questions
will soon be flooding in. I will be lucky if I can even remember to spell
spqlusl , I mean sqlplus :-)
Cheers
Lee
Title: Message
Or was
it that we just ignored your post? ;o)
Dave
-Original Message-From: Sujatha Madan
[mailto:[EMAIL PROTECTED]Sent: Tuesday, October 07, 2003
11:29 PMTo: Multiple recipients of list ORACLE-LSubject:
IGNORE: Unix Help
Sorry ... but I solved it.
Now we know where the RBO went too!! They pulled it out of 10g and
stuck it into Oracle Standard Edition One. Duh. It's smaller, cheaper
it uses RBO. You gotta pay extra for CBO.
Sorry for stealing your thunder Mladen ...just borrowing it...you can
have it back now.
-Original
The question was posed to me about a simple web browser (non ssl),
accessing an oracle database and shooting the information across the
internet to a client, this info is NOT encrypted i assume.
is that also true for like remote sqlplus connections and if you wanted
it to be for web, you need
List,
from the following url on the application server you can resister for
the OTN session in your area.
http://www.oracle.com/appserver/ Featuring 10g for the grid.
Ron
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ron Rogers
INET: [EMAIL PROTECTED]
Fat City
Title: RE: RE: Cary's Book - new topic
Thanks,
I have been using that tool for a long time now, it needs a big tablespace (cause everything is loaded in tables) and puts a load on the server. It is good for smaller files, but takes too long on larger files.
Nevertheless it is a great
Ryan, Ian - Thanks for your replies. This helped get the developers talking
to BEA. It may come back to the database, but at least it got them looking
at possibilities beyond the database. Sometimes a statement from an outsider
carries more weight.
Thanks,
Dennis Williams
DBA, 80%OCP, 100% DBA
those sessions are typical all marketing and buzz word type training. you wont get the
goods until the product and the documentation comes out. i dont see the rush. it wont
be out until atleast 2nd quarter next year. Most shops arent even using 9i yet...
From: Ron Rogers [EMAIL PROTECTED]
I agree that it's common. But it's probably provably correct to say that
these sites cannot reach a targeted performance level as quickly or as
cheaply as if they would if they removed the constraint.
I know it's a slow, uphill battle. Getting ammunition together to fight
this battle is one of
Title: RE: RE: Cary's Book - new topic
http://www.eweek.com/article2/0,4149,1312906,00.asp
ASO should work here, although I've not used it personally (apparently it's rather
expensive). It's certainly not the only option, however. I've used OpenSSH's
tunneling capabilities for this purpose, for example, but there are a number of other
utilities which can do more-or-less the same
Guys,
Does it make sense to separate data and index segments into separate
tablespaces if you create a single logical volume and all files are
striped using the SAME methodology ?
Thanks
vikas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: vikas kawatra
INET:
the goal of government maintenance projects is not to get anything done. its to keep
the contract going and keep the revenues coming in. people dont want to work
themselves out of a job.
I think its one of the reasons people over do the CMM stuff. They can look good with
their processes, get
Hi Paul,
Have a look at the paper i wrote for security focus a few months ago,
called An Introduction to simple Oracle auditing - there is a link to
it on my site - http://www.petefinnigan.com/orasec.htm - its the second
paper on there. It is not in-depth but concentrates on the benefits of
just
Or you can tunnel sqlplus and many other programs through ssh.
-Original Message-
Sent: Wednesday, October 08, 2003 10:40 AM
To: Multiple recipients of list ORACLE-L
The question was posed to me about a simple web browser (non ssl),
accessing an oracle database and shooting the
sounds like bad error handling on BEA's part. i hate when vendors 'translate' database
messages to something else.
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 2003/10/08 Wed AM 10:59:26 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: BROKEN_PIPE during
Works like a champ, and didn't bring down the DB.
Thanks,
Mike
-Original Message-
Sent: Wednesday, October 08, 2003 1:25 AM
To: Multiple recipients of list ORACLE-L
How about...
declare
ora600 exception;
pragma exception_init(ora600, -600);
begin
raise ora600;
end;
/
show
At the moment, I'm more interested in the new governator of California
then Larry Ellison. Even if oracle is out, I'll be able to do other
things. As a former VAX/VMS system administrator, believe me, I know.
On Wed, 2003-10-08 at 11:29, Chris Stephens wrote:
Title: RE: RE: Cary's Book - new topic
it is
interesting. but who knows if this person's opinions are correct.
should we start "shorting" Oracle stock?
-Original Message-From: Chris Stephens
[mailto:[EMAIL PROTECTED]Sent: Wednesday, October 08, 2003
11:29 AMTo: Multiple
Hey good to see you back again Lee.
The big change here is that all Oracle knowledge has been cyber-engineered into an
automoton called Tanel Poder.
Any query to the list is routed by a big fast connection into a huge server with
hundreds of CPU's and unlimited memory
An almost instantaneous
I am wondering... Does anyone know if Oracle completed its transition to
LINUX?
Are they even running their backup servers to the linux platform?
The proof is in the pudding as they say, if Oracle converted even their
backup architecture to LINUX then you know LINUX is ready for the
I have the impression it's November perhaps December for 10G shipping.
Patrice.
-Original Message-
Sent: Wednesday, October 08, 2003 12:25 PM
To: Multiple recipients of list ORACLE-L
those sessions are typical all marketing and buzz word type training. you
wont get the goods until the
I suggest you buy your mushrooms from the supermarket like the rest of us
instead of picking them in those strange fields my friend
-Original Message-
Sent: 08 October 2003 17:25
To: Multiple recipients of list ORACLE-L
Hey good to see you back again Lee.
The big change here is that
Did you see this in the news?
http://www.theonion.com/3939/news1.html
Patrice
-Original Message-
Sent: Wednesday, October 08, 2003 7:34 AM
To: Multiple recipients of list ORACLE-L
Hi everyone,
I'm back in the land of the living after spending a year on a DB2 EEE
project. I've just
from Chap. 1 of Oracle Database 10g New Features on
http://otn.oracle.com/oramag/webcolumns/2003/techarticles/new_features_previ
ew.pdf
The Rule Based Optimizer (RBO) is desupported with Oracle Database 10 g. It
's still
there in Oracle Database 10 g, but Oracle is moving away from it quickly and
I'm just hoping that Larry won't loose interest in the next 10 years.
After that, he can sell out to CA anytime.
Mercadante,
Title: RE: RE: Cary's Book - new topic
Hotsos Profiler will handle it, no problem.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis101:
10/28 Phoenix, 11/19 Sydney
- Hotsos Symposium 2004:
March 710 Dallas
- Visit www.hotsos.com
Thank Stephane and Jacques for your reply. We are running Oracle 8.1.7.4,
but will upgrade to Oracle 9.2.0.3 soon. Partitioning works for some of our
tables. Are there other methods that allow us to avoid the problem of
unique constraint.
From: Jacques Kilchoer [EMAIL PROTECTED]
Reply-To:
I expect to find it under my Christmas tree on 12/25. I've been
a bad boy during the whole year, I deserve 10g for Xmas.
On Wed, 2003-10-08 at 12:39, Boivin, Patrice J wrote:
I have the impression it's November perhaps December for 10G shipping.
Patrice.
-Original Message-
Sent:
Vikas,
The answer is an enthusiastic yes. This is purely from
an administrative and manageability standpoint. For
example, if you have INDEX and DATA segments separated
in 2 different tablespaces, the backup of these
tablespaces can be done INDEPENDENTLY. This is
relevant, as if you were to
Title: Message
See
the four stepinvestment strategy I laid out in the feedback on the
article... It only involves one illegal action. ;-)
-Original Message-From: Mercadante,
Thomas F [mailto:[EMAIL PROTECTED] Sent: Wednesday, October
08, 2003 10:25 AMTo: Multiple
Welcome back!
Michael Milligan
Oracle DBA
Ingenix, Inc.
2525 Lake Park Blvd.
Salt Lake City, Utah 84120
wrk 801-982-3081
mbl 801-628-6058
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, October 08, 2003 4:34 AM
To: Multiple recipients of list ORACLE-L
Hi everyone,
I'm back in
Hi Paul,
Long time no talk/see. Hope things are well with you.
I personally don't think there is any need for concern
here. OraPerf still remains as a free analyzer, just
the way it did when it was Anjo's site. OraPerf is now
provided as a service, as part of the Veritas
Architect Network. The
Hello,
I upgraded my oracle version from 9.2.0.1 to 9.2.0.3 and now I am getting this error.
I collected stats on all the tables and still have this error. Any ideas?
--
Thanks,
Jake Johnson
[EMAIL PROTECTED]
__
Plutoid -
Thanks Gaja ! Does it also make sense from a performance perspective
(I/O issues due to concurrent access of index and data ) to separate
them or is that point moot once you apply the SAME methodology ?
-Original Message-
Gaja Krishna Vaidyanatha
Sent: Wednesday, October 08, 2003 9:24
Try this:
A shell script calling sql env to ANALYZE certain table. kill the process running the
shell script before it is done. You might get ora-00600 with argumrnt[1113]
Thanks
Pradhan
On Wed, 08 Oct 2003 Sinardy Xing wrote :
ora-600 may result your db
Title: Message
I've been looking to do this for a
while...would you mind sharing the script??
Thanks either way!!
chris
-Original Message-
From: Sujatha Madan
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 07, 2003
11:29 PM
To: Multiple recipients of list
ORACLE-L
No, I was too busy reading this:
http://www.welovearnold.com/
On Wed, 2003-10-08 at 12:39, Boivin, Patrice J wrote:
Did you see this in the news?
http://www.theonion.com/3939/news1.html
Patrice
-Original Message-
Sent: Wednesday, October 08, 2003 7:34 AM
To: Multiple
Did you collect system stats? In case everything else fails,
export will work with statistics=none
On Wed, 2003-10-08 at 13:49, Jake Johnson wrote:
Hello,
I upgraded my oracle version from 9.2.0.1 to 9.2.0.3 and now I am getting this
error. I collected stats on all the tables and still have
hi
i had a migration from 9.2.0.3 to 9.2.0.4 of a database and here are a couple of observations. please help me inunderstanding this.
i changed the db block size from 8k to 16k and all sql queires which were using nested loops earlier moved to sort merge joins. i ran 10053 and form whatever i
Hi. I have a query that seems to be waiting for a PS
enqueu for about 2 days. When querying the
v$session_wait, I'm getting the following:
SID EVENT S-I-WT P1
P2 P3
- - -- --
--- --
48
Hi List:
How to copy recursive files in Windows? like unix cp
-r
Thanks in advance,
Sami
__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Title: RE: How to copy recursive files in Windows? like unix cp -r
xcopy /s -- copies recursively if sub-dir is not empty
xcopy /e -- everything including empty.
Raj
Rajendra dot Jamadagni at nospamespn dot com
xcopy /e source destination
Example: xcopy /e c:\temp e:\
-Original Message-
Sent: Wednesday, October 08, 2003 2:59 PM
To: Multiple recipients of list ORACLE-L
Hi List:
How to copy recursive files in Windows? like unix cp
-r
Thanks in advance,
Sami
There are a number of reasons why you might get that error. The most
frequent one is probably that the NLS_LANG setting between the server and
the client are different. In Oracle 8i that prevented the export from
exporting existing statistics altogether. Oracle 9i does export the
statistics,
xcopy
-Original Message-
Sent: Wednesday, October 08, 2003 2:59 PM
To: Multiple recipients of list ORACLE-L
Hi List:
How to copy recursive files in Windows? like unix cp
-r
Thanks in advance,
Sami
__
Do you Yahoo!?
The New Yahoo! Shopping - with
use xcopy /S or /E
C:\help xcopy
Copies files and directory trees.
XCOPY source [destination] [/A | /M] [/D[:date]] [/P] [/S [/E]] [/V] [/W]
[/C] [/I] [/Q] [/F] [/L] [/H] [/R] [/T] [/U]
[/K] [/N] [/O] [/X] [/Y] [/-Y] [/Z]
Very Much expected behaviour. Your increase in the db_block_size from 8 to
16, is making the optimizer choose full table scans, where applicable,
since you have to scan through only half the number of blocks now.
A nested loop will starting throwing the initial results faster. A sort
merge join
Did you remember to cut the db_file_multiblock_read_count
in half, since you doubled the blocksize? I would assume that you also started
seeing more full table scans, as well.
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
Life is like a sewer, what you get
out of it depends on
Vikas,
Spend an hour on reading this usenet thread:
http://groups.google.nl/groups?hl=nllr=ie=UTF-8oe=UTF-8threadm=brjz8.15%24707.245%40news.oracle.comrnum=1prev=/groups%3Fhl%3Dnl%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26q%3Drogers%2Bseparate%2Bdata%2Bindex
It will open your eyes about separating
tried that too.infact i changed the db_file_multiblock_read_count to a very small value about 1/8 of the previous value. for it to move from SM to NL in only one case.
generally,it is using SJ only.and right i have started seeing a lot of full table scans.
apparently the general recommendation
OK, I know I must be doing something wrong, would somebody please point
out what it is? I would like to set up a job to sync an intermedia text
index. Here is my job:
SQL select what from all_jobs where job = 2;
WHAT
-
Title: Message
Raj
(and all who use Oracle's Trace analyzer,
I
'converted' the trace analzyer tables to GTTs, and no longer had the space
issues with large trace files. This is because the data is stored 'temporarily'
and is used for reporting in a subsequent SQL in the same session
Title: Message
How
big are your sort_area_size and hash_area_size? I would guess that your
hash_area_size is set very small when compared to your sort_area_size I know
that won't move the queries back to using a NL, but I've found that in most
cases a hash join is much more efficient
bill
this is a bug..infact it was happening in 8i and oracle said they will try to fix in 9i.
u have to call the procedure in the ur job and embed the sync index in ur procedure.
here is a snippet.u can try this way.
create or replace procedure i_doc_sync
is
begin
ctx_ddl.sync_index(
Title: Message
God that you mentioned ... I am doing the same thing ... changing the
code.
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any
How does one keep CBO statistics for an applications base tables up to
date?
We are about to implement the CBO any must read documents.
Many thanks
bob
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bob Metelsky
INET: [EMAIL PROTECTED]
Fat City Network Services
Title: Message
Sai,
Thank
you so very much! It worked perfectly!!!
Bill
Bill TantzenUniversity of Minnesota
Libraries[EMAIL PROTECTED]612-626-9949 (office) 612-250-6125
(cell)I
guess the man's a genius, but whata dirty mind
Pete,
I readyour paper before I turned auditing on (in the first place). I've spent many an evening reading papers posted on your site and on the sans.org site.
I haven't picked up your book in awhile, but I'm due to do so in updating our install docs for Oracle 9i on w2k3 svr. Has content been
For stubborn files, or if an error occurs during the copy, this uses the
/c switch
FOR /d %a in (G:\some\location\*) do xcopy *.* /s /c
H:\someother\location
This essentially forces the xcopy through the source directory,
sometimes useful for copying off of cds where the data can be
temporarily
Title: RE: how to keep statistics up to date for CBO
I like to use a cron job that runs the following in SQL Plus:
begin
dbms_stats.gather_schema_stats(ownname= 'YOUR_SCHEMA_NAME', options= 'GATHER AUTO');
end;
You should search the Oracle docs for your version of Oracle (you didn't
Title: Message
I am trying to issue the following command in SQL*PLUS but it
doesn't like the space between 'program' and
'files'.
Can
anyone tell me how to get around this?
echo select 'host c:\program
files\resource kit\robocopy;' from dual;
Thanks!
Ron
Smith
Hi:
I just installed Oracle 9.2.0.1.0 on our Solaris 9 box for the 1st time. I
let the installation to create a sample db. Now I am trying to see where I
can find the db creation script, so I can study it and use it to create db
instance manually. I can only find a bounch of log files in
So Lee... As an experienced Oracle guy, what are your thoughts about DB2?
-Original Message-
Sent: Wednesday, October 08, 2003 12:40 PM
To: Multiple recipients of list ORACLE-L
I suggest you buy your mushrooms from the supermarket like the rest of us
instead of picking them in those
Hi Hans/Vikas,
I tend to agree that the old draconian rule that thou
shalt always separate indexes from tables may not
apply any more. We used to apply that principle in the
past when the number of available spindles was not
adequate. Seems like with 256G drives in the market,
we are being pushed
Ron,
It works as you requested on 8.1.7.4.
Ron mª¿ªm
[EMAIL PROTECTED] 10/08/03 05:34PM
I am trying to issue the following command in SQL*PLUS but it doesn't
like the space between 'program' and 'files'.
Can anyone tell me how to get around this?
echo select 'host c:\program
Ron,
First of all, is echo a SQL*Plis command?
Secondly, I think this will do what you want:
select 'host c:\program files\resource kit\robocopy' from dual;
as long as what you want is to execute the robocopy program from the
SQL*Plus prompt.
If you want to do something else, clarify your
Sorry, this is what I am trying to run. But again, it barfs on the
'program files' portion of the script.
I have tried with and without quotes.
set heading off;
set feedback off;
set linesize 1000;
I completely agree with Howard about one thing: indexes and data don't
necessarily compete against each other for I/O capacity.
So the following is *not* true: You should separate indexes and data
into different tablespaces because they compete so strenuously for I/O
capacity.
However, the
What is echo supposed to do? The proper command
should read like this:
select 'host /program\ files/resource\ kit/robocopy' from dual;
On Wed, 2003-10-08 at 17:34, Smith, Ron L. wrote:
I am trying to issue the following command in SQL*PLUS but it doesn't
like the space between 'program' and
Microsoft issued this critical update on the 3rd, which I found out about,
when I did a Windows Update from my IE.
Try using double quotes:
select 'host c:\program files\resource kit\robocopy
f:\oracle\oradata\llbot1\archive\ e:\BACKUP\llbot1\HOT\arch /Move;' from
dual;
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Smith, Ron L.
Sent: Wednesday, October 08, 2003 5:05 PM
To: Multiple
%ORACLEHOME%\rdbms\admin\build.db is one of them check this script which
calls several others
bob
-Original Message-
Sent: Wednesday, October 08, 2003 5:39 PM
To: Multiple recipients of list ORACLE-L
installation)?
Hi:
I just installed Oracle 9.2.0.1.0 on our Solaris 9 box for the 1st
Never mind. The error was related to another problem with the script.
Thanks!
Ron
-Original Message-
Sent: Wednesday, October 08, 2003 5:24 PM
To: Multiple recipients of list ORACLE-L
Try using double quotes:
select 'host c:\program files\resource kit\robocopy
Title: RE: OT - Microsoft Security Bulletin MS03-040 (828750)
Can you get to the Windows Update web page? If so does it freeze at 0% or 33%? If so there are some fixes available. If you can get to the web page, there's a button towards the bottom left for help with Windows Update. Check in
Two options:
1. Change \program files\ to \program~1\
That should execute with no problems.
2. Another tact:
select 'host '||chr(34)||'c:\program files\resource kit\robocopy'||chr(34)||
' f:\oracle\oradata\llbot1\archive\ e:\BACKUP\llbot1\HOT\arch /Move;' from
dual;
Hi List:
I have
Database DB1
Table name T1
Column Name C1
C1 has some japanese character
Database DB2
Table name T2
Column Name C2
I want to update C2 column(only one record) with C1
column value.
Note:-
Exp/Imp AND db_link is not possible
===
Any help
1 - 100 of 128 matches
Mail list logo
