Oracle

新建默认Table

CREATE TABLE SPCR."SYNC_ROUTE_ID" (
"ID" NUMBER(18,0) GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE ,
NAME NVARCHAR2(20) NOT NULL,
DELETED NUMBER(1,0) NOT NULL,
CREATE_BY NVARCHAR2(10)NOT NULL,
CREATE_AT DATE NOT NULL,
LAST_BY NVARCHAR2(10) NOT NULL,
LAST_AT DATE NOT NULL
);

ALTER TABLE SPCR.SYNC_ROUTE_ID ADD CONSTRAINT SYNC_ROUTE_ID_PK PRIMARY KEY (ID) ENABLE;

将Table或View赋权限给用户

GRANT SELECT ON 表名 TO 用户名; 

删除原有的DB Link

DROP PUBLIC