比如:CREATE PUBLIC DATABASE LINK BS_LINK CONNECT TO users IDENTIFIED BY userspass USING 'mis' /DROP SNAPSHOT "MIS"."C_WZ_WZFL" / CREATE SNAPSHOT "MIS"."C_WZ_WZFL" NOLOGGING NOCACHE TABLESPACE "MIS" USING INDEX TABLESPACE "MIS" REFRESH WITH ROWID START WITH SYSDATE NEXT SYSDATE+1 AS SELECT * FROM C_WZ_WZFL@my_LINK
/DROP SNAPSHOT "MIS"."C_WZ_WZFL"
/
CREATE SNAPSHOT "MIS"."C_WZ_WZFL"
NOLOGGING NOCACHE
TABLESPACE "MIS"
USING INDEX TABLESPACE "MIS"
REFRESH WITH ROWID
START WITH SYSDATE
NEXT SYSDATE+1
AS
SELECT * FROM C_WZ_WZFL@my_LINK