Oracle linked server top N syntax
Depending on the logic you want, you could pull the top 100 rows into a temporary table and then use that. I say "depending" because you may want your final query to have 100 rows, which could require more from the Oracle box.