ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Ensuring Sufficient Disk Space

Ensuring Sufficient Disk Space

原创 Linux操作系统 作者:victor1010 时间:2009-05-12 13:40:28 0 删除 编辑
Ensuring Sufficient Disk Space
Before you run Export, ensure that there is sufficient disk or tape storage space to
write the export file. If there is not enough space, Export terminates with a
write-failure error.
You can use table sizes to estimate the maximum space needed. You can find table
sizes in the USER_SEGMENTS view of the Oracle data dictionary
. The following
query displays disk usage for all tables:
SELECT SUM(BYTES) FROM USER_SEGMENTS WHERE SEGMENT_TYPE=’TABLE’;
The result of the query does not include disk space used for data stored in LOB

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

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

注册时间:2008-04-29

  • 博文量
    296
  • 访问量
    570732