Error importing table using IMP (Oracle 8i)

From: Kim <kim_at_costa.no_remove>
Date: Wed, 16 Jan 2002 19:47:39 +0100
Message-ID: <MPG.16afe9323ff4c505989681@news.spaniatjenester.es>

Hi, on linux (Suse) I am trying to import a users tables from an export done on a win2000 I get a strange error.

Most tables are imported without any problems.. But ONE table failes with the following error. And as far as I know there is not really much difference between the table that failes and the tables that get imported. Any clue ??

IMP-00017: following statement failed with ORACLE error 2195:
"CREATE TABLE "DATA" ("ID" NUMBER, "DATA1" NUMBER, "DATA2" NUMBER,
"DATA3" V"
"ARCHAR2(1000)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING
STORA"
"GE(INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50
FREE"
"LISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE
"TEMPORARY_DATA""
IMP-00003: ORACLE error 2195 encountered ORA-02195: Attempt to create PERMANENT object in a TEMPORARY tablespace

-- 
Mvh - Kim

Received on Wed Jan 16 2002 - 12:47:39 CST