move tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: move tablespace

  1. #1
    Join Date
    Apr 2001
    Posts
    103

    Angry

    Hello,
    I have all my table space in one unix partition(/oracle/tablespace/user.dbf, etc)
    This partition is full there is no more space.
    I am removing certain files to make some space.
    I have another partition (/oraexport/home) which has around 40G free space.
    Is it possible for me move oracle files and tablespace to this partition.
    It is very urgent. Sorry for my english.
    Naeem
    Naeem

  2. #2
    Join Date
    Jun 2001
    Posts
    33
    possible :

    1) take the tablespace offline
    2) move the datafiles at OS level
    3) alter tablespace xxx rename datafile 'olddatafile1' 'olddatafile2'
    to 'newdatafile1' 'newdatafile2'
    4) take the tablespace online

    this works only with non system tablespace because u cannot take system tablespace offline

    hope that will help

    the other solution is startup nomount ur database and use
    alter database move datafile ...


  3. #3
    Join Date
    Apr 2001
    Posts
    103

    move tablespace

    Thanks Armel
    I will try it
    Naeem

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