DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: tablespace resize

  1. #1
    Join Date
    Mar 2004
    Posts
    53

    tablespace resize

    Hi,

    Hi can somebody help me in resizing the tablespace here? Most of the tablespace is used. Database is oracle 8.1.5 Please tell if there is a really short way to do it OR if there are steps, please send some links

    Thanks in advance.

    Code:
    ================================================================================
    TABLESPACE UTILIZATION REPORT - xxx@yyy   March 26, 2004
    ================================================================================
                                                                                    
                                  Total     Used     Free     Pct   Largest         
    TABLESPACE                     (Mb)     (Mb)     (Mb)     Free   (Mb)  Fragments
    --------------------------------------------------------------------------------
    dabce                       6260.1   6218.1     42.0       .7     10.0       42

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    ok, lil bit of concepts here, you dont resize a tablespace you resize a datafiles

    so in sqlpl*plus or svrmgrl

    Code:
    select file_name, bytes/1024/1024 from dba_data_files where tablespace_name = 'DABCE';
    This will give you the current size in Mb

    to resize do this

    Code:
    alter database datafile 'full_path_to_datafile' reisze XXXM;
    where XXX is the new size

    so for example this could be
    Code:
    alter database datafile '/u01/oradata/DB/dabce.dbf' resize 8000M;
    This must be done with someone who was the alter database privelege, e.g. sys or system or someone with dba role.

  3. #3
    Join Date
    Apr 2002
    Location
    Bangalore
    Posts
    47

    Smile

    alternatively,you can add a new datafile to the tablespace
    Cheers
    Murali

  4. #4
    Join Date
    Feb 2004
    Location
    India
    Posts
    18
    Please remember resizing does not add up to the existing ones.
    Say u r having the size for the existing datafile as 100M then resizing the datafile by 800M will not make the size of datafile 900M.
    It will be 800M.

    KAushik

  5. #5
    Join Date
    Mar 2004
    Posts
    53
    HI,

    Can you tell me what this means?

    select file_name, bytes/1024/1024 from dba_data_files where tablespace_name = 'DABCE';


    What is file_name and what is dba_data_files? Can you tell how to find their exact names.

    alter database datafile 'full_path_to_datafile' reisze XXXM;

    Also, how to find the full path to datafiles?

    Thanks

  6. #6
    Join Date
    Mar 2004
    Posts
    53
    Can somebody explain ASAP please?

  7. #7
    Join Date
    Mar 2004
    Posts
    53
    Hi,

    I tried issuing desc dba_data_files and it says table or view doesn't exist. I also tried sys.dba_data_files.

  8. #8
    Join Date
    Mar 2004
    Posts
    53
    Hi Also,,

    Where do I give that command? Will it work when I log in as su oracle?

    Or should it be given at a sqlplus env? And how do I get the dba/sys privilege? Please note that I am performing an exercise.

  9. #9
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    U better RTM
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  10. #10
    Join Date
    Mar 2004
    Posts
    53
    Hi,

    What's RTM? I am just looking for some answers. I don't think I should give up doing this task at this time. Thanks

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