DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: DMP file problems..

  1. #1
    Join Date
    Jan 2001
    Posts
    153
    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

  2. #2
    Join Date
    Feb 2002
    Location
    http://db-migration.co.in
    Posts
    50
    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

  3. #3
    Join Date
    Apr 2001
    Posts
    107
    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
  •  


Click Here to Expand Forum to Full Width