ORA-03297 file contains used data beyond requested RESIZE value
Cause: Some portion of the file in the region to be trimmed is currently in use by a database object.Action: Drop or move segments containing extents in this region prior to resizing the file, or choose a resize value such that only free space is in the trimmed.看来是你新设定的数据文件大小不够存放当前已经占用的区,把数据文件大小再改大一点
Cause: Some portion of the file in the region to be trimmed is currently in use by a database object.Action: Drop or move segments containing extents in this region prior to resizing the file, or choose a resize value such that only free space is in the trimmed.看来是你新设定的数据文件大小不够存放当前已经占用的区,把数据文件大小再改大一点
解决方案 »
- 帮我看看这个百分号什么意思啊!!!在线等
- cursor 是否可以作为参数传递
- 求救
- 超变态的BUG!33-ORA-01002: fetch out of sequence
- win7旗舰从官网上下的oracle 11g R2的安装包,安装时各种错误.
- ORACLE用户登陆和权限的简单问题,大家帮我看下吧,谢谢
- oracle中各个系统用户的作用是什么?比如OE,QS,RMAN等等.
- 如何在oracle中实现取前10条纪录?(在线等)
- oracle8i 在solaris8 下面怎么安装?
- sql查询问题求解
- 为什么我的ORACLE817中没有安装LOGMINER要用到的dbmslsm.sql和dbmslsmd.sql两个脚本啊?
- 一个简单的关于SELECT语句的问题,急!!!
RENAME DATAFILE 'J:\ORACLE\ORADATA\TJYY\TEMP01.DBF'
TO 'diska:tbs_f5.dat';当然,这个数据文件已经定义好