[Oracle] Register MVIEW manually

1. Check if MVIEW is already registered.

 select * from dba_registered_mviews;  

2. Register MVIEW if it doesn't exist in DBA_REGISTERED_MVIEWS

 begin  
 dbms_mview.register_mview ( 'TSTCBF' , 'ADDRESS_EX' , 'TST', 204, DBMS_MVIEW.REG_PRIMARY_KEY_MVIEW,  
 'select Address_Ex_ID Tracking_ID, Unique_Address_FK Address_ID, Last_Mod_Date Last_Mod_Date from ADDRESS_EX_TBL@BAS',  
 DBMS_MVIEW.REG_V8_SNAPSHOT);  
 end;  

As input parameters use package specific constants where necessary, as mentioned in documentation.

DBMS_MVIEW.REG_PRIMARY_KEY_MVIEW

DBMS_MVIEW.REG_V8_SNAPSHOT

More about sys.dbms_mview package here