RE: transfer objects from system TS to others : Not for Adv. DBA'

From: Wolfe, Charles <charles.wolfe_at_digex.com>
Date: Tue, 9 Jan 2001 17:16:59 -0000
Message-Id: <10736.126172@fatcity.com>

If your database is release 8.1.5 or later, you can do the following:

ALTER TABLE table_name MOVE TABLESPACE tablespace_name;

ALTER INDEX index_name REBUILD TABLESPACE tablespace_name;

hth

Regards,
Chuck

-----Original Message-----
From: Nirmal Kumar Muthu Kumaran [mailto:NIRMALK_at_qtel.com.qa] Sent: Tuesday, January 09, 2001 11:46 AM To: Multiple recipients of list ORACLE-L Subject: transfer objects from system TS to others : Not for Adv. DBA's

        HI gurus,

        I just found some of my user objects are existing in SYSTEM tablespace.

        I findout all the objects which were in SYSTEM tablespace. Now i need to move those objects to different tablespaces.

        How can i do this.

	Rgds,
	Nirmal.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Nirmal Kumar Muthu Kumaran
  INET: NIRMALK_at_qtel.com.qa

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 Tue Jan 09 2001 - 11:16:59 CST