Re: Deleting a tablespace

From: Carlos Netto <Carlos.Netto_at_ibase.org.br>
Date: Sat, 20 Aug 94 22:30:00 -0300
Message-ID: <2aa.719.846%mpcbbs_at_ibase.org.br>

On 17 Aug 94 05:24pm, Ramesh (cntr - rfisher wrote to ALL:

 R(> Newsgroup: comp.databases.oracle
 R(> Organization: Oracle Corporation, Redwood Shores CA 94065

[deleted lines]

 R(> It is always safer to drop all the tables ,indexes etc in the tablespace
 R(> and then drop the tablespace without specifying the including contents 
 R(> option. The tables etc in the tablespace can be queried from 
 R(> dba_segments to find out the names of the tables and indexes....
 

[deleted lines]

 R(> Ramesh Krishnamurthy

There is another good reason to not use "drop tablespace including contents" -> Oracle BUG! I used it once and my database was OVER! Once I know Oracle for years, I made a backup before :-). I just created the database again and imported the data. My database became unfragmented!

I don't know if it's working now, because it's dangerous to test it ;-)

Good luck,

---

| Carlos Augusto Leite Netto | Voice : +55.192.51.1153 |
| Software Design Informatica | Fax : +55.192.54.6518 |
| Oracle VAR | e-mail : carlos.netto%mpcbbs_at_ibase.org.br |
| Software Development & DBA | FidoNet: 4:801/31 (Carlos Netto) |

|---------------------------------------------------------------------------|


|  Softex 2000 member           | Brazil, Sao Paulo state, Campinas city    | 


=============================================================================

• Evaluation copy of Silver Xpress. Day # 57 --- via Silver Xpress V4.01P [NR]

  ---

User Name: Carlos Netto - ( %mpcbbs_at_ibase.org.br ) This message was processed by RAuucp from Merlin Systems Inc.

---

Received on Sun Aug 21 1994 - 03:30:00 CEST