Today colleagues say that the table name you created is lowercase. In the parfile of EXPDP. Include=view: "(' view_name ')", this view_name in lowercase for what hint:
Ora-39168:object path VIEW is not found. Ora-31655:no data or metadata objects selected for job
I'm saying that when I build a view it's lowercase, but when it exists in the data dictionary, it becomes uppercase. This is how Oracle is stored.
CREATE TABLE Lm.dxmy (ID number); --Lowercase Select d.owner,d.object_name from dba_objects d where owner= ' LM ' ORDER by D.object_name;<pre name= "code" class= "HT ML ">owner object_name---------------------------------------------------------------------------------- ----------------------------------------------------------------------------LM dxmy --caps
Assume:
CREATE table LM. " Dxmy "(ID number); --After the addition of an argument. Just store the desired uppercase and lowercase 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 – Fixed Justified lowercase
Table names are stored in the database in uppercase and lowercase slightly