how to drop datafile [message #555636] |
Fri, 25 May 2012 22:56 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
andy huang
Messages: 498 Registered: July 2011
|
Senior Member |
|
|
Dear all,
I can not drop datafile in a tablespace,how can i do?
SQL> Alter Database Datafile '/u02/app/oracle/oradata/oracl/hxl06.dbf'
Offline 2
3 /
Database altered.
SQL> Alter Tablespace tps_hxl
Drop Datafile '/u02/app/oracle/oradata/oracl/hxl06.dbf'; 2
Alter Tablespace tps_hxl
*
ERROR at line 1:
ORA-03264: cannot drop offline datafile of locally managed tablespace
|
|
|
|
|
|
|
Re: how to drop datafile [message #559224 is a reply to message #559221] |
Sat, 30 June 2012 00:22 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68663 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Please do NOT feed the lazy.
The purpose of this site is to help people learn NOT to spoonfeed and give basic solutions.
If you want you can provide a link to the documentation.
Regards
Michel
|
|
|