OraFAQ Forum: Server Administration » move datafile to another tablespace

Home » RDBMS Server » Server Administration » move datafile to another tablespace (Oracle 7.3.4/ Solaris 8)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

move datafile to another tablespace [message #543649]

Thu, 16 February 2012 02:13

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Pls. help me, an erroneously created datafile, re: "/path/../large_rbs_03.dbf" was created under the SYSTEM tablespace which is supposedly be in the LARGE_RBS tablespace.

How do I make the said datafile be under LARGE_RBS?

Thanks in advance.

Report message to a moderator

Re: move datafile to another tablespace [message #543653 is a reply to message #543649]

Thu, 16 February 2012 02:32

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You can't.
The only thing you can do is to resize it to the smaller size you can and create a new datafile in the correct tablespace.

Regards
Michel

Report message to a moderator

Re: move datafile to another tablespace [message #543796 is a reply to message #543653]

Thu, 16 February 2012 19:50

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Sir, thanks for this. I'm curious only what will happen to this erroneous datafile, it would just take storage space for sure, am I right?

Thanks again.

Report message to a moderator

Re: move datafile to another tablespace [message #543812 is a reply to message #543796]

Fri, 17 February 2012 01:05

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If you resize it to the smaller possible size, yes.
If it is greater, it can also contain object extents.

Regards
Michel

Report message to a moderator

Previous Topic:	unable to generate manual AWR snapshot
Next Topic:	Reorganize table and index

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 02:33:31 CST 2024