I'm working on getting a new system up on the same (?) platform - Dell
PowerEdge 6450 nodes, Dell/EMC FC4700 array, and 9i RAC. Click on the
Dell/Linux Yes in the certification matrix at:
http://www.oracle.com/ip/deploy/database/features/ops/certification/index.ht
ml?content2.html
1) The
BDY.RTF
Description: RTF file
hi!
if it's just a few tables you can use copy
copy from x/x@db to y/y@db create table_name using
select * from original_table
if thats not handy i would EXP the scheme and import it
with
imp y/y@db file=/path fromuser=x touser=y
then drop the old scheme
regards
daniel
[EMAIL PROTECTED]
C:\EXP SCOTT/TIGER TABLES=EMP QUERY='WHERE JOB IN (''MANAGER'')'
THIS WORKS FINE...
hth.
nIRMAL
(oCP?).
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 9:53 AM
To: Multiple recipients of list ORACLE-L
the following syntax gives invalid col name :
exp
Title: RE: Export syntax
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: lundi, 22. juillet 2002 23:53
To: Multiple recipients of list ORACLE-L
Subject: Export syntax
the following syntax gives invalid col name :
exp test/test file=expt.dmp
Let me know why you put restriction on export/import?
-Original Message-
Sent: Monday, July 22, 2002 8:59 PM
To: Multiple recipients of list ORACLE-L
Hi
I have a user with a schema and want to move that schema to another user.
I don't need the original user after the change
Can
BDY.RTF
Description: RTF file
From the O'Reilly Oracle SQL Tuning Pocket Reference
There is one situation in which bind variables are not such a great choice.
If you have column data in a table having a disproportionate number of rows
with certain values, and a very small number of rows with other values, you
should be using
Hi friends .
I am getting the error ora-24238 when accessing the table table_privileges .
How can I solve this
.?? Oracle version is 8.1.7.4.1 in win2k.
[EMAIL PROTECTED] SELECT * FROM TABLE_PRIVILEGES;
ERROR:
ORA-24328: illegal attribute value
Thanks
shibu
No, Instance recovery has to take place internally, SMON has to recover the
committed transactions which were left hanging in the cache to datafiles so
that the files become synchronized.
After that the db gets opened and roll backwards takes its own time. It
depends SMON does this job in the
Did you run catalog.sql which calls catexp.sql?
Sanjay
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: 23 July, 2002 4:53 PM
To: Multiple recipients of list ORACLE-L
Oracle Version: 8.1.7
OS : Sun Solaris
Shell: ksh
the following syntax gives invalid col name :
exp
Vikas, even if the parameters were set for the checkpoint to happen often,
all the
transactions *not* commited would still be rolled back !! for example, when
i shut down the PC
in the middle of doing an update of 1/2 a million rows !!! (how would these
parameters help?)
--
From:
Rahul,
Instance recovery requires Rollforward and Rollbackwards. If the transaction
is not committed it has to be rollbacked once the instance gets started. Let
us assume that there are no committed transactions which were left in the
buffer cache to be flushed back on to datafiles. This means I
Just log into the database using sqlplus and it will tell you
/u01/app/oraclesqlplus /
SQL*Plus: Release 9.0.1.0.0 - Production on Tue Jul 23 10:16:50 2002
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.0.1.2.0 - 64bit
If 64 bit then
Oracle9i Enterprise Edition Release 9.0.1.2.0 - 64bit Production
else
Oracle9i Enterprise Edition Release 9.0.1.2.0
end if;
Vikas Khanna
-Original Message-
Sent: Tuesday, July 23, 2002 3:54 PM
To: Multiple recipients of list ORACLE-L
Just log into the
Security is like insurance, people don't want to think about it.
Like people in battle, everyone tells themselves that the person next to
them will be the one to get shot. And they advance over the ridge, facing
the sun...
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems
Hi there!
In discoverer 9.0.2.39.01 (desktop edition), EUL 5.0.0.0.0.0 the export data
option
to PDF gives the following error:
Internal Error in generating report Export failed.
In MetaLink you can find bug 780474 for Discoverer 3! It seems to be the
same bug?!
If there is a workaround
Mike:
According to the docs, the first time an query is parsed, Oracle peaks at
the bind variable and bases the explain plan on those values. The values of
the bind variables are never looked at again
Kevin
-Original Message-
Sent: Tuesday, July 23, 2002 6:58 AM
To: Multiple recipients
Anita
Oracle Support doesn't really care why it is happening. All I get is, hangs
happen, your two options are shutdown abort/startup restricted/shutdown
immediate (a valid solution) or putting in Dead Connection Detection and
adding overhead. The ever so wonderful Metalink has at least a
Don Granaman£¬
I write to dell and they said:
//
We are working on a certified configuration of Oracle 9iRAC - Release 2
on RH Advanced Server on the 6650 platforms. This certified configuration
will be available soon. I have cc'ed our Product Marketing
But if you restore to a clone and then export and import you won't have the
tablespace offline will you? RBG
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 23, 2002 1:53 AM
What Ruth describes is tablespace point in time recovery or
um the I doesn't mean stubbornness
it's where you get your energy -- from yourself (Introvert) or from
others (Extrovert)
it's the Feeling part that makes me wonder about the DBA/computer
stuff... aren't geeks supposed to be loners?
--- Boivin, Patrice J [EMAIL PROTECTED] wrote:
That's
my constant comment to management is
If I am doing my job right, you should be wondering why you are paying
me this much money. When the world blows up and I fix it, fast, you
will KNOW why you are
--- Joe Testa [EMAIL PROTECTED] wrote:
mkb, you're right, the glory is in tuning nowadays, but
Where do you take this profile to find out what you are? I'm curious now. Is there someplace on-line that will let you do this?
Rodd Holman
On Mon, 2002-07-22 at 21:18, Boivin, Patrice J wrote:
That's very funny. INFP DBA... Wow! You do what you want with verve and to
Hell the
I start those discussions with are you SURE you want to depend on me
being ethical and honest as your security policy?
--- Tim Gorman [EMAIL PROTECTED] wrote:
I agree that the glory is in tuning, but I also think
backup/recovery gets
a sufficient amount of respect. It's nice now that
Banish him to the hinter lands, (where ever they are) and let us purify the
list!
And Gary, I have root privileges!
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 22, 2002 4:49 PM
hey - who is this SA and what is he doing here?
Title: RE: SQL Query
I hope this is not to late for you. Anyway, this questions comes up often. Below is the solution to pivot rows for up to 12 values of field1. Just adjust to fit your range of values.
HTH
Tony Aponte
Home Shopping Network, Inc.
create table tab1 (field1 number,field2
It makes it possible to upgrade without bringing the entire cluster down.
Erik
-Original Message-
From: Orr, Steve [SMTP:[EMAIL PROTECTED]]
Sent: Monday, July 22, 2002 7:54 PM
To: Multiple recipients of list ORACLE-L
Subject: 9i RAC on NetApp
I'm looking at the NetApp
so sweet. so deluded.
I'm one of the chronological seniors here.. not the oldest I've found
but close
on the other hand, AARP (American Association of Retired People) hasn't
started sending me their propaganda yet
--- [EMAIL PROTECTED] wrote:
I didn't know that they gave Managers jobs to
Hi
I'm not very familiar with web based application development.
One of our programmers has asked me a question regarding locking issues in
web based applications.In a typical scenario , users access the oracle
database
thro a browser via app-svr/web-svr . Connection pooling is implemented on
Now please, please tell me you don't REALLY talk about this geeky stuff at parties!
Jim
-Original Message-
Sent: Monday, July 22, 2002 9:53 PM
To: Multiple recipients of list ORACLE-L
Wish I could. This was at a party, and the person speaking was an
Oracle employee. We were
-Anniversary
-Wife's birthday
Suck up.
;o)
-Original Message-
Sent: Monday, July 22, 2002 3:10 PM
To: Multiple recipients of list ORACLE-L
For me, two things are embedded in permanent memory
Anniversary
Wife's birthday
All that is good flows from these
(see, I NEVER remember the
Hi Guys
,
I have
a standby server at diffrent city and Automotic log transfer which is performed
via listener is not fast fast becuase of our network structer and so I have
decided to ship logs via an autotamed shell ftp script but may be is there an
intellegent tool for this kind of
Hi
I am executing following query adn this query hits a number of indices on
this table.let me know what is wrong please.all in where clause are having
indexes.
select name,last_access, reg_date from empmaster where emp_id100
and reg_dateto_date('2001-01-01','-MM-DD') and
emp_st='valid'
Had a problem this morning where a package was invalid and it would hang
when we tried to recompile.
We assumed that some other session was trying to recompile it but was
hanging for some reason.
I have plenty of ways to look at table locks but don't have a query to show
locked packages.
do a search for Meyers-Briggs and there are sites
A lot of companies use this as a way of finding out what type a
person is so you can learn how to deal with the people you work with.
It's supposed to help with management styles etc
--- Rodd Holman [EMAIL PROTECTED] wrote:
Where do you take
What's your mailing address? I can make the arrangements for you.
Ken Janusz,CPIM
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 23, 2002 8:33 AM
so sweet. so deluded.
I'm one of the chronological seniors here.. not the
OH, to be young again and know what I know now.
AARP has some nice offers when you travel.
Mentioning the youth in management, At my last job (pre golden
handshake) I loved letting my manager know that I had more time in the
company then they had on the face of the earth. . It helped when
As I understand it the classes are required now to get certified straight
from nothing to 9i. Only a test is required to go from 8i to 9i. Also, I
believe it is only one course to get OCP. It is two more advanced courses
for OCM.
-Original Message-
Sent: Friday, July 19, 2002 1:04 PM
To:
AARP has already stopped sending me propaganda. I think I am the oldest on
the list. RBG
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 23, 2002 9:33 AM
so sweet. so deluded.
I'm one of the chronological seniors here.. not the
Ratnesh
I assume you are using the JDBC interface, rather than J2EE. You may want
to consider buying the book Java Programming with Oracle JDBC by Donald
Bales. He devotes a chapter to this subject. One issue he raises that will
limit your options is whether you have other applications besides
All,
We are tuning a new vital process on our data
warehouse, and it is IO intensive - lots of parallel
direct reads and writes. During our testing we are
driving IO wait to ~60% (per top).
questions:
1) is top a valid measure of IO wait?
2) Is a high io wait an issue to be concerned about?
3)
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate
What I
sometimes use is
alter
system checkpoint
startup force restrict
shutdown normal
-Rich
-Original Message-From: Jacques Kilchoer
[mailto:[EMAIL PROTECTED]]Sent: Monday, July 22, 2002
10:53
Here is the online test, very interesting. I am INTJ
as well.
http://www.humanmetrics.com/cgi-win/JTypes1.htm
Jack
That's very funny. INFP DBA... Wow! You do what
you want with verve and to
Hell the consequences whenever you blow up.
Being a P, you are pragmatic
about your
We used to use these at my last company, and I turned out to be a High C..
Which actually meant that I was a classic sales person profile.. Funny.. I
always thought of myself as more of a techie in a sales persons role.. ;)
-Original Message-
Carmichael
Sent: 23 July 2002 16:18
To:
Hmmm... thats intersting. I'm somewhat your junior and I've been getting
their propaganda for a couple of years already.
-Original Message-
Sent: Tuesday, July 23, 2002 9:34 AM
To: Multiple recipients of list ORACLE-L
so sweet. so deluded.
I'm one of the chronological seniors here..
Arslan - Have you looked at mapping a network drive (or is that what you
mean by automatic log transfer)? What do you mean that it is not fast, and
why should an FTP be faster? For example, is it a matter of the time taken
to transfer each log, or the amount of network bandwidth used?
Dennis
http://www.humanmetrics.com/cgi-win/JTypes1.htm
-Original Message-From: Rodd Holman
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 11:18
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
Myers-BriggsWhere do you take this profile to find out
what you are? I'm
Is there a utility similar to SQLLDR which will load tables
from XML files?
I found the Java and PL/SQL APIs for loading tables from
XML files and wrote a trivial Java application to load data so
my immediate problem is solved. I just wanted to make sure
that I hadn't missed a simpler way to
Has anybody ever come across a virus that affects Oracle db's via sqlnet?
Just curious how such a thing would work (have some ideas). There have to be thousands
of vulnerable db's out there (sys/change_on_install, system/manager, etc.)
(I've been reading Tom Clancy lately... Getting even
On an installation on a Tru64 Cluster, with the Cluster-File-System, there
*is* only 1 ORACLE_HOME, shared by both nodes.
I don't see why it cannot be done on another platforms, provided that the
platform allows the file-system to be mounted on both nodes concurrently.
Hemant
At 03:53 PM
That happens even to us SAs who are also DBAs (or vice versa). About five
years ago, I was explaining DCL and VMS to a new co-worker and describing
how I help protect against accidental file deletion by having DEL*ETE :==
DELETE/LOG/CONFIRM in my SYS$LOGIN:LOGIN.COM. So, I confidently issued a
Beware of self-reports!
They are notoriously innacurate.
e.g. ask people what they will be doing in the next three years, they are
almost always wrong.
Ask them what they are like, ask them their traits, and often they are
wrong. Wishful thinking kicks in, perhaps. Also when people think
not often... but there were at least 8 or 10 people there who were DBAs
and this party was the thank goodness the darned book is done party
so we started talking about writing books and someone said something
about OEM 101 and
I'm usually the one at the party saying (screaming?) NO MORE
We did a personality assessment class as a facilitation to team building.
It was supposed to make 'us' aware of other personalities, and how they
think and how they work best and how they interact and what they can bring
to a team. Was a kinda neat class... but it needed to be given to more than
Hi All,
Does anybody have a standard code or process for sending email from oracle to address
the following issue.
Thanks,
Ashoke
-Original Message-
Sent: Monday, July 22, 2002 3:37 PM
To: Multiple recipients of list ORACLE-L
Not sure it would be the best but... logically I would:
Robert,
I got into computers after being in the fertilizer industry, a
segue which has many times seemed quite apt.
A year or two ago, I noticed that Oracle Education had a
training/certification track for something they called
Database Operator (DBO) that was quite similar to what you
are
About 15 years ago, I was working as a contractor for a federal agency. The director
got this bright idea to have everyone, both fed and contract, take the Myers-Briggs.
I got through about the first 10 questions before I gave up in disgust and
frustration. I was able to answer about 1 or 2
why do you think hitting the indexes is a bad thing? what is the
performance of this query? What's the explain plan?
--- Seema Singh [EMAIL PROTECTED] wrote:
Hi
I am executing following query adn this query hits a number of
indices on
this table.let me know what is wrong please.all in
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate
For
openers, shutdown immediate is generally quicker than the combination
ofshutdown-abort/startup-restrict/shutdown-normal. It is also
gentler. Consider the analogy of shutting down a Windows desktop
computer. Is it
oh, thanks, but they'll start sending me stuff next year and I can wait
until then :)
--- KENNETH JANUSZ [EMAIL PROTECTED] wrote:
What's your mailing address? I can make the arrangements for you.
Ken Janusz,CPIM
- Original Message -
To: Multiple recipients of list ORACLE-L
I think this is funny, corporations relying on the Myers-Briggs which is
based on Jung's depth psychology - archetypes, synchronicity, collective
consciousness, alchemy and magic...
I don't believe most HR realize this.
Bureaucracies are supposed to be rational and here they rely on knowledge
Hold on does that mean that since I never learned
it, I should just wait for the new one? :)
Will it support 8.1.7 in client-server mode? :):)
(Or just Oracle9i?)
regards,
ep
On 22 Jul 2002 at 10:13, [EMAIL PROTECTED] wrote:
YUP, Saw the new version at an Oracle event in Boston a
I sit corrected...
Intuitive = stuborn.
Intraverted = leave me alone, I need to recharge.
: )
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
Sent: Tuesday, July 23, 2002 10:28 AM
To: Multiple recipients of list ORACLE-L
Subject:Re:
Well, just watch your mailbox for when the American society of Morticians
starts sending you funeral planning information. Now you know your REALLY old.
Dick Goulet
Reply Separator
Author: Ruth Gramolini [EMAIL PROTECTED]
Date: 7/23/2002 7:38 AM
Select using a column list, excluding the CREATED column. ORA-24328
means 'illegal attribute value', so I think the CREATED column is the
problem because it's defined as a varchar2(0).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Suzy Vordos
INET: [EMAIL
You can get a color laser printer cheaper than that.
besides RTFM, is there going to now be PTFM?
On 22 Jul 2002 at 12:36, [EMAIL PROTECTED] wrote:
Patrice,
You can still get them, you just have to order them seperatly at a platinum
plated cost. Last time I looked is was $1500 per
strange I seem to have changed somewhat I'm now an ISFJ... hm, it
still seems to fit me
Okay, no more on this here... it needs to move to the OT list now!
--- Jack Silvey [EMAIL PROTECTED] wrote:
Here is the online test, very interesting. I am INTJ
as well.
Gerald,
Contact SANS, they are working on an Oracle step-by-step guide, they are
looking for people who might want to volunteer as test sites.
SANS Research Office [[EMAIL PROTECTED]]
Send e-mail with subject line: Oracle bench test.
They are just collecting names for now, waiting for
Hi,
One of my developer wants to know what are the tables or any other objects being
modified during the execution of his application.
dba_objects have following 3 date fields. But I am not sure if any of these date
fields will capture the last DML(update, insert or delete) time.
CREATED
Jerry,
Don't laugh! I did an interview a couple, or has it been longer, of years
ago at a financial institution in my neighborhood (northern Mass). Anyway, the
interviewer who was the head of the DBA group suggested I show him how I would
troubleshoot a problem that they were having. OK,
I'm: ENTJ (Extroverted, Intuitive, Thinking, Judging)
slightly expressed extrovert
slightly expressed intuitive personality
moderately expressed thinking personality
slightly expressed judging personality
LOL
I'm a Field Marshall..
-Original Message-
Sent: 23 July 2002 16:29
To:
AMEN!!! Those yellow stickies all over the CD case just don't cut it and there is not
enough screen space on any terminal I've seen that replaces multiple books open at the
same time or books with paper weights holding them open to two separate sections for
quick flipping.
On the other hand,
What version?
Reply Separator
Author: Mandal; Ashoke [EMAIL PROTECTED]
Date: 7/23/2002 8:53 AM
Hi All,
Does anybody have a standard code or process for sending email from oracle to
address the following issue.
Thanks,
Ashoke
-Original
Title: RE: Myers-Briggs
I have been subjected to this rubbish repeatedly for
the last 20 years or so, including being forced
to do my senior project in college on non-sense related
to this test and the results.
My personal opinion: it's a bunch of crapola.
One of the major precepts of this
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate
Check
this out too :)
http://www.speakeasy.org/~jwilton/oracle/shutdown-abort-bad.html
-
Kirti
-Original Message-From: kkennedy
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23, 2002 12:14
PMTo:
How about PARTFM (pronouned 'PartyFM' ;) ?
- Kirti
-Original Message-
Sent: Tuesday, July 23, 2002 12:34 PM
To: Multiple recipients of list ORACLE-L
You can get a color laser printer cheaper than that.
besides RTFM, is there going to now be PTFM?
On 22 Jul 2002 at 12:36, [EMAIL
Also do you know what is the most selective part of the query. If you know
that one index will bring back the fewest rows then try hinting to use it.
-Original Message-
Sent: Tuesday, July 23, 2002 5:59 PM
To: Multiple recipients of list ORACLE-L
why do you think hitting the indexes
Have you considered trying StorageXpert from Quest?
- Kirti
-Original Message-
Sent: Tuesday, July 23, 2002 10:58 AM
To: Multiple recipients of list ORACLE-L
All,
We are tuning a new vital process on our data
warehouse, and it is IO intensive - lots of parallel
direct reads and
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate
I
don't necessarily agree that shutdown immediate is quicker. If you force a
checkpoint prior to the shutdown abort the subsequent crash recovery upon
startup is usually pretty fast. Parallel recovery could be a
Not a problem under 8.1.5 or 9.2.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 23, 2002 12:58 PM
Select using a column list, excluding the CREATED column. ORA-24328
means 'illegal
Title: RE: Index performance
Seema,
It would really help to see your index scripts also. If you have an index that includes emp_id, reg_date, emp_st, last_access, emp_status, and match, that index should work best. Use a hint on that index.
You say that this query hits a number of
Jack,
You can run 'iostat -x 5 5' to see which disk are being used.
In this example, the arguments state 5 sec increments, 5 times. This
output may show a need to spread your data amongst your disk differently.
-reggie
-Original Message-
From: Jack Silvey [mailto:[EMAIL PROTECTED]]
There have been a lot of off topic topics lately. I finally had to add the
"Rant" thread to my filters so I wouldn't get any more of it. Can we please
stick to things Oracle??
Boivin, Patrice J wrote:
I think this is funny, corporations relying on the Myers-Briggs which is
based on Jung's
none of them will capture DML changes
you have two choices:
1) turn on auditing... this will tell you at a macro level what has
been touched, but won't necessarily tell you who did it or if it was
done by the execution of his app
2) add an update_dt and an updated_by column to all tables and
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate
The
differences are
1.shutdown abort - is more drastic, no new
users are allowed to log in, disconnects current sessions without rollback,
recovery however would have to be done when restarted.
2.
shutdown immediate
Eric,
Huh?
Tom (you lost me at hallo)
-Original Message-
Sent: Tuesday, July 23, 2002 1:14 PM
To: Multiple recipients of list ORACLE-L
Robert,
I got into computers after being in the fertilizer industry, a
segue which has many times seemed quite apt.
A year or two ago, I noticed
well, I've done a number of test, both under trained supervision and
ones like this (and yes, I do discount a lot of the online stuff)
I've also worked with a therapist for years to get to really understand
me. I'm pretty sure I'm not mis-stating who I am :)
--- Boivin, Patrice J [EMAIL
what a nice way to put that :)
maybe they are taking mental age into account and so think I'm about
16?
either that or they have you confused with someone else, it was my
understanding that they tag you as soon as you hit 50
--- Toepke, Kevin M [EMAIL PROTECTED] wrote:
Hmmm... thats
Eric,
I learned OEM and decided it just wasn't worth it. I saw nothing of added
value there. I can and do everything that OEM does via either Cron or any
other scheduling tool.
The product makes no sense to me.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent:
oh goodie, now I can stop feeling badly over it :)
I've learned that whenever I log into a database as a superuser
(connect internal or / as sysdba) the FIRST command I issue is select
* from v$database so that I confirm that I am in the database I think
I'm in.
just a habit, but one that
Actually I'd think entj would be just about the ideal for a dba or sa. You
have the leadership ability to ride herd on people (such as developers), are
driven to keep up on the technical stuff, are well-organized enough to keep
track of everything...
I very aware of working against my natural
I am surprised that the developer doesn't know the code s/he
wrote/maintains.
g
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
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate
The
Backup Recovery Handbook has a great treatment of what happens in the
various shutdown methods.
Here
is a quick summary:
ABORT
- Disallow new connections, drop file locks, terminate
processes
IMMEDIATE -
I like the hyperlinks on the CD docs.
I like the improved master index and the search facility
I HATE not being able to write my own notes on the page or reading the
docs on the train
--- kkennedy [EMAIL PROTECTED] wrote:
AMEN!!! Those yellow stickies all over the CD case just don't cut it
Maybe
during these stressful times of financial market chaos and job uncertainty, some
people just need to clear the air and get stuf off their chest. The rest
of us are just goofs.
;o)
-Original Message-From: Jesse W. Asher
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 23,
Ashoke,
Any programer worth their salt should know what tables or objects are
modified by their applications. They documented and wrote it and should
know what happens when an update, delete, insert, etc happens to the
data. If they do not know what happens, How did they write the
application?.
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate
Well.
I'll
agree with you only on the basis that shutdown immediate sometimes hangs and in
those cases it is quicker to do the abort/start/shut normal combination.
However, based on a quick review of my logs from
It is common situation. He/she is probably a GUI developer. Most front end
developers are not too familiar with dba tables.
Mandal, you can do run this query next time you have a similar queston:
1 select column_name, comments
2 from dba_col_comments
3 where table_name='DBA_OBJECTS'
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate
Yes, I
WHOLE heartedly agree, and we do a shutdown immediate now, but the point
is... Oracle SUPPORT seems to be of the opinion that rather than trying to
figure out what is 'wrong' we should just do a shutdown abort
1 - 100 of 154 matches
Mail list logo