系統安裝手記-Database schema

1. Check database environment
Such as:
 select * from session_roles
 select file_name,tablespace_name,bytes/1024/1024 file_size from dba_data_files

2. Create table space
3. Create user
4. Grant privilege
5. Create tables
6. Create View
7. Create index
8. Create sequence
9. Create trigger
10. Create Procedure/Function/Package/Type
11. Create SYNONYM
12. Create database link
13. Insert initiation data
14. Verify installation result

<createdb.sh>
#!/bin/sh
#Wrote by fanyamin

echo "=============Begion to create new database schema============="
echo "Please make sure you have created relative user , tablespace,  dblink and you have the privileges(connect+resource) "
echo "Are all of these done?[Y/N]:"
read continue
if [ "$continue" != "Y" -a "$continue" != "y" ]
then
 echo "See you later!"
 return
fi

echo "Please input your Oracle username:"
read username
echo "Please input your Oracle password:"
read password
echo "Please input your Oracle SID:"
read sid

if [ "$username" == null -a "$password" == null -a  "$sid" == null ]
then
 echo "Your username, or password, or sid is null, please try again. See you later."
 return
fi

echo "check database environment..."
$ORACLE_HOME/bin/sqlplus -S "$username"/"$password"@"$sid" @check_environ.sql>/dev/null

(To be continued)