Moving BIGFILE tablespace datafile location
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,
How about adding a big disk and resizing the tablespace?
hi chucks ,
yes same,nothing is difference between smallfile and bigfile for placing new loc.
You can do that without shutting down the database ( same is true on small files)
alter tablespace ... offline normal;
alter tablespace rename datafile
alter tablespace online
Not sure about the exact syntax of rename file
alter database rename file <<old location>> to << new location>>;
Click Here to Expand Forum to Full Width