error on extent of tablespace....
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: error on extent of tablespace....

  1. #1
    Join Date
    Jul 2002
    Posts
    228

    error on extent of tablespace....

    Hi,
    I create a new istance Oracle PMA and then:

    CREATE TABLESPACE PMA1 DATAFILE 'c:\...\PMA01.dbf' SIZE 500M REUSE DEFAULT STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 256 PCTINCREASE 0) ONLINE;

    CREATE USER PM IDENTIFIED BY PM DEFAULT TABLESPACE PMA1 TEMPORARY TABLESPACE TEMP;

    imp system/manager@PMA fromuser=PM touser=PM file=C:\...\xxxxx.dmp log=C:\...\imp_pm.log

    I get this error on one table:

    IMP-00003: ORACLE error 1658 encountered
    ORA-01658: unable to create INITIAL extent for segment in tablespace PMA1
    IMP-00017: following statement failed with ORACLE error 1658:

    I tried with:
    CREATE TABLESPACE PMA1 DATAFILE 'c:\...\PMA01.dbf' SIZE 500M EXTENT MANAGEMENT LOCAL UNIFORM;

    but I get the same error on another table

    How can I resolve my problem?

    Thanks
    Raf

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    You say that when you create the locally managed tablespace the problem occurs on 'another' table does that mean the previous ones are created okay?

    Are you sure that the failing object is created in that tablespace?

    Is there enough space in the new tablespace for all the objects?

    If your still having problems can you create the objects manually and just insert the data?

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    because you export ith compress=n you are creating huge initial extent sizes

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