RE: full exp/imp of user to new tablespace; same user

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Fri, 08 Nov 2002 06:58:32 -0800
Message-ID: <F001.004FEBED.20021108065832@fatcity.com>

RE: full exp/imp of user to new tablespace; same userA quick note to those that downloaded a version of DBATool yesterday following on from my message, and to all those that have a past version as well.

The download link on the DBATool web page hadn't been updated for the new version that is on the web site - shoot the webmaster (me)! Following is a link to the latest version of DBATool (which has added support for partitioned table DDL etc.), if you would like to grab the latest download, just pull it down, and install straight over the version you already have. You do not need to de-install the old version, and will not have to re-apply for a registration key.

http://www.cool-tools.co.uk/products/downloads/dbatool_install020306.exe

Sorry for my stupidity! ;)

Mark

-----Original Message-----

  From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Markham, Richard
  Sent: 07 November 2002 16:14
  To: Multiple recipients of list ORACLE-L   Subject: RE: full exp/imp of user to new tablespace; same user

  well now I can say I'm spoiled. I was given more than enough information to
  to accomplish the task (done) and a new tool to boot! =)

  Thanks alot everyone.

-----Original Message-----

  From: Mark Leith [mailto:mark_at_cool-tools.co.uk]   Sent: Thursday, November 07, 2002 10:45 AM   To: Multiple recipients of list ORACLE-L   Subject: RE: full exp/imp of user to new tablespace; same user

  And if all else fails (not that the advice already given will!), we have a   tool that can manipulate the DDL for the users objects VERY quickly and   easily, through a "rule based" change (e.g. Modify <ALL> tables storage   clauses within <USERS> schema to <TABLESPACE>):

  http://www.cool-tools.co.uk/products/dbatool.html

  It's free, have at it!

  HTH   Mark

-----Original Message-----

  Sent: 07 November 2002 14:44
  To: Multiple recipients of list ORACLE-L

  Extra security could be to give zero quota on other tablespaces.
-----Original Message-----

  Sent: donderdag 7 november 2002 14:59
  To: Multiple recipients of list ORACLE-L

  I have a full export of user to where I need to import all his   objects/grants
  but into a NEW tablespace. What's the easiest way I can assure that   ~everything~ is imported. Will I need to use a combination of INDEXFILE   and other procedures or will a full export; drop tablespace; create new   tablespace; alter user's default tablespace; full import suffice for   all objects? Thanks for any tips.

--

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

  Author: Mark Leith
    INET: mark_at_cool-tools.co.uk

  Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
  San Diego, California        -- Mailing list and web hosting services


  ---------------------------------------------------------------------

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  INET: mark_at_cool-tools.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Nov 08 2002 - 08:58:32 CST