Hi Leo, it does not currently support an optional schema. Here is the documentation on that connector if you have any other questions:
The Oracle source does not alter the schema present in your database. Depending on the destination connected to this source, however, the schema may be altered. See the destination's documentation for more details.