Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Posts
    165

    Unanswered: Shrink undotbs does not shrink undotbs datafile?

    My env is RAC 9.2.0.4 on W2k and oracle CFS.With enterprise manager,i tried to shrink undotbs,equal to command ALTER TABLESPACE UNDOTBS1 RESIZE...Command is completed succesfully.But,when i look through Windows Explorer,I can see file is same size as before.Why?
    TIA,Zvonimir

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    Look into your undo-retention parameter.
    It really only shrinks if you bounce the database.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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