| Napster |
Posted: Apr 28, 2008 05:37:51 AM |
Total Post: 29
Joined: Apr, 2008
|
Can a datafile offlined and then dropped be brought online?
If Y/N why?
Regards,
Np |
|
|
 GOPU |
| Posted: Apr 28, 2008 05:44:27 AM |  |
|
Total Post: 333
Joined: Apr, 2008
|
Hi,
Can you brief the quesion ?
what is your requirement ?
Regards
Gopu
|
|
|
|
|
| Napster |
| Posted: Apr 28, 2008 06:12:20 AM | |
|
Total Post: 29
Joined: Apr, 2008
|
I use the following command
Alter datafile 8 offline drop
can i bring this datafile online?
if y/n why?
|
|
|
|
|
| GOPU |
| Posted: Apr 28, 2008 06:15:57 AM | |
|
Total Post: 333
Joined: Apr, 2008
|
but you dropped the datafile ?
after dropping how you will bring the datafile online ?
|
|
|
|
|
| Napster |
| Posted: Apr 28, 2008 06:18:19 AM | |
|
Total Post: 29
Joined: Apr, 2008
|
hi,
thats exactly what my question is?...can u bring it online?
i feel the entry will be present in the control file
breif about the same
Regards
|
|
|
|
|
| GOPU |
| Posted: Apr 28, 2008 06:19:39 AM | |
|
Total Post: 333
Joined: Apr, 2008
|
One more thing this "alter datafile command worked properly"
I think it is "alter database datafile '<path>' offline drop;
OR
" alter tablespace <tablespace name> drop datafile '/....';
|
|
|
|
|
| Napster |
| Posted: Apr 28, 2008 06:23:02 AM | |
|
Total Post: 29
Joined: Apr, 2008
|
Yes it works..y wont it work?
for reference http://www.adp-gmbh.ch/ora/sql/alter_database.html
regards
|
|
|
|
|
| http://shaharear.blogspot.com |
| Posted: Apr 28, 2008 06:56:38 AM | |
|
Total Post: 128
Joined: Apr, 2008
|
if you take a datafile off line and then deleted it, the deleted datafile can be brought back IF the datafile physically exist.
hope it will answer your question..
http://sharear.blogspot.com/2008/04/brought-back-deleted-datafile.html
regard
http://sharear.blogspot.com
|
|
|
|
|
| Napster |
| Posted: Apr 28, 2008 07:00:28 AM | |
|
Total Post: 29
Joined: Apr, 2008
|
data file is physicaly present ..
but i have done "offline drop" not offline ... my database is in no archive mode ...
|
|
|
|
|
| GOPU |
| Posted: Apr 28, 2008 07:45:24 AM | |
|
Total Post: 333
Joined: Apr, 2008
|
The command to drop a datafile is
alter database datafile offline drop;
then command you given "Alter datafile 8 offline drop" is worked for you ?
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
