I'm trying to link an Access database to an Oracle database. The Oracle database is quite huge, so I was thinking if this will cause any performance issues in the Oracle database while the link is created and also when queries are made against the Access database?

Also, when linking from an Access database, is the Service name to be provided the same as the host string when accessing the Oracle DB through SQL Plus? I am having trouble connecting to Oracle.