oracle 错误 1950,ora- no privilege on tablespace error

supersen wrote:

Hello Guys,

I have the user

HR

HR_DM

and  HR  has  tablespacename is HRTBS

HR_DM has tablespacename as HR_DMTBS

My script tries to export the data from HR and import to HR_DM

export completed successfully.

while importing into HR_DM I am getting error as

....Importing  HR objects into HR_DM

no  privileges on tablespace  HRTBS

I am surprised  why we are getting error as above.

we are inserting the records into HR_HB

Please advise

S

Please provide proof that you are importing into the tablespace HR_DMTBS.

Provide full commands that you are executing.

Are you using REMAP_TABLESPACE?