Finding a good web host for your database sites is a big problem. Check our recommended host for database hosting or the datacenters with the most powerful and reliable dedicated servers suited for large databases.
This databases discussion was started by Opus 0n 06 January 2009
We upgraded our production database and server from 32 to 64-bit. The testing server is still on 32-bit. The production server database was restored via a data dump.
My problem is that all the synonyms for a particular id are missing in the new production server. I don’t want to rewrite hundreds of scripts to fully qualify all the tables and views.
My question: Is there a why to auto-generate the sql to recreate the synonyms in the test db and run it against the production db? I can’t spend the time to create 629 synonyms individually.
Learn more about Oracle databases here. Should you need to go for trustworthy hosting services for all database related sites, we suggest this host for virtual database hosting and this one for dedicated databases hosting
This entry was posted in Databases Bookmark this post and come back later for the best web hosting coupons.
Oracle : Synonyms & and two databases
Finding a good web host for your database sites is a big problem. Check our recommended host for database hosting or the datacenters with the most powerful and reliable dedicated servers suited for large databases.
This databases discussion was started by Opus 0n 06 January 2009
Learn more about Oracle databases here. Should you need to go for trustworthy hosting services for all database related sites, we suggest this host for virtual database hosting and this one for dedicated databases hosting