执行一个sql脚本的时候报错, @ /sql/a.sql.pre 这里执行非sql后缀的sql脚本可以吗?报错如下:CREATE OR REPLACE PACKAGE BODY a_pkg
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-30036: unable to extend segment by 8 in undo tablespace 'ROLLBACK'是表空间分配不够吗?
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-30036: unable to extend segment by 8 in undo tablespace 'ROLLBACK'是表空间分配不够吗?
2.把你的临时表空间的数据文件修改为autotextend
ALTER TABLESPACE temp ADD DATAFILE ‘xxx.dbf' size 200M;
ALTER TABLESPACE temp ADD DATAFILE ‘xxx.dbf' resize 200M
ALTER TABLESPACE temp ADD DATAFILE 'xxx.dbf' resize 200M
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
alter database datafile 'dataName.dbf' resize 200M
ORA-00933: SQL command not properly ended
--see it
SQL> alter database datafile 'F:\oracle\product\10.2.0\oradata\orcl\TBS_CCARE_IDEF.DBF' autoextend on;Database alteredSQL> alter database datafile 'F:\oracle\product\10.2.0\oradata\orcl\TBS_CCARE_IDEF.DBF' resize 31M;Database alteredSQL>
-rw-r----- 1 qscora dba 134225920 Dec 16 11:27 /qscora/oradata/temp1.dbfsu - qscora
sqlplus /nolog
SQL> connect / as sysdba;
SQL> alter database datafile '/qscora/oradata/temp1.dbf' autoextend on;
alter database datafile '/qscora/oradata/temp1.dbf' autoextend on
*
ERROR at line 1:
ORA-01516: nonexistent log file, datafile, or tempfile
"/qscora/oradata/temp1.dbf"这是什么问题呢? 明明文件存在呀
---first
select file_name from dba_data_files;---snd,choice you dataFileName replace it
alter database datafile 'TBS_CCARE_IDEF.DBF' autoextend on
ALTER TABLESPACE temp ADD DATAFILE ‘xxx.dbf' size 200M; 改变数据文件的大小
ALTER TABLESPACE temp ADD DATAFILE ‘xxx.dbf' resize 200M改变数据库的自动扩展
alter database datafile 'F:\oracle\TBS_CCARE_IDEF.DBF' autoextend on;