Toad World® Forums

create table missing semicolons

There is a script generated by Toad [1404] - there is a lack of semicolons afert table create statement and after each grant

CREATE TABLE “SYS_LOCAL_REPORT”.“BTR_NR2”
(
“NR” VARCHAR2(30),
“TSK_ID” VARCHAR2(30) ) SEGMENT CREATION DEFERRED
PCTFREE 10 PCTUSED 40
INITRANS 1
MAXTRANS 255 NOCOMPRESS LOGGING
TABLESPACE “DATA2”
GRANT
ALTER ON “SYS_LOCAL_REPORT”.“BTR_NR2” TO “SYS_ZAD”
GRANT DEBUG ON “SYS_LOCAL_REPORT”.“BTR_NR2” TO “SYS_ZAD”
GRANT DELETE ON “SYS_LOCAL_REPORT”.“BTR_NR2” TO “SYS_ZAD”
GRANT FLASHBACK ON “SYS_LOCAL_REPORT”.“BTR_NR2” TO “SYS_ZAD”
GRANT INDEX ON “SYS_LOCAL_REPORT”.“BTR_NR2” TO “SYS_ZAD”
GRANT INSERT ON “SYS_LOCAL_REPORT”.“BTR_NR2” TO “SYS_ZAD”
GRANT ON COMMIT REFRESH ON “SYS_LOCAL_REPORT”.“BTR_NR2” TO “SYS_ZAD”
GRANT QUERY REWRITE ON “SYS_LOCAL_REPORT”.“BTR_NR2” TO “SYS_ZAD”
GRANT
REFERENCES ON “SYS_LOCAL_REPORT”.“BTR_NR2” TO “SYS_ZAD”
GRANT SELECT ON “SYS_LOCAL_REPORT”.“BTR_NR2” TO “SYS_ZAD”
GRANT UPDATE ON “SYS_LOCAL_REPORT”.“BTR_NR2” TO “SYS_ZAD”;

Hello! If I may ask, which database type is this on?

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

Ryan, I am doing to manual formatting here. Please make a Cr and include the script.

Debbie

I created CR 109287 for this issue.