论坛首页新手上路 签到
查看: 277|回复: 0

帆软报表迁移插件 自动新建表、索引、序列、触发器;删除

[复制链接]
金智教育-熊俊

该用户从未签到

40

主题

40

帖子

120

积分

版主

Rank: 7Rank: 7Rank: 7

积分
120
发表于 2020-10-26 16:40:24 | 显示全部楼层 |阅读模式
本帖最后由 xiongjun 于 2020-10-26 16:45 编辑

一、自动创建的表、索引、序列、触发器

表:

FR_CALENDAR_ITRIGGER
FR_CRONEXPRESSION_ITRIGGER
fr_errrecord
FR_EXCEL_SUBMIT_TASK
fr_exerecord
fr_exprecord
FR_FILEENTRY
FR_FOLDERENTRY
fr_fsrecord
FR_ONCE_ITRIGGER
fr_pri_track_record
FR_PROCESS_ALERT_TOAST
FR_PROCESS_LOG
FR_PROCESS_REMIND_TOAST
FR_PROCESS_STASH_DATA
FR_PROCESS_TASK_IMPL
fr_ptrecord
FR_REPORT_PROCESS
FR_REPORT_PROCESS_NODE
FR_REPORT_PROCESS_TASK
FR_REPORTLETENTRY
FR_RPPE
FR_SCHEDULE_ACTIONLIST
FR_SCHEDULE_CLASSACTION
FR_SCHEDULE_EMAIL
FR_SCHEDULE_FTP
FR_SCHEDULE_OUTPUT
FR_SCHEDULE_PRINT
FR_SCHEDULE_PUSH
fr_schedule_sapsyn_task
FR_SCHEDULE_TASK
fr_schedulerecord
FR_SIMPLE_ITRIGGER
FR_T_COMPANYROLE
FR_T_CORDACRP
FR_T_CORDCP
FR_T_COREP
FR_T_CORESP
FR_T_CORHPP
FR_T_CORMP
FR_T_CORTP
FR_T_CURDACRP
FR_T_CURDCP
FR_T_CUREP
FR_T_CURESP
FR_T_CURHPP
FR_T_CURMP
FR_T_CURTP
FR_T_CUSTOMROLE
FR_T_CustomRole_User
FR_T_DEPARTMENT
FR_T_Department_Post_User
FR_T_FAVORITENODE
FR_T_HOMEPAGE
FR_T_LOGINUSER
FR_T_PFMM
FR_T_POST
FR_T_UENF
FR_T_USER
FR_T_USERDEVICEINFO
FR_URLENTRY
FR_WRITE_TEMP_DATA
FSTLO
OFFSET_IP_RELATIVE
QRTZ_BLOB_TRIGGERS
QRTZ_CALENDARS
QRTZ_CRON_TRIGGERS
QRTZ_FIRED_TRIGGERS
QRTZ_JOB_DETAILS
QRTZ_JOB_LISTENERS
QRTZ_LOCKS
QRTZ_PAUSED_TRIGGER_GRPS
QRTZ_SCHEDULER_STATE
QRTZ_SIMPLE_TRIGGERS
QRTZ_TRIGGER_LISTENERS
QRTZ_TRIGGERS
SET_PRINTER_OFFSET

索引:
FR_ERRRECORD_INDEX
FR_EXERECORD_INDEX
FR_EXPRECORD_INDEX
FR_FSRECORD_INDEX
FR_PTRECORD_INDEX
FR_SCHEDULERECORD_INDEX
...(建表语句中未命名的索引)

