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.

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 01 17:14:36 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.