Copying structure table from a databse to an other (ORACLE)?

Hi,





Is there a simple way to copy structure tables from an ORACLE database to another without exporting/importing the data?





Thanks, Péter





JChem Base version 5.1

Hi Péter,





One way to do it "smarter" is doing it through replication (http://download.oracle.com/docs/cd/B28359_01/server.111/b28324/toc.htm). It is not necessarily simpler, though. (If you want to do this frequently, replication is exactly what you need.) The easiest way is probably through Materialized Views: http://download.oracle.com/docs/cd/B28359_01/server.111/b28324/tdpii_reppit.htm#BEHHGGIB .





You can create an empty structure table in the target database and you can populate it from the MV. If you need read-only access to the structure table and feel adventurous enough, you can modify the entries for this structure table in the jchemproperties table in the target database, so that these entries actually point to the MV, which would spare you copying from the MV to the empty structure table.





Péter