As title, can you tell me whether the imp of oracle can be imported to the specified tablespace?

CodePudding user response:

Imp no such parameters, impdp can be specified,

CodePudding user response:

Yes, but very troublesome, need to build table (specify the new table space) to import again, if the data pump, is a remap_tablespace parameters

CodePudding user response:

A seer and user
Then use the imp when add a fromuser touser==
Try?

CodePudding user response:

Set the user's default tablespace, users in the other table Spaces without permission

CodePudding user response:

Generally it is recommended to use EXPDP