今天同事表示对于自己创建的表名是小写。在expdp的parfile中。include=view:"('view_name')",这个view_name用小写为什么提示:
ORA-39168: Object path VIEW was not found.
ORA-31655: no data or metadata objects selected for job
我表示建立视图的时候是小写,可是它存在数据字典中的时候,自己主动会变成大写。这是Oracle的存储方式。
create table lm.dxmy(id number); --小写
select d.owner,d.object_name from dba_objects d where owner='LM' order by d.object_name;
<pre name="code" class="html">OWNER OBJECT_NAME
------------------------------ --------------------------------------------------------------------------------------------------------------------------------
LM DXMY --大写
假设:
create table lm."dxmy"(id number); --加引號之后。就存储想要的大写和小写
SQL> select d.owner,d.object_name from dba_objects d where owner='LM' order by d.object_name desc;
OWNER OBJECT_NAME
------------------------------ --------------------------------------------------------------------------------------------------------------------------------
LM dxmy --定义的小写