Oracle 建立数据库,用户,表空间,数据导入
来源:互联网 发布:java中的api文档 编辑:程序博客网 时间:2024/04/26 18:54
以oa为例:
1 建立oa数据库。字符集为utf-8。
2 prompt '创建LOGIN---oa'
create user oa IDENTIFIED BY oa;
GRANT ALTER ANY CLUSTER TO oa WITH ADMIN OPTION;
GRANT ALTER ANY INDEX TO oa WITH ADMIN OPTION;
GRANT ALTER ANY LIBRARY TO oa WITH ADMIN OPTION;
GRANT ALTER ANY PROCEDURE TO oa WITH ADMIN OPTION;
GRANT ALTER ANY ROLE TO oa WITH ADMIN OPTION;
GRANT ALTER ANY SEQUENCE TO oa WITH ADMIN OPTION;
GRANT ALTER ANY SNAPSHOT TO oa WITH ADMIN OPTION;
GRANT ALTER ANY TABLE TO oa WITH ADMIN OPTION;
GRANT ALTER ANY TRIGGER TO oa WITH ADMIN OPTION;
GRANT ALTER ANY TYPE TO oa WITH ADMIN OPTION;
GRANT ALTER DATABASE TO oa WITH ADMIN OPTION;
GRANT ALTER PROFILE TO oa WITH ADMIN OPTION;
GRANT ALTER RESOURCE COST TO oa WITH ADMIN OPTION;
GRANT ALTER ROLLBACK SEGMENT TO oa WITH ADMIN OPTION;
GRANT ALTER SESSION TO oa WITH ADMIN OPTION;
GRANT ALTER SYSTEM TO oa WITH ADMIN OPTION;
GRANT ALTER TABLESPACE TO oa WITH ADMIN OPTION;
GRANT ALTER USER TO oa WITH ADMIN OPTION;
GRANT ANALYZE ANY TO oa WITH ADMIN OPTION;
GRANT AUDIT ANY TO oa WITH ADMIN OPTION;
GRANT AUDIT SYSTEM TO oa WITH ADMIN OPTION;
GRANT BACKUP ANY TABLE TO oa WITH ADMIN OPTION;
GRANT BECOME USER TO oa WITH ADMIN OPTION;
GRANT COMMENT ANY TABLE TO oa WITH ADMIN OPTION;
GRANT CREATE ANY CLUSTER TO oa WITH ADMIN OPTION;
GRANT CREATE ANY DIRECTORY TO oa WITH ADMIN OPTION;
GRANT CREATE ANY INDEX TO oa WITH ADMIN OPTION;
GRANT CREATE ANY LIBRARY TO oa WITH ADMIN OPTION;
GRANT CREATE ANY PROCEDURE TO oa WITH ADMIN OPTION;
GRANT CREATE ANY SEQUENCE TO oa WITH ADMIN OPTION;
GRANT CREATE ANY SNAPSHOT TO oa WITH ADMIN OPTION;
GRANT CREATE ANY SYNONYM TO oa WITH ADMIN OPTION;
GRANT CREATE ANY TABLE TO oa WITH ADMIN OPTION;
GRANT CREATE ANY TRIGGER TO oa WITH ADMIN OPTION;
GRANT CREATE ANY TYPE TO oa WITH ADMIN OPTION;
GRANT CREATE ANY VIEW TO oa WITH ADMIN OPTION;
GRANT CREATE CLUSTER TO oa WITH ADMIN OPTION;
GRANT CREATE DATABASE LINK TO oa WITH ADMIN OPTION;
GRANT CREATE LIBRARY TO oa WITH ADMIN OPTION;
GRANT CREATE PROCEDURE TO oa WITH ADMIN OPTION;
GRANT CREATE PROFILE TO oa WITH ADMIN OPTION;
GRANT CREATE PUBLIC DATABASE LINK TO oa WITH ADMIN OPTION;
GRANT CREATE PUBLIC SYNONYM TO oa WITH ADMIN OPTION;
GRANT CREATE ROLE TO oa WITH ADMIN OPTION;
GRANT CREATE ROLLBACK SEGMENT TO oa WITH ADMIN OPTION;
GRANT CREATE SEQUENCE TO oa WITH ADMIN OPTION;
GRANT CREATE SESSION TO oa WITH ADMIN OPTION;
GRANT CREATE SNAPSHOT TO oa WITH ADMIN OPTION;
GRANT CREATE SYNONYM TO oa WITH ADMIN OPTION;
GRANT CREATE TABLE TO oa WITH ADMIN OPTION;
GRANT CREATE TABLESPACE TO oa WITH ADMIN OPTION;
GRANT CREATE TRIGGER TO oa WITH ADMIN OPTION;
GRANT CREATE TYPE TO oa WITH ADMIN OPTION;
GRANT CREATE USER TO oa WITH ADMIN OPTION;
GRANT CREATE VIEW TO oa WITH ADMIN OPTION;
GRANT DELETE ANY TABLE TO oa WITH ADMIN OPTION;
GRANT DROP ANY CLUSTER TO oa WITH ADMIN OPTION;
GRANT DROP ANY DIRECTORY TO oa WITH ADMIN OPTION;
GRANT DROP ANY INDEX TO oa WITH ADMIN OPTION;
GRANT DROP ANY LIBRARY TO oa WITH ADMIN OPTION;
GRANT DROP ANY PROCEDURE TO oa WITH ADMIN OPTION;
GRANT DROP ANY ROLE TO oa WITH ADMIN OPTION;
GRANT DROP ANY SEQUENCE TO oa WITH ADMIN OPTION;
GRANT DROP ANY SNAPSHOT TO oa WITH ADMIN OPTION;
GRANT DROP ANY SYNONYM TO oa WITH ADMIN OPTION;
GRANT DROP ANY TABLE TO oa WITH ADMIN OPTION;
GRANT DROP ANY TRIGGER TO oa WITH ADMIN OPTION;
GRANT DROP ANY TYPE TO oa WITH ADMIN OPTION;
GRANT DROP ANY VIEW TO oa WITH ADMIN OPTION;
GRANT DROP PROFILE TO oa WITH ADMIN OPTION;
GRANT DROP PUBLIC DATABASE LINK TO oa WITH ADMIN OPTION;
GRANT DROP PUBLIC SYNONYM TO oa WITH ADMIN OPTION;
GRANT DROP ROLLBACK SEGMENT TO oa WITH ADMIN OPTION;
GRANT DROP TABLESPACE TO oa WITH ADMIN OPTION;
GRANT DROP USER TO oa WITH ADMIN OPTION;
GRANT EXECUTE ANY LIBRARY TO oa WITH ADMIN OPTION;
GRANT EXECUTE ANY PROCEDURE TO oa WITH ADMIN OPTION;
GRANT EXECUTE ANY TYPE TO oa WITH ADMIN OPTION;
GRANT FORCE ANY TRANSACTION TO oa WITH ADMIN OPTION;
GRANT FORCE TRANSACTION TO oa WITH ADMIN OPTION;
GRANT GRANT ANY PRIVILEGE TO oa WITH ADMIN OPTION;
GRANT GRANT ANY ROLE TO oa WITH ADMIN OPTION;
GRANT INSERT ANY TABLE TO oa WITH ADMIN OPTION;
GRANT LOCK ANY TABLE TO oa WITH ADMIN OPTION;
GRANT MANAGE TABLESPACE TO oa WITH ADMIN OPTION;
GRANT RESTRICTED SESSION TO oa WITH ADMIN OPTION;
GRANT SELECT ANY SEQUENCE TO oa WITH ADMIN OPTION;
GRANT SELECT ANY TABLE TO oa WITH ADMIN OPTION;
GRANT UNLIMITED TABLESPACE TO oa WITH ADMIN OPTION;
GRANT UPDATE ANY TABLE TO oa WITH ADMIN OPTION;
GRANT "AQ_ADMINISTRATOR_ROLE" TO oa WITH ADMIN OPTION;
GRANT "AQ_USER_ROLE" TO oa WITH ADMIN OPTION;
GRANT "CONNECT" TO oa WITH ADMIN OPTION;
GRANT "DBA" TO oa WITH ADMIN OPTION;
GRANT "DELETE_CATALOG_ROLE" TO oa WITH ADMIN OPTION;
GRANT "EXECUTE_CATALOG_ROLE" TO oa WITH ADMIN OPTION;
GRANT "EXP_FULL_DATABASE" TO oa WITH ADMIN OPTION;
GRANT "HS_ADMIN_ROLE" TO oa WITH ADMIN OPTION;
GRANT "IMP_FULL_DATABASE" TO oa WITH ADMIN OPTION;
GRANT "RECOVERY_CATALOG_OWNER" TO oa WITH ADMIN OPTION;
GRANT "RESOURCE" TO oa WITH ADMIN OPTION;
GRANT "SELECT_CATALOG_ROLE" TO oa WITH ADMIN OPTION;
3 set verify off
define tb_path='D:\app\Administrator\oradata\oa'
prompt '建立表空间开始...'
prompt '建立oa临时表空间---oa_tmp'
CREATE TEMPORARY TABLESPACE "OA_TMP" TEMPFILE
'&tb_path\OA_TMP.ora' SIZE 5M AUTOEXTEND
ON NEXT 64K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
UNIFORM SIZE 1M;
alter database default temporary tablespace oaGBK_TMP;
prompt '建立oa缺省数据表空间---oa_dat'
CREATE TABLESPACE "OA_DAT"
LOGGING
DATAFILE '&tb_path\OA_DAT.ora' SIZE 5M
AUTOEXTEND
ON NEXT 64K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
prompt '建立oa索引表空间---oa_idx'
CREATE TABLESPACE "OA_IDX"
LOGGING
DATAFILE '&tb_path\OA_IDX.ora' SIZE 5M
AUTOEXTEND
ON NEXT 64K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
prompt '建立oa日志表空间---oa_log'
CREATE TABLESPACE "OA_LOG"
LOGGING
DATAFILE '&tb_path\OA_LOG.ora' SIZE 5M
AUTOEXTEND
ON NEXT 64K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
prompt '建立表空间完毕!'
set feedback off
4 imp 登录名/登录密码@SID file=文件完整路径 full=y
1 建立oa数据库。字符集为utf-8。
2 prompt '创建LOGIN---oa'
create user oa IDENTIFIED BY oa;
GRANT ALTER ANY CLUSTER TO oa WITH ADMIN OPTION;
GRANT ALTER ANY INDEX TO oa WITH ADMIN OPTION;
GRANT ALTER ANY LIBRARY TO oa WITH ADMIN OPTION;
GRANT ALTER ANY PROCEDURE TO oa WITH ADMIN OPTION;
GRANT ALTER ANY ROLE TO oa WITH ADMIN OPTION;
GRANT ALTER ANY SEQUENCE TO oa WITH ADMIN OPTION;
GRANT ALTER ANY SNAPSHOT TO oa WITH ADMIN OPTION;
GRANT ALTER ANY TABLE TO oa WITH ADMIN OPTION;
GRANT ALTER ANY TRIGGER TO oa WITH ADMIN OPTION;
GRANT ALTER ANY TYPE TO oa WITH ADMIN OPTION;
GRANT ALTER DATABASE TO oa WITH ADMIN OPTION;
GRANT ALTER PROFILE TO oa WITH ADMIN OPTION;
GRANT ALTER RESOURCE COST TO oa WITH ADMIN OPTION;
GRANT ALTER ROLLBACK SEGMENT TO oa WITH ADMIN OPTION;
GRANT ALTER SESSION TO oa WITH ADMIN OPTION;
GRANT ALTER SYSTEM TO oa WITH ADMIN OPTION;
GRANT ALTER TABLESPACE TO oa WITH ADMIN OPTION;
GRANT ALTER USER TO oa WITH ADMIN OPTION;
GRANT ANALYZE ANY TO oa WITH ADMIN OPTION;
GRANT AUDIT ANY TO oa WITH ADMIN OPTION;
GRANT AUDIT SYSTEM TO oa WITH ADMIN OPTION;
GRANT BACKUP ANY TABLE TO oa WITH ADMIN OPTION;
GRANT BECOME USER TO oa WITH ADMIN OPTION;
GRANT COMMENT ANY TABLE TO oa WITH ADMIN OPTION;
GRANT CREATE ANY CLUSTER TO oa WITH ADMIN OPTION;
GRANT CREATE ANY DIRECTORY TO oa WITH ADMIN OPTION;
GRANT CREATE ANY INDEX TO oa WITH ADMIN OPTION;
GRANT CREATE ANY LIBRARY TO oa WITH ADMIN OPTION;
GRANT CREATE ANY PROCEDURE TO oa WITH ADMIN OPTION;
GRANT CREATE ANY SEQUENCE TO oa WITH ADMIN OPTION;
GRANT CREATE ANY SNAPSHOT TO oa WITH ADMIN OPTION;
GRANT CREATE ANY SYNONYM TO oa WITH ADMIN OPTION;
GRANT CREATE ANY TABLE TO oa WITH ADMIN OPTION;
GRANT CREATE ANY TRIGGER TO oa WITH ADMIN OPTION;
GRANT CREATE ANY TYPE TO oa WITH ADMIN OPTION;
GRANT CREATE ANY VIEW TO oa WITH ADMIN OPTION;
GRANT CREATE CLUSTER TO oa WITH ADMIN OPTION;
GRANT CREATE DATABASE LINK TO oa WITH ADMIN OPTION;
GRANT CREATE LIBRARY TO oa WITH ADMIN OPTION;
GRANT CREATE PROCEDURE TO oa WITH ADMIN OPTION;
GRANT CREATE PROFILE TO oa WITH ADMIN OPTION;
GRANT CREATE PUBLIC DATABASE LINK TO oa WITH ADMIN OPTION;
GRANT CREATE PUBLIC SYNONYM TO oa WITH ADMIN OPTION;
GRANT CREATE ROLE TO oa WITH ADMIN OPTION;
GRANT CREATE ROLLBACK SEGMENT TO oa WITH ADMIN OPTION;
GRANT CREATE SEQUENCE TO oa WITH ADMIN OPTION;
GRANT CREATE SESSION TO oa WITH ADMIN OPTION;
GRANT CREATE SNAPSHOT TO oa WITH ADMIN OPTION;
GRANT CREATE SYNONYM TO oa WITH ADMIN OPTION;
GRANT CREATE TABLE TO oa WITH ADMIN OPTION;
GRANT CREATE TABLESPACE TO oa WITH ADMIN OPTION;
GRANT CREATE TRIGGER TO oa WITH ADMIN OPTION;
GRANT CREATE TYPE TO oa WITH ADMIN OPTION;
GRANT CREATE USER TO oa WITH ADMIN OPTION;
GRANT CREATE VIEW TO oa WITH ADMIN OPTION;
GRANT DELETE ANY TABLE TO oa WITH ADMIN OPTION;
GRANT DROP ANY CLUSTER TO oa WITH ADMIN OPTION;
GRANT DROP ANY DIRECTORY TO oa WITH ADMIN OPTION;
GRANT DROP ANY INDEX TO oa WITH ADMIN OPTION;
GRANT DROP ANY LIBRARY TO oa WITH ADMIN OPTION;
GRANT DROP ANY PROCEDURE TO oa WITH ADMIN OPTION;
GRANT DROP ANY ROLE TO oa WITH ADMIN OPTION;
GRANT DROP ANY SEQUENCE TO oa WITH ADMIN OPTION;
GRANT DROP ANY SNAPSHOT TO oa WITH ADMIN OPTION;
GRANT DROP ANY SYNONYM TO oa WITH ADMIN OPTION;
GRANT DROP ANY TABLE TO oa WITH ADMIN OPTION;
GRANT DROP ANY TRIGGER TO oa WITH ADMIN OPTION;
GRANT DROP ANY TYPE TO oa WITH ADMIN OPTION;
GRANT DROP ANY VIEW TO oa WITH ADMIN OPTION;
GRANT DROP PROFILE TO oa WITH ADMIN OPTION;
GRANT DROP PUBLIC DATABASE LINK TO oa WITH ADMIN OPTION;
GRANT DROP PUBLIC SYNONYM TO oa WITH ADMIN OPTION;
GRANT DROP ROLLBACK SEGMENT TO oa WITH ADMIN OPTION;
GRANT DROP TABLESPACE TO oa WITH ADMIN OPTION;
GRANT DROP USER TO oa WITH ADMIN OPTION;
GRANT EXECUTE ANY LIBRARY TO oa WITH ADMIN OPTION;
GRANT EXECUTE ANY PROCEDURE TO oa WITH ADMIN OPTION;
GRANT EXECUTE ANY TYPE TO oa WITH ADMIN OPTION;
GRANT FORCE ANY TRANSACTION TO oa WITH ADMIN OPTION;
GRANT FORCE TRANSACTION TO oa WITH ADMIN OPTION;
GRANT GRANT ANY PRIVILEGE TO oa WITH ADMIN OPTION;
GRANT GRANT ANY ROLE TO oa WITH ADMIN OPTION;
GRANT INSERT ANY TABLE TO oa WITH ADMIN OPTION;
GRANT LOCK ANY TABLE TO oa WITH ADMIN OPTION;
GRANT MANAGE TABLESPACE TO oa WITH ADMIN OPTION;
GRANT RESTRICTED SESSION TO oa WITH ADMIN OPTION;
GRANT SELECT ANY SEQUENCE TO oa WITH ADMIN OPTION;
GRANT SELECT ANY TABLE TO oa WITH ADMIN OPTION;
GRANT UNLIMITED TABLESPACE TO oa WITH ADMIN OPTION;
GRANT UPDATE ANY TABLE TO oa WITH ADMIN OPTION;
GRANT "AQ_ADMINISTRATOR_ROLE" TO oa WITH ADMIN OPTION;
GRANT "AQ_USER_ROLE" TO oa WITH ADMIN OPTION;
GRANT "CONNECT" TO oa WITH ADMIN OPTION;
GRANT "DBA" TO oa WITH ADMIN OPTION;
GRANT "DELETE_CATALOG_ROLE" TO oa WITH ADMIN OPTION;
GRANT "EXECUTE_CATALOG_ROLE" TO oa WITH ADMIN OPTION;
GRANT "EXP_FULL_DATABASE" TO oa WITH ADMIN OPTION;
GRANT "HS_ADMIN_ROLE" TO oa WITH ADMIN OPTION;
GRANT "IMP_FULL_DATABASE" TO oa WITH ADMIN OPTION;
GRANT "RECOVERY_CATALOG_OWNER" TO oa WITH ADMIN OPTION;
GRANT "RESOURCE" TO oa WITH ADMIN OPTION;
GRANT "SELECT_CATALOG_ROLE" TO oa WITH ADMIN OPTION;
3 set verify off
define tb_path='D:\app\Administrator\oradata\oa'
prompt '建立表空间开始...'
prompt '建立oa临时表空间---oa_tmp'
CREATE TEMPORARY TABLESPACE "OA_TMP" TEMPFILE
'&tb_path\OA_TMP.ora' SIZE 5M AUTOEXTEND
ON NEXT 64K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
UNIFORM SIZE 1M;
alter database default temporary tablespace oaGBK_TMP;
prompt '建立oa缺省数据表空间---oa_dat'
CREATE TABLESPACE "OA_DAT"
LOGGING
DATAFILE '&tb_path\OA_DAT.ora' SIZE 5M
AUTOEXTEND
ON NEXT 64K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
prompt '建立oa索引表空间---oa_idx'
CREATE TABLESPACE "OA_IDX"
LOGGING
DATAFILE '&tb_path\OA_IDX.ora' SIZE 5M
AUTOEXTEND
ON NEXT 64K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
prompt '建立oa日志表空间---oa_log'
CREATE TABLESPACE "OA_LOG"
LOGGING
DATAFILE '&tb_path\OA_LOG.ora' SIZE 5M
AUTOEXTEND
ON NEXT 64K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
prompt '建立表空间完毕!'
set feedback off
4 imp 登录名/登录密码@SID file=文件完整路径 full=y
阅读全文
0 0
- Oracle 建立数据库,用户,表空间,数据导入
- Oracle建立表空间和用户、数据导入导出
- oracle建立表空间和数据库用户
- Oracle数据库建立表空间/用户
- oracle 11g linux 建立表空间 用户 授权 数据库导入导出
- oracle 11g linux 建立表空间 用户 授权 数据库导入导出
- Linux下Oracle启动、建立表空间、用户、授权、数据库导入导出
- oracle创建用户、表空间、导入数据
- oracle 11g linux 建立表空间 用户 授权 数据导入 导出
- oracle 数据库 创建用户 创建空间 导入数据
- Oracle 建立表空间和用户 \ 导出和导入 数据表
- Oracle建立表空间用户以及dmp文件导入导出
- Oracle从创建数据库到导入数据的具体步骤(创建数据库,表空间,用户,导入数据乱码等)
- oracle新建数据库schema-建立数据库、表空间和用户
- oracle 数据库创建表空间和用户级导入数据等的一些语句
- Oracle数据库创建表空间、用户及数据的导入、导出【源自于实战】
- 删除原来的oracle数据库(用户),但不更换表空间,并重新导入数据
- 批处理操作Oracle数据库创建表空间、用户及导入数据
- GitChat · 移动开发 | 小程序快速上手:三步完成小程序从无到有的开发
- J2SE相关笔记
- linux awk命令
- mybatis简单使用
- java中stringBuilder的用法
- Oracle 建立数据库,用户,表空间,数据导入
- 微信小程序动态增加组件、删除组件
- 我真的了解基本数据类型和引用类型的自动拆装箱吗?
- centos 7.2 安装 mysql 5.6
- Django admin 的 list_display 变量统计后台作者发贴总数
- nvl()函数和nvl2()函数
- phpstudy 版本切换问题
- 将字符串中空格替换成“20%”
- (转)解决Android 5.0以上版本Button自带阴影效果的方法