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
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: 64122
Registered: March 2007
Location: Nanterre, France, http://...
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
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
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: 64122
Registered: March 2007
Location: Nanterre, France, http://...
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
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
Previous Topic: unable to write to file
Next Topic: Power failure contoling
Goto Forum:
  


Current Time: Wed Dec 07 04:57:05 CST 2016

Total time taken to generate the page: 0.21669 seconds