Okay, so I have a new set of DDL from the PPDM to load up the RMOTC data set. Now where to start? Well, here are the steps that I did.
- Create a new Oracle schema called P38 with connect & resource. Not very exciting or current, but it works.
- edit the .sql script that came with it so a .log file is created and I can see what, if any errors are create.
- run the .sql script file and review the .log file; no errors. Okay, I have a empty PPDM v3.8 Alpha schema with all 1692 tables and full RI. Yippy.
- Have to load the base tables, R_SOURCE & R_PPDM_ROW_QUALITY. There are two ways of doing this; the first is to run a series of SQL Insert & Update statements in the right order or disable the RI between the two tables, run simple SQL Insert statements and then turn the RI back on. That's the key, turning the RI back on.
- The next step is to populate the R_* tables of the tables that I want to use. Fortunately I have a series of SQL Insert files kicking around and just modded these. I did review what was stored in the row_quality and source columns.
- Now on to the capturing the meta-data object info. Again, I have a series of SQL statements that do this. I had to assign 'dba' to the account; temporarily, so that I could query the 'dba_*' views. I got lazy about this but what the hay. It's my database. I did remember to revoke this privilege at the end.
- Did an export at this point and imported the dataset into the Oracle XE database on my tablet.
Comments