Re: Error importing table using IMP (Oracle 8i)

It seems IMP is trying to put this table into a tablespace marked as TEMPORARY. From your orgininal database, what tablespace does the table sit in?

Two suggestions:

1. Do a separate export of just that one table;
2. I assume both your original and destination database are on a network? try a "create table x as (select * from tablex_at_link);"

HTH James

Kim wrote:

> 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 - 14:44:28 CST