Re: Transfer Data to another tablespace with different name

Armin,

try the same imp with additional

    IGNORE=Y hth
  Martin

--
Martin Berger                                     http://berx.at/

Am 24.11.2008 um 05:33 schrieb Amir Gheibi:



> Thnaks. I tried that. But it looks like that it tries to create the  

> PKs and Indexes in the original tablespace. That's why I got a lot  

> of 1658 errors.

>

> IMP-00017: following statement failed with ORACLE error 1658:

>  "CREATE UNIQUE INDEX "PK_SKILLPREFERENCES" ON  

> "SKILLPREFERENCES" ("ID" )  PC"

>  "TFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1  

> FREELIST"

>  " GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "BETATEST" LOGGING"

> IMP-00003: ORACLE error 1658 encountered

> ORA-01658: unable to create INITIAL extent for segment in tablespace  

> BETATEST

>

> "BETATEST" is the original tablespace. As you can see it tries to  

> create it in there and because doesn't have enough space, it comes  

> up with that error. But why it creates it there?

>

> here is the command I used:

>

> imp tblspc_user/tblspc_user fromuser=betatest touser=tblspc_user  

> file=".\desktop\a.dmp" log=".\desktop\b.log"

>

> tblspc_user is the second user (S2) and the second tablespace is  

> called "tblspc". Should I have logged in as Sys or system?

>





--
http://www.freelists.org/webpage/oracle-l




application/pkcs7-signature attachment: smime.p7s