Moving BIGFILE tablespace datafile location
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Moving BIGFILE tablespace datafile location

  1. #1
    Join Date
    Dec 2001
    Posts
    337

    Moving BIGFILE tablespace datafile location

    Hi all,

    A need has arisen to move our BIGFILE tablespace (the actual datafile) from one SAN mount point to another. When it comes to moving the file from one location to another, is it the same procedure as with moving normal datafiles?

    i.e shutting down the db, copying the file to the new location, mounting the db and renaming the file, opening the database.

    Thanks in advance,
    Chucks

  2. #2
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    How about adding a big disk and resizing the tablespace?

  3. #3
    Join Date
    Feb 2007
    Location
    UNDER MOON
    Posts
    44
    hi chucks ,

    yes same,nothing is difference between smallfile and bigfile for placing new loc.

  4. #4
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    You can do that without shutting down the database ( same is true on small files)
    alter tablespace ... offline normal;
    move file
    alter tablespace rename datafile
    alter tablespace online

    Not sure about the exact syntax of rename file

    Cheers

  5. #5
    Join Date
    Feb 2007
    Location
    UNDER MOON
    Posts
    44
    rename file....

    alter database rename file <<old location>> to << new location>>;

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