- Post for FREE via your newsreader at post.usenet.com ****
Dave wrote:
> "Sybrand Bakker" <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote in
> message news:cfijl0984h3e44hpqnvj0e41vqr9c7an84_at_4ax.com...
>> On 28 Sep 2004 13:23:11 -0700, madcap_at_email.com (madcap) wrote:
>>
>>>Hi folks,
>>>
>>>I am using Oracle 9i with LMT. However one of the tablespace, USERS,
>>>is sized on a higher side and is 20% used. Can I not simply export
>>>all the objects that belong in that tablespace, drop objects, resize
>>>the tablespace and re-import?
>>>
>>>Is there anything wrong in the above method? The data is not much.
>>>
>>>Thanks in advance.
>>
>>
>> should work.
>>
>>
>> --
>> Sybrand Bakker, Senior Oracle DBA
> umm why not just resize it downwards?
How about using OEM?
It's easy to resizing or add datafile.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
- Usenet.com - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.usenet.com
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Received on Tue Sep 28 2004 - 21:39:13 CDT