|
-
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
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
|