How to get capacity specifications for a particular Oracle release?
Physical Database Limits

Logical Database Limits

The maximum number of users (schemas): 2^31 = 2147483648

The official answer to your other questions: unlimited.

The practical answer is: as many as your hardware/operating system/design can handle.