Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Getting workspace for a specific _LT row

user1486505Jan 18 2017 — edited Jan 24 2017

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 21 2017
Added on Jan 18 2017
5 comments
350 views