Re: Moving my objects to a new tablespace

Here's how:

1. export the data from the user's schema with the EXP application
2. Drop the user with the "cascade" option (all tables will be dropped from the user's schema
3. Create the new user with a default tablespace set to the NEW tablespace
4. Create the structure from your DDL, if you have it. Otherwise... Well, ask someone else! ;) I think that exp can give you the DDL, you'd have to massage it to change the tablespace names
5. reimport the data with the IMP application

JP

s_agbodza_at_yahoo.co.uk (sagbodza) wrote in message news:<d5173cd6.0204021059.404a2c9d_at_posting.google.com>...
> Hi folks,
>
> I am developing an application using Developer 6i and Oracle 8.1.7.
> All my schema objects i.e tables, views, stored procedures, functions
> etc are in the system tablespace. I want to move them to a new
> tablespace but i do not really know the steps to take and what to
> watch out for.
> I have about 100 tables and views now and i am about halfway through.
> Any script to create tablespaces and associated files will be most
> welcome.
>
> Thanks.
>
> Stephen Agbodza.
Received on Wed Apr 03 2002 - 08:07:38 CST