Q
Problem solve Get help with specific problems with your technologies, process and projects.

ORA-03297 when trying to resize tablespace

When I try to resize the tablespace I get the error ORA-03297.

Hello Sir, I have a tablespace of 2000m and it only used 40m. When I try to resize the tablespace I get the error ORA-03297. I've also used the coalesce command but it does not work. Please tell me what to do.
You are trying to shrink the tablespace below its high water mark. If you are running Oracle 10g and are using locally management tablespaces with Automatic Storage Management and row movement enabled on the tables, you could issue an Alter Table Shrink. If you are not at Oracle 10g or are not using locally managed tablespaces, the only way around this is to drop or move the tables or indexes containing extents above region in the tablespace you are trying to resize it to, or try a different size that is not below the tablespace's high water mark.
This was last published in June 2007

Dig Deeper on Oracle error messages

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close