Re: Relocate Tablespace

From: Anjali R <anjali_r_1999_at_yahoo.co.uk>
Date: Wed, 13 Dec 2000 09:01:49 +0300
Message-Id: <10709.124428@fatcity.com>

I think - Export/Import is the best way to do it.

You export all the users. Create the user in new production DB. Allocate the tablespace quota only for the respected data and index tablespaces. Import the user.

Remember, the user should not have unlimited tablespace privilege, otherwise, the default object will again go in SYSTEM tablespace.

HTH,

Original Message ----- From: Nosie <tekait11_at_bni.co.id> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Wednesday, December 13, 2000 7:35 AM Subject: Relocate Tablespace

Hi DBAs,

I plan to redesign a database structure. Currently a production DB has all objects stored in SYSTEM tablespace. I want to move it to a new production DB (in a new server machine) while relocate user objects (tables, indexes, triggers, stored procedures, etc) to tablespaces different than SYSTEM. What is the safest way to do it?

Thanks in advance for your helps...

--

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

Author: Nosie
INET: tekait11_at_bni.co.id

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).

Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com Received on Wed Dec 13 2000 - 00:01:49 CST