-
Bug
-
Resolution: Done
-
Major
-
3.0.4.Final
-
None
-
False
-
None
-
False
-
-
Given the following SQL:
CREATE TABLE "MASTERBILL"."ET$03D5D0AD0001" ("USER#", "NAME") ORGANIZATION EXTERNAL ( TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY "DBEXPORT" ACCESS PARAMETERS ( DEBUG = (0 , 0) DATAPUMP INTERNAL TABLE "SYS"."KU$_USER_MAPPING_VIEW" TEMPLATE_TABLE "KU$_USER_MAPPING_VIEW_TBL" JOB ( "MASTERBILL","SYS_EXPORT_FULL_01",2) WORKERID 1 PARALLEL 1 VERSION '19.3.0.0.0' ENCRYPTPASSWORDISNULL COMPRESSION DISABLED ENCRYPTION DISABLED ) LOCATION ('bogus.dat') ) PARALLEL 1 REJECT LIMIT UNLIMITED AS SELECT /*+ PARALLEL(KU$,1) */ "USER#", "NAME" FROM "SYS"."KU$_USER_MAPPING_VIEW" KU$;
This yields
extraneous input 'TEMPLATE_TABLE' expecting {'COMPRESSION', 'DATAPUMP', 'DBLINK', 'DEBUG', 'ENCRYPTION', 'ENCRYPTPASSWORDISNULL', 'HADOOP_TRAILERS', 'JOB', 'LOGFILE', 'NOLOG', 'NOLOGFILE', 'PARALLEL', 'VERSION', 'WORKERID', ')