Hi,
Von: Baswannappa, Shiva [mailto:[EMAIL PROTECTED]
Gesendet am: Montag, 30. Juni 2003 18:09
1. Have the UTL_FILE write to a file in directory called
'printdir' (you can
name it whatever you like)
.
that is exactly the way it is running right now but our customer
had to change it's
Dear Friends,
I am willing to buy Oracle DBA 9i books. ,I need your suggestion on this.
I got information friends from this list that the book (Practical Oracle 8i
- Jonathan Lewis.) is practically good. Even I am also looking for the
same kind of book, But I want it for both 8i and 9i. It
Title: RE: Oracle unlimited concurrent license
Depending on the type of data/application ; one can buy licensing based on the CPU, nbr of CPU's within the nodes. For example; what if you have a n-tier application where the data maintained within the Oracle RDBMS is exposed to an un-countable
Title: RE: Oracle DBA 9i Books ever needed.
If you are anywhere near around Jonathan, he will _upgrade_ the book to 9i version for you ... he even showed us how at Hotsos/2003 ...
I think his book is still valid for 9i as well ...
Raj
Unless you management has a very OLD license agreement with Oracle, which I believe
have all been replaced, then their wrong and you are right. Now if you have a named
user license upgrade your processors with no worry. But if your running on a
processor license or an older power units
Anyone take this? Is it worth doing? There are a ton of 9iAS documents on OTN, any
idea which ones to read for this certification? Its only one test, so I dont know how
broad reaching it is.
i think the cert is pretty new so probably not too many people with it.
--
Please see the official
Frank,
Could you use an extproc call to handle the printing of the file then
deleting it?
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, July 01, 2003 3:35 AM
To: Multiple recipients of list ORACLE-L
Hi,
Von: Baswannappa, Shiva
A musical? Is this what militant extremism is coming to?
...I'll admit though, I'm more inclined to give into the demands of
extremists who won't cease singing, rather than give into the more
traditional actions taken by militants...
All right already! I'll trash all my RAID-5 storage and
Title: RE: 9iAS admin certification
it is only an associate, though...
the description of what to study looks like it is EXTREMELY broad
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
You will recognize your own path when you come upon it, because you will
Hi Von
If you do not want to have any opportunity to expose any external person or
process to tamper the output file, then I think one way you could achieve it
is by writing a report and run the report and print it directly to the
printer. That would be just a bit of a work but it will meet the
Thanks for this link, Dave.
Regards,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 10:19 AM
I want to share this link with the listers. It is a good article on
Oracle locally managed tablespaces with some good info
Now you have made them really mad. Now you will be forced to listen to
their singing *AND* their accordion players!
-Original Message-
All right already! I'll trash all my RAID-5 storage and
replace it with
RAID10!!! For the love of mercy, just PLEASE STOP SINGING!!!
--
Please
Hi Group,
In one of our client place we are having Oracle 8.1.7 (std Ed) on NT.
Here we need to send mails if the DB is down or if the listener is down or
any errors in the alert log is found. In Unix we can use shell scripts and
awk to do this. What about in NT/
Guru's do you have any
Even the global_name can be different from the SID and db_name.
Everytime I clone a database from a hot backup the SID name is different
but the db_name is the same till I
complete the recovery. Then I change the db_name as well. 9 times out of
10, I forget to change the global_name --
1. I have configured RMAN for controlfile autobackup, so that every DB
backup produces a backup of the controlfiles and spfile as well. With
these, I can easily recover from a loss of every single database file.
I can't imagine why anyone wouldn't do it this way (reponses invited).
2.
if i want to start learning 9iAS where do I start. I assume concepts document. What
else is good to read? There is too much stuff there for me to narrow it down?
From: April Wells [EMAIL PROTECTED]
Date: 2003/07/01 Tue AM 10:19:40 EDT
To: Multiple recipients of list ORACLE-L [EMAIL
Rajuveera
Are you seeking a book on DBA (administration) or performance tuning or
real time database design? The more specific the question, the more likely
the answer will match your needs. If you have some books, don't be shy about
mentioning them so you don't just get recommendations that
Hi listers,
I am working on a nt script. I download FORFILE exe, it works fine. My
intention is finding the ORA-03113 string in the log. If there is a
match, then reboot the server, else do nothing. I don't have problem
with the findstr part. However, the errorlevel always return 0, no
matter it
Hi Dick,
Could you use an extproc call to handle the printing of
the file then deleting it?
I have never tried to use extproc, nor have I done dll function calls out of
PlSQL.
What version of Oracle can do this. We are using 8.0.6. Is it able to do
that ?
Someone give an example, on howto
I don't know much about 9iAS, but one technique that has served me well when
I need to learn a broad new subject like this is a glossary. Once you
understand all the unfamiliar terms they use (and even familiar terms that
are used in a different sense), you are well on your way to being able to
I haven't like SPFILEs either -- haven't got used to them. When I do use
an SPFILE, I have a backup initsid.ora pfile available.
Hemant
At 01:29 PM 30-06-03 -0800, you wrote:
And another thing. If in pre 9i days you tried to allocate more than 2gb
to the Oracle.exe process, just cause you have 9i
Hi:
Does anyone know if I can pass an array in perl to an sql using DBI/DBD so
that I get result set from Oracle?
Specifically, I want do something like in perl:
$sth = $dbh-prepare ( select tab1.col1, tab2.col2 from tab1, tab2
where tab1.ID1 = tab2.ID2
and tab1.X = ? );
my
Depends on who you talk to. Our sales rep is a bit of a bulldog,
and he had no problem with our power units license.
Same with some consultants that checked it out, and their business
is managing software licensing.
Jared
On Tuesday 01 July 2003 06:24, Goulet, Dick wrote:
Unless you
FYI
One of my friends at Microsoft, (yes I must to
confess, I have friends at MS) gave me a present,
it's a 4 cd's kit called SQL Server 2000 for the
Oracle Customer, the kit consist in 4 cd's with
demos, docs, presentations, videos and a lot of stuff
showing why sql server is a better option as
Title: RE: RE: 9iAS admin certification
From what I have been able to determine... you pretty much have to read everything and hope you remember something for the test.
There is supposed to be a book out by WROX publishing... It is 'supposed' to be out in May according to Amazon... I thought
There's great freeware smtp client called BLAT that you can use. You
can probably google search for it or find it on www.download.com
HTH.
-Original Message-
Sent: Tuesday, July 01, 2003 11:20 AM
To: Multiple recipients of list ORACLE-L
Hi Group,
In one of our client place we are
Tks Stephane and Madlen,
Still the same problem.
I added the hint /*+ FIRST_ROWS */ to the query that invoke the function
and it changed from FTS to use Index but still have the same problem. I
added the same hint to the function and
Nothing.
I checked the v$session_wait during the execution
Which reminds me, I somehow missed that when cloning a
SAP db last weekend. Guess I'll go fix it now.
On Tuesday 01 July 2003 08:34, Hemant K Chitale wrote:
Even the global_name can be different from the SID and db_name.
Everytime I clone a database from a hot backup the SID name is
Title: Upgrade 8.1.7.3.0 to 8.1.7.4.1 on W2K
Hi All,
We have a test machine with both the 81730 and 81741 software in their own oracle homes.
We now want to move a database from the 81730 home to 81741
I know I have to run the catalog.sql, catproc.sql from the new home etc...
But how do
echo off
@cls
find ORA-124 C:\yourlog.txt NUL
IF ERRORLEVEL 1 GOTO no
IF NOT ERRORLEVEL 1 GOTO yes
:no
ECHO NOT FOUND
goto end
:yes
ECHO String IS found
pause
goto end
:end
exit
Hi listers,
I am working on a nt script. I download FORFILE exe, it works
fine. My intention is
Joan:
Where did you get the FORFILE.EXE program from? And, yes I will look at the
NT script.
RWB
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly
Hey, we can kill Martians by singing. Have you ever seen Mars Attacks?
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, July 01, 2003 11:09 AM
To: Multiple recipients of list ORACLE-L
Now you have made them really mad. Now you
you can use perl from activestate.com. run your awk script through a2p and
see if it works. there are many mail modules... Mime::Lite, Mail::Send to
name a couple.
On Tue, 1 Jul 2003, Senthil Kumar D wrote:
Hi Group,
In one of our client place we are having Oracle 8.1.7 (std Ed) on NT.
Everything I have seen says no. I did the following.
Set PCTINCREASE = 0
Set my initial and next extents to 5m so they are uniform. A woman I work with swears
there is Oracle documentation that in 817 PCTINCREASE should be greater than 0 because
the default is 50.
ORA-03232 unable to
There have been over 10,000,000 entries made in the National Do Not Call
Registry since Friday June 27. Does anyone know the database engine in
which this is stored?
Curious in Bozeman, MT
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Orr, Steve
INET: [EMAIL
I'm now working on the problem of restoring a database
from one server to another, with different directory
locations and names. ( on Windoze )
I've got the syntax down, but there's something missing
in the Veritas docs, and I'm not quite there yet.
Guess I'll have to call Veritas support
Try telling it very nicely. :)
Try looking in the registry under HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE.
You can change the home location of the appropriate instance (HOME0, HOME1,
etc.) there. Change it in the main Oracle directory then in the individual
HOME(n) folder.
I hope this helps.
I got it from http://www.ipass.net/davesisk/oont_download.htm
[EMAIL PROTECTED] wrote:
Joan:
Where did you get the FORFILE.EXE program from? And, yes I will look at the
NT script.
RWB
Title: RE: Microsoft VS Oracle (again)
Aargh ...
you must be very brave telling a Oracle cult to move to SQL Server ...
How do we know you are not Billy G using an alias ...
8)
Raj
Rajendra dot Jamadagni
we've started them recently -- only had two so far, part 1 and 2
presentations/interactive sessions on extreme programming
the goal is to get us talking across the various application groups,
spread knowledge, learn some of the newer techniques out there.
No one has (yet) asked me to do one or
Hi,
I think FORFILES is probably overkill here. And it probably is only
going to return the errorlevel for the last file checked. Just use
FINDSTR with a wildcard.
FINDSTR /S /I /L ORA-03113 d:\pslogs_psfm\fmdev8\_psprcsrvlog\*.log
if errorlevel 1 goto run_proc
echo 'there is a match'
if
Greetings,
Non-zero PCTINCREASE causes unnecessary free space
fragmentation in your tablespaces and should be
avoided. Especially in 8.1.7, where there is no need
for this, given that locally-managed tablespaces are
supported, where PCTINCREASE is NOT even relevant. If
you use
One of the
Thanks Seefelt,
I need to get the most recent log to check. There are more than 30 logs
on that directory. I just check the most currenct one. That's why I use
d+0 still it give me 2 files. Is there any way I can just get one file?
Jon
Seefelt, Beth wrote:
Hi,
I think FORFILES is
Hi Bob, thanks for the reply. I added your code and tested still no
good. I tested the case without a match. Still go to run.
Joan
D:\oracle\adminFORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s
-m*.log -d+0 -cCMD /c echo @FILE
PSPRCSRV_PSNT_0630.log
PSPRCSRV_PSNT_0701.log
D:\oracle\adminecho
Title: RE: Do Not Call
Paradox for DOS
-Original Message-
From: Orr, Steve [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 01, 2003 2:00 PM
To: Multiple recipients of list ORACLE-L
Subject: Do Not Call
There have been over 10,000,000 entries made in the National Do Not Call
Title: RE: Any Collaboration Suite or 9iAS listservers?
Guys,
Are there any 9ias listservers for admins? What are the best references for 9ias for admins. related to security, load balancing, performance tuning, high-availability.
Thanks,
Paula
-Original Message-
From: Larry
thank you. new project for me, so if im going to argue with someone who has been here
for a while... want to be safe.
From: Gaja Krishna Vaidyanatha [EMAIL PROTECTED]
Date: 2003/07/01 Tue PM 02:25:00 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Should percent
We had
these at the last place I was at... The senior folks from the various
teams would get together... One person or group was designated to present
a topic for the next meeting... Neat idea but it
failed at that location... The reason? The VP of App Dev decided he
wanted to attend the
I misspoke--there ARE in fact orphan records in the child table, and
they're the ones inserted by the import on the primary. So this would
seem to be a problem of the order in which operations are applied on
the standby--perhaps due to parallelism in the apply process.
Am I making any sense
For the mail part use...
On this page -
http://www.interlog.com/~tcharron/blat.html
Download and install his file -
http://www.interlog.com/~tcharron/blat194.zip
To send mail from a *.bat script- blat %myfile.log% -subject
%mysubject% -to %toaddress% -f %fromaddress%
Don't run it line by line
Save it to a file called myfind.bat
Then call from a command prompt
C:\ myfind.bat
Or click the batch file, be sure to leave the pause so you can see an
error if any. Once its working, you can then implemet blat as someone
suggested
Here is a version using
Title: RE: Do Not Call
Turbo Pascal Database Toolbox
http://www.emsps.com/oldtools/borpasv.htm#tpdb
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Another month has ended.
All Targets Met. All Systems Working.
All Customers Satisfied. All Staff Enthusiastic.
All Pigs Fed And Ready
if i get you right - you're trying to treat the resultset from a query as an
array in Perl. That's the way it works. Try something like this:
$sth = $dbh-prepare ( select tab1.col1, tab2.col2 from tab1, tab2
where tab1.ID1 = tab2.ID2
and tab1.X = ? );
my $resultset =
Title: Message
Don't
know if what we do in our shop here qualifies for your question or not, but our
dev groups do "stand-up meetings." Relatively quick meetings (that can be done
standing up; no meeting rooms required) that are usually finished in about 20
minutes. In the stand-ups, we get
Guys,
Help me figure this one out. Was helping a colleague
diagnose slow response time (8.1.7/Solaris running
Peoplesoft ). x$bh showed 102,248 out of 170,000
buffers belonged to a single table, which he said he
cached explicitly. He did NOCACHE (on my suggestion)
on the large table.
I still
On which unix boxes does SQL Server work? I don't want to
replace all of my AIX, HP-UX and Solaris boxes with NT.
I'll consider SQL Server as a replacement as soon as it starts
operating on Unix. Microsoft operating systems have spurned the whole
industry trying to protect them from viruses,
Hi Seefelt,
with or without match, I added ORA-03113 and deleted it later to test
both case. They all run ERRORLEVERL 1 condition. No matter what.
Joan
CODE:
FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log -d+0 -cCMD
/c type d:[EMAIL PROTECTED]|findstr ORA-03113
IF ERRORLEVEL 1 (
http://uptime.netcraft.com/up/graph/?host=www.donotcall.gov
Well, if it were unix then it couldn't be SQLserver. It is Windows,
therefore I assume its SQLserver, but it could be Oracle. But who runs
Oracle on Windows anyway *hahahaha*
[EMAIL PROTECTED] 07/01/03 02:29PM
Paradox for DOS
Probably MS Access.
My $0.02 worth,
Ken Janusz, CPIM
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 01, 2003 12:59 PM
There have been over 10,000,000 entries made in the National Do Not Call
Registry since Friday June 27. Does
mmm maybe I was not clear, my intention was to show
you what I call the MS's desperated cry for help.. I
love Oracle! for ever!
I just want to hear some comments about the 'facts'
they put there, I mean, how much is true?
;-)
--- Jamadagni, Rajendra
[EMAIL PROTECTED] wrote:
Aargh ...
you
Yes.
FOR /F %x in ('dir /b /od d:\pslogs_psfm\fmdev8\_psprcsrvlog\*.log') do
FIND ORA-03313 %x
if errorlevel 1 ( echo 'there is a match'
d:\start_proc.bat )
goto :EOF
What this does is list each file in order of oldest to newest. It does
the FIND on each one, but the
SQL server on Unix lets see.That would be none.
SQL Server doesn't even run on Windows much less any other platform...
Bwahahahahahaha...
sorry...I got carried away...
-Original Message-
Sent: Tuesday, July 01, 2003 2:00 PM
To: Multiple recipients of list ORACLE-L
On which unix
Small correction
FOR /F %x in ('dir /b /od d:\pslogs_psfm\fmdev8\_psprcsrvlog\*.log') do
FIND ORA-03313 %~fx
if errorlevel 1 ( echo 'there is a match'
d:\start_proc.bat )
goto :EOF
And when you use FOR in a bat file, you have to replace all % with %%
-Original
Bob,
I tested it out, it works on one hard code file. If I set thisfile it
works. But in reality, I need to find today's log, the log file name
convention is always goes psprcsrv_psnt_0701.log with the date suffix to
the end. I can't hard code the file name in the bat file. Is there
anyway how to
there is an animal that once looked very much like SQL Server (could be an
identical twin). it does run on your favorite flavor of Unix and Linux.
it's called Sybase Adaptive Server Enterprise :o)
-Original Message-
Sent: Tuesday, July 01, 2003 2:00 PM
To: Multiple recipients of list
Title: RE: Do Not Call
They
contracted with Halliburtonthey then subcontracted withAccenture to
design and build a RDBMS engine from open source code (they outsourced it to a
guyin Jaipur).
900
million Halliburton gets 700 million, Accenture199.999
millioncontractor got $15/hour
By tech meetings, do you mean status type meetings or learning type
meetings?
-Original Message-
Sent: Tuesday, July 01, 2003 11:30 AM
To: Multiple recipients of list ORACLE-L
List,
Just wondering if your organization has tech meetings, and what is discussed
and what the goals of the
A little of both! I would think there is some how do plan to do this, or why is that the recommended way of doing it type questions and answers sessions.
DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
By tech meetings, do you mean status type meetings or learning typemeetings?-Original
Thanks! This does help me.Rudy Zung [EMAIL PROTECTED] wrote:
Don't know if what we do in our shop here qualifies for your question or not, but our dev groups do "stand-up meetings." Relatively quick meetings (that can be done standing up; no meeting rooms required) that are usually finished in
Title: RE: Microsoft VS Oracle (again)
You missed the smiley ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having
Good information! Thanks for the heads up on the pit falls."Johnston, Tim" [EMAIL PROTECTED] wrote:
We had these at the last place I was at... The senior folks from the various teams would get together... One person or group was designated to present a topic for the next meeting... Neat idea but
Correct. FORFILES will not work.
-Original Message-
Sent: Tuesday, July 01, 2003 3:20 PM
To: Multiple recipients of list ORACLE-L
Hi Seefelt,
with or without match, I added ORA-03113 and deleted it later to test
both case. They all run ERRORLEVERL 1 condition. No matter what.
Joan
No. I want to reduce the numebr of sql calls.
For example,
@my_array = (1,2,3);
I don't want to do
select tab1.col1, tab2.col2 from tab1, tab2
where tab1.ID1 = tab2.ID2
and tab1.X = 1;
select tab1.col1, tab2.col2 from tab1, tab2
where tab1.ID1 = tab2.ID2
and
ok - that makes more sense. sorry for misinterpreting the question. i've
never done it, but my first instinct would be to explore using an in clause
in the query -
select tab1.col1, tab2.col2 from tab1, tab2
where tab1.ID1 = tab2.ID2
and tab1.X in (1, 2, 3)
can you simply
This could be called training and we have no budget for training
If it wasn't for the constant change and lack of communications I think
I would be bored here.
Ronmô¿ôm
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ron Rogers
INET: [EMAIL PROTECTED]
Fat
Nah... Too current. It's probably COBOL/ISAM.
-Original Message-
Sent: Tuesday, July 01, 2003 1:15 PM
To: Multiple recipients of list ORACLE-L
Probably MS Access.
My $0.02 worth,
Ken Janusz, CPIM
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Ramon,
I have had a closer look at your coe. My gut feeling is that
SELECT MAX(A.ACM_FECACUM),
Nvl(A.ACM_ACUMDBANT,0) -
nvl(A.ACM_ACUMCRANT,0) +
nvl(A.ACM_ACUMDB,0)-
nvl(A.ACM_ACUMCR,0)
Write your daily file to a 'nodate' file. Then copy it to a date file for
backup. Run your script against the 'nodate' file.
Ron
-Original Message-
Sent: Tuesday, July 01, 2003 2:51 PM
To: Multiple recipients of list ORACLE-L
Bob,
I tested it out, it works on one hard code file. If
oops! My apologies for not posting the solution to the list. Thanks
for covering for my oversight Jared. *sheepish grin*
Dwayne
Jared Still wrote:
FYI, if any of you are using the dbup.pl script
from the PDBA toolkit:
The solution to Dwayne's problem was to change
the following line in
Title: RE: Microsoft VS Oracle (again)
Well, I'll be a little more forgiving than Raj has
been. Basically MicroSoft is just the "pot calling the kettle
black".
On the issue of price, well yes MicroSoft does have an
edge, but that's just how they've eliminated all of their other
Now wait a minute, isn't that suppose to be
a government web site? Therefore it must be a flat file processed by an
Ada backend.
Dick GouletSenior Oracle DBAOracle Certified 8i DBA
-Original Message-From: Gene Sais
[mailto:[EMAIL PROTECTED]Sent: Tuesday, July 01, 2003 3:10
PMTo:
Now, now, Microsoft has made some very useful desktop caliber applications, including
SQL Server.
[EMAIL PROTECTED] 07/01/03 02:30PM
SQL server on Unix lets see.That would be none.
SQL Server doesn't even run on Windows much less any other platform...
Bwahahahahahaha...
sorry...I got
Or maybe RPGII and flat files.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 01, 2003 2:58 PM
Nah... Too current. It's probably COBOL/ISAM.
-Original Message-
Sent: Tuesday, July 01, 2003 1:15 PM
To: Multiple
The most useful thing that Microsoft has ever been
selling is Microsoft Xenix.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, July 01, 2003 4:11 PM
To: Multiple recipients of list ORACLE-L
Now, now, Microsoft has made some very
PCTINCREASE is a bad good thing. Every DBA that I know of hunts down objects with a
pctincrease other than 0 and resets them.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, July 01, 2003 12:25 PM
To: Multiple recipients of list ORACLE-L
Title: Message
Sounds
like that meeting was missing the middle letter "A."
-Original Message-From: Johnston, Tim
[mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 12:45
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Tech meetings
We
had these at the
Frank,
I've not done dll calls from Oracle as well, we use HP-UX and Linux, which I
believe is much simpler. Anyhow, along a similar lane, here's a snippet of extproc C
code that I've written to run an SQR from a PL/SQL call:
char *run_sqr(char *prog, char *uname)
{ FILE *sout =
None.
Hmmm, maybe if you run VMware on Linux then you can run
SQL Server from a virtual machine.
Richard Ji
-Original Message-
Sent: Tuesday, July 01, 2003 3:00 PM
To: Multiple recipients of list ORACLE-L
On which unix boxes does SQL Server work? I don't want to
replace all of my
Title: Message
The
best meetings should be like the most efficient SQL statements...
;-)
-Original Message-From: M.Godlewski
[mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 10:30
AMTo: Multiple recipients of list ORACLE-LSubject: Tech
meetings
List,
Just
Do you see only one distinct change#?
Note that if you got read only tablespaces, then it's ok to see more than
one distinct change#'s, but for read write's it should be the same.
Tanel.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel Poder
INET: [EMAIL
Hi!
Oracle can only guarantee database consistency and sanity when it's
underlying layers like OS and disk controllers do not fail.
Try:
Startup mount;
select distinct resetlogs_change# from v$datafile_header;
Do you see only one distinct change#?
Tanel.
- Original Message -
To:
Nope, does not work that way. I've seen it tried.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, July 01, 2003 4:15 PM
To: Multiple recipients of list ORACLE-L
None.
Hmmm, maybe if you run VMware on Linux then you can run
SQL Server from a
That actually makes it alot easier
FOR /F tokens=1-5 delims=/, %%i in ('date/t') DO SET MMDD=%%j%%k
if NOT EXIST psprcsrv_psnt_%MMDD%.log goto no_file
FIND ORA-03313 psprcsrv_psnt_%MMDD%.log
if errorlevel 1 ( echo 'there is a match'
d:\start_proc.bat )
goto :EOF
:no_file
not sure if this is what you want. one sql call
select tab1.col1, tab2.col2 from tab1, tab2
where tab1.ID1 = tab2.ID2
and tab1.X = ?
and tab1.X = ?
and tab1.X = ?
;
@my_array = (1,2,3);
sth-execute(@my_array);
On Tue, 1 Jul 2003, Guang Mei wrote:
No. I want to reduce the numebr of
Hi List,
Today I have dropped a big tablespace(4 Gig) as soon as I dropped it the
data file also disappeared from the list of datafiles, as I know the
datafile must be removed manually Any idea?
I am using 9.0.1 on solaris 2.8
Thanks,
Hamid Alavi
Office : 818-737-0526
Cell phone :
Title: RE: Do Not Call
IMS...
HDAM database!
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need.
~ Jerry Gillies ~
What about ones that you don't know?
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, July 01, 2003 4:11 PM
To: Multiple recipients of list ORACLE-L
PCTINCREASE is a bad good thing. Every DBA that I know of hunts down
objects
Not familiar with SQL*Server but why not? What's preventing it
from work? I run Oracle under a Linux environment which runs
in VMware for my dev and test. Also run a RAC under Linux using
VMware. Other people have done RAC running under Windows under VMware.
So, what is it with SQL*Server that
That's only on the GUI side. The
backend is an Excel spreadsheet with embedded FORTRAN calls. That gets
interfaced with all the assembler code. :-)
Respectfully, Maggie Tompkins - DCII
Integration Technology
Services Organization - Kansas City Defense Finance and Accounting Service
It dissappered from the data dict...
but it should exist at os level...
you need to rm it...
check it...
HTH
JL
--- Hamid Alavi [EMAIL PROTECTED] wrote:
Hi List,
Today I have dropped a big tablespace(4 Gig) as soon
as I dropped it the
data file also disappeared from the list of
1 - 100 of 127 matches
Mail list logo