How to map a NuGenesis SDMS project to an Oracle tablespace - WKB49782

OBJECTIVE or GOAL

To find the exact Oracle tablespace for an SDMS project in NuGenesis.

ENVIRONMENT

• NuGenesis 8 SDMS.

PROCEDURE

• Contact Waters Technical Support for the SQL scripts.

ADDITIONAL INFORMATION

Example:
 

The sdms8_partition_monitor script would provide Partition name:

Partition Name       # Rows            Project Name                    Project Guid

NGTAGS_P16          4               BBB                1EB5D539-9CF7-47ce-9209-2E1C000A9095

 

The sdms8_db_monitor script would provide the tablespace info:

TOTAL SPACE ALLOCATED TO TABLESPACE SDMS80DATA_P16 IS 92151.3 MB

TOTAL SPACE USED IN TABLESPACE SDMS80DATA_P16 IS 59.24 MB

 

The sdms8_partid_identification script provides:

SDMS 8 PROJECT: BBB WILL USE SDMS 8 PARTITION: NGTAGS_16

PROJECT GUID: 1EB5D539-9CF7-47ce-9209-2E1C000A9095