Home » RDBMS Server » Server Administration » Re-organisation of datafiles (Solaris , 9i R2)
Re-organisation of datafiles [message #308717] Tue, 25 March 2008 04:55 Go to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member
Hi,

I want to reorg some of my datafiles from filesystem /u01 to /u02 filesystem without making offline my tablespace and datafiles.(Not System tablespace)

Is it possible? This is my production DB and I cannot offline my tablespace and datafiles...

Please help...

Pokhraj

Report message to a moderator

Re: Re-organisation of datafiles [message #308723 is a reply to message #308717] Tue, 25 March 2008 05:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No, if you move them you have to put them offline otherwise Oracle will try to write outside the files.

Regards
Michel

Report message to a moderator

Re: Re-organisation of datafiles [message #308735 is a reply to message #308717] Tue, 25 March 2008 05:37 Go to previous messageGo to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member
The tablespace that required reorg has 5 datafiles.
My question is :
1. Whether entire tablespace I have to take offline or only individual datafile need reorg, have to take offline.....

2. If I take my tablespace offline whether the user able to make the dml transaction.

Pokhraj

Report message to a moderator

Re: Re-organisation of datafiles [message #308755 is a reply to message #308735] Tue, 25 March 2008 06:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
1. As you want, it depends on how you move the files
2. Of course they are not able to access the tablespace, this is the purpose to put it offline

Regards
Michel

Report message to a moderator

Re: Re-organisation of datafiles [message #308770 is a reply to message #308717] Tue, 25 March 2008 07:01 Go to previous message
pokhraj_das
Messages: 64
Registered: February 2008
Member
many thanx for your valuable comments...

Regards-
Pokhraj

Report message to a moderator

Previous Topic: unable to write to file
Next Topic: Power failure contoling
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 03:48:52 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.