ora11du / ora12du / ora18du - Oracle Disk Usage
ora11du -[cw] -bx [-u DbLoginName] [-p Password] dataarea [tablespace ...] (online mode)
ora11du -os[w] -nx -bx [-u DbLoginName] [-p Password] dataarea [tablespace ...] (offline mode)
ora12du -[cw] -bx [-u DbLoginName] [-p Password] dataarea [tablespace ...] (online mode)
ora12du -os[w] -nx -bx [-u DbLoginName] [-p Password] dataarea [tablespace ...] (offline mode)
ora18du -[cw] -bx [-u DbLoginName] [-p Password]
dataarea [tablespace
...] (online mode)
ora18du -os[w] -nx -bx [-u DbLoginName] [-p
Password] dataarea
[tablespace ...] (offline mode)
Provide an estimate (plus or minus ten percent) of the amount of disk space required for the table and index data in a given data area. Used during initial setup or when migrating from another database.
In online mode, the utility also checks the Oracle database to determine how much space you have available in your table space.
In online mode, the utility reads the Lawson dictionary to find the initial and incremental record counts for each table and index listed in the dictionary. From the record counts and row sizes, the utility estimates the actual physical size required.
| Program Option | Description |
|---|---|
c
|
Show information about the existing Oracle table spaces. (Online mode only.) |
o
|
Run in offline mode. |
s
|
Show tablespace summary. |
w
|
Show detailed warning messages for tables and indexes. |
nx
|
Use a record count of x. |
bx
|
Use a block size of xK. This must be the last specified option in the command line. |