Tablespace shrinking:
Error: ORA-03297 file
contains <number> blocks of data beyond requested
RESIZE value
RESIZE value
Solution: Check the
max block id in the each datafile of the tablespace, multiply with db block
size parameter. You will get minimum size of data file in bytes.
Use dba_extents,
dba_data_files tables to figure it out.
No comments:
Post a Comment