| Export/import from users of diff tablespaces. [message #74411] |
Tue, 07 December 2004 00:15  |
M. Pallas
Messages: 12
Registered: November 2004
|
Junior Member |
|
|
Some help please:
When importing tables from an export taken by user1 with a default tablespace1 to user2 with a default tablespace2 on the same server and the same database Oracle does not physically move the tables imported to the other tablespace. Is there a parameter or workaround that enable physically moving the tables from the exporting users tablespace to the importing user tablespace? Thank you for the help in advance.
M. Pallas
|
|
|
|
| Re: Export/import from users of diff tablespaces. [message #74413 is a reply to message #74411] |
Tue, 07 December 2004 00:38  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
the user2 is been granted with RESOURCE role.
RESOURCE role allows the user to write to any available tablespace.
so first revoke the RESOURCE ROLE from user2.
allocate a default tablespace tablespace2 to user2.
grant unlimited quota on tablespace2 to user2.
to the import with these options.
fromuser=user1 touser=user2
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
