service name is an identifier of a database service.
A database can be presented as multiple services and
A service can be implemented as multiple database instances.
The service name is specified by the SERVICE_NAMES initialization parameter.
SID or Service Name
If the destination service is:
- an Oracle8i or later release database, then use Service Name
- an Oracle release 8.0 database, then use the SID