Re: Size of USR.ora

On 8 Oct 2004 01:28:41 -0700, arindam_ghose_at_hotmail.com (arg) wrote:

>I am using Personal Oracle 8.0. When I import and expost user the size
>of usr.ora in oranwin95/database increase and it eats up the Hard Disk
>space. Even if I drop user it does not help to reduce usr.ora size and
>increase free space in HDD.
>
>How can I solve the proble.Is there any DBA paramter setting to
>initialise the ora file Please help.
>Thanks in advance.
>arg

You have the usr.ora datafile set to autoextend and you are exporting with compress=Y (the default). As a result every individual segment will be created in one contiguous extent, causing the datafile to extend.
Probably not much can be done about it, because you likely don't have the original table definitions anymore and/or the original export.

There are however a few other factors to consider - Oracle desupported 8.0 in the previous century - Oracle also desupported win95 and in the meantime Microsoft has withdrawn support for win95
- You seem to know not much about Oracle. I would strongly recommend you to read the Oracle Concepts manual. Your question shows your blatant ignorance.

--
Sybrand Bakker, Senior Oracle DBA