ORACLE_BASE=/u01/app/oracle export ORACLE_BASE ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe export ORACLE_HOME ORACLE_SID=XE export ORACLE_SID PATH=$ORACLE_HOME/bin:$PATH export PATH BKUP_DEST=/home/mohan/backups find $BKUP_DEST -name ‘backup*.dmp’ -mtime +10 -exec rm {} \; cd /home/mohan/backups && /u01/app/oracle/product/11.2.0/xe/bin/exp schema/password FILE=backup_`date +’%Y%m%d-%H%M’`.dmp STATISTICS=NONE startup nomount pfile=/u01/app/oracle/product/11.2.0/xe/dbs/initXE.ora / create database maxinstances 1 maxloghistory 2 maxlogfiles 16 maxlogmembers 2 maxdatafiles 30 datafile ‘/u01/app/oracle/oradata/XE/system.dbf’ size 200M reuse autoextend on next […]

1) To view database select * from v$database; 2) To view instance select * from v$instance; 3) To view all users select * from all_users; 4) To view table and columns for a particular user select tc.table_name Table_name ,tc.column_id Column_id ,lower(tc.column_name) Column_name ,lower(tc.data_type) Data_type ,nvl(tc.data_precision,tc.data_length) Length ,lower(tc.data_scale) Data_scale ,tc.nullable nullable FROM all_tab_columns tc ,all_tables t […]