Louis,
Yep, old bug. :)
I seem to recall that removing the files is enough;
best check on MetaLink though.
Do you have access? I can find it for you tomorrow
if you don't. ( gotta get to bed now, the eyelids
won't stay up :)
Jared
On Wed, 21 Mar 2001, Louis Avrami wrote:
> Jared,
>
> Th
Michael,
thanks for your response.
I meant the following situation. Transaction#1 updates a row#1 in block#1 of a table.
In order to do
it allocates a ITL slot.
Transaction#2 updates a row#100 in block#100 of the same table and also allocates
transaction slot.
If there is no free space to alloc
Jared,
Thanks for the reply.
I'm embarrassed to say that the cause of the problem was Oracle Trace. The
solution was to set EPC_DISABLE=TRUE in the environment and listener.ora, and
stop and restart the database.
I remember doing this a couple of years ago, when Oracle Trace was first
enabled
sorry for test.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rongcheng Zhang (ETC)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
--
jkfdhkjhdfjkkjdf
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rongcheng Zhang (ETC)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
-
I have heard about this Storage box. It can be plugged with any OS and diff OS can
use this box as their Storage, by allocating diff LUN's to them. When all the
datafiles,redologs,archives are in same place do u expect to get better
performance. Think it over. Go for RAID1 and RAID0 co
I have been working with Oracle under HP, I find HP server with high fault toulerence
and reliable. If we tune the OS and DB then we can get maximum performance. One word
of caution is that, if u use Mc Servicegaurd then u shud go for OPS. Which works for
only on RAW partitions. Administration
At 10:07 AM 3/20/01 -0800, you wrote:
U, Is this kinda like Mr. Sulu
(that was Mr Chekov)
on Star Trek who was sure that the
Russians invented everything? I might be wrong (happens all the
time), but
I thought Baseball and Basketball were distinctly inventions of the
USA.
You are correct, th
Recently, one of my users nor I could update a table. As I dug around, I
couldn't find any of the 'lock' tables such as dba_locks. Eventually, I
managed to start data gatherer and get OEM's lock manager to kill the hung
session. What do you guys do to find and terminate this deadlock or hung
Hi there!
Is anybody out there running Oracle on NetApp Storage Networking box?
I was told by some NetApp guys that using their boxes we don't have to worry
about distributing datafiles, RBS etc. across the disks because the NetApp
OS takes care of all that.
Any comments?
Thanks,
Helmut
--
IS IT POSSIBLE TO LIST JOB OPPORTUNITIES TO THIS LIST IF ONE BECOMES
AVAILABLE?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ginger Mejia
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- P
You will get patches and new versions of software
sooner on Solaris than you will on HP.
Jared
On Tue, 20 Mar 2001, Alex Apostolopoulos wrote:
> Hi,
>
> we are currently in the process of evaluating a high availiability cluster
> for our production database. The final two solutions are:
>
> Su
Alex,
We've used HP servers for the last 8-9 years. Right now we have L & N class
machines with a few K's still working hard every day. I find the K, L, and N
class machines VERY fault tolerant. If a power supply fails the other can hold
the entire load & their hot swap able. If a CPU fai
Actually, the problem started with the 10.20 32-bit. They do stay up
for months at a time as well. We only get 4 downtimes per year (when we are
lucky).
Its during reboots that we have issues. And the other plants that
had issues are also running 32-bit (not Fujitsu plants either).
Personall
Sure, why not. The BRICK-BAT method.
Reply Separator
Author: "Mohan; Ross" <[EMAIL PROTECTED]>
Date: 3/20/2001 5:08 PM
Wow. Talk about enforcing "foreign constraints".
-Original Message-
Sent: Tuesday, March 20, 2001 5:01 PM
To: Mohan; Ross
Well of course it's a bad idea, I thought
that was obvious. ;)
Jared
On Tue, 20 Mar 2001, Jacques Kilchoer wrote:
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> >
> > How can I create an insert statement without telling all the
> > names of the columns
Ross,
When a B-52, otherwise known as a BUFF (Big Ugly Fat F^cker), unloads 150 to
200(B-52D with wing racks) 750LB demolition bombs nothing stands. Even
duhvelopers. I've had Marines discribe the area where a BUFF strike landed as
"It looked like God reached down, scooped out a three mile
Title: RE: RE: RE: RE: RE: OT: Rachel in Vietnam
Wow. Talk about enforcing "foreign constraints".
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 5:01 PM
To: Mohan; Ross; Multiple recipients of list ORACLE-L
Subject: Re:RE: RE: RE:
Hi all -
I stand (sit?) before you with egg on my face. I KNOW you can insert
without naming column names if you're filling the entire row, I just
didn't consider that this might be what Roland was attempting to
accomplish. As Regina and Jacques both pointed out, if your package,
procedure or s
Sorry, I misspelled your name as 'Audrey' in
my previous reply.
Jared
On Tue, 20 Mar 2001, andrey wrote:
> Hi DBAs !
> I'm looking for some FREE Oracle DBA / developer resources on the web :
> self-tests , OCP preparations materials , articles , books , etc ...
> Please share your resources !
Audrey,
Try researching and answering at least one post
a day on this forum.
That will get you further than training tests. :)
Jared
On Tue, 20 Mar 2001, andrey wrote:
> Hi DBAs !
> I'm looking for some FREE Oracle DBA / developer resources on the web :
> self-tests , OCP preparations materi
If there is, I haven't found one ... that's what I've done on other
applications I've worked on.
Rachel
>From: "Witold Iwaniec" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Columns in triggers
>Date: Tue, 20 Mar 2001 1
To ALL, especially those looking for a new position, I got the attached in the
Mail. I've heard from these folks in the past & they have been helpful so I
don't think it's a spam (boy I've been wrong on that point before too). Anyway
if there is anyone out there who can help Sean, give him a cal
Actually, I think the Aztecs (or some other Central American tribe) invented
basketball and the losers were slain literally. Now that's what I call a
salary cap. We need something like that in professional sports today.
Steve Orr
-Original Message-
Sent: Tuesday, March 20, 2001 10:07 AM
Hi,
I need to find whether SYSDATE falls between beginning
date and ending date while loading data from a flat
file. I searched Oracle manuals and Metalink, could
not find a clue. Is this possible at all? If so how?
example:
=
LOAD DATA
INFILE 'price.dat'
INTO TABLE price
WHEN TRUNC(SYSD
Ed,
Not sure that I understood it right, but I'll take a try.
So there are 2 transactions and each one is trying to update the row which was already
updated by the other transaction?
IMHO, if you are trying to place an exclusive lock on the locked row ( it remains
locked until commit ), you eit
First off, do you have Perl and DBD::Oracle or
Java?
Those would be the preferred methods to do something
like this, in this order. PL/SQL sould be a distant
third place as it is not very fast for this kind of
wholesale string operation.
PL/SQL may be a good choice though, if your requirements
Title: RE: RE: RE: RE: OT: Rachel in Vietnam
BUFF bomb. That sounds cool. Will it work on developers?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 4:18 PM
To: Mohan; Ross; Multiple recipients of list ORACLE-L
Subject: Re:RE: RE:
Kimberley,
The problem is that you loaded the 64 bit kernel in the K class. It does
not have the buss required for 64 bit, therefore the kernel does a fake it 64
emulation. Rebuild the machine with the 32 bit version of HP 11.0 & you'll be a
lot happier. Ours stay up for months without pro
Ross,
Makes sense, Nam was BUG heaven, unless they got caught in the path of a
BUFF bomb run. Nothing survived that. :-)
Dick Goulet
Reply Separator
Author: "Mohan; Ross" <[EMAIL PROTECTED]>
Date: 3/20/2001 8:02 AM
Dick ,
Didn't you know? Ra
Hi list:
I am looking for some guidance as to how I should
find special characters used in the database and
then replace them with blanks.
If someone has a drawn procedure, would appreciate
feed back.
TIA,
Shakeel Qureshi
[EMAIL PROTECTED]
__
Yeah, more money!
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 4:30 PM
> And like a lot of Canadian doctors he became an U.S. citizen
>
> -Original Message-
> Sent: Tuesday, March 20, 2001 12:57 PM
> To: Multiple
Hi,
it's difficult to help you because we don't know anything about your
nightmare skript. Either you do a business/application tuning about these
procedures or you can create a ressource plan and drive this with low
processor resources.
oli
--
Oliver Artelt
Oracle Certified DBA
cubeoffice
Yeah, but do you guys have Texas Weiners?? I think not!! Now those are
g.
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 7:05 PM
> The Smarties we are talking about in Canada are much
> different. Candy cover
It was Mr. Checkov who thought the Russians invented everything. Alexander G. Bell
maintained at home at Baddeck, Nova Scotia, but he was a Scot, not a Canadian. I'm
not sure where the telephone was invented, I seem to remember someplace in New York.
Dr. Nasmith of Massachusets is usually c
Hi all,
I am executing initjvm.sql to load oracle java classes into oracle 8.1.6
database under HP-UX 32bit environment. Suddenly the process stops with the
following error:
ORA-04021: time out occurred while waiting to lock object
SYS.INITJVMAUX.
My SGA is around 400M and Java-pool-size i
Raghu,
To reorg Oracle Financials table is very tricky as some triggers created by
apps whereas owner of tables may AR. If you drop any stuf ,you will lose
those triggers. As table size is big truncate and reinsert option will
create a lot of logs(if ver 7.3.4).
The best way to capture back s
In theory, 32 to 64 bits means a loss of performance due to a lesser number
of entries in the Translation Lookaside Buffer (I have seen several times
mentionning a loss of 5-10%, but I never ran into actual tests). This of
course can be compensated by the larger memory you can address.
Christian
We are in the midst of starting to use RMAN for our Backup and Recovery. The backups I
have put into place are Once a week a Level 0 full backup, three times a week Level 1
incremental and three times archive logs only.
Can anyone suggest some different recovery scenarios to test? Or if I missed
On Tue, 20 Mar 2001, Ginger Mejia wrote:
> IS IT POSSIBLE TO LIST JOB OPPORTUNITIES TO THIS LIST IF ONE BECOMES
> AVAILABLE?
>
> --
Yes, but please don't abuse the privilege.
Don't post a position more than once a week; if you
have several, please send them in a single message.
And thanks for
Hi all
I would like to create an audit trial for particular tables within Oracle
database and thought about using triggers.
I would like to log changes to each column separately. Is it
possible to find dynamically name of the columns that were
updated?
I guess on INSERT I can check value of
That's not why they are some of the best, they were already some of the best
if they were able to get there. Fact is, that it used to be just Canadians
who were the bomb, now good old American boys are actually climbing the
ranks. Now don't get me wrong, we ain't bread no Gretzky yet, but who
kn
For a heavy transactional system, I'd (like) to try to keep it around
20-30 minutes per switch, but most of the databases I'm dealing with right
now are hybrids. Basically, lots of reporting all day long with occassional
updates to data (unless they decide to re-calculate the figures during the
The reason I proposed the question is the rule seems to deal with databases which
have a constant transaction rate. Ours are highly variable. I've gone with keeping
the median within 15 and 30 minutes. Our logs are 200MB and can switch as often as a
once per minute to as seldom as once ev
At 10:07 AM 3/20/01 -0800, you wrote:
>U, Is this kinda like Mr. Sulu on Star Trek who was sure that the
>Russians invented everything?
I'm sure you're going to take a lot of hits on that one -- it was Mr Chekov.
>I thought Baseball and Basketball were distinctly inventions of the USA.
Can'
Rachel Carmichael wrote:
>
> I'm old but not THAT old :) would not have been draftable even at the end
> of the war (even if I were male!)
i am, and i was, and i don't. [and it doesn't have to do with the bugs.]
--
Bill Thater Certifiable ORACLE DBA
Telergy, Inc [EMAIL PROTECTED]
Home of baseball... home of baseball...
That doesn't mean anything -- it's like billboards that say "Our product was
voted the best!"
The best what?
Voted by whom?
Emotion with no context. Advertising at its best!
Do you know how many "blueberry capital of the world" towns there are in
Canad
The Smarties we are talking about in Canada are much
different. Candy covered chocolate. No sour taste at
all. Crispy Crunch is a chocolate bar (forget what the
inside is, maybe peanut butter).
-Original Message-
Sent: Tuesday, March 20, 2001 1:30 PM
To: Multiple recipients of list
And like a lot of Canadian doctors he became an U.S. citizen
-Original Message-
Sent: Tuesday, March 20, 2001 12:57 PM
To: Multiple recipients of list ORACLE-L
First off, I had no idea that a Canadian had invented baseball but
a Canadian most definitely invented Basketball. Go look it
Answered your own question, we have more money!!! It's fun to go to Canada
and feel like a "wealthy" american. Jeez, I wished I lived in Buffalo, I
would go to Canada and hang out and spend less money! hahaah jk, not trying
to pick a fight
USA RULES
-Original Message-
Smith
OH GOD THAT'S IT!!! I can't even look at the thing on my monitor...man I
have problems!
-Original Message-
Travis
Sent: Tuesday, March 20, 2001 1:51 PM
To: Multiple recipients of list ORACLE-L
I think what you are referring to is the camel [back] cricket, which is also
known as the ca
Hi Andrey,
> Hi DBAs !
> I'm looking for some FREE Oracle DBA / developer resources on the web :
> self-tests , OCP preparations materials , articles , books , etc ...
> Please share your resources !
> Thanks a lot in advance .
Check out the links in Table 1-1 on the following page:
=> http://
WoooHooo, this could really get things hot down here. Again, I have no idea
of what I'm talking about. Just a bunch of stuff that I "know" which is
probably wrong. Additionally, I imagine people in Miami think Philadelphia
is the Great White North, so the whole bikini thing was a jab at the
ste
Hello,
I have a partitioned historical table in tablespace TS1 with 8 local
indexes.
I'm not sure how is better to:
- put the eight indexes in separate tablespaces (with small extents) or
- create just one big tablespace (with larger extents) for all indexes.
Other concerns include:
- a form
Dan,
You've made one of the only mortal sins of the Internet, it's not dis'ing
the Canadians. It's making an inaccurate Star Trek reference. The ensign
of Russian-descent was Pavel Checkov played by . . . joined the cast in
episode # ... entitled ...
Your penance should be long and severe.
Kathe,
I thought every red-blooded American knew what Smarties where. And since I
have become the newest OCP (Other Confection Professional), I will enlighten
you. Smarties are a "penny" candy, sour in taste about the size of an M&M
vended in plastic wrap of 12-15 in a stack. I think Crispy Cru
Can someone give me a guideline as to how I
should draw a script to find special characters
in the database and replace them with blanks.
TIA
Shakeel Qureshi
[EMAIL PROTECTED]
__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http
Check the numbers again, especially the software. Having done the same study 1.5 yrs
ago, HP was a little more expensive in the HW but much cheaper in SW. Reason being
Sun uses Veritas Trusted Cluster (expensive $100k) for HA and HP uses MCServiceguard.
I've worked 5 yrs w/ Sun and 1.5 yrs w
I have no experience with the Sun cluster but I do have
experience with the HP ServiceGuard as its what we run
here. We have even had it fail. We do have a Sun server
here with a database on it and although I like the server
and have no complaints I am much happier with HP. There
are just littl
Do you know that all most of the top ranked American/European hockey
players actually played in the CHL. They start by getting drafted in
the major junior leagues. So ya, you could be just as good as an
American, as long as you train in Canada. In Canada if you are playing
hockey for your Unive
Smarties rule. Much better then M&M's. And for those
of you who think that Smarties are those sugar candies, its
not that man. People here at work had no clues either so
I had my mom ship up a whole wack of them.
I don't like Crispy Crunch bars but the Coffee Crisp bars
are pretty good. Perso
I thought it was that, but figured it was better to ask... you can find rock
candy these days in the fancier candy stores masquerading as coffee stir
sticks :)
>From: "Hand, Michael T" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]
I'm old but not THAT old :) would not have been draftable even at the end
of the war (even if I were male!)
>From: "Mohan, Ross" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: RE: RE: OT: Rachel in Vietnam
>Date: Tue
We are going 64-bit for HP but keeping Oracle at 32-bit. We really
had no choice for the HP side. We just need the memory that 32 bit
could not support. We have 9 K-class servers here that have been running
11-64-bit for quite some time (relatively speaking). But we are
getting rid of all our
Wow that was good!! You know, I don't really like baseball, but I am pretty
sure that when you drive into Hoboken it says on a sign "Home of Baseball
and Frank Sinatra". hmm Canada invented hockey, but they also invented
curling didn't they. Yeah, isn't that like the Canadian version of sh
First off, I had no idea that a Canadian had invented baseball but
a Canadian most definitely invented Basketball. Go look it up.
However, he was in the States when he invented it.
Once we get rid of Quebec we will have no issues as to what language
we are. We are bilingual. Except for Que
You are misinformed. If you have a table of the form
col1varchar2(1)
col2 number
col3 date
You can insert into it with the insert statement
INSERT INTO MYTABLE VALUES('X',23,SYSDATE);
As long as ALL the columns are included in the values clause in the order they were
created in the tab
I think what you are referring to is the camel [back] cricket, which is also
known as the cave cricket.
Look here --> http://entweb.clemson.edu/cuentres/cesheets/hhold/ce190.htm
and http://www.ent.iastate.edu/ipm/iiin/ccamelcr.html
We had alot of them in our basement - and boy, can they jump!
>
Hi all,
One of our developer is testing a function as shown below and this function
is used in a view. Just to see how many times the function is called, we
have a dbms_output statement in the function body. I was surprised to find
that the function gets called 3 times for each row.
Maybe the g
Andrey '
Electronic books can be found at:
RUSSIAN FREE BOOKS HTML FORMAT_+++
http://docs.rinet.ru/
ROR mª¿ªm
>>> [EMAIL PROTECTED] 03/20/01 12:36PM >>>
Hi DBAs !
I'm looking for some FREE Oracle DBA / developer resources on the web :
self-tests , OCP preparations materials , articles
Ian,
This is one of those where you can get the old "it depends" answer.
What type of database is this? What level of transaction activity do you
have? How big are your redo logs if you switch every 15 min, 20 min, 30 min?
How critical is recovery to the current time to you?
If you don't want
Yeah, but we could kick your XXX!! Not to mention that American Hockey
players are just as good if not better than Canadians!
-Original Message-
Patrice J
Sent: Tuesday, March 20, 2001 12:37 PM
To: Multiple recipients of list ORACLE-L
Sorry about this, but someone sent me this and I th
Hi,
we are currently in the process of evaluating a high availiability cluster
for our production database. The final two solutions are:
SunCluster 2x420R 2Gig 2x450Mhz
Storage 100Gig
Hewlett Packard MC ServiceGuard
2xL-Class 2x440Mhz 2Gig
Storage VA 7100 100Gig
Based on our criterias (scal
U, Is this kinda like Mr. Sulu on Star Trek who was sure that the
Russians invented everything? I might be wrong (happens all the time), but
I thought Baseball and Basketball were distinctly inventions of the USA.
You might be able to tell I'm a rabid fan of neither. Penicillin and the
telep
Well, group-
I have completely enjoyed the discussion on Canada, especially since I
make my first trip
to Toronto this April.
But can someone tell me what Smarties are? And Crispy Crunch/Coffee
Crisp?
Thanks-
Kathe
--
Kathe C. Newsome
Centenary College of Louisiana
Sr. Software Manager/Database
Title: RE: How long will 8.0.6 be supported?
According to a spreadsheet I've got
normal support ends 30-Sep-2001
Extended Assistance Support ends
30-Sep-2004
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Doing linear scans over an associative array is like
trying to club someone t
Interesting. We've got a 4-way K570 w/3GB mem that we'll be moving from
HPUX 10.20 to HPUX 11.0 this weekend (8 hours of watching tape spin), which
means I can FINALLY get us to 8i! YAY!
So, why or why not should one go to 64bit? Here's my perception:
Pros
---
Hi
Gurus !
Just
wanted to clarify that i'm interested in ANY FREE Oracle DBA related
resources on the web , not only OCP stuff .
Thanks
a lot for your attention !
Andrey
.
-Original Message-From: andrey
[mailto:[EMAIL PROTECTED]]Sent: Tue, March 20, 2001 7:49
PMTo: oralis
At 08:36 AM 3/20/01 -0800, you wrote:
>Roland,
>
>You can't. There are a number of ways to really cut down on the code
>required to do an insert, but if you think about it, how will Oracle
>know where the data is supposed to go if you don't give it the column
>name(at some point)?
Of course you
Andrey,
Here is a partial list that I have.
I give credit for these site and their content to the original authors. This is a
partial list I have gleaned from this list.
ROR mª¿ªm
http://www.stewartmc.com/oracle
http://www.stewartmc.com/oracle/tips.html
www.oraes.com/scr/expfull.sh
http://w
Actually, he was very valid in his request. He did not ask that
you completely stop but rather add the OFF-TOPIC into the subject
so it can be ruled out. It has been a rather long discussion with
lots of e-mails (not that I am complaining, just seeing his point).
-Original Message-
Se
09/30/2001 unless you have Extended Support, then it's 09/30/2004
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 10:36 AM
> I can't get into Metalink. Can anyone tell me how long 8.0.6 will be
> supported?
>
> Ron Smit
It was sarcastic.
Alex Hillman
-Original Message-
From: Kimberly Smith [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 12:37 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Lemon Juice in Ants Pooh-Poohed
Act
I don't get new user requests.. I get requests from end-users for data.
But I understand. And I know that it's a question of coming in with the
baseball bat and assorted heavy weaponry and making a stand (or as my CTO is
fond of saying "putting a stake in the ground")
Just haven't collected al
Arul
In init.ora have you specified MM/DD/ WITHOUT Quotes , as follows simply
:-
NLS_DATE_FORMAT=MM/DD/
> -Original Message-
> From: Martin Kendall [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, March 20, 2001 6:36 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE:
Everything about them is long except their body's. Oh Man!! If you
like'em, come on down to my house this spring and you take all of them out
of the pool change room!! They sit in there, on the cieling, on the floor
on the walls!! I can't deal, I know they can't hurt me, but they are just
so n
Yup. Like I said, you'd never want to do this in real life. I was just
illustrating the idea.
-Original Message-
Sent: Tuesday, March 20, 2001 12:30 PM
To: Multiple recipients of list ORACLE-L
Won't that continuously print:
Inserted 1 rows.
Inserted 1 rows.
...
(well, as long as you
Roland,
Check out the SQL manual, the syntax diagram clearly illustrates that you
don't need to explicitly name the column names as long as you are inserting
into all of the columns in the order they are defined in the data
dictionary.
insert into table_A values ('Hi', 'there');
A word of frien
While I've stayed away from the discussions about offended dieties and the like where
people espouse their philosophies of life, I could not let an assertion which was
clearly mistaken stand. In fairness to Mr. Steven, ants will have some citric acid in
their bodies; it is an intermediate step
Hi Folks ,
When I was tracing connect internal in sqlplus I came
across this quirk and of course I have to investigate
Guess what I found...: )
Bookmark Fixed font Go to End
Doc ID: Note:107842.1
Audit Trail: Connect Internal
Type: BULLETIN
Status: PUBLISHED
Content Type: TEXT
You can use the orapwd utility to recreate password file with new internal
password.
Rick
> -Original Message-
> From: Murali Vallath [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, March 20, 2001 9:17 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Someone changed INTERNAL pas
Two brand spanking new N-Class servers arrived yesterday as I was leaving
work. Sure look nicer then the K-Class's we currently run on. Can't wait
to get my hands on it. Plus I got a brand new NT server just waiting for me
as well (although its awfully hard to get excited about that one let me
Sorry Lee, it looks like Rachel is too much of a chocoholic to be up on her
hard candy nomenclature. In the US its refered to as Rock candy, basically
colored, flavored, crystaline sugar (sucrose, not glucose) available in
various shapes and sizes though I haven't seen much of it lately. [It's
p
Run orapwd.
Replace the password file. This is only possible if you have admin rights on
the system.
The options will come up if you add nothing to the end of the command, and
you can go from there.
You can change the system and sys passwords using ALTER USER as an
authenticated privileged user
Hi,
Pl. check in {ORACLE_HOME}/database directory there is a file
PWD.ora.
Just move this file some where and try to connect.
Bye
-Original Message-
Sent: Tuesday, March 20, 2001 4:18 PM
To: Multiple recipients of list ORACLE-L
URGENT,
Someone changed the internal password. How do
Title: RE: RE: RE: OT: Rachel in Vietnam
Dick ,
Didn't you know? Rachel WAS in Nam. But she
never talks about it. I think it had to do
with the bugs.
Just a thought.
Ross
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 8:3
Title: RE: Insert without telling column names
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>
> How can I create an insert statement without telling all the
> names of the columns?
> Give an example, please.
As Jared mentioned, if you are inserting int
Hi DBAs
!
I'm looking for some
FREE Oracle DBA / developer resources on the web :
self-tests , OCP
preparations materials , articles , books , etc ...
Please share your
resources !
Thanks a lot in
advance .
Andrey
.
Sorry about this, but someone sent me this and I thought it might be
relevant to the Canada and US discussion that took place last week.
With all the recipes going around, I thought it wouldn't do any harm.
Regards,
Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
F
We do not have a practice to give password for the internal account. So when
it promoted it sounded like someone had assigned a password. Apparently
there was a parameter
SQLNET.AUTHENTICATION_SERVICES parameter added to the sqlnet.ora file. when
I commented this out. It worked.
Thanks for yo
1 - 100 of 160 matches
Mail list logo