Re: dropping datafiles

chuckh_at_ix.netcom.com (Chuck Hamilton) wrote:
>
> Is there any way to drop datafiles from a tablespace short of dropping
> the entire tablspace? I have a whole bunch of datafiles that were added
> to the "system" tablespace (a few hundred meg) with objects that have
> been created in them. I'd like to recreate the objects in the "users"
> tablespace and clean up "system". How can I do it?
>
> According to the Server Concepts Manual for version 7, it can be done.
> But I haven't figured out how yet.
> --
> Chuck Hamilton
> chuckh_at_ix.netcom.com
>
> Incoming fire has the right of way

You can drop all the tables for a user by dropping the user with cascade option. This will drop all the users tables without you having to drop the tablespace. you can then create the user. when creating the user do remeber to specify default tablespace and temporary tablespace names. If you do not specify the default tablespace and if the user creates tables without a tablespace clause, they will get created in the SYSTEM tablespace.

Ashok Kapur
DBA/Developer
Thomson Technology Consulting Group
akapur_at_thomtech.com Received on Wed May 24 1995 - 00:00:00 CEST