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

aman.oracle.dba schreef:
> Hi,
>
> If I export full tablespace with the command
> exp userid=system/manager owner=hr
>
> and then imp in other database
> imp userid=system/manager fromuser=hr
> touser=hr ignore=y
>
> (Some same tables exists there but without data)
> or
> If I export tablespace with the command
> exp userid=system/manage tablespaces=users
>
> and then imp in other database
> imp userid=system/manager tablespaces=users
> ignore=y
>
> Both user and tablespace with the same name exists there and user "HR"
> is the only user who is using tablespace "USERS".
> So what is difference between both (WITH OWNER and TABLESPACE) exp and
> imp.
>
>
> As well as what will the difference if some tables already exists in
> user "HR" or Not Exists.
>

Who says that the tablespace contains only tables of one user? Who said a user can only have objects in one tablespace?

There's your difference.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...