Redo a Tablespace

From: Burton, Laura L. <BurtonL_at_prismplus.com>
Date: Mon, 13 Nov 2000 16:34:42 -0600
Message-Id: <10679.121950@fatcity.com>

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?

Shutdown database and back it up (datafiles, redo, archive, etc)
Restart database ... maybe exclusive to keep others off
Export user (which only has tables on the tablespace I want to delete)
Drop user cascade
Drop tablespace
Delete datafile file from disk (if the drop tablespace takes care of this then I'll go to step 7)
Create tablespace with new info
Create user
Import user
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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>Redo a Tablespace</TITLE>
</HEAD>
<BODY>

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
Received on Mon Nov 13 2000 - 16:34:42 CST