ITPub博客

首页 > 数据库 > Oracle > Oracle 11G OCP 1Z0-053 701

Oracle 11G OCP 1Z0-053 701

原创 Oracle 作者:LuiseDalian 时间:2014-11-28 09:13:10 0 删除 编辑
(701)A user receives the following error while performing a large volume of inserts into a table:

ERROR at line 1:

ORA-01536: space quota exceeded for tablespace 'USERS'

The issue is resolved by increasing the space quota on the USERS tablespace for the user.

But the user may perform such transaction in the future.

You want to ensure that the command waits rather than produce an error when such an event occurs the next time.

What can you do to achieve this before running the command in the future?

A. Set RESUMABLE_TIMEOUT for the instance.

B. Set the RESOURCE_LIMIT Parameter to TRUE.

C. Enable the database instance to use asynchronous commit.

D. Set the LOG_CHECKPOINT_TIMEOUT parameter to a nonzero value for the database instance.

答案:(A)

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/17013648/viewspace-1349665/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2012-02-06

  • 博文量
    1986
  • 访问量
    6043395