Oracle 10g 异常:ORA-01658:unable to create INITIAL extent for segmnet in tablespace SYSTEM
来源:互联网 发布:家庭网络信息箱接法 编辑:程序博客网 时间:2024/06/05 22:46
问题描述:
ORA-01658:unable to create INITIAL extent for segmnet in tablespace DATA01
原因:
表空间DATA01空间不足,导致数据无法插入。
Solution:
- 重新定义表空间大小:
ALTER TABLESPACE DATA01 RESIZE 5G ;
- 将表空间删除后重新定义表空间:
DROP TABLESPACE DATA01 INCLUDING CONTENTS AND DATAFILES ;
CREATE TABLESPACE “DATA01”
LOGGING DATAFILE ’D:/ORACLE/PRODUCT/10.2.0/SSVC/DATA01.DBF’
SIZE 5000M REUSE
DEFAULT STORAGE (INITIAL 10K NEXT 128K MINEXTENTS 1 MAXEXTENTS UMLIMITED PCTINCREASE 100) ;
- Oracle 10g 异常:ORA-01658:unable to create INITIAL extent for segmnet in tablespace SYSTEM
- ORA-01658:unable to create INITIAL extent for segmnet in tablespace XXX
- ORA-01658:unable to create INITIAL extent for segmnet in tablespace XXX
- Oracle导入异常: unable to create INITIAL extent for segment in tablespace MY_DATA
- hibernate--:Oracle unable to create INITIAL extent for segment in tablespace xx
- IMP-00003:遇到Oracle错误1658 ORA-01658:unable to create INTTIAL extent for segment in table LICAIEDU_INFO
- Oracle Linux 6.1 安装Oracle 10g ORA-27125:unable to create shared memory segment 解决方法
- Oracle Linux 6.1 安装Oracle 10g ORA-27125:unable to create shared memory segment 解决方法
- Oracle Linux 6.1 安装Oracle 10g ORA-27125:unable to create shared memory segment 解决方法
- Oracle 10g 异常:ORA-01950: no privileges on Tablespace
- ORA-01653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM
- 关于“ORA-01653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM”的错误
- ORA-01653:unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM
- Oracle unable to extend table in tablespace
- Create tablespace in Oracle
- ORA-01653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM系统表空间满
- oracle 11g 错误之ORA-09925: Unable to create audit trail file解决办法之一!
- IMP-00058: ORACLE error 30036 encountered ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'
- 基本原则:强烈建议在站点中不要使用window.open方法
- typedef跟枚举变量。
- struts Logic标签介绍
- 秋已凉
- 手机获取IMEI号的方法
- Oracle 10g 异常:ORA-01658:unable to create INITIAL extent for segmnet in tablespace SYSTEM
- google相册(Picasa)打不开picasaweb不能访问解决办法
- 学习机罢工?原来是中了文件夹变exe文件的病毒Trojan-Dropper.Win32.Flystud.yo
- 如何在流程中触发其他工作流
- C/C++中的静态数据和静态函数的用法
- JSP通用分页组件 pager-taglib使用
- 阶乘算法全集,阶乘末尾非零位,阶末尾零的个数(转)
- ABC.SCR 用VFOX8.0连编成ABC.EXE文件问什么不能运行?
- 闲扯原码、反码、补码(转)