Message-Id: <10679.121950@fatcity.com> From: "Burton, Laura L." Date: Mon, 13 Nov 2000 16:34:42 -0600 Subject: Redo a Tablespace This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C04DC1.EAE13FD2 Content-Type: text/plain; charset="iso-8859-1" I want to delete a tablespace that is already in use (contains tables) and rebuild it. Would someone please look at the steps I am going to take and offer advice if you see a problem? 1. Shutdown database and back it up (datafiles, redo, archive, etc) 2. Restart database ... maybe exclusive to keep others off 3. Export user (which only has tables on the tablespace I want to delete) 4. Drop user cascade 5. Drop tablespace 6. Delete datafile file from disk (if the drop tablespace takes care of this then I'll go to step 7) 7. Create tablespace with new info 8. Create user 9. Import user 10. Alter database for everyone's use Thank you in advance. Laura ------_=_NextPart_001_01C04DC1.EAE13FD2 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Redo a Tablespace

I want to delete a tablespace that is = already in use (contains tables) and rebuild it.  Would someone = please look at the steps I am going to take and offer advice if you see = a problem? 

 1.  Shutdown database and = back it up (datafiles, redo, archive, etc)
 2.  Restart database ... = maybe exclusive to keep others off
 3.  Export user (which = only has tables on the tablespace I want to delete)
 4.  Drop user = cascade
 5.  Drop tablespace
 6.  Delete datafile file = from disk (if the drop tablespace takes care of this then I'll go to = step 7)
 7.  Create tablespace with = new info
 8.  Create user
 9.   Import user =
10.  Alter database for = everyone's use

Thank you in advance.

Laura