Quote Originally Posted by silver40
however, i just found out that our production server is behind a firewall so creating a database link between development and production would probably prove useless..
If what you want is a DBLink just create a new listener in a weird port, ask Networking team to open that port in the firewall, point your DBLink there, Use it then shut down the new listener.