Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to increase the Min Extents for a tablespace?

Dev. MusbahAug 8 2012 — edited Aug 8 2012
Hi All,
I've exported a dmp file using expdp command from a higher version of Oracle 10.2.0.3.0 with parameter Version = 10.2.0.1.0 (I should use it due to the Version of Oracle I wanna to import to if it is lower than the version of exporting which is 10.2.0.3.0 as I mentioned)
and then imported it to Oracle version 10.2.0.1.0
there is no problem with this but I mentioned it to tell you what I did exactly!
but when the impdp command finished to work the log file tells me some tables did not imported due to lacking of tablespace!
some of tables in the Export Schema had created using users tablespace and others using a tablespace I've created (which is given in the error of not importing some tables in the log file of the import)
To solve this I've created a tablespace with the same name then created a user using it, and then import the export file to this user
but the command prompt gives me an error talking about Min Extents I don't remember what is it but might about not enough space or something like!
Now: how to solve this problem? should I change the space of Min Extents? if so how?
OR: what should I do please!

Thank you
This post has been answered by kuljeet singh - on Aug 8 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 5 2012
Added on Aug 8 2012
3 comments
529 views