Hi Xperts,
Platform is Windows NT Server SP-6 , Oracle Enterprise Edition 8.1.6
Question:
1. How do I know before someone tells me that Oracle is down ( e.g. in Unix
we check dbw process )
2. If Oracle is Down , Why ? means which file should be looked for the
possible causes.
Thanks,
No, I mean, if (x+y) 1, that is a value of .92 which it prints out, but I want it
to print out like, 0.92, that is a 0. is concatenateed to the result.
therefore, when i have,
select x+y from blah
I should get 90 when the value is really 90
and I should get 0.92 when the value is really
Hello,
Which performance do you need ?
We have really bad performance with AQ (300 req/s) or JMS from Oracle.
We will use a JMS driver from an other company.
Regards
Henrik
---
Experience is a hard teacher because she
Other than using some third party tool you might like to use either a
windows or Perl script to poll the listener and see if it can connect to
the instance. and that would send you an alert of some kind
I thought someone had posted one in the past but I don't seem to have a
copy in my stored
hi all,
is there any problems using different
filetypes for various datafiles in the same database.
i mean using some files as .dbf
extension while some as .ora
i'm using system, rbs, temp, oemrep
as .dbf, while the one i creted later are using .ora extension.
does it cause any problem in
Hi all,
In 8i
Is there a way to restrict user with dba role to drop system tbs ? while not
interrupting oracle work with that tbs.
I always think of triggers which is mean we have to protect those
triggers... to cover security hole : (
perhaps Just recreating oracle dba role without drop any
[EMAIL PROTECTED] wrote:
thank you all for your reply. i think i got it now :)
'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'
Omar Khalid
Software Engineer
LMK Resources
Voice: 111-101-101*780
Mobile: 0333-510-4465
Web: www.lmkr.com
'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'
Title: RE: simple sql problem
Hello Raja,
You can try this way
1)select x+y sum1 from blah
2)col sum1 format 09.99
3)select x+y sum1 from blah
rgds
swapna
-Original Message-
From: Viraj Luthra [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 12:31 PM
To: Multiple
Title: RE: simple sql problem
or,
set
numformat '0.99' (in sql*plus)
-Original Message-From: Swapna_Chinnagangannagari
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, July
31, 2001 12:26 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: simple sql problem
Hello
Can somebody please Tell the COMMAND Syntax for CREATE TABLE AS SELECT *
FROM ANOTHER TABLE with the Direct LOAD Option ?
Seem to have Seen it Before on the List .
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
INET: [EMAIL PROTECTED]
Fat City
Title: Creating DDL level triggers in Oracle 8.1.7
hi list,
Oracle 8.1.7
It supports DDL level triggers but i cannot find the proper syntax for writing such triggers not even in OEM (DBA STUDIO or Schema Manager) ..can anybody guide me to a link or a sample trigger set on DDL (like create
Saurabh,
My views are that I tend to use datafile extentions to reflect the type of
tablesapces I use in the file or the file type:
For example:
.DBF for datafile
.RBS for Rollback
.ARC for Archived redo logs (can confuse Winzip utility on Windoze)
.RDO for Online Redo
.CTL for control file
In
Hi again everybody,
Since you were all so helpful
last time, I'm going to bug you again. I've been fiddling with utl_smtp
recently, trying to get the silly thing working without having to copy off an
example. Sadly, in the end, I've had to copy :(
I'm ripping off the example code
from
I hear rumors of Oracle databases of hundreds of terabytes at the CIA, but
I have no way to confirm them.
I'm sure a member of their team will knock on your door shortly, just for
mentioning their name and data in the same email - why not ask them then
:)
-Original Message-
Ian A.
Till Oracle 8.0 the default extension was .ora. But from Oracle 8i the extension was
changed to .dbf=databasefile. .ctl=extension for controlfiles. When u create
datafile for OEM_repository from the OEM config assistant, by default it gives an
extension as .ora. But as a good practise keep
OR
SELECT LPAD(TO_CHAR(x+y),LENGTH(x+y)+1,'0') FROM BLAH
I'm still slogging away at selection process of DB monitor tool. I'm now at
stage where I'm compiling a list of specific tasks I'd like to take the
contenders through and score them on same.
E.G.
Can package alert if Oracle DB goes down?
Can package alert if Control File extends?
I'd appreciate
This is a bit like book-selling: All you wanted to know about C++ and
Oracle in 24 hours, including the Idiot's guide to the Mystery of Life and
how to successfully avoid reincarnation with minimum effort. Avoid the
mistake of having to live your life all over again! Just send us US$60 and
I do not use the CTL extension for database control
files as it is used by sql*loader control files.
I'm using dbf for all data files including data,
indexes, temp or rbs. The naming of the files shows
what the file contains.
I do not think different extensions could lead to
problem but I
the only way to make sure oracle is up/down is to connect to the
database.
the listener could be up but that doesnt prove anything at the dblevel.
joe
Peter McLarty wrote:
Other than using some third party tool you might like to use either a
windows or Perl script to poll the listener and
hi all
this is the summary of my findings on the question is cc Compiler is
required for installing ORACLE 8i on Solaris 2.6'
Solaris ships in with every thing you need, with the exception of the cc
Compiler itself.
Solaris ships with the include files, make,an assembler,linker and
libraries.
Raja:
Let me put my two cents into the idea bin. How about:
select decode(sign(num-1),-1,'0' || to_char(num), to_char(num)) as num
from t1;
Jon Walthour
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 31, 2001 1:10 AM
Hello all,
Folks,
All of the underscore parameters used to force the db
open or ignore inconsistency in the redo logs or the
RBS's, such as the one below, have two major
drawbacks:
1. The db MUST be recreated afterwards (recreating
the RBS and/or RBS tablespace is not sufficient).
2. Most likely there
oracle doesn't care.
joe
Saurabh Sharma wrote:
hi all,
is there any problems using different filetypes for various datafiles
in the same database.
i mean using some files as .dbf extension while some as .ora
i'm using system, rbs, temp, oemrep as .dbf, while the one i creted
later
I would think that some of the physics research facilities like Fermi,
Argonne, Sandia or Los Alamos would have some rather large data
repositories. I've been out of the nuke industry to long. I doubt my Q
clearance is any good any more. Cray had many of the computers for these
places but they
Kamel,
Just because an RBS can extend doesn't mean it will.
From the description you've given I suspect that the
transactions were committing fast enough that when it
came time to wrap around from one exent to the next,
the next extent didn't have any active transactions so
it was reused
if you have to restrict someone with DBA role from dropping the system
ts, take away the dba role since that person EVIDENTLY shouldn't have
it.
joe
Sinardy wrote:
Hi all,
In 8i
Is there a way to restrict user with dba role to drop system tbs ? while not
interrupting oracle work with
thats not exactly true.
Since the CIA is a govt agency, they HAVE to tell you that kind of info,
they just dont have to tell you what the data is. But layouts, tuning
recommendations, etc all can be gotten, worst case here in the US, you
can always invoke FOIA(aka Freedom of information act).
one I want is can the package tell me when a datafile extends
also, I want (and have NEVER found) a package that can tell me the locking
SQL, when the locker has gone on and done other SQL after the lock.
ex.
user1 does:
select * from table for update where some where clause
update
http://oracle.com/features/insider/index.html?oi_bonvanie_04.html
-Original Message-
From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 8:00 PM
To: Multiple recipients of list ORACLE-L
Subject: Largest Oracle Databases
One of the smaller Physics
Are you saying that if I called up the CIA and said Hey guys, I was just
wondering how many bytes you db's are and what platform your using they
would HAVE to tell me:? That's sweet!!! I'll give them and the NSA a call,
if I disappear, you'll know why:)
--
Please see the official ORACLE-L
The book is Teach yourself Perl in 21 days It's is written so anyone can
understand it. The book was first published in 1996 and is out of print but
I found it at www.AllBooks4Less.com for $11.99. The original price was
$39.95. Our company has bought at least 6 of the books.
Ron
We looked at it. It looked great. The vendor would admit it would still
take about 25% of a DBA's time to maintain it though. Also, it was
expensive. You have to buy a license for every server.
Ron Smith
Database Administrator
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, July
Omar,
I believe that if you look a little further you will find that the C
compiler and utilities included with any Unix OS are there primarily to allow
you to rebuild your kernel. Consequently while they are fine for installing
Oracle (all you really need is the linker) you may find them
David,
SQL*Loader probably can't help here, because, unfortunatly,
the WHEN clause is not nearly as flexible as a SQL WHERE
clause. If no other solution presents itself, you could load
the data into a work table and write some PL/SQL code to
filter out the records that you don't want. You're
Chris,
Come-on! Never heard the phrase There's a sucker born every minute - and
two to take'em?
The good news is that it only costs $250. You get what you pay for.
PS. they have no overheads - what does THAT mean?
Tom Mercadante
Oracle Certified Professional
-Original Message-
They can market what they want, but as a participating member of this list,
I wanted to let everyone know how far fetched it sounds. Hey if someone
thinks they can handle it, by all means, but it would be sad day if someone
went into it and thought it was a good quick get me up and found out
Loadprof is it.
Then you need to make profiler tables. Proftab under the appropriate
schema.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Monday, July 30, 2001 7:31 PM
Using JMS on E450 on Solaris we are lucky to do 4/s without having problems.
300/s would be great.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
[mailto:[EMAIL PROTECTED]]
Use Decode function
Ramon Estevez
*809-565-3121 x 225
* [EMAIL PROTECTED]
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Viraj Luthra
Enviado el: Tuesday, 31 July, 2001 12:10 AM
Para: Multiple recipients of list ORACLE-L
Asunto: simple
1.Your users complain loudly .
2. First check to see if your smon processes are running. If it is not
then you know oracle is down. If it is up then check a query against the
catalog. If you get what you expect then Oracle is up. From this
information you can then either set a
I can only imagine.
Perhaps they have them circled around a tree ;)
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Tuesday, July 31, 2001 9:55 AM
To: Multiple recipients
I am reading technical note 112490.1, which explains how to set up secure
socket layer connections for the Oracle Portal.
The note refers a few times to a CA, to whom I am supposed to send the new
certificate request.
Who is this CA? How do I contact him/her/them?
I am new at this, can you
yeppers thats exactly what i'm saying they have to tell you
the metrics but not what they store.
joe
[EMAIL PROTECTED] 07/31/01 09:55AM Are
you saying that if I called up the CIA and said "Hey guys, I was
justwondering how many bytes you db's are and what platform your using"
theywould
Dick,
Congrats on the being published in the SELECT magazine this month. The Oralive
program looks like it could be very helpfull to a lot of the forum users.
Thanks for providing the source code.
ROR mô¿ôm
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
You could try:
when (9:12) 'UNIX'
However, this will only work if you have fixed field lengths in the input file.
Jonathan Gennick wrote:
David,
SQL*Loader probably can't help here, because, unfortunatly,
the WHEN clause is not nearly as flexible as a SQL WHERE
clause. If no other
Probably that they are doing the training from somebody's back yard on PC's
that run on a generator powered by 1000 hamsters running on spinning wheel
transformers. Lunch is self-service at your local McDonalds. :)
In short they are really telling you that they are suckering $250 out of
you -
Rachel,
Now that's a darn good question. Can you specify when such an alarm should
be triggered?
Dick Goulet
Reply Separator
Author: Rachel Carmichael [EMAIL PROTECTED]
Date: 7/31/2001 4:55 AM
one I want is can the package tell me when a
I'm supposed to know all this? Oh, oh.
;)
Jim
-Original Message-
Sent: Monday, July 30, 2001 3:57 PM
To: Multiple recipients of list ORACLE-L
[small/Sacr
I would be curious how one can obtain to be amoung the best after a single
7.5 hour course which I assume has an 1 hour lunch
Rachel,
You are right, I have not seen a tool that does this as standard either,
though I think there could be a way of doing this with our particular
product, that I will look in to - but I have a couple of questions:
In a real world situation - what would the timeframe be for a user to update
CA is an abbreviation for Certificate Authority. One is Verisign.
You can request a certificate by filling out a form on their site and
pasting the certificate request into a text box on the form. They will
verify the data, then send you the certificate.
Dennis
Boivin, Patrice J wrote:
I also did not find any reporting scripts. In the tables created by
proftab.sql - there is only line numbers, not PL/SQL text. So I need to get
text from the module using line numbers - right? Anybody have report script
which join these table with dba_source?
Alex Hillman
-Original
Title: RE: Largest Oracle Databases
In theory, Oracle can handle 512 Picobytes (or roughly 512,000 Terabytes) for Oracle 8i.
Have not heard if this has been increased for 9i.
-Original Message-
From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 8:00
Hi Friends
What is the best way of rebuilding of following Index??
Index has total size 5.8Gb But lot of deletions, may be the real data around
2.5Gb has initial extent 71M, next 197M. So How my doubt which is best way
for setting initial=next or give more space for initial for putting more
Thats funny...
--
Chris J. Guidry P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]
-Original Message-
From: Post, Ethan [SMTP:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 05:20 PM
To: Multiple recipients of list
Hi, all
I kept packages in shared pool, try to reduce number of parses for main
packages. But I still found many parse counts in trace file as following.
(Status for package ModelCache in v$db_object_cache is 'YES', and db is
8.0.5 on NT4.0)
BEGIN
ModelCache.RemoveModelData(INCASENO = :001);
END;
Certification Authority ... probably the company who issues certificates.
HTH
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
Save yourself the trouble and
read James Bamford's new book,
Body of Secrets.
Amazing
http://www.amazon.com/exec/obidos/ASIN/0385499078/qid=996585632/sr=2-1/107-9
950210-2774136
-Original Message-
Sent: Tuesday, July 31, 2001 9:55 AM
To: Multiple recipients of list ORACLE-L
Are
Hello,
I have a soft copy of the book Teach yourself perl 5 in 21 days by David
Till. I can give it on demand
Cheers
Okan
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 31, 2001 4:41 PM
The book is Teach yourself Perl in 21 days
Hi All,
Does anyone know where I can get/download copy of Oracle that runs on Window
ME I downloaded 8i for 98 but BSOD.
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cale, Rick T (Richard)
INET: [EMAIL PROTECTED]
Fat City Network Services--
Is it a good book? Like the Discovery channel on hardcover?
KK
-Original Message-
Sent: Tuesday, July 31, 2001 10:26 AM
To: Multiple recipients of list ORACLE-L
Save yourself the trouble and
read James Bamford's new book,
Body of Secrets.
Amazing
Hi, Patrice,
It seems to be Certificate Authority, like http://www.verisign.com/
Regards
Vadim Gorbounov
Oracle DBA
-Original Message-
Sent: Tuesday, July 31, 2001 10:42 AM
To: Multiple recipients of list ORACLE-L
I am reading technical note 112490.1, which explains how to set up
Boivin, Patrice J wrote:
I am reading technical note 112490.1, which explains how to set up secure
socket layer connections for the Oracle Portal.
The note refers a few times to a CA, to whom I am supposed to send the new
certificate request.
Who is this CA? How do I contact
I have been doing Oracle admin for about 6 months now. I have literally
spent a couple hundred hours RTFM and reading books. I feel that I have
gotten much better in my understanding of Oracle, BUT, I would not consider
myself an Oracle guru or anything close to it, which is obvious from the
Mike,
Check out notes 130785.1 and 105472.1 on MetaLink. I followed there
instructions and it worked first time. NOTE: After you run
$ORACLE_HOME/javam/install/initjvm.sql you need to manually run
$ORACLE_HOME/rdbms/admin/initplsj.sql. It's a listed bug.
Dick Goulet
The problem is that I need one to encrypt a password in the same manner as
the Sun OS. This is because we use the database to populate /etc/passwd.
So if the OS can't compare passwords with what is stored in the database,
then nobody will be able to log into the Unix box.
Thanks for you help,
Are you sure you can do that with NT? NT makes Oracle one large process
called Oracle.exe, I know there are programs that will let you see the
individual processes though.
For me the easiest way is to just try and log on to the db, if you can't,
it's gone:)
KK
-Original Message-
Title: RE: Largest Oracle Databases
"picobytes"? lol.
Attoboy!
-Original Message-From: Jon Baker
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 31, 2001 10:56
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
Largest Oracle Databases
In theory, Oracle can handle
You can use the following shell script and have it
email you the error message . Th eemailing is not
enabled in teh script because I use it for HP OpenView
monitoring which reads the text out put constantly .
** Script Starts here
SCRIPT TO CHECK THE AVAILABILITY
Mark,
Transactions should not typically last more than 15-20 minutes. But I want a
warning that there is a lock, not a kill, as it is possible that a
non-typical transaction would last longer. As an example, I'm thinking of
taking phone orders and entering them into a system (catalog sales).
Actually, speaking from a state college, the official policy is you get
forwarded around and put on hold for a couple hours, until you get to
someone sitting in a closet somewhere at the public information desk,
who will research your question and send it right to you in 6 - 8
months.
thanks!
From: Smith, Ron L. [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Perl Script for Alert Log
Date: Tue, 31 Jul 2001 05:41:14 -0800
The book is Teach yourself Perl in 21 days It's is written so anyone can
understand
Grats, nice honor to be published.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Tuesday, July 31, 2001 11:02 AM
To: Multiple recipients of list ORACLE-L
Dick,
Congrats
Hi
This is an organisation that is allowed to create valid
certificates(Certificate Authority I think)
Verisign is a well known one.
Jack
Boivin, Patrice
Steve
Are there any Docs / Links Comparing the Same ?
Thanks indeed though for your Experienced Valuable input .
Also do need to present Some Documents for taking a Decision .
Vivek
-Original Message-
From: Austin, Steve S [SMTP:[EMAIL PROTECTED]]
Sent:
I have 2 varchar2 variables, one containing a number of hours and the other
containing a number of minutes, which I want to add to a date variable.
How can I do this?
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat
Perhaps what they are doing is great, I just wanted to put in my thought
that I think it is very far fetched and doesn't smell right.
Perhaps it is completely useless perhaps it is great, I didn't want to go on
and say anything more than that.
Just didn't want to see anyone go into it thinking
Use the alter index rebuild command. It uses the existing index to build the new one
rather than going to the table.
-Original Message-
From: Raghu Kota [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 11:23 AM
To: Multiple recipients of list ORACLE-L
Subject: alter index??
Try looking into PAM under Unix. That should help.
Also, contact Collective Technologies. They are a consulting firm I
interviewed for, but I know they were able to do single login to Windows
2000, Oracle, and Unix. I am sure they will be able to help out in such a
task.
There solution was
Gary,
I wish it did. I worked with Q Diagnostics for quite a while, and worked
directly with the developer (although calling John Beresniewicz a developer
is an understatement, he's brilliant!) on answering that problem.
Neither Q nor anything from Platinum (does that tell you how long ago it
they need to hold another class to make enough money to develop the next web
page...
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, July 31, 2001 11:16 AM
To: Multiple recipients of list ORACLE-L
Thats funny...
--
Chris J. Guidry P.Eng.
ATCO
in my 816/Tru64 4.0f instance, I have alot of latch waits/sleeps/longholds
on:
dlm resource table freelist
dlm lock table freelist
I have downloaded Note 72316.1, but this does not contain material exactly
on these
latches.
Further, I have very very high system-level waits for:
lock manager
Thanks for the responses.
This is free, right? Like PGP?
Otherwise why put it in a web server suite based on Apache?
; )
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From: Vadim Gorbounov [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday,
If you have the space in the tablespace you could always use ALTER INDEX
REBUILD
-Original Message-
Sent: Tuesday, July 31, 2001 10:23 AM
To: Multiple recipients of list ORACLE-L
Hi Friends
What is the best way of rebuilding of following Index??
Index has total size 5.8Gb But lot of
Hi
Which Unix command is used to see disk layout in sun cluster and veritas
cluster on sun solaris?
Thanks in advance.
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
Please see the official
You can easily check if you can make a connection. The rest ???/ well, I
am not sure. I use a real OS. (Ok, so I am a Unix Biggot).
-Original Message-
Sent: Tuesday, July 31, 2001 10:31 AM
To: Multiple recipients of list ORACLE-L
Are you sure you can do that with NT? NT makes
John,
SELECT SYSDATE + ((TO_NUMBER(HOUR_VAR)*3600) +
(TO_NUMBER(MINS_VAR)*60))/86400
FROM DUAL;
HTH
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't
kinda sorta in link$ (including the in the clear password)
woohoo.
joe
[EMAIL PROTECTED] 07/31/01 11:48AM
All,Where is the source for database links stored ? Perhaps,
another to state myquestion is:How can I fully reconstruct a database link
?TIAAl
Rusnak804-734-8453[EMAIL PROTECTED]--
I think you're going to have a rude awakening, there is
nothing free from verisign, heck they charge u a yearly fee to get a personal
certificate, i hate to see the other fees.
joe
[EMAIL PROTECTED] 07/31/01 01:21PM
Thanks for the responses.This is free, right? Like
PGP?Otherwise why put
Add the hour field converted to a number divided by 24 plus the minute field
converted to a number divided by (24*60)
For example:
declare
num_hours varchar2(10) := '24';
num_mins varchar2(10) := '10';
date_field date := sysdate;
new_date_field date := null;
begin
new_date_field := date_field
I have installed Personal Oracle 8i for Windows 98, on Windows Me, and it runs.
There was a change required in win.ini to get the installer to work properly but
other than that everything was OK.
Witold
Cale, Rick T (Richard) [EMAIL PROTECTED] on 07/31/2001 12:30:52
Please respond to
Try
select date+(hours/24)+(minutes/60/24)
this would give you the decimal equivalent of the hours and minutes added to your date field for a time stamp type output. This assumes that your date field is a date datatype and that all entries are for date 00:00 and not just a sysdate input.
lol...i wouldn't know..i don't watch TV, buthis
first book, Puzzle Palace, was amazing, truly.
What i've read about this one ( i have not read it myself yet)
is that it's a bit less nuts and bolts and a bit more political.
-Original Message-
Sent: Tuesday, July 31, 2001 11:23 AM
Hi all,
I have a new install of Oracle 8.1.7 on a Compaq ES40. The install all went
fine, (so it seemed)
I tried starting up the db and got the error ORA-00205 Error in identifying
controlfile, check alert log for more info.
I looked around the entire system thinking the control files were
Title: Weird character
Hi List,
I got ora 911 (invalid character) or ora 904 (invalid column name) when running
application from VB.
I've turned trace session and found weird character in the SQL in output of
tkprof on trc file as the following :
UPDATE Address SET ZIPCOa=:1 AND E^=:32
Patrice,
Nop, it's not free. Simply it's different service to your Apache, like gas
for new car - your either can put or not - it still shines.
Seriously, the Certificate needs some efforts and resources from Authority
to support - it's like domain name.
Cheers,
Vadim Gorbounov
Oracle DBA
George,
The code below will near enough do it (at least way back here in 7.3.4)
assuming the passwords aren't encrypted (I think you can force that in the
init.ora)
-Original Message-
Sent: 31 July 2001 16:48
To: Multiple recipients of list ORACLE-L
All,
Where is the source for
Title: RE: Add hours and minutes to date
-Original Message-
From: John Dunn [mailto:[EMAIL PROTECTED]]
I have 2 varchar2 variables, one containing a number of
hours and the other
containing a number of minutes, which I want to add to a date
variable.
a) - read manual on
Title: Weird character
Hi List,
I got ora 911 (invalid character) or ora 904 (invalid column name) when running
application from VB.
I've turned trace session and found weird character in the SQL in output of
tkprof on trc file as the following :
UPDATE Address SET ZIPCOa=:1 AND E^=:32
Did you create the database?
Or, just installed oracle software?
Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 31, 2001 1:46 PM
Hi all,
I have a new install
1 - 100 of 222 matches
Mail list logo