Current Oracle DB I am using is 'Oracle Database 12c Enterprise Edition Release 18.104.22.168.0 - 64bit' and we have a use case for using 'Oracle 12.2.X.X.0'. We want to use the elongated object name lengths of 128 which come with Oracle 12.2
Is Oracle 12.2 backward compatible and supports everything on Oracle 12.1? Like Stored Procs, JBDC connections etc.
If new tables & columns with long names on 12.2 start coming in, Can those tables be used in conjunction with tables created on 12.1 for joins etc., and can they start residing in the same schemas?