system的默认表空间是不是system啊,那tools表空间和 system用户有什么联系啊,又该如何分配合理呢.请大家解答. :em02: :em02: :em02:
SQL>; create table aaa tablespace users as select * from sys.test; create table aaa tablespace users as select * from sys.test * ERROR at line 1: ORA-01552: cannot use system rollback segment for non-system tablespace 'users' 用move的方法也不行 (2) ORA-01552 cannot use system rollback segment for non-system tablespace 'string' 原因: 没有可...
操作系统BSD(其实就是使用emulate linux模拟linux环境) oracle9.2.0.4 SQL> startup oracle instance started. Total System Global Area 1613101776 bytes Fixed Size 453328 bytes Variable Size 1610612736 bytes Database Buffers 819200 bytes Redo Buffers 1216512 bytes Database mounted. ORA-01115: IO error reading block from file 30 (block # 262144) O...
环境sco unix 5.0.5 + ora 7.3.4 在表空间users上建立了一个存放数据的文件,users01.dbf为1100M,当存放到900多M时,数据库提示ORA-01653错误,用oerr ora 01653查看其错误信息提示如下, l$ oerr ora 01653 01653, 00000, "unable to extend table %s.%s by %s in tablespace %s" // *Cause: Failed to allocate an extent for table segment in tablespace. // *Action: Use ALTER TABLESPACE ADD DATAFILE statement to add o...
本来我是想查users的空闲表空间的, 我现在用 select * from dba_free_space where tablespace_name='users'; 查出来是多条记录,请问是怎么回事?