| datafile use problem [message #53433] |
Thu, 19 September 2002 07:34  |
eddie mc Govern
Messages: 1
Registered: September 2002
|
Junior Member |
|
|
I have a datafile in a tablespace that give ora-00600 errrors when anything tries to use it.
I don't want to drop the tablespace and re-org as it is going to be a massive amount of work.
I am wondering if there is a way i can tell oracle not to use that datafile.Currently the datafile has no extents allocated , as i dropped an index that was in it but something will grab it eventually and i can't control it.
Oracle musrt an algorithmn that decides where to look next and if i could flag the datafile not to be picked up , anyone out there able to rescue me ?
|
|
|
|
| Re: datafile use problem [message #53455 is a reply to message #53433] |
Fri, 20 September 2002 11:51  |
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
|
Senior Member |
|
|
Hi,
Please Test and then Try the command
SVRMGRL > Startup mount
SVRMGRL > Alter database datafile <DF NO> Offline [[<drop>]] ;
SVRMGRL > alter database open;
Now the corresponding datafile will be offline.. and database will be opened...
sai
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
