Ensuring Sufficient Disk Space
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
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博客 ” ，链接：https://blog.itpub.net/8102208/viewspace-594824/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
