Re: Space Occupation by ORAWIN95 for Personal oracle 8.0

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Mon, 4 Oct 2004 09:14:53 -0400
Message-ID: <lsmdnQJ6d-xH0fzcRVn-pQ@comcast.com>

"arg" <arindam_ghose_at_hotmail.com> wrote in message news:e01c3812.0410040447.79e70110_at_posting.google.com...
| I have created a oracle tablespace . Whenever I am inporting and
| exporting users into it the usr.ora and usr1.orcl.ora is incremented.
| But that eats up my diskspace too. Can I initialise the usr.ora
| keeping my data intact or any other solution for it.
|
| Thanks in advance

tablespaces use diskfiles -- so if your tablespace grows to accommodate more data, the diskfiles (if set to autoextensible) will grow

however, the schemas you are importing may have table storage parameters that are specifying more storage allocation than what is actually needed -- if you precreate the tables you can specify more appropriate storage parameters (if that really is the problem). then use the imp IGNORE=Y option when importing into the pre-created (but empty) tables.

++ mcs Received on Mon Oct 04 2004 - 08:14:53 CDT