Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Estimate the Size of an Full Database Export
I am not sure if it is going to work, but you shouldn't add sums of spaces taken up by indexes.... and probobly take into consideration pctfrees, etc.. anyway, I think it's too complicated to estimate it...
On Fri, 26 May 2000 12:29:28 GMT, vslabs_at_onwe.co.za (Billy Verreynne) wrote:
>As for determing the size.. guess work will have to do as it depends
>on how well the data can compress. At worse, the export size will be
>the same size as the database, minus of course rollback and temp
>segments. Do a select from dba_data_files, select only the data files
>(exclude the files assigned to the temp and rollback tablespaces) and
>sum the bytes. This should give you a very rough total to play around
>with.
Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 750-3630 AOL: NetComrade ICQ: 11340726 remove NSPAM to emailReceived on Wed May 31 2000 - 00:00:00 CDT
![]() |
![]() |