I have a database running live application, I need to create a meta data clone of this database to another oracle database, so my question is what are the best way of going forward to this? and also how to do this? is RMAN is good way of doing it or is it even possible with RMAN to do metadata back of the tables and procedures etc.
I don't need the actual data but the metadata like tables, views, store procedures etc.
database is: oracle 10G
os: sun sparc
thanks for help