I have two identical schema, which have the same named tables and sequences. When I connect as SYS and open an editor window to work with Schema2, I change the "Current Schema" drop down tool bar option to Schema2. The problem is when I type in a sequence name for Schema2 and press the "F4" key. When I do this, I get a pop up with all the correct details about the Schema2 owned sequence except the "last cached value". The value that is displayed in the "last cached value" is the value for the sequence in Schema1 with the same name.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center