Sql nav 7.1 and 6.7 are both showing the same behavior.
- Create a sequence in a schema.
create sequence schema_name.sequece_name_seq nocache;
(increment this sequence a few times so the value is not 1)
- Create a sequence with the same name in your own schema.
create sequence sequence_name_seq nocache; (should default into your own personal schema)
- select schema_name.sequence_name_seq.nextval from dual;
You will select the value of the sequence from your schema not the target schema.