Hence, you must re-define the tablespace to change the extent management: Backup the tablespace Export the tablespace data Drop and re-allocate the tablespace Import the tablespace For details of 10g tablespace management, see the bestselling book " Oracle 10g Grid and Real Application Clusters ". Alter tablespace segment space management options The segment space management options are either "auto OR manual" see the vertical OR bar " " in the syntax diagram above.
The tablespace syntax above that the "auto" and "manual" tablespace segment space management options are "mutually exclusive", meaning that you must choose either "auto" or "manual". The "segment space management space auto" is sometimes called ASSM Automatic Segment Space Management , or " bitmap freelists ", because the freelist management is moved from one-way linked lists to bitmaps.
Again, there is no syntax for changing segment space management from manual to auto and you cannot use "alter tablespace" to change the segment space management mode of a tablespace.
Hence, you must re-define the tablespace to change the extent management: Backup the tablespace Export the tablespace data Drop and re-allocate the tablespace Import the tablespace Also see my notes on Oracle tablespace migrate from dictionary to local managed tablespaces.
If you like Oracle tuning, see the book " Oracle Tuning: The Definitive Reference ", with pages of tuning tips and scripts. Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise.
Thanks in advance Dileep. Join Date Mar Location Ft. Lauderdale, FL Posts 3, As far as I remember you cannot. Create new ASSM tablespaces, move the data then drop the old tablespaces. Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Contact Us DBAsupport. If they do not meet this, it will warn you than it cannot be reorganised online. Therefore the best in this case is to use Offline reorganize. Remember to read more on this and only do it if you know what you are doing. No comments:. Newer Post Older Post Home. Subscribe to: Post Comments Atom. He has worked on various IT projects in different sectors and like to share and transfer knowledge and experiences to others.
0コメント