USER_DIMENSIONS describes dimension objects in the user's schema. Its columns are the same as those in ALL_DIMENSIONS.