Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: What is different b/w exp tablespace and exp user
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.orgReceived on Thu Nov 02 2006 - 11:26:13 CST