What is different b/w exp tablespace and exp user

From: aman.oracle.dba <aman.oracle.dba_at_gmail.com>
Date: 31 Oct 2006 10:47:46 -0800
Message-ID: <1162320466.811168.284010@f16g2000cwb.googlegroups.com>

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. Received on Tue Oct 31 2006 - 12:47:46 CST