AnsweredAssumed Answered

Datasets and Oracle char name limit

Question asked by p3edwards on Jul 9, 2014

Has anyone else run into the Oracle 30 char limitation for table names when using an Enterprise DB using Windows Authentication?  It appears that Oracle counts the users' windows user name as part of the table name.  So when a user with the windows username = "Joseph.Snuffysmith" logs in and attempts to create a dataset Oracle uses the "Joseph.Snuffysmith" to the feature name or table name leaving very little characters for the actual feature name.  Anyone know of any work arounds?

Outcomes