Table of Contents

Search

  1. Preface
  2. Backing Up and Restoring the Data Vault
  3. Configuring Centera as a Remote Data Vault Store
  4. Configuring Data Archive for a Legacy Source Using Legacy Adapters
  5. Data Archive Seamless Access for PeopleSoft
  6. Data Archive Transaction Restore API
  7. Dropping and Truncating Partitions in Data Archive
  8. High Availability Configuration for the Data Archive and File Archive Service Versions 6.1 to 6.3
  9. 0955-High Availability Configuration for the Data Vault Version 6.4 and Later
  10. How to Create Business Rules to Archive and Purge Transactional Data
  11. How to Uninstall Data Archive 5.1
  12. How to Uninstall Data Archive 5.3
  13. How to Use Scripts to Change Database User Passwords in the ILM Repository
  14. IBM DB2 Database Connectivity and Setup for Data Archive
  15. Installing Data Visualization
  16. Integrating Third-Party Schedulers in ILM Engine
  17. Parallel Processing in Data Archive
  18. Seamless Access Configuration for Siebel Applications
  19. Seamless Access Setup for Oracle E-Business Suite
  20. Seamless Access Setup for Oracle R12 in Data Archive
  21. Using the Data Vault Service JDBC Driver to Connect to the Data Vault
  22. Using Multiple Engines in an ILM Environment
  23. Using PowerExchange ODBC Connections in a Data Archive Retirement Project
  24. Discovering Foreign Key Relationships in Enterprise Data Manager

Data Archive How-To Guide

Data Archive How-To Guide

Sample Script for Archive Only Schema

Sample Script for Archive Only Schema

