Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Export objects to another tablespace.

Re: Export objects to another tablespace.

From: Andrew Babb <andrewb_at_mail.com>
Date: Sun, 25 Apr 1999 10:48:41 +0800
Message-ID: <37228289.3147935A@mail.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US