Keep it short
Short names work better both for display and for technical reasons.
-
Keep all table Oracle names to 25 characters or less. This is because target tables contain an internal column for surrogate key information that contains all source table names.
-
Windows has a maximum file path length of 256 characters that may be a problem for users who develop custom programs in Oracle LSH; see Keep container and object names short for integrated development environments.