11 15, 2005
被人耻笑我不会数据库了...
改变表空间的大小出现ora-03297时,exp 导出备份,删除用户重建表空间,再imp
如何删除UNDOTBS的空间
(1)
create UNDO tablespace undotbs2
datafile 'E:\oracle\oradata\ycjt\UNDOTBS02.DBF' size 25m
autoextend on next 1m maxsize 500m;
(2)
alter system set undo_tablespace= UNDOTBS2;
Posted by hoofi at 11 15, 2005 08:57 PM