Re: Import bug

From: Chuck <chuckh_at_softhome.net>
Date: Fri, 28 Jun 2002 11:28:30 -0400
Message-ID: <afhvav$drp0a$1@ID-85580.news.dfncis.de>

"Knut Talman" <knut.talman_at_mytoys.de> wrote in message news:3D1C7294.35C174C0_at_mytoys.de...
> Chuck wrote:
> >
> > I believe I've just discovered a bug in the import process.Please tell
me if
> > you agree. In the case where a user owns tables but has no quota on any
> > tablespace, you can export that user but when you try to import it the
> > tables will not be created. Even running the import as a DBA user, you
still
> > cannot import the the tables.
>
> The user has *no* quota and his tables can't be imported? Which error
messages?

IMP-00017: following statement failed with ORACLE error 1536:

 "CREATE TABLE "PSDBOWNER" ("DBNAME" VARCHAR2(8) NOT NULL ENABLE, "OWNERID"
V"
 "ARCHAR2(8) NOT NULL ENABLE)  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

"
 "LOGGING STORAGE(INITIAL 16384 NEXT 8192 MINEXTENTS 1 MAXEXTENTS 2147483645 "
 "PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) "
 " "
IMP-00003: ORACLE error 1536 encountered ORA-01536: space quota exceeded for tablespace 'USERS' Received on Fri Jun 28 2002 - 10:28:30 CDT