Home » RDBMS Server » Server Administration » How to move tablespace from logical volume to another (oracle 10g release1, HP-Unix 11)
How to move tablespace from logical volume to another [message #403380] Fri, 15 May 2009 04:43 Go to next message
majid tahir
Messages: 39
Registered: July 2007
Location: Pakistan
Member
I want to move the datafiles to another volume group. Currently the datafiles are located on (storagetek) SAN. I want to create a new volume group and move the datafiles to that new volume group. What steps i have to perform to avoid problems.
Re: How to move tablespace from logical volume to another [message #403397 is a reply to message #403380] Fri, 15 May 2009 06:03 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
offline datafiles or tablespace (I prefer the latter)
move datafiles
online datafiles or tablespace

For steps 1 and 3, see ALTER DATABASE or ALTER TABLESPACE statement.

Regards
Michel
Previous Topic: Undo TBS full, does transaction rollback or hang?
Next Topic: tempfile
Goto Forum:
  


Current Time: Sat Dec 10 17:04:25 CST 2016

Total time taken to generate the page: 0.12332 seconds