Not exactly what the purpose of the reply was to my post, but I got that
syntax directly off of Oracle's MetaLink.
"RZ" <zagni_at_yahoo.com> wrote in message
news:829f60ae.0201181727.23fe7b1e_at_posting.google.com...
> The error is valid. You cannot create permanant objects in a temporary
tablespace.
>
> "alphacon" <alphacon_at_nospam.headfog.com> wrote in message
news:<0SM18.58457$6L1.11999582_at_typhoon.southeast.rr.com>...
> > ORA-2195: Attempt to create PERMANENT object in a TEMPORARY tablespace
> >
> > This error is encountered anytime you attempt to create a permanent
segment
> > (table, index, etc) in a tablespace that is defined as TEMPORARY
tablespace.
> >
> > Tablespaces of type TEMPORARY became available as of ORACLE7.3. Prior
to
> > that,
> > all tablespaces were PERMANENT (even though they could be designated as
> > temporary tablespaces).
> >
> > If a tablespace is defined as type TEMPORARY, ORACLE will not allow the
> > creation of anything besides temporary segments (used for disk-based
> > sorting).
> >
> > Some applications (e.g., GL) create temporary tables for internal use.
If
> > the
> > application has a tablespace of type TEMPORARY designated as its
"temporary
> > tablespace", you will receive the ORA-2195 error when it tries to create
the
> > table.
> >
> > You can solve this in one of two ways:
> >
> > 1. Redesignate a PERMANENT tablespace as the application's temporary
> > tablespace
> >
> > or
> >
> > 2. Redefine the tablespace as a PERMANENT tablespace (this requires DBA
> > privileges). The syntax is:
> >
> > ALTER TABLESPACE ts_name PERMANENT;
> > (where ts_name is the name of the tablespace you wish to redefine).
> >
> >
> >
> > "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 Sat Jan 19 2002 - 14:52:18 CST
