You yourself well analyzed your design.

Go for the 2nd option. (Normalize tables). Today Oracle can handle billions of rows in a table, performance will not be a problem.