Re: Tablespace Reorg

From: Stuart Hemming <shemminga_at_cix.compulink.co.uk>
Date: 1996/01/31
Message-ID: <DM1Kwy.6zG_at_cix.compulink.co.uk>#1/1

> "Mark C. Rush" <mrush_at_ocdis01.tinker.af.mil> writes:
> How do you reorg a tablespace?
>
> Export all the objects in the tablespace, drop them, then import?
>
> If so, how do you find all of the objects in a tablespace?
>
> I know how to find all the tables, indexes, or clusters in a specific
> tablespace.

That's all you need I think. A quick look at my DBA notes suggests that all SP's etc are stored in the system tablespace.

---

These are *my* opinions. Please don't make the mistake of believing anybody else is stupid enough to think like this!

---

 Stuart Hemming                     | shemminga_at_cix.compulink.co.uk
 The Data Base                      | Tel: + 44 (0) 115 925 0005
 Nottingham UK                      | Fax: + 44 (0) 115 929 4668
-------------------------------------------------------------------

Received on Wed Jan 31 1996 - 00:00:00 CET