Oracle 视图 USER_IM_EXPRESSIONS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图USER_IM_EXPRESSIONS(引导导入/导出)用于存储导入/导出定义的定义和函数数据。它用于帮助用户在使用Oracle的Data Pump功能时管理和查询数据。
用法：
1.查询某一定义：使用SELECT * FROM USER_IM_EXPRESSIONS WHERE DEFINITION_NAME=;来查询某一定义的信息。
2.查看某一定义下的函数：使用SELECT * FROM USER_IM_EXPRESSIONS WHERE DEFINITION_NAME= AND FUNCTION_NAME IS NOT NULL;来查看某一定义下的函数。
3.更新某一定义：使用UPDATE USER_IM_EXPRESSIONS.DEFINITION_NAME= SET = WHERE DEFINITION_NAME=;来更新某一定义下的内容。
4.删除某一定义：使用DELETE FROM USER_IM_EXPRESSIONS WHERE DEFINITION_NAME=;来删除某一定义。
官方英文解释
USER_IM_EXPRESSIONS provides information about the list of expressions (SYS_IME virtual columns) that are currently enabled for in-memory storage in schemas owned by the current user. Its columns (except for OWNER) are the same as those in DBA_IM_EXPRESSIONS.
Typically, you can query this view after invoking the DBMS_INMEMORY_ADMIN.IME_CAPTURE_EXPRESSIONS PL/SQL procedure to see the list of hot expressions added to tables owned by you across the database.
Based on this view, you can:
-
Populate expressions on a particular table immediately
-
Drop certain expressions that are marked for in-memory but not desired by you
See Also:
“DBA_IM_EXPRESSIONS”
