Install Oracle Scramble Components

The components required for Oracle are found in the scrambleinstall\ORACLE sub directory found in the Data Subset install directory. 
tdm40
The components required for Oracle are found in the scrambleinstall\ORACLE sub directory found in the Data Subset install directory. 
Note:
Oracle 11g XE does not support Java. If you want to use the scramble functionality of Data Subset, Oracle 11g standard version or higher is required. 
To install the Oracle scramble components:
Follow these steps:
  1. Create a new user called SCRAMBLE in your production or copy of production instance. 
  2. (Optional) Use an existing administrative processes schema.
  3. To create a schema, issue the commands:
    CREATE USER SCRAMBLE IDENTIFIED BY [enter a password here] DEFAULT TABLESPACE USERS; GRANT CONNECT, RESOURCE TO SCRAMBLE;
  4. Import the scramble.dmp file user into the schema.
    • On Windows:
      1. Browse to the Datamaker directory
        install_kit\Oracle_Install_Kit\Database\Scramble
        .
      2. Edit the
        scramble.bat
        file and update the version number in the impdp command to reflect your Oracle database version (11.1, 12.0, or 12.1).
        Example for Oracle database version 12.1:
        impdp '"%GT_SYS_USER%/%GT_SYS_PASSWORD%%GT_TNS%"' remap_schema=scramble:%DB_USER% directory=SCRMBLPUMP dumpfile=scramble.dmp logfile=import.log version=
        12.1
      3. Run the scramble.bat file.
        You have imported the
        scramble.dmp
        file user into the schema.
    • On *UNIX:
      1. Copy or ftp the
        scramble.dmp
        file to, for example, the
        /usr/temp/oracle
        directory on your Unix box.
      2. Log in as your DBA user.
      3. Create the "scramble" directory.
      4. Grant the SCRAMBLE_USER create privileges for the "scramble" directory and any child directory.
      5. Log in as your scramble user.
      6. Create or replace the "scramble" directory as '
        /usr/temp/oracle
        ' in Oracle SQL PLUS:
        CREATE OR REPLACE DIRECTORY scramble AS ‘/usr/temp/oracle’;
      7. Run the following command in the Terminal. Update the version number in the
        impdp
        command to reflect your Oracle database version (11.1, 12.0, or 12.1).
        impdp
        username
        /
        password
        @tnsname remap_schema=scramble:%DB_USER% directory=
        scramble
        dumpfile=scramble.dmp logfile=import.log version=
        12.1
        You have imported the
        scramble.dmp
        file user into the schema.
  5. Create public synonyms as follows:
    CREATE PUBLIC SYNONYM GTSRC_XREF FOR SCRAMBLE.GTSRC_XREF;
    CREATE PUBLIC SYNONYM GTSRC_SHUFFLE FOR SCRAMBLE.GTSRC_SHUFFLE;
    CREATE PUBLIC SYNONYM GTSRC_SHUFFLEID FOR SCRAMBLE.GTSRC_SHUFFLEID;
    CREATE PUBLIC SYNONYM GTSRC_REPLACE FOR SCRAMBLE.GTSRC_REPLACE;
    CREATE PUBLIC SYNONYM GTSRC_REFERENCE_DATA FOR SCRAMBLE.GTSRC_REFERENCE_DATA;
    CREATE PUBLIC SYNONYM GTSRC_CHECKSUM FOR SCRAMBLE.GTSRC_CHECKSUM;
    CREATE PUBLIC SYNONYM GTSRC_SETCOUNT FOR SCRAMBLE.GTSRC_SETCOUNT;
    CREATE PUBLIC SYNONYM GTSRC_SCRAMBLE2 FOR SCRAMBLE.GTSRC_SCRAMBLE2;
    CREATE PUBLIC SYNONYM GTSRC_SCRAMBLED2 FOR SCRAMBLE.GTSRC_SCRAMBLED2;
    CREATE PUBLIC SYNONYM GTSRC_SCRAMBLED3 FOR SCRAMBLE.GTSRC_SCRAMBLED3;
    CREATE PUBLIC SYNONYM GTSRC_SCRAMBLEN2 FOR SCRAMBLE.GTSRC_SCRAMBLEN2;
  6. Issue the following Grants on:
    GRANT SELECT,UPDATE,DELETE,INSERT ON  SCRAMBLE.GTSRC_XREF TO PUBLIC;
    GRANT SELECT,UPDATE,DELETE,INSERT ON  SCRAMBLE.GTSRC_SHUFFLE TO PUBLIC;
    GRANT SELECT   ON  SCRAMBLE.GTSRC_REFERENCE_DATA TO PUBLIC;
    GRANT EXECUTE  ON  SCRAMBLE.GTSRC_SCRAMBLE2      TO PUBLIC;
    GRANT EXECUTE  ON  SCRAMBLE.GTSRC_SCRAMBLEN2     TO PUBLIC;
    GRANT EXECUTE  ON  SCRAMBLE.GTSRC_SCRAMBLED2     TO PUBLIC;
    GRANT EXECUTE  ON  SCRAMBLE.GTSRC_SCRAMBLED3     TO PUBLIC;
    GRANT EXECUTE  ON  SCRAMBLE.GTSRC_CHECKSUM       TO PUBLIC;
    GRANT EXECUTE  ON  SCRAMBLE.GTSRC_SETCOUNT       TO PUBLIC;
    GRANT EXECUTE  ON  SCRAMBLE.GTSRC_REPLACE        TO PUBLIC;
    GRANT EXECUTE  ON  SCRAMBLE.GTSRC_SHUFFLEID      TO PUBLIC;
  7. (Optional) You can add extra seed data to the GTSRC_REFERENCE_DATA. Manually enter the data, or build insert statements as follows:
    INSERT INTO gtsrc_reference_data (rd_ref_id, rd_ref_value )
    VALUES (‘MY CUSTOMERS’,’FREDS AUTOREPAIRS’);
    INSERT INTO gtsrc_reference_data (rd_ref_id, rd_ref_value )
    VALUES (‘MY CUSTOMERS’,’JOES TYRES’);