-
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
-
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;
move file
alter tablespace rename datafile
alter tablespace online
Not sure about the exact syntax of rename file
Cheers
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|