Re: Transfer Data to another tablespace with different name

  • From: Martin Berger <martin.a.berger@xxxxxxxxx>
  • To: "Amir Gheibi" <gheibia@xxxxxxxxx>
  • Date: Mon, 24 Nov 2008 05:35:39 +0100

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?

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2008