150.The user HR receives the following error while inserting data into the TTK table: ERROR at line

来源:互联网 发布:udp端口扫描器报告 编辑:程序博客网 时间:2024/05/16 14:06
150.The user HR receives the following error while inserting data into the TTK table:
ERROR at line 1:
ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMD
Upon investigation, you find that SMD is a small file tablespace. Which three action would allow the user
to insert data? (Choose three.)
A.Add a data file to the SMD tablespace.
B.Add a data file to the temporary tablespace associated with the user HR.
C.Resize the data file associated with the SMD tablespace to make it larger.
D.Alter the data file associated with the SMD tablespace to grow automatically.
E.Change the segment space management for the SMD tablespace to automatic n segments is managed through free lists.
答案:ACD
解析:
重置表空间大小
  1.这个只是用于字典管理的表空间,如果是本地管理的是无法修改大小的
      alter tablespace 表空间名 
      [minimum extent 正整数[K|M] 
      |default 存储子句]
  2.如果是本地管理的表空间,可以通过如下方法增加大小
      a.改变数据文件的大小
        i.创建的时候使用autoextend on 自动改变数据文件的大小
        ii.创建完后使用autoextend on 选项的alter database命令手动开启自动扩展数据文件大小  
          alter database datafile '/u01/wahaha.dbf' autoextent on next 1m;
        iii.改变数据文件的大小
          alter database datafile '/u01/wahaha.dbf' resize 10m;
      b.增加数据文件
          alter tablespace wahaha add datafile '/u01/wahaha.dbf' size 80M;
A:正确,属于增加数据文件
B:错误,与临时表空间没啥关系
c:正确,属于改变数据文件的大小
D:正确,属于自动改变数据文件的大小
E:错误,没关系,这个是段空间管理,并不是总大小
0 0