The one I have heard is Scott being the main developer way back when.. and
Tiger was the name of his pet cat..
-Original Message-
Sent: 23 January 2002 16:45
To: Multiple recipients of list ORACLE-L
Anyone out there know the history of this?
--
Please see the official ORACLE-L FAQ:
Golly, that looks an awful lot like VMS. I think what it's trying to tell
you is that the node you specified is not reachable, or that the SID you've
specified is not on the node listed. There's some kind of connection
problem there. Try doing a select from the Ingres side over the connection.
I was once told with certainty from an Oracle instructor that Scott was
an early developer, and Tiger was his cat. But without actually meeting
Scott I take this with a grain of salt. I expect there are many urban
legends surrounding this.
Jim
-Original Message-
Sent: Wednesday,
Title: FW: Electrical background
Sorry folks, that went to the wrong list.
I apologize. We now return you to your
regularly scheduled Oracle discussion.
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Thus spake the master programmer:
Let the programmers by many and the managers few,
I do.
-Original Message-
Sent: Wednesday, January 23, 2002 9:45 AM
To: Multiple recipients of list ORACLE-L
Anyone out there know the history of this?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohan, Ross
INET: [EMAIL PROTECTED]
Fat City Network
Ed Scott was one of the founders of Oracle and that was a sign on
he liked to use.
-Original Message-
Sent: Wednesday, January 23, 2002 11:45 AM
To: Multiple recipients of list ORACLE-L
Anyone out there know the history of this?
--
Please see the official ORACLE-L FAQ:
Fred,
one of the easier ways is this:
1. on ur prod take a control file backup to trace
2. copy the trace to server b and edit the path/drives
3. copy init file from prod to server b
4. set the env vars in server b and startup nomount
5. create the control file using edited trace on B
6.
Hi, Henry,
Please, post it. I am terribly sorry for asking dumb questions, but hey!
I've come a long way to be a part of this country, learned the language,
become a DBA and proud of it! Time to learn! Thanks a bunch in advance!
Sincerely,
Sergey
-Original Message-
Sent: Wednesday,
-- Adams, Matthew (GEA, 088130) [EMAIL PROTECTED] on 01/23/02 10:15:31
-0800
Anybody got a EE or electronics background?
I've got a question about relays.
See:
The Art Of Electronics, 2nd ed
Horowitz Hill
Cambridge U. Press.
Excellent descriptions of using and configuring
LMAO!
-Original Message-
Kirti
Sent: 23 January 2002 18:21
To: Multiple recipients of list ORACLE-L
Prepareing for the OCP, eh?
-Kirti
-Original Message-
Sent: Wednesday, January 23, 2002 10:46 AM
To: Multiple recipients of list ORACLE-L
Anyone out there know the history of
First load all the datafiles and logfiles to server B in the locations
you want them. Load the controlfiles as well, they aren't useless.
Now.
edit the init.ora file on server B to point to where the control files
are.
create a sql script file that contains (for every datafile and logfile)
I heard from unnamed sources that it was a developer named Tiger and Scott
was his monkey.
Unknown
-Original Message-
Sent: Wednesday, January 23, 2002 12:26 PM
To: Multiple recipients of list ORACLE-L
I was once told with certainty from an Oracle instructor that
Ok...it's true. Take the Oracle Technical seminars and you too may
get to meet Scott, Live and In Person. Unfortunately, Tiger is waiting
for Scott at the Rainbow Bridge, but Scott is still there (at least
he was last year...you know how Oracle's been lately).
-Original Message-
Sent:
SO, what did you want?
Dick Goulet
Ancient Electronics Tech tinkerer, Also certified relay NUT
Reply Separator
Author: Adams; Matthew (GEA; 088130) [EMAIL PROTECTED]
Date: 1/23/2002 10:30 AM
Sorry folks, that went to the wrong list.
I apologize.
Would I be better off doing that or doing a backup controlfile to trace
from server A, moving the datfiles logfiles to server B, and then editing
the newly created trace file into a script that creates a new controlfile
with the new datafile/logfile locations?
From: Rachel Carmichael
Poor thing got spanked a lot, eh?
Scott Shafer
San Antonio, TX
210-581-6217
Common sense will not accomplish great things. Simply become insane and
desperate.
-Original Message-
From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, January 23, 2002 1:11 PM
To: Multiple
Thanks Larry.
I had forgotten about the 75 message per day problem. That
was really a pain.
This list finally came about when the 'other' list was down for
10 days. The list owner would not answer his emails or
his phone. ( I had to track down his phone #, for all the good
it did )
I think
I think one should not be running export of those tables when heavy DML is
being done against those.
- Kirti
-Original Message-
Sent: Wednesday, January 23, 2002 3:11 AM
To: Multiple recipients of list ORACLE-L
If you want to avoid snapshot too old set the DB (or tablespaces) to
Both an Oracle DBA instructor and myself have encountered some rather
nasty results from changing column names in the data dictionary.
I was able to recover from my predicament. :)
He wasn't. :(
Jared
Deshpande, Kirti [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/23/02 07:55 AM
ORACLE-L Digest -- Volume 2002, Number 023
--
From: [EMAIL PROTECTED]
Date: Tue, 22 Jan 2002 09:09:23 -0500
Subject: Re:RE: dropped datafile problem
While the damage here has already been done, it should be a point of
caution for us all. I make a point
??
ORACLE-L Digest -- Volume 2002, Number 023
--
From: [EMAIL PROTECTED]
Date: Tue, 22 Jan 2002 11:00:47 -0800
Subject: RE: Yet Another Off Topic Discussion
VGhhbmsgeW91LiAgOikNCg0KSmFyZWQNCg0KDQoNCg0KDQrXkNeT16gg15nXl9eZ15DXnCA8YW
Rh
Hi
Rename data file from one location to another location is riskly process?
If some thing wrong what will happened?Can I do it database on condition?
Can I do it when db is running?If yes then it is risky?
Thx
-Seema
_
Get your
If you have access to Oracle on a unix system, take a look at
$ORACLE_HOME/rdbms/admin/oraus.msg.
Events 1 - 10999 are of interest here. You may also note
that it says they are for debugging Oracle. As such you will
likely never find documentation for some of them.
A few of them are
Fred,
Either method works fine. You have the same amount of data editing in both
methods (Either issue alter database rename commands, or edit the create
controlfile file.
The other consideration is that in Rachel's method, you are simply opening
the database afterword.
With the re-creation
I would have thought that the first day of the month
is ALWAYS the 1st, as in 1 (ONE)!
Please explain why it needs to be calculated or
could be a value other than ONE.
[EMAIL PROTECTED] 01/23/02 10:35AM
Hey guys,
I know this is propablby easy, but I'm a bit
overwhelmed here this
Renaming or moving a datafile is a two step proposition. Whether or not you do
it with the database running depends on the archive log mode of the database.
If at all possible the OS portion should be done with the database shutdown. If
your in noarchive log mode then you have no choice. If
Seema,
It is not a risky process. The proper way to do it is:
Alter tablespace {name} offline;
! host copy filename to newlocation;
Alter database rename file 'oldname' to 'newname';
alter tablespace {name} online;
* backup your database! *
if all goes well, remove the old file.
You
Charlie Mengler wrote:
I would have thought that the first day of the month
is ALWAYS the 1st, as in 1 (ONE)!
Please explain why it needs to be calculated or
could be a value other than ONE.
[EMAIL PROTECTED] 01/23/02 10:35AM
Hey guys,
I know this is propablby easy, but I'm
It is the 1st. I've already got quick help on that...
thanks
--- Charlie Mengler [EMAIL PROTECTED] wrote:
I would have thought that the first day of the
month
is ALWAYS the 1st, as in 1 (ONE)!
Please explain why it needs to be calculated or
could be a value other than ONE.
select last_day(add_months(sysdate,-1)) from dual;
-Original Message-
Sent: Wednesday, January 23, 2002 2:38 PM
To: Multiple recipients of list ORACLE-L
It is the 1st. I've already got quick help on that...
thanks
--- Charlie Mengler [EMAIL PROTECTED] wrote:
I would have thought
First day calculations;
select last_day(add_months(sysdate,-1))+1 form dual; for current month
1st day.
select last_day(add_months(sysdate,-1)) from dual ; for end of
previous month.
ROR
[EMAIL PROTECTED] 01/23/02 10:35AM
Hey guys,
I know this is propablby easy, but I'm a bit
overwhelmed
Well, yes the first day of the month is always 1.
Representing it as the first day of the current month requires
you to use the SYSDATE function.
Returning the first day of the month can be done in several
ways, some more reasonable than others.
there's the new to SQL basic programmer DBA
With the re-creation of the control file, you must (I think) alter
database
open resetlogs.
A minor difference.
But one worth noting.
If this method is chosen and the database must be opened
with resetlogs, you must take a cold backup before allowing
the database to be used.
As to the
the first is always the first and the last may be calculated by using
last_day function.
-Original Message-
Sent: Wednesday, January 23, 2002 4:32 PM
To: Multiple recipients of list ORACLE-L
Charlie Mengler wrote:
I would have thought that the first day of the month
is ALWAYS the
Oracle 8.1.7.0.0
table event_t range partitioned by column poid_id0. only 1 partition called p_1 out of
the 14 contains data. A query on event_t became significantly slow after rows increase:
select poid_DB, poid_ID0, poid_TYPE, poid_REV, start_t, end_t, sys_descr
from event_t
where
I want to create a stored procedure that takes the following information and
puts it into a table. How would I do this?
CREATE OR REPLACE Procedure Used_license as
Begin
Select A.Pc_session_id From pt_client_event A where A.pc_event_op = 'LAUNCH'
and A.pc_date =SYSDATE -1
minus
Select
I think you need a ; at the end of the select statement.
-Original Message-
Sent: Wednesday, January 23, 2002 6:20 PM
To: Multiple recipients of list ORACLE-L
I want to create a stored procedure that takes the following information and
puts it into a table. How would I do this?
there are several instructors named Scott how do you know which one
it is or even if it's one of the instructors?
--- Vergara, Michael (TEM) [EMAIL PROTECTED] wrote:
Ok...it's true. Take the Oracle Technical seminars and you too may
get to meet Scott, Live and In Person. Unfortunately,
You used an incorrect name for the procedure. Here
is one that compiles flawlessly:
CREATE OR REPLACE Procedure RTFM
Begin
Select A.Pc_session_id From pt_client_event A
where A.pc_event_op = 'LAUNCH'
and A.pc_date =SYSDATE -1
minus
Select B.Pc_session_id From pt_client_event B
I think that all you need is a ; before the end You need to close your
statement within the procedure body
--
=
Peter McLarty E-mail: [EMAIL PROTECTED]
Technical ConsultantWWW: http://www.mincom.com
APAC Technical Services
and most importantly of all, if you don't want to have to repeat (and
repeat) this exercise...
BACKUP THE NEW DATABASE
--- Mercadante, Thomas F [EMAIL PROTECTED] wrote:
Fred,
Either method works fine. You have the same amount of data editing
in both
methods (Either issue alter database
The name I was given is Scott Gossett. My team leader and one
of our team members took the advanced seminars last year, and
their instructor was Scott, and he admitted his notoriety.
-Original Message-
Sent: Wednesday, January 23, 2002 4:00 PM
To: Multiple recipients of list ORACLE-L
Title: link error - gnu compiler / cygwin / Pro*C / Oracle 8.1.7 / Windows 2000
My apologies for this non-strictly DBA question.
Has anyone successfully used Oracle 8.1.7 Pro*C on Windows 2000 using the Gnu Compiler (gcc) that comes with Cygwin?
I've tried the following commands in Cygwin
Title: RE: creating a procedure
-Original Message-
From: Lance Prais [mailto:[EMAIL PROTECTED]]
I want to create a stored procedure that takes the following
information and
puts it into a table. How would I do this?
CREATE OR REPLACE Procedure Used_license as
Begin
Select
Ethan,
Thanks for the alternative code.
I got the exact same time either way.
table a = 7000 records, table b = 30,000 records.
old netware/oracle7 server.
1 select
2 count( m.student_ssn )
3from
4 student_master m,
5 SIS_CSUS_ALL_FALL_2001_eos1 x
6
I am not one to usually shout RTFM from the mountain top, but I somehow feel
compelled because I have read a couple of responses that hadn't mentioned
that age old mantra.
Your procedure might be salvagable by putting a ; at the end of your select
statement, but I don't believe it will do
I have purchased an eval copy of 9i for my PC using XP
Prof. The eval is for 30 days. What happens at the
end of the eval period? Does my PC melt, does the DB
lock up, or nothing?
TIA,
Ken Janusz, CPIM
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET:
So who was SYS, and why on earth did s/he name his/her pet CHANGE_ON_INSTALL???
:-)
[EMAIL PROTECTED] 24/1/2002 12:00:27
This message has been scanned by MAILSweeper.
The name I was given is Scott Gossett. My team leader and one
Dear Bambi,
Unfortunatly, 10 years ago I still a kid.. ^_^
Did you know any web site/mailing list/or other resources relate with
this problem (INGRES), so I can solve this problem?
Thanks in advance
Holly
-Original Message-
Sent: Thursday, January 24, 2002 1:02 AM
To: Multiple
Yes your PC melts down.
my question is why would you purchase an eval copy when you can join
technet and download the latest version and play with it to your heart's
content(single user developer license)?
joe
[EMAIL PROTECTED] wrote:
I have purchased an eval copy of 9i for my PC
That was Scott's Dad, and system was his mother and Yes Jared, i'm
moving it to the OT list :)
joe
Arn Klammer wrote:
So who was SYS, and why on earth did s/he name his/her pet CHANGE_ON_INSTALL???
:-)
[EMAIL PROTECTED] 24/1/2002 12:00:27
This message has been scanned by
Nothing, really.
But it is quite likely that an Oracle sales rep will be giving you a call
sometime during your evaluation.
Chuck
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 23, 2002 10:15 PM
I have purchased an eval copy
When I migrate the Form5 to Form6i and deploy the form
into WEB, I encounter a problem. In Form5, I use a form to call all the
functions forms and process the login. So, the functions forms can get the login
user's information by :Global variable. Now, in Web method, I use a jsp to
process
Dear Friends, I am
trying to install Oracle 9i on Sun Solaris 5.8.But while installting i get the following
error
hi,
you need JRE for
installation. I think your system didn't installed or have a problem. You can
download , install and try to install Oracle again.
-Onder
Kokturk
54 matches
Mail list logo