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

DA Morgan wrote:
> 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.
>

At least one legitimate use of this (assuming by user he means schema) is when refreshing one schema in test from production, via dbms_file_transfer and transport tablespace. We only push across the datafiles of that tablespace and the metadata, and voila, instant schema refresh with no impact on anyone else. We did a 85GB transport last month and had it set up in less than 45 minutes, including making it read only, pushing it across, and importing the tablespace metadata.

Regards,

Steve Received on Thu Nov 02 2006 - 12:06:21 CST