DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: how to reduce size of datafile

Threaded View

  1. 04-29-2003, 01:07 AM #3
    shandj
    shandj is offline Junior Member
    Join Date
    Feb 2002
    Posts
    70
    ALTER DATABASE DATAFILE '' resize 200m;

    What are the storage parameters of your temp tablespace?? Is contents of your tablespace permanent or temporary. If it permanent change it to temporary.
    Last edited by shandj; 04-29-2003 at 02:00 AM.
    ________________
    ShanDJ
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width