switching databases with same app.

 what is involved in creating an application that could use paradox as
well as oracle tables. Is it as simple as changing the alias from
standard to oracle?
 The paradox tables are backups in case the server goes down. It is my
understanding that from a programer's perspective the databases all
look the same and as long as my configuration is set up correctly I
will be okay, and my program will not know the difference.
 Any help would be greatly appreciated.