For MedDRA 19.0 and prior

Previous Topic

Next Topic

Book Contents

For MedDRA 19.0 and prior

  1. Copy the MedDRAxxx.zip file from the distribution media to a temporary directory on the server.
  2. Unpack the MedDRAxxx.zip file into a temporary directory, for example:

    $ unzip MedDRAxxx.zip -d /u01/stage/

    The MedDRAxxx subdirectory is created.

  3. Navigate to the /MedDRAxxx directory, for example:

    $ cd /u01/stage/MedDRAxxx

  4. Using a text editor, open the Create_MedDRA.sql file.
    1. Locate the DEFINE ORACLE_DBF_FILE statement.
    2. Edit the path portion in the DEFINE ORACLE_DBF_FILE statement to point to the desired location for the Oracle tablespace data files.

      Keep the single quotes and use &SCHEMA.a.dbf as last part of the string.

      The path can point to any existing location on the database server. However, the Oracle tablespace data files are usually located in the oradata subdirectory of the Oracle Database installation directory.

    3. Optionally, change the default password. Be sure to abide by your site's password policies.

      The default password has the same value as the username.

      Locate the DEFINE PASSWORD='&SCHEMA' line near the top, and replace &SCHEMA with the desired password.

    4. Save and close the file.
  5. Execute the Create_MedDRA.sql script as the system user to create the MEDDRAxxx tablespace and user account, for example:

    $ sqlplus system@<TNS_name> @Create_MedDRA.sql

    A password prompt appears.

  6. Enter the system database account password, and press Enter.
  7. Execute the imp command to populate the MedDRA tablespace you created in a previous step, for example:

    $ imp userid=MEDDRAxxx@<TNS_name> file=MEDDRAxxx.dmp full=Y Log=Imp_MEDDRAxxx.log

    A password prompt appears.

  8. Enter a password for the MEDDRAxxx database account, and press Enter.

    Installation produces log files in the MedDRAxxx directory, including counts of imported records for each table:

    imp_MEDDRAxxx.log

    Create_MedDRA.log

  9. To verify that the import has completed successfully, compare the record counts in imp_MEDDRAxxx.log to the counts of exported records in exp_MEDDRAxxx.log.
Send Feedback