Oracle exports mobile tablespace

For example, an Oracle database has two users: A corresponds to tablespace A and B Corresponds to tablespace B.

1. First Use A to export dmp;

2. Grant DBA permissions to B and then execute: revoke unlimited tablespace from B;

3. alter user B quota 0 on;

4. alter user B quota unlimited on B;

5. Execute import imp xxx/xxx@orcl_xxx.xxx.xxx.xxx fromuser = A touser = B file = xxx. dmp

If the table contains lob, it cannot be imported, and a 1536 exception is reported.
6. If an exception occurs, execute alter user B quota unlimited on A; re-import the table with lob. But it will be imported to space.

7. alter table A move tablespace B; move A to B

8. alter table B move lob (lob name) store as (tablespace B); move the lob field of a to B

Move the lob to B and then click OK. Do not forget that each sentence is commit;