REPOST: Re: Importing user in an other tablespace

Hi Frank

On Thu, 24 Jan 2002 12:18:25 +0100, "Frank Demuynck" <frank.demuynck_at_entelec.be> wrote:

>I want to move a user who is created in the tablespace users to an other
>tablespace on an other server.
> [...stuff snipped...]
>So the import want to create the table in the tablespace users who is
>offline
>But I want that the import create the tables in the new tablespace

The export file has the storage clause and tablespace information imbedded within it. You will have to pre-create the objects that are to go into the new tablespace and then import with the ignore=Y option.

If you don't wish to find and modify all the DDL by hand you should consider getting the free DBATool software. The DBATool is designed to read an export file and strip off (or replace) tablespace and storage clause information. It is a trival task to have the DBATool generate runnable SQL scripts of your DDL without the tablespace and storage clause information.

The DBATool can be found at: http://www.databee.com/dt_home.htm

Thanks
Dale Edgar
Net 2000 Ltd.
Dale_at_DataBee.com

• WAS CANCELLED BY =======: From: dale_at_databee.com (Dale Edgar) Control: cancel <3c500289.2554631_at_news.btclick.com> Subject: cmsg cancel <3c500289.2554631_at_news.btclick.com> Date: Mon, 28 Jan 2002 00:43:57 GMT Message-ID: <cancel.3c500289.2554631_at_news.btclick.com> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.tools NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!fu-berlin.de!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40719188

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Thu Jan 24 2002 - 13:48:26 CET