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: What is different b/w exp tablespace and exp user

Re: What is different b/w exp tablespace and exp user

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 02 Nov 2006 09:26:13 -0800
Message-ID: <1162488371.336999@bubbleator.drizzle.com>


aman.oracle.dba wrote:

> I know that one tablespace can contain the data of many users and one
> users objects can be save in many tablespaces but I reserve one
> tablespace for one user.

Why? This is a bad practice by almost any definition I can conceive.

> Is there no difference in data after imp.
> Is there no difference in speed of imp or exp.

None whatsoever except you are wasting huge amounts of disk space and time and making management far more difficult than it need be.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Nov 02 2006 - 11:26:13 CST

Original text of this message

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