Use the following sample script to create Archive only schema.
CREATE USER AMARCHIVE IDENTIFIED BY password DEFAULT TABLESPACE ARC53_STAGE_D TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK; GRANT SELECT_CATALOG_ROLE TO AMARCHIVE; GRANT CTXAPP TO AMARCHIVE; GRANT HR_REPORTING_USER TO AMARCHIVE WITH ADMIN OPTION; GRANT CONNECT TO AMARCHIVE; GRANT AQ_ADMINISTRATOR_ROLE TO AMARCHIVE WITH ADMIN OPTION; GRANT HR_SECURE_USER TO AMARCHIVE WITH ADMIN OPTION; GRANT OLAP_USER TO AMARCHIVE; ALTER USER AMARCHIVE DEFAULT ROLE ALL; GRANT CREATE ANY TRIGGER TO AMARCHIVE; GRANT DROP ANY PROCEDURE TO AMARCHIVE; GRANT CREATE DATABASE LINK TO AMARCHIVE; GRANT CREATE ANY SEQUENCE TO AMARCHIVE; GRANT DROP ANY VIEW TO AMARCHIVE; GRANT UPDATE ANY TABLE TO AMARCHIVE; GRANT ALTER ANY TABLE TO AMARCHIVE; GRANT CREATE TABLE TO AMARCHIVE; GRANT CREATE ANY CONTEXT TO AMARCHIVE; GRANT CREATE ANY DIRECTORY TO AMARCHIVE; GRANT CREATE TRIGGER TO AMARCHIVE; GRANT GRANT ANY ROLE TO AMARCHIVE; GRANT SELECT ANY SEQUENCE TO AMARCHIVE; GRANT CREATE ANY TABLE TO AMARCHIVE; GRANT DROP ANY MATERIALIZED VIEW TO AMARCHIVE; GRANT ALTER ANY MATERIALIZED VIEW TO AMARCHIVE; GRANT ALTER ANY TRIGGER TO AMARCHIVE; GRANT ALTER ANY ROLE TO AMARCHIVE; GRANT ALTER ANY CLUSTER TO AMARCHIVE; GRANT ALTER ANY OUTLINE TO AMARCHIVE; GRANT DROP PUBLIC SYNONYM TO AMARCHIVE; GRANT CREATE CLUSTER TO AMARCHIVE; GRANT SELECT ANY TABLE TO AMARCHIVE; GRANT DROP ANY TABLE TO AMARCHIVE; GRANT SELECT ANY DICTIONARY TO AMARCHIVE; GRANT DROP ANY OUTLINE TO AMARCHIVE; GRANT CREATE ANY OUTLINE TO AMARCHIVE; GRANT DROP ANY CONTEXT TO AMARCHIVE; GRANT EXECUTE ANY PROCEDURE TO AMARCHIVE; GRANT CREATE PUBLIC DATABASE LINK TO AMARCHIVE; GRANT CREATE PUBLIC SYNONYM TO AMARCHIVE; GRANT DROP ANY INDEX TO AMARCHIVE; GRANT DROP ANY CLUSTER TO AMARCHIVE; GRANT COMMENT ANY TABLE TO AMARCHIVE; GRANT ALTER SYSTEM TO AMARCHIVE; GRANT CREATE TYPE TO AMARCHIVE; GRANT DROP ANY TRIGGER TO AMARCHIVE; GRANT ALTER ANY PROCEDURE TO AMARCHIVE; GRANT DROP ANY ROLE TO AMARCHIVE; GRANT ALTER ANY SEQUENCE TO AMARCHIVE; GRANT ALTER ANY INDEX TO AMARCHIVE; GRANT CREATE ANY CLUSTER TO AMARCHIVE; GRANT GLOBAL QUERY REWRITE TO AMARCHIVE; GRANT CREATE ANY MATERIALIZED VIEW TO AMARCHIVE; GRANT DROP ANY SEQUENCE TO AMARCHIVE; GRANT CREATE ROLE TO AMARCHIVE; GRANT ADMINISTER DATABASE TRIGGER TO AMARCHIVE; GRANT ALTER SESSION TO AMARCHIVE; GRANT ANALYZE ANY TO AMARCHIVE; GRANT CREATE ANY INDEX TO AMARCHIVE; GRANT CREATE ANY PROCEDURE TO AMARCHIVE; GRANT CREATE ANY SYNONYM TO AMARCHIVE; GRANT CREATE ANY VIEW TO AMARCHIVE; GRANT CREATE PROCEDURE TO AMARCHIVE; GRANT CREATE SEQUENCE TO AMARCHIVE; GRANT CREATE SESSION TO AMARCHIVE; GRANT CREATE SYNONYM TO AMARCHIVE; GRANT CREATE VIEW TO AMARCHIVE; GRANT DELETE ANY TABLE TO AMARCHIVE; GRANT DROP ANY SYNONYM TO AMARCHIVE; GRANT EXECUTE ANY PROCEDURE TO AMARCHIVE WITH ADMIN OPTION; GRANT EXECUTE ANY TYPE TO AMARCHIVE; GRANT INSERT ANY TABLE TO AMARCHIVE; GRANT LOCK ANY TABLE TO AMARCHIVE; GRANT SELECT ANY DICTIONARY TO AMARCHIVE WITH ADMIN OPTION; GRANT SELECT ANY TABLE TO AMARCHIVE WITH ADMIN OPTION; GRANT UNLIMITED TABLESPACE TO AMARCHIVE; GRANT EXECUTE ON APPS.EMCASO_FREIGHT_MGR_PKG TO AMARCHIVE; GRANT SELECT ON APPS.EMCASO_QUOTE_HEADERS_ALL_V TO AMARCHIVE; GRANT EXECUTE ON APPS.FND_FLEX_SERVER TO AMARCHIVE; GRANT EXECUTE ON APPS.WF_EVENT TO AMARCHIVE; GRANT EXECUTE ON SYS.DBMS_ALERT TO AMARCHIVE; GRANT EXECUTE ON SYS.DBMS_LOCK TO AMARCHIVE; GRANT EXECUTE ON SYS.DBMS_SPACE_ADMIN TO AMARCHIVE; GRANT SELECT ON SYS.LINK$ TO AMARCHIVE; GRANT SELECT ON SYS.USER$ TO AMARCHIVE; GRANT EXECUTE_CATALOG_ROLE TO AMARCHIVE; GRANT PUBLIC TO AMARCHIVE; GRANT RESOURCE TO AMARCHIVE;

0 COMMENTS

We’d like to hear from you!