Re: Import bug

hi chuck,

   the user has currently no right to create tables in the    database (he had once, but someone decided to revoke)    so the import dont want create objects as this is    the CURRENT state in the database.
   If the user could create tables with import he could    create any table with exporting and importing.    

   If Imp is invoked by the DBA and imp should ignore    the qota then this means that the DBA have to know that    there is a rule which he overrides. For people like me    its better to get rememberd that there is an operation    that conflicts with a rule.

   if i remberer dumps are called inconsitent, so if you want    a "copy" of a database you need a cold backup.

just an opinion (mental errors included)

s.k.

"Chuck" <chuckh_at_softhome.net> wrote in message news:<afhphc$e55en$1_at_ID-85580.news.dfncis.de>...
> 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.
>
> I discovered this the hard way. I imported an export file to recreate a
> database. Everything worked fone except for that one user.
Received on Fri Jun 28 2002 - 15:48:19 CDT