databaseoracle-databasenfsdatabase-link

Database Link vs. NFS


What would be faster to migrate data from an old Oracle DB server to a new server, using a database link, or create a shared directory via NFS between old and new server to move data?


Solution

  • It all depends on which database version , are the two database server source & destination in same network or different network . Size of the database . Generally you would be requiring expdp or rman backup to migrate to new version to maintain the consitency of the database. So in practice NFS will work much better