Timeline for How to remove datafile from oracle database which is already remove locally?
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 23, 2016 at 23:43 | comment | added | EdStevens | What was the error message when you tried to drop the file? It would be very rare to be able to drop an individual file from a multi-file tablespace, as all the files will have data. If, as the name suggests, this TS has only index segments, your best bet would be to drop the entire TS, re-create it, and rebuild the indexes. | |
| May 23, 2016 at 11:03 | history | edited | Nainita | CC BY-SA 3.0 |
added 3 characters in body
|
| S May 23, 2016 at 9:34 | history | suggested | Marco | CC BY-SA 3.0 |
SQL command now more visible.
|
| May 23, 2016 at 9:29 | answer | added | Marco | timeline score: 2 | |
| May 23, 2016 at 9:19 | review | Suggested edits | |||
| S May 23, 2016 at 9:34 | |||||
| May 23, 2016 at 8:15 | history | asked | Nainita | CC BY-SA 3.0 |