触发器:
FR_CALENDAR_ITRIGGERTG
FR_CRONEXPRESSION_ITRIGGERTG
FR_ERRRECORDTG
FR_EXCEL_SUBMIT_TASKTG
FR_EXERECORDTG
FR_EXPRECORDTG
FR_FILEENTRYTG
FR_FOLDERENTRYTG
FR_FSRECORDTG
FR_ONCE_ITRIGGERTG
FR_PRI_TRACK_RECORDTG
FR_PROCESS_ALERT_TOASTTG
FR_PROCESS_LOGTG
FR_PROCESS_REMIND_TOASTTG
FR_PROCESS_STASH_DATATG
FR_PROCESS_TASK_IMPLTG
FR_PTRECORDTG
FR_REPORT_PROCESS_NODETG
FR_REPORT_PROCESS_TASKTG
FR_REPORT_PROCESSTG
FR_REPORTLETENTRYTG
FR_RPPETG
FR_SCHEDULE_ACTIONLISTTG
FR_SCHEDULE_CLASSACTIONTG
FR_SCHEDULE_EMAILTG
FR_SCHEDULE_FTPTG
FR_SCHEDULE_OUTPUTTG
FR_SCHEDULE_PRINTTG
FR_SCHEDULE_PUSHTG
FR_SCHEDULE_SAPSYN_TASKTG
FR_SCHEDULE_TASKTG
FR_SCHEDULERECORDTG
FR_SIMPLE_ITRIGGERTG
FR_T_COMPANYROLETG
FR_T_CORDACRPTG
FR_T_CORDCPTG
FR_T_COREPTG
FR_T_CORESPTG
FR_T_CORHPPTG
FR_T_CORMPTG
FR_T_CORTPTG
FR_T_CURDACRPTG
FR_T_CURDCPTG
FR_T_CUREPTG
FR_T_CURESPTG
FR_T_CURHPPTG
FR_T_CURMPTG
FR_T_CURTPTG
FR_T_CUSTOMROLE_USERTG
FR_T_CUSTOMROLETG
FR_T_DEPARTMENT_POST_USERTG
FR_T_DEPARTMENTTG
FR_T_FAVORITENODETG
FR_T_HOMEPAGETG
FR_T_LOGINUSERTG
FR_T_PFMMTG
FR_T_POSTTG
FR_T_UENFTG
FR_T_USERDEVICEINFOTG
FR_T_USERTG
FR_URLENTRYTG
FR_WRITE_TEMP_DATATG
FSTLOTG
OFFSET_IP_RELATIVETG
SET_PRINTER_OFFSETTG

序列:
FR_CALENDAR_ITRIGGER_SEQ
FR_CRONEXPRESSION_ITRIGGER_SEQ
FR_ERRRECORD_SEQ
FR_EXCEL_SUBMIT_TASK_SEQ
FR_EXERECORD_SEQ
FR_EXPRECORD_SEQ
FR_FILEENTRY_SEQ
FR_FOLDERENTRY_SEQ
FR_FSRECORD_SEQ
FR_ONCE_ITRIGGER_SEQ
FR_PRI_TRACK_RECORD_SEQ
FR_PROCESS_ALERT_TOAST_SEQ
FR_PROCESS_LOG_SEQ
FR_PROCESS_REMIND_TOAST_SEQ
FR_PROCESS_STASH_DATA_SEQ
FR_PROCESS_TASK_IMPL_SEQ
FR_PTRECORD_SEQ
FR_REPORT_PROCESS_NODE_SEQ
FR_REPORT_PROCESS_SEQ
FR_REPORT_PROCESS_TASK_SEQ
FR_REPORTLETENTRY_SEQ
FR_RPPE_SEQ
FR_SCHEDULE_ACTIONLIST_SEQ
FR_SCHEDULE_CLASSACTION_SEQ
FR_SCHEDULE_EMAIL_SEQ
FR_SCHEDULE_FTP_SEQ
FR_SCHEDULE_OUTPUT_SEQ
FR_SCHEDULE_PRINT_SEQ
FR_SCHEDULE_PUSH_SEQ
FR_SCHEDULE_SAPSYN_TASK_SEQ
FR_SCHEDULE_TASK_SEQ
FR_SCHEDULERECORD_SEQ
FR_SIMPLE_ITRIGGER_SEQ
FR_T_COMPANYROLE_SEQ
FR_T_CORDACRP_SEQ
FR_T_CORDCP_SEQ
FR_T_COREP_SEQ
FR_T_CORESP_SEQ
FR_T_CORHPP_SEQ
FR_T_CORMP_SEQ
FR_T_CORTP_SEQ
FR_T_CURDACRP_SEQ
FR_T_CURDCP_SEQ
FR_T_CUREP_SEQ
FR_T_CURESP_SEQ
FR_T_CURHPP_SEQ
FR_T_CURMP_SEQ
FR_T_CURTP_SEQ
FR_T_CUSTOMROLE_SEQ
FR_T_CUSTOMROLE_USER_SEQ
FR_T_DEPARTMENT_POST_USER_SEQ
FR_T_DEPARTMENT_SEQ
FR_T_FAVORITENODE_SEQ
FR_T_HOMEPAGE_SEQ
FR_T_LOGINUSER_SEQ
FR_T_PFMM_SEQ
FR_T_POST_SEQ
FR_T_UENF_SEQ
FR_T_USER_SEQ
FR_T_USERDEVICEINFO_SEQ
FR_URLENTRY_SEQ
FR_WRITE_TEMP_DATA_SEQ
FSTLO_SEQ
OFFSET_IP_RELATIVE_SEQ
SET_PRINTER_OFFSET_SEQ


