For tables and materialized views (avoid materialized views by removing them from dba_mviews): #!/bin/ksh export ORACLE_BASE=/…/oracle export ORACLE_HOME=/…/oracle/product/11.2.0/dbhome_1 export ORACLE_HOSTNAME=… export ORACLE_SID=[…] /…/oracle/product/11.2.0/dbhome_1/bin/sqlplus user/passwd