|
-
export from 1 user & import to 2nd user in same db
Hi All
I am exporting from 1 user (user1) to another user(user2) in the
same database.
user1 uses tablespace (ts1) & user2 uses tablespace (ts2).
The probem i am facing is
after importing from user2 all objects are created in ts1 and not in
ts2 as I want it.
the options i used
1)
export from user1 (using user1 login)
import to user2(using user2 login)
2)
i tried taking export from system login
exp owner=user1
then imp touser=user2 from system login
In both options the tablespace used for the new data objects is ts1
and not ts2. How do i force the import into ts2
Regards
Sushant
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|