Re: Oracle Export

A copy of this was sent to Salva.Brad_at_DIMAC.COM (if that email address didn't require changing) On Fri, 28 May 1999 13:48:27 GMT, you wrote:

>In the past, my backup/recovery procedures have consisted of operating
>system backups. I have used Export/Import to move data to Test/Devl
>instances of databases. Yesterday, however, I did a FULL export of a
>database that shows up as a little over 3 Gb in Oracle Storage Manager,
>yet the actual file that export creates is about 21 Mb. I can explain
>away some of the difference with extent size and pct. free/used
>settings (I think), but 3 Gb to 21 Mb????
>
>Can anyone explain this to me?

1- an index CREATE statement is exported -- not index itself 2- empty space within tables is not exported -- only data is.

You probably have a table with lots of free space in it. this could be the result of way oversizing the initial extent or letting your pctincrease run away

>
>Thanks!
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'...  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri May 28 1999 - 09:10:33 CDT