Re: Imp keeps putting data in SYSTEM

Jeff,

One of the reasons could be that the user has dba privileges, so even setting a zero quota on system will not stop objects going into system. Temporarily revoke the privilege and it should work.

Also, you may want to examine the actual user performing the export/import for dba privileges as well.

Jeff Wiegand wrote:

> We have some databases with user data is SYSTEM.
>
> I exported the data, and set the users default tablespace to users,
> temporary tablespace to temp, quota 0 on SYSTEM.
>
> Upon import, the users data goes right back into the SYSTEM tablespace.
>
> I've also tried dropping and recreating the user.
>
> I've set import from the command line:
>
> imp user file=user.dmp
>
> I've tried it this way:
>
> imp user file=user.dmp fromuser=user touser=user
>
> Still, the data is placed into SYSTEM.
>
> Why, Why, Why?????????
>
> Jeff
> --
> Author: Jeff Wiegand
> INET: jwiegand_at_ancept.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

--
   Dev Anand Mathura
   Senior Consultant - Oracle Applications
   Management Information Systems
   61-63 Edward Street, PO Box 544
   Port-of-Spain, Trinidad and Tobago
   phone: (868) 627-4203, fax: (868) 624-8569