Or the user may have DBA role.
- Terry Ball <terry_ball_at_csgsystems.com> wrote:
> Does the user have the sys priv unlimited tablespace, either directly
> or thru a role? If so, this is why. No matter how much you revoke
> the quota, if the user has this role, the quota still exists.
>
> Terry
>
> 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).
>
> --
> Author: Terry Ball
> INET: terry_ball_at_csgsystems.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).
Rocky Welch
Oracle DBA Consultant
rockyw_99_at_yahoo.com
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
Received on Tue May 23 2000 - 14:23:27 CDT