you wrote:
there to claim his 42 virgins in Paradise?
This is a common mistake.
Read the following to know the truth:
Humor . . . bin Laden's fate?
After getting nailed by a Daisy Cutter, Osama made his way to the Pearly
Gates.
There, he is greeted by George Washington. How dare you attack
Umm.. couple of things to verify...
First, yes, it is me again!
Second, the U-Turn was done on a yellow light (at least that
is what I see that
night!)
Third, that is just a LA street, not a highway! :P
Forth, this is not wild... just LA type of driving!
Hey Welcome back Winnie!
John
Thanks, Winnie! It works.
I have a further quetion. If the archivelogs from time when the file was
created to current were lost, do we still have someway to bring the file
online?
Tom
-Original Message-
Sent: Wednesday, May 15, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L
Is that Winnie Liu?? The LA wild women street driver? Doing u-turns on a
red light across a 4 lane highway??
Good to see you again.
-Original Message-
Sent: Friday, May 17, 2002 12:28 PM
To: Multiple recipients of list ORACLE-L
Tom,
If you lost an archivelog from the time this
Tom,
If you lost an archivelog from the time this datafile was created to present
time. There is no way to simply offline that file and recover that file. It will
become a classic case of performing incomplete recovery then.
Glad that it works out for you! :D
WInnie
--
\ /
Umm.. couple of things to verify...
First, yes, it is me again!
Second, the U-Turn was done on a yellow light (at least that is what I see that
night!)
Third, that is just a LA street, not a highway! :P
Forth, this is not wild... just LA type of driving!
Winnie
--
\ /
Yeah, I have missed every OOW since then. Just not worth it compared to
IOUG.
I could have sworn I saw some Perl-looking DBA standing on the corner with
his eyes wide and mouth hanging open when she flung that car and her
passengers around.
BTW, when is that Perl/Oracle DBA book coming out.
Just make sure you have a good recovery plan!
Waleed
-Original Message-
Sent: Friday, May 17, 2002 2:01 PM
To: Multiple recipients of list ORACLE-L
Umm.. couple of things to verify...
First, yes, it is me again!
Second, the U-Turn was done on a yellow light (at least that is what I
No. Get some downtime, quickly(!) before data does get written to that
file. Go through the export/drop tablespace/recreate. BTW, do you know
_why_ the file header is corrupted? Is there a disk hardware problem? You
are gonna have downtime sooner or later. Tell damagement to get over it.
Since there is no data in the file, can we make a datafile to replace it?
Tom Xie
-Original Message-
Sent: Wednesday, May 15, 2002 11:25 AM
To: [EMAIL PROTECTED]
There is absolutely NO WAY to drop a datafile from a tablespace at all.
--
\ /
Umm.. Try this:
1) ALTER DATABASE DATAFILE 'filename' OFFLINE;
2) get rid of the offended datafile from OS
3) ALTER DATABASE CREATE DATAFILE 'filename(same as 1)';
4) RECOVER DATAFILE 'filename';
5) ALTER DATABASE DATAFILE 'filename' ONLINE;
Winnie
--
\ /
Scott - I agree with your advice. Could he take the bad datafile offline to
prevent Oracle from writing to it (until he rebuilds the table)? Would that
cause any other problems that I am overlooking?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
[mailto:[EMAIL
Not that I'm aware of. Sounds like an interesting idea, but one I've never
tried. I just told the users there was a hardware problem that necessitated
oracle coming down (whether there was one or not). Dishonest? Maybe, but
it bought me the brief, immediate downtime necessary to prevent more
there is a hardware problem that necessitated Oracle coming down. the only
question is does the database come down cleanly when YOU want it to or does it
come down with a crash, time undetermined, when the file is accessed?
|+---
||
Rachel,
you said
It's not just grants. Any procedure that references that table will have
to be
recreated, oracle uses object_id not object_name so the procedure will point
to
the old table etc etc
Can't he just re-compile the procedures? He doesn't have to re-create them.
Tom Mercadante
Tom,
Or,
- create a new tablespace
- ALTER TABLE {table_name} MOVE {new_tablespace)
- alter index {all indexes that belong to this table) rebuild
Hope this helps
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, May 15, 2002 1:49 PM
To: Multiple
Exactly my point. The answer is 42.
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: [EMAIL PROTECTED]
[SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 2:19 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: How to drop a datafile from a
Scott,
Did you hear that Douglas Adams was asked recently (i.e. a few years ago)
how he knew the Hubble Constant was (roughly) 42, back when he wrote the
Hitchhiker's Guide To The Galaxy series back in the 60s and 70s? The
Hubble Constant (having to do with the rate of expansion of the
no you can't recompile them... I tried that once, the recompiled procedure
referenced the renamed (old) table
it's the object_id thing. Oracle doesn't care what you name or rename an object,
it tracks it by the object_id.
Trust me, it screwed up triggers etc. real pita
I did not know that.
Didn't Douglas Adams recently adjourn to the right hand of Hubble, there to
claim his 42 virgins in Paradise?
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: Tim Gorman [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 3:38 PM
To:
I did not know that.
We're not worthy! We're not worthy!
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 15, 2002 3:13 PM
I did not know that.
Didn't Douglas Adams recently adjourn to the right hand of Hubble, there
to
AFAIK you can't quickly drop a datafile. What we have done in this situation is to resize the datafile to 1 byte or however small you can make it. That way oracle can never write an extent there. Then do the export/drop tablespace/import routine at your next maintenance.
Rodd
On Wed,
Pretty sure that ain't a Oracle7 feature
-Original Message-
Thomas F
Sent: Wednesday, May 15, 2002 12:43 PM
To: Multiple recipients of list ORACLE-L
Tom,
Or,
- create a new tablespace
- ALTER TABLE {table_name} MOVE {new_tablespace)
- alter index {all indexes that belong to this
No easy way to drop a datafile.
Your best bet would be to resize the datafile to a very small size
( eg 10k).
(This will cause a trivial performance overhead since it has to
checkpoint an extra
file. But not even worth mentioning)
And then add another
24 matches
Mail list logo