DMP data import, problem solving from BLOB field data loss

xiaoxiao2021-03-06  17

When you back up the Oracle database user with BLOB, you will have a phenomenon of the table loss of the BLOB field in re-establishing a user.

Solution step:

1. Newly create a database user (such as Test), and specify the table space used by default (TEST)

2, build a table space (original database user book, such as BOOK), and give permission to newly established users

3. Execute the import operation.

4. Execute the command to modify the tablespace used by the missing table. ALTER TABLE Name Move TableSpace Test

5. Remove the permissions of Test users to access the Book tablespace

转载请注明原文地址:https://www.9cbs.com/read-63307.html

New Post(0)