look at alter user command, yes break out the documentation and begin
reading.
joe
>From: Harsh Agrawal <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Moving user to a different tablespace ...
>Date: Fri, 23 Mar 2001 08:10:38 -0800
>MIME-Version: 1.0
>Received: from localhost (localhost [127.0.0.1])by parents.the-testas.net
>(8.9.3/8.8.7) with ESMTP id NAA14937for <jtestamail@localhost>; Fri, 23 Mar
>2001 13:42:01 -0500
>Received: from mail.the-testas.netby localhost with POP3
>(fetchmail-5.3.1)for jtestamail@localhost (multi-drop); Fri, 23 Mar 2001
>13:42:02 -0500 (EST)
>Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.192.199])by
>mail.acfi.net (8.11.0/8.11.0) with ESMTP id f2NJjp013747for
><[EMAIL PROTECTED]>; Fri, 23 Mar 2001 13:45:52 -0600
>Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com
>(8.9.3/8.9.3) with UUCP id KAA26614;Fri, 23 Mar 2001 10:29:04 -0800 (PST)
>Received: by fatcity.com (26-Feb-2001/v1.0g-b70/bab) via UUCP id 002D6239;
>Fri, 23 Mar 2001 08:10:38 -0800
>Return-Path: <[EMAIL PROTECTED]>
>Message-ID: <[EMAIL PROTECTED]>
>X-Comment: Oracle RDBMS Community Forum
>X-Sender: Harsh Agrawal <[EMAIL PROTECTED]>
>Sender: [EMAIL PROTECTED]
>Errors-To: [EMAIL PROTECTED]
>Organization: Fat City Network Services, San Diego, California
>X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman
>Precedence: bulk
>X-Fetchmail-Warning: recipient address [EMAIL PROTECTED] didn't match
>any local name
>X-SpamBouncer: 1.2 (10/20/00)
>X-SBPass: NoBounce
>X-SBClass: OK
>Status:
>
>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.
>
>Thanks,
>- Harsh
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Harsh Agrawal
> INET: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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).
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joseph Testa
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
