Is there a recommended method of getting the workspace name for a specific _LT table row?
IOW. I want to know the workspaces for given _LT rows and I've tried taking the _LT.version value and comparing it to the all_version_hview.version row to get the workspace but it my dataset, the value is always LIVE.
i.e.
select workspace from all_version_hview where version in (select version from MyData_LT where id = 1);
always returns LIVE even though I believe some of the data should be in a non-LIVE workspace.
Thanks,
Keith