Re: System tablespace cramped, PLEASE HELP!!!

All points true except for point 5. If you remove the quota to the system tablespace for the user, the import will not be able to create the table in the system tablespace and will create the tablespace in the default of the user.

Vince Germscheid wrote:
>
> Rich Headrick <rheadric_at_macromedia.com> writes:
> > I've really blown it, and created my application objects in my system
> > tablespace. They are now populated with data. Is there an easy way
> > to export the application from the system tablespace, and assign the
> > proper default tablespace, and import the application?
> >
> > All responses very greatly appreciated,
> >
> > Rich
> Easy? Well you'll have to decide. You need to;
> 1. export the owner of the tables, with grants, etc.
> 2. drop all of the owners objects
> 3. create a new tablespace(s) for the application
> 4. set this tablespace as the default tablespace for the owner
> 5. create the tables in the new tablespace(s)
> 6. import
>
> for any user that will be creating tables, you should set the
> default tablespace to someplace other than SYSTEM to avoid this
> problem in the future. I usually create a USER tablespace and
> set this as default for ALL users, and create seperate data/index
> tablespaces for applications as necessary.
  Received on Sat Jul 20 1996 - 00:00:00 CEST