Re: Dropping tablespace (create zero-block tablespace)

From: Joel Garry <joelga_at_pebble.org>
Date: Tue, 18 Aug 1998 18:41:23 GMT
Message-Id: <slrn6tjinq.aa8.joelga@pebble.org>

On 18 Aug 1998 00:52:40 GMT, LEVINIR <levinir_at_aol.com> wrote:
>> * Make sure the 'old' tablespace doesn't exist
>
>How can I do this. When I do import I use my export.dmp file thatt already has
>unwanted create tablespace user_data statement.
>
>This is why I had a question how can I create zero block tablespace that would
>make my statement fail.

You can use the ROWS=[y,n] to separate the import into two parts - creating the objects, and populating the objects. In between, you can do whatever manipulations you want.

>
>Thanks
>Irina
>
>

--
These opinions are my own and not necessarily those of Information Quest or Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Tue Aug 18 1998 - 13:41:23 CDT