二、删除步骤

1、在 plsql 中删除:触发器、序列
-- 删除触发器
drop trigger FR_CALENDAR_ITRIGGERTG;
drop trigger FR_CRONEXPRESSION_ITRIGGERTG;
drop trigger FR_ERRRECORDTG;
drop trigger FR_EXCEL_SUBMIT_TASKTG;
drop trigger FR_EXERECORDTG;
drop trigger FR_EXPRECORDTG;
drop trigger FR_FILEENTRYTG;
drop trigger FR_FOLDERENTRYTG;
drop trigger FR_FSRECORDTG;
drop trigger FR_ONCE_ITRIGGERTG;
drop trigger FR_PRI_TRACK_RECORDTG;
drop trigger FR_PROCESS_ALERT_TOASTTG;
drop trigger FR_PROCESS_LOGTG;
drop trigger FR_PROCESS_REMIND_TOASTTG;
drop trigger FR_PROCESS_STASH_DATATG;
drop trigger FR_PROCESS_TASK_IMPLTG;
drop trigger FR_PTRECORDTG;
drop trigger FR_REPORT_PROCESS_NODETG;
drop trigger FR_REPORT_PROCESS_TASKTG;
drop trigger FR_REPORT_PROCESSTG;
drop trigger FR_REPORTLETENTRYTG;
drop trigger FR_RPPETG;
drop trigger FR_SCHEDULE_ACTIONLISTTG;
drop trigger FR_SCHEDULE_CLASSACTIONTG;
drop trigger FR_SCHEDULE_EMAILTG;
drop trigger FR_SCHEDULE_FTPTG;
drop trigger FR_SCHEDULE_OUTPUTTG;
drop trigger FR_SCHEDULE_PRINTTG;
drop trigger FR_SCHEDULE_PUSHTG;
drop trigger FR_SCHEDULE_SAPSYN_TASKTG;
drop trigger FR_SCHEDULE_TASKTG;
drop trigger FR_SCHEDULERECORDTG;
drop trigger FR_SIMPLE_ITRIGGERTG;
drop trigger FR_T_COMPANYROLETG;
drop trigger FR_T_CORDACRPTG;
drop trigger FR_T_CORDCPTG;
drop trigger FR_T_COREPTG;
drop trigger FR_T_CORESPTG;
drop trigger FR_T_CORHPPTG;
drop trigger FR_T_CORMPTG;
drop trigger FR_T_CORTPTG;
drop trigger FR_T_CURDACRPTG;
drop trigger FR_T_CURDCPTG;
drop trigger FR_T_CUREPTG;
drop trigger FR_T_CURESPTG;
drop trigger FR_T_CURHPPTG;
drop trigger FR_T_CURMPTG;
drop trigger FR_T_CURTPTG;
drop trigger FR_T_CUSTOMROLE_USERTG;
drop trigger FR_T_CUSTOMROLETG;
drop trigger FR_T_DEPARTMENT_POST_USERTG;
drop trigger FR_T_DEPARTMENTTG;
drop trigger FR_T_FAVORITENODETG;
drop trigger FR_T_HOMEPAGETG;
drop trigger FR_T_LOGINUSERTG;
drop trigger FR_T_PFMMTG;
drop trigger FR_T_POSTTG;
drop trigger FR_T_UENFTG;
drop trigger FR_T_USERDEVICEINFOTG;
drop trigger FR_T_USERTG;
drop trigger FR_URLENTRYTG;
drop trigger FR_WRITE_TEMP_DATATG;
drop trigger FSTLOTG;
drop trigger OFFSET_IP_RELATIVETG;
drop trigger SET_PRINTER_OFFSETTG;

