Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Invalid code generated with CRUD compatibility for original table = yes #12

Open
PhilippSalvisberg opened this issue May 7, 2018 · 0 comments
Assignees
Labels

Comments

@PhilippSalvisberg
Copy link
Contributor

Configuration

-- 
-- Bitemp Remodeler configuration
-- - Input table : DEPT
-- - Origin model: non-temporal
-- - Target model: uni-temporal transaction-time
-- - Parameters
--     - Generate table API?                   : Yes
--     - CRUD compatibility for original table?: Yes
--     - Flashback data archive name           : FBA
--     - Flashback archive context level       : Keep current level
--     - Suffix for table with latest content  : _lt
--     - Suffix for full history view          : _fhv
--     - Suffix for object type                : _ot
--     - Suffix for collection type            : _ct
--     - Suffix for instead-of-trigger         : _trg
--     - Suffix for API PL/SQL package         : _api
--     - Suffix for hook PL/SQL package        : _hook
--

Wrong generated code

Table DEPT instead of DEPT_LT is used.

here (table_name = 'DEPT')

--
-- Enforce visibility of source flashback archive tables (for SCN 0 instead of SCN MINVALUE)
--
BEGIN
   dbms_flashback_archive.disassociate_fba(
      owner_name => 'OGDEMO',
      table_name => 'DEPT'
   );
   dbms_flashback_archive.reassociate_fba(
       owner_name => 'OGDEMO',
       table_name => 'DEPT'
   );
END;
/

and here (FROM dept)

--
-- Create full history view
--
CREATE OR REPLACE FORCE VIEW dept_fhv (
...
  FROM dept VERSIONS BETWEEN SCN 0 AND MAXVALUE
...
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant