|
-
Hi,
Temporary tablespace can be used by many users to perform sorting and other creation of database objects such as indexes.
The solution to the problem is to shutdown the database and then try it out.When u shutdown the database Oracle flushes all the temporary segments.
If u have more memory than u can increase the SORT_AREA_SIZE in init.ora paramter file.Since when Oracle needs some sorting it will be done in memory first and then if it is insufficent it will be done in temporary tablespace.So i u have more memory increase the parameter.
In case of any help please be free to ask me at [email protected]
Regards,
Rohit Nirkhe,Oracle DBA,OCP 8i
[email protected]
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
|
Reply With Quote