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

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Wed, 16 Jan 2002 20:40:54 -0000
Message-ID: <3c45e71b$1_2@mk-nntp-1.news.uk.worldonline.com>

Suggest you look at your objects/tablespaces, and relocate the table in the source db:

ORA-02195: Attempt to create PERMANENT object in a TEMPORARY tablespace seems to be the problem

HTH Paul

"Kim" <kim_at_costa.no_remove> wrote in message news:MPG.16afe9323ff4c505989681_at_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 - 14:40:54 CST