You can optionally include a table name if you only want to count one ontology table (this IS case sensitive):
Note: If you get the error as: ERROR at line 1: ORA-01031: insufficient privilege, then run the command:
|SQL server:||exec RunTotalnum 'observation_fact','dbo','@' |
Parameters are: 1) the observation table name (for multi-fact-table setups), 2) the schema name, 3) a single table name to run on a single ontology table or '@' to run on all, and 4) and a wildcard flag that will ignore multifact references in the ontology if 'Y'
Replace 'public' by the schema name for the fact table
If using a schema other than public for metadata, you might need to run "set search_path to 'i2b2metadata','public' " first as well