-- 序列
drop sequence FR_CALENDAR_ITRIGGER_SEQ;
drop sequence FR_CRONEXPRESSION_ITRIGGER_SEQ;
drop sequence FR_ERRRECORD_SEQ;
drop sequence FR_EXCEL_SUBMIT_TASK_SEQ;
drop sequence FR_EXERECORD_SEQ;
drop sequence FR_EXPRECORD_SEQ;
drop sequence FR_FILEENTRY_SEQ;
drop sequence FR_FOLDERENTRY_SEQ;
drop sequence FR_FSRECORD_SEQ;
drop sequence FR_ONCE_ITRIGGER_SEQ;
drop sequence FR_PRI_TRACK_RECORD_SEQ;
drop sequence FR_PROCESS_ALERT_TOAST_SEQ;
drop sequence FR_PROCESS_LOG_SEQ;
drop sequence FR_PROCESS_REMIND_TOAST_SEQ;
drop sequence FR_PROCESS_STASH_DATA_SEQ;
drop sequence FR_PROCESS_TASK_IMPL_SEQ;
drop sequence FR_PTRECORD_SEQ;
drop sequence FR_REPORT_PROCESS_NODE_SEQ;
drop sequence FR_REPORT_PROCESS_SEQ;
drop sequence FR_REPORT_PROCESS_TASK_SEQ;
drop sequence FR_REPORTLETENTRY_SEQ;
drop sequence FR_RPPE_SEQ;
drop sequence FR_SCHEDULE_ACTIONLIST_SEQ;
drop sequence FR_SCHEDULE_CLASSACTION_SEQ;
drop sequence FR_SCHEDULE_EMAIL_SEQ;
drop sequence FR_SCHEDULE_FTP_SEQ;
drop sequence FR_SCHEDULE_OUTPUT_SEQ;
drop sequence FR_SCHEDULE_PRINT_SEQ;
drop sequence FR_SCHEDULE_PUSH_SEQ;
drop sequence FR_SCHEDULE_SAPSYN_TASK_SEQ;
drop sequence FR_SCHEDULE_TASK_SEQ;
drop sequence FR_SCHEDULERECORD_SEQ;
drop sequence FR_SIMPLE_ITRIGGER_SEQ;
drop sequence FR_T_COMPANYROLE_SEQ;
drop sequence FR_T_CORDACRP_SEQ;
drop sequence FR_T_CORDCP_SEQ;
drop sequence FR_T_COREP_SEQ;
drop sequence FR_T_CORESP_SEQ;
drop sequence FR_T_CORHPP_SEQ;
drop sequence FR_T_CORMP_SEQ;
drop sequence FR_T_CORTP_SEQ;
drop sequence FR_T_CURDACRP_SEQ;
drop sequence FR_T_CURDCP_SEQ;
drop sequence FR_T_CUREP_SEQ;
drop sequence FR_T_CURESP_SEQ;
drop sequence FR_T_CURHPP_SEQ;
drop sequence FR_T_CURMP_SEQ;
drop sequence FR_T_CURTP_SEQ;
drop sequence FR_T_CUSTOMROLE_SEQ;
drop sequence FR_T_CUSTOMROLE_USER_SEQ;
drop sequence FR_T_DEPARTMENT_POST_USER_SEQ;
drop sequence FR_T_DEPARTMENT_SEQ;
drop sequence FR_T_FAVORITENODE_SEQ;
drop sequence FR_T_HOMEPAGE_SEQ;
drop sequence FR_T_LOGINUSER_SEQ;
drop sequence FR_T_PFMM_SEQ;
drop sequence FR_T_POST_SEQ;
drop sequence FR_T_UENF_SEQ;
drop sequence FR_T_USER_SEQ;
drop sequence FR_T_USERDEVICEINFO_SEQ;
drop sequence FR_URLENTRY_SEQ;
drop sequence FR_WRITE_TEMP_DATA_SEQ;
drop sequence FSTLO_SEQ;
drop sequence OFFSET_IP_RELATIVE_SEQ;
drop sequence SET_PRINTER_OFFSET_SEQ;


2、因为有些表中涉及未命名条件约束,借助 sql developer 手动删除以下表(右键-表名-删除)
fr_errrecord
fr_exerecord
fr_exprecord
fr_fsrecord
fr_pri_track_record
fr_ptrecord
fr_schedule_sapsyn_task
fr_schedulerecord
FR_T_COMPANYROLE
FR_T_CustomRole_User
FR_T_Department_Post_User
FR_T_CUSTOMROLE
FR_T_DEPARTMENT
FR_T_POST
FR_T_USER

3、删除剩余表
drop table FR_CALENDAR_ITRIGGER;
drop table FR_CRONEXPRESSION_ITRIGGER;
drop table FR_EXCEL_SUBMIT_TASK;
drop table FR_FILEENTRY;
drop table FR_FOLDERENTRY;
drop table FR_ONCE_ITRIGGER;
drop table FR_PROCESS_ALERT_TOAST;
drop table FR_PROCESS_LOG;
drop table FR_PROCESS_REMIND_TOAST;
drop table FR_PROCESS_STASH_DATA;
drop table FR_PROCESS_TASK_IMPL;
drop table FR_REPORT_PROCESS;
drop table FR_REPORT_PROCESS_NODE;
drop table FR_REPORT_PROCESS_TASK;
drop table FR_REPORTLETENTRY;
drop table FR_RPPE;
drop table FR_SCHEDULE_ACTIONLIST;
drop table FR_SCHEDULE_CLASSACTION;
drop table FR_SCHEDULE_EMAIL;
drop table FR_SCHEDULE_FTP;
drop table FR_SCHEDULE_OUTPUT;
drop table FR_SCHEDULE_PRINT;
drop table FR_SCHEDULE_PUSH;
drop table FR_SCHEDULE_TASK;
drop table FR_SIMPLE_ITRIGGER;
drop table FR_T_CORDACRP;
drop table FR_T_CORDCP;
drop table FR_T_COREP;
drop table FR_T_CORESP;
drop table FR_T_CORHPP;
drop table FR_T_CORMP;
drop table FR_T_CORTP;
drop table FR_T_CURDACRP;
drop table FR_T_CURDCP;
drop table FR_T_CUREP;
drop table FR_T_CURESP;
drop table FR_T_CURHPP;
drop table FR_T_CURMP;
drop table FR_T_CURTP;
drop table FR_T_FAVORITENODE;
drop table FR_T_HOMEPAGE;
drop table FR_T_LOGINUSER;
drop table FR_T_PFMM;
drop table FR_T_UENF;
drop table FR_T_USERDEVICEINFO;
drop table FR_URLENTRY;
drop table FR_WRITE_TEMP_DATA;
drop table FSTLO;
drop table OFFSET_IP_RELATIVE;
drop table QRTZ_BLOB_TRIGGERS;
drop table QRTZ_CALENDARS;
drop table QRTZ_CRON_TRIGGERS;
drop table QRTZ_FIRED_TRIGGERS;
drop table QRTZ_JOB_DETAILS;
drop table QRTZ_JOB_LISTENERS;
drop table QRTZ_LOCKS;
drop table QRTZ_PAUSED_TRIGGER_GRPS;
drop table QRTZ_SCHEDULER_STATE;
drop table QRTZ_SIMPLE_TRIGGERS;
drop table QRTZ_TRIGGER_LISTENERS;
drop table QRTZ_TRIGGERS;
drop table SET_PRINTER_OFFSET;



您需要登录后才可以回帖 登录 | 加入我们

本版积分规则

Archiver|手机版|小黑屋|江苏金智教育信息股份有限公司 ( 系统管理员:binmeng@wisedu.com  

GMT+8, 2021-3-3 03:37

Powered by Discuz! X3.2

© 2015 Design: www.wisedu.com

快速回复 返回顶部 返回列表