i would like to export a particular table in my oracle database installed in a hpux box. i would like to determine the filesize of the output before performing these action so i can assess if my harddisk can still handle it.
thanks as usuall :rolleyes:
First, I'm not a Oracle expert (or even a DBA). But in working with them I've learned some things and I know when they do their exports (of an entire database) they need approximately the same space as the database is USING, not what it's set up to (as far as growth).
The same for exporting tables - if it's set up to be 200mb but is only using 25mb, then you would need 25 mb free to export it. Always add 5-10% to be sure and I also believe they compress it on the way out.
See the following info on determining the size of a table:
samoratech.com - table size