-
hi
we ve taken the entire database backup from 8.1.6 and now we are trying to import some specified users in 8.1.7 !!! actually the user what we try to import doesnt have much data and when we import IT IS growing more than 600 MB and throwing an initial extent error..what could be the problem ?
Vijay.s
-
Hi,
What is the extent error in the import?
I hope the userid, fromuser and touser parameters are correct and possibly, if u can create at first the tablespaces having datafiles with Autoextend on and proper initial extent size, and if you have taken export with defalut param COMPRESS=Y, and take import, the objects shud be imported in single extent.
If the error is like maxextents reached then one way is to set maxtents unlimted form the particular tablespace.
Prakash
-
Hi,
Try to first create the objects with their storage clauses.
If that user owns a big table, for example, even if that table is almost empty, the imp utility will try to create it at a given initial size. If your tablespace can't hold that initial size, you'll get the 'unable to create initial extent' error.
Another thing: does that user have 'unlimited tablespace' privilege, or adequate quotas on the tbs ?
Hope it helps
Cheers
Fabien
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|