-
I am using Oracle 8.1.7 on Solaris. My TEMP tablespace is of size 3GB and I want to maintain it at 1GB. The HWM is at 2.6G, so I created a new temporary tablespace, assigned it to all the users who were using the old one, brought the old one offline and ran the
DROP TABLESPACE TEMP INCLUDING CONTENTS;
The database is live and this process is really slow - it has been running for 2 hours now - as I have renamed the default temp tablespace for all the users I know this tablespace is not being used. Is this time period normal ? If not, what am I doing wrong ? The old temp tablespace was database managed.
Thanks,
Shiva.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|