Re: System tablespace cramped, PLEASE HELP!!!

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