ORA-03297: file contains used data beyond requested RESIZE value - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: ORA-03297: file contains used data beyond requested RESIZE value

  1. #11
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Call me a cheat but why not try:

    1) Start DBA Studio and connect to the instance of interest.
    2) Expand the storage and tablespace nodes in the navigator.
    3) Right-click on the tablespace of interest and select "Show Tablespace Map"
    4) Look at the distribution of blocks in the tablespace and decide what you need to do next.

    Why make life hard for yourself
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  2. #12
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Originally posted by TimHall
    Why make life hard for yourself
    Tim,

    Only possible when the databases are Configured to OMS repository. Its always better get to know both ways of doing it.

    My Manager used to challenge the DBA team, howmany DBA's can do their job efficiently with no GUI based Tools. I guess only few people who have been working in Oracle technology for a while. Of course! Lots of installations have GUI tools now a days but, not all of the shops. For example, My shop doesn't have OEM configured ( though, I want to Configure) for a simple reason of "lack of resources".
    Reddy,Sam

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width