error on extent of tablespace....
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?
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?
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!
because you export ith compress=n you are creating huge initial extent sizes
Click Here to Expand Forum to Full Width