Coder Social home page Coder Social logo

Ignore SYS.BFILE of type TYPE about ddlfs HOT 1 CLOSED

usrecnik avatar usrecnik commented on August 18, 2024
Ignore SYS.BFILE of type TYPE

from ddlfs.

Comments (1)

usrecnik avatar usrecnik commented on August 18, 2024

Actually, there is much more of such objects:

SQL> select object_name from dba_objects o where o.owner='SYS' and o.object_type='TYPE' and not exists (select 1 from dba_source s where s.owner='SYS' and s."TYPE"='TYPE' AND s."NAME"=o.object_name);                                        

OBJECT_NAME                                                
------------------------------                             
BFILE                                                      
BINARY ROWID                                               
BINARY_DOUBLE                                              
BINARY_FLOAT                                               
BLOB                                                       
CANONICAL                                                  
CFILE                                                      
CHAR                                                       
CLOB                                                       
CONTIGUOUS ARRAY                                           
DATE                                                       
DECIMAL                                                    
DOUBLE PRECISION                                           
FLOAT                                                      
INTEGER                                                    
INTERVAL DAY TO SECOND                                     
INTERVAL YEAR TO MONTH                                     
KOTAD                                                      
KOTADX                                                     
KOTMD                                                      
KOTMI                                                      
KOTTB                                                      
KOTTBX                                                     
KOTTD                                                      
LOB POINTER                                                
NAMED COLLECTION                                           
NAMED OBJECT                                               
NUMBER                                                     
OCTET                                                      
OID                                                        
PL/SQL BINARY INTEGER                                      
PL/SQL BOOLEAN                                             
PL/SQL COLLECTION                                          
PL/SQL LONG                                                
PL/SQL LONG RAW                                            
PL/SQL NATURAL                                             
PL/SQL NATURALN                                            
PL/SQL PLS INTEGER                                         
PL/SQL POSITIVE                                            
PL/SQL POSITIVEN                                           
PL/SQL RECORD                                              
PL/SQL REF CURSOR                                          
PL/SQL ROWID                                               
PL/SQL STRING                                              
POINTER                                                    
RAW                                                        
REAL                                                       
REF                                                        
SIGNED BINARY INTEGER(16)                                  
SIGNED BINARY INTEGER(32)                                  
SIGNED BINARY INTEGER(8)                                   
SMALLINT                                                   
TABLE                                                      
TIME                                                       
TIME WITH TZ                                               
TIMESTAMP                                                  
TIMESTAMP WITH LOCAL TZ                                    
TIMESTAMP WITH TZ                                          
UNSIGNED BINARY INTEGER(16)                                
UNSIGNED BINARY INTEGER(32)                                
UNSIGNED BINARY INTEGER(8)                                 
UROWID                                                     
VARCHAR                                                    
VARCHAR2                                                   
VARYING ARRAY                                              
KOKED                                                      
KOKED1                                                     

67 rows selected.                                          

from ddlfs.

Related Issues (13)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.