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

    Unanswered: Shrink undotbs does not shrink undotbs datafile?

    My env is RAC 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?

  2. #2
    Join Date
    Jul 2003
    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