--Step1、Query Data SELECT FDS.DB_SEQUENCE_NAME, FDS.DOC_SEQUENCE_ID, FDS.NAME FROM FND_DOCUMENT_SEQUENCES FDS WHERE 1 = 1 AND FDS.NAME = 'Want to Delete Data' --Use Step1 DB_SEQUENCE_NAME DROP SEQUENCE APPLSYS.XXXX; --其餘省略 --Use Step1 DOC_SEQUENCE_ID DELETE FND_DOC_SEQUENCE_ASSIGNMENTS FDSA WHERE FDSA.DOC_SEQUENCE_ID = XXXX --Use Step1 NAME DELETE FND_DOCUMENT_SEQUENCES A WHERE 1 = 1 AND A.NAME = 'XXXX'
2023-04-14
[Oracle]How to Data Fix Sequences Define or Assigments Error
訂閱:
張貼留言 (Atom)
沒有留言:
張貼留言