系统安装手记-Database schema
来源:互联网 发布:欧几里德算法的应用 编辑:程序博客网 时间:2024/05/22 06:48
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)
- 系统安装手记-Database schema
- 系统安装手记-Oracle9i
- Database Schema
- database schema
- piwik database schema 研究
- Database Schema Reader
- 改善database schema
- Database catalog and schema
- PostgreSQL tablespace database schema
- 系统安装手记-Apache-PHP-Mysql
- NS2虚拟LINUX系统下安装手记
- 关于安装WIN7系统的一些手记
- Trac - Trac Database Schema - 数据结构
- Auto Building and Database Schema
- Database schema(From Wikipedia)
- sqlserver基础:database schema user
- Mysql中Database和Schema
- openfire安装The Openfire database schema does not appear to be installed. Follow the installation guid
- Macromedia Fireworks MX 认证考试样卷
- Macromedia Dreamweaver MX 认证考试样卷
- 使用 Visual Studio 2005 Team System 进行单元测试并生成用于 Unit Test Framework 的源代码
- 系统安装手记-Oracle9i
- .Net软件在线升级的原理及实现
- 系统安装手记-Database schema
- 系统安装手记-Apache-PHP-Mysql
- 10天学会ASP.net之第五天
- 设定sql server定期自动备份数据库
- javax.ejb.EnterpriseBean翻译
- 10天学会ASP.net之第六天
- javax.ejb.FinderException翻译
- 使用jsp生成彩色汉字验证码
- 10天学会ASP.net之第七天