Goofy122Fogel,

в 11c нету ntile()
https://docs.oracle.com/cd/B28359_01/server.111/b28286/img_text/ntile.htm
Home / Database / Oracle Database Online Documentation 11 g Release 1 (11.1) / Database Administration

NTILE(expr)
OVER ([ query_partition_clause ] order_by_clause)

NTILE is an analytic function. It divides an ordered data set into a number of buckets indicated by expr and assigns the appropriate bucket number to each row. The buckets are numbered 1 through expr. The expr value must resolve to a positive constant for each partition. Oracle Database expects an integer, and if expr is a noninteger constant, then Oracle truncates the value to an integer. The return value is NUMBER.

......
stax