Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Moving user to a different tablespace ...
Harsh Agrawal wrote:
>
> By mistake a user was assigned default tablespace SYSTEM.
> How we can change it to some new tablespace let's say "TBS1" ?
> Because if we do export and import it will again import into that "SYSTEM"
> tablespace.
alter user bob default tablespace tbs1;
then grant a quota to bob on tbs1, revoke his quota on system, export and import his objects. since they can't go into system [he has no quota on system] they go in his default tablespace.
-- Bill Thater Certifiable ORACLE DBA Telergy, Inc thaterw_at_telergy.net ---------------------------------------------------------------- You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! ---------------------------------------------------------------- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: ThaterW_at_telergy.net 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).Received on Fri Mar 23 2001 - 13:16:00 CST
![]() |
![]() |