Home » RDBMS Server » Server Administration » move datafile to another tablespace (Oracle 7.3.4/ Solaris 8)
move datafile to another tablespace [message #543649] Thu, 16 February 2012 02:13 Go to next message
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.
Re: move datafile to another tablespace [message #543653 is a reply to message #543649] Thu, 16 February 2012 02:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: move datafile to another tablespace [message #543796 is a reply to message #543653] Thu, 16 February 2012 19:50 Go to previous messageGo to next message
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.
Re: move datafile to another tablespace [message #543812 is a reply to message #543796] Fri, 17 February 2012 01:05 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: unable to generate manual AWR snapshot
Next Topic: Reorganize table and index
Goto Forum:
  


Current Time: Thu Mar 28 04:17:32 CDT 2024