List of oracle Table Names and Rows

I was looking for ways of displaying table names and number of rows it hold. It took me a lot of time to figure out how this can be done. After nearly completing my script, I found a better script than the one I created and want to share it with you.

You can find the full script @List of oracle Table Names and Rows

Export oracle METADATA_ONLY

steps
1. create dump directory (CREATE DIRECTORY metadata_export AS '/opt/app/oracle';
2. make sure the directory has got read and write permssion
3. create shell script as follows
4. schedule the script to run

#!/bin/sh
. envfile.env
$ORACLE_HOME/bin/expdp \"/ as sysdba\" SCHEMAS=shcema1, schema2, schema3 content='METADATA_ONLY' directory=met
adata_export NOLOGFILE=Y dumpfile=metadata_export:metadata.dmp compression=metadata_only