Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Each schema on separate listener

CatinredbootsFeb 19 2018 — edited Feb 21 2018

  Hello,

Is it posible to have each schema on separate listener so each schema will be accessed from different port?

Please let me know if it is possible.

Thanks!

Comments

user9540031
Answer

A quick look into the Globalization Support Guide, sections 5.9.1 Character Range '[x-y]' in Regular Expressions, and 5.5.2 Specifying a Case-Insensitive or Accent-Insensitive Collation, suggests that this is expected behaviour: a < A < b < B (etc.) is true in the GERMAN collating sequence (if I understand well). The reason why there is no match with 'aaaa' is because 'a' is not in the [A-Z] range, whereas 'b' is, when NLS_SORT = 'GERMAN'.
So in this case it would seem that 19.5 gives the right result, whereas 12.1 did not.

Marked as Answer by User_RVFU1 · Dec 18 2020
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 21 2018
Added on Feb 19 2018
50 comments
2,083 views