To Create a Database for the United Kingdom Patient Solution

Before You Begin

The Oracle scripts that come with the solution create a user identified as uk. They are located in the Solutions\NB\MI\project\UKPatient\sca\source\DatabaseScript directory.

1. As a SYSDBA user run the createuser-uk.sql script.

2. As the uk user, with a password of uk, run the following scripts.

   ---

   Tip –

   Run the create.sql script first.

   ---

   • create.sql

   • codelist.sql

   • systems.sql

   • createIndexes.sql

   • createUserCodeData.sql

See Also

• United Kingdom Patient Solution Using MDM

• Benefits of the United Kingdom Patient Solution

• United Kingdom Patient Solution Template

• United Kingdom Patient Solution Uses