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.
Dig Deeper on Oracle error messages
A user complains that every time he tries to access a table (select only), it takes more than two hours to get
the results. There are no DML ...continue reading
I have always used TKPROF to do SQL tuning in previous versions of
Oracle (7,8 and 9). Can I still use TKPROF in Oracle 10g R2?continue reading
I have a table with 1.5 million records that needs to have a column updated based on a correlated subselect. This update is currently sitting at four...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.