

create directory GG_RPT as '/oracle/product/ggate/11.2/dirrpt';
grant READ on directory GG_RPT to GGADMIN;
grant READ on directory GG_RPT to RDSQA;
create table GGADMIN.MM_R1RT1_log (line varchar2(4000)) organization external (type oracle_loader default directory GG_RPT
                                   access parameters (records delimited by newline nobadfile nologfile nodiscardfile) location ('MM_R1RT1.rpt'))
/

