I have 2 Oracle databases running on 2 different
Solaris 8 machines. Database 1 is a Oracle 8.1.5 database and Database 2 is an Oracle 8.1.7. I want to import the tables from database 1 to database 2 via user_name. This user_name is the same for both databases. The ultimate goal is to get all the tables owned by said user into 1 tablespace on database 2. Easy enough. Here's the rub. Both databases have the same tablespaces names (Help). Both database have the same table names (11 total). Both databases have the same user name (User1). However, the "exporting" databases have all the tables in 1 tablespace (Help) while the matching tables on database are in 2 different tablespaces (Help and Data). User1 owns the tables in both Help and Data in the recieving database.
How can I make sure that when I import database 2 tables into database 1 the tables in Data are not overwritten. I want all the imported tables to go into the Help tablespace.
Damn, I hope this is easier to understand then what I've written.