Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Moving user to a different tablespace ...

Re: Moving user to a different tablespace ...

From: Joseph Testa <teci_dba1_at_hotmail.com>
Date: Fri, 23 Mar 2001 11:51:33 -0800
Message-ID: <F001.002D67E3.20010323110710@fatcity.com>

look at alter user command, yes break out the documentation and begin reading.

joe

>From: Harsh Agrawal <HARSHA_at_Amdocs.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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_at_localhost>; Fri, 23 Mar
>2001 13:42:01 -0500
>Received: from mail.the-testas.netby localhost with POP3
>(fetchmail-5.3.1)for jtestamail_at_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
><oracle-l_at_the-testas.net>; Fri, 23 Mar 2001 13:45:52 -0600
>Received: from fatcity.UUCP (uucp_at_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: <root_at_fatcity.cts.com>
>Message-ID: <F001.002D6239.20010323081038_at_fatcity.com>
>X-Comment: Oracle RDBMS Community Forum
>X-Sender: Harsh Agrawal <HARSHA_at_Amdocs.com>
>Sender: root_at_fatcity.com
>Errors-To: ML-ERRORS_at_fatcity.com
>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 ORACLE-L_at_fatcity.com 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: HARSHA_at_Amdocs.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).



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: teci_dba1_at_hotmail.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).
Received on Fri Mar 23 2001 - 13:51:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US