Re: Dropping tablespace (create zero-block tablespace)

From: <gpapillo_at_my-dejanews.com>
Date: Tue, 25 Aug 1998 18:57:07 GMT
Message-ID: <6rv1e3$o1g$1@nnrp1.dejanews.com>

I posted this before, but I didn't see it here so I'm re-posting it. I also had something to add.....

You can create a tablespace that is less than or equal to your block size, this will prevent any objects from being created in this tablespace, 2K has always worked for us. (Not exactly a 0 block tablespace) This will do the trick for creating the tablespace.

In order to change a users default tablespace you must pre-create the user the new default tablespace. Make sure that the user does not have the system privilege UNLIMITED TABLESPACE and give the users a quota on both tablespaces (old and new) using the alter user statement. I always use UNLIMITED when importing.

Gerri L. Papillon, President/Oralce DBA PTCS Corp.

In article <1998081800524000.UAA12536_at_ladder03.news.aol.com>, levinir_at_aol.com (LEVINIR) 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.
>
> Thanks
> Irina
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Aug 25 1998 - 13:57:07 CDT