Hot answers tagged schema
Your question implies that you're using a Kimball Star Schema approach. Option 1 implies a star schema while option 2 implies a more snowflaked design. Kimball argues against snowflaking your design. Therefore, go with option one. It will be easier for your report writers long term and newer in memory database technologies will take advantage of it. ...
Datapump is one answer. Look at http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_export.htm#i1007524 - specifically "Transportable Table mode". Moves the metadata, but not the data. You can choose which schemas to include with the SCHEMAS switch, along with the INCLUDE/EXCLUDE parameters.
Only top voted, non community-wiki answers of a minimum length are eligible