#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    1
    Rep Power
    0

    Need help with Oracle 11g


    Hi,
    I am trying to Shrink Table space using the following SQl
    As we are dropping large datasets. Later i am trying to shrink the table space

    Alter Tablespace table_name Shrink Space Keep 20M;

    Is this the best way to do in oracle 11G
  2. #2
  3. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Sep 2006
    Posts
    840
    Rep Power
    387

    Cool


    Originally Posted by aditya reddy
    Hi,
    I am trying to Shrink Table space using the following SQl
    As we are dropping large datasets. Later i am trying to shrink the table space

    Alter Tablespace table_name Shrink Space Keep 20M;

    Is this the best way to do in oracle 11G
    SHRINK SPACE Clause is valid only for temporary tablespaces.

    You could start by shrinking the tablespace files:
    Code:
    ALTER DATABASE DATAFILE '/pathto/oradata/sid/the_file01.dbf' RESIZE 64K;
    ALTER DATABASE DATAFILE '/pathto/oradata/sid/the_file02.dbf' RESIZE 64K;
    -- Etc --

    Comments on this post

    • debasisdas agrees

IMN logo majestic logo threadwatch logo seochat tools logo