Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export objects to another tablespace.
Alan,
After you create the user on the new tablespace, make sure that the users default tablespace is (presumably) data, and the temporary tablespace (presumably) temp. Then allocate unlimited QUOTAS on the tablespace data (your default tablespace), and possibly quotas on the temporary tablespaces.
Now make sure that the System Privilege UNLIMITED TABLESPACE does NOT belong to the user.
When you perform an import of the user, Import will determine that it cannot restore the objects into the SYSTEM tablespace, and will then create the objects in the default tablespace.
Hope this helps,
Andrew
Alan Russell wrote:
> We have a vendor supplied application running on AIX that uses a runtime
> version of Oracle. Older revisions of the app installed Oracle and placed
> everything in the system tablespace. They have "wised up" and now new
> installations have 3 tablespaces SYS, data and temp. My question is how can
> I export the tables and indexes from a existing install with all in the
> system tablespace to a new install to the data tablespace on another box? Is
> this a simple export - import?
>
> AR.
Received on Sat Apr 24 1999 - 21:48:41 CDT