oracle创建表空间和用户

---oracle创建表空间---
CREATE TABLESPACE ssitablespace
 DATAFILE
     '/opt/oracle/db/oradata/iptvrpt/lv_ssitablespace1tbs' SIZE 20M AUTOEXTEND ON NEXT 10M MAXSIZE 100M
   EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

---oracle创建用户---
create user ssi identified by ssi default tablespace ssitablespace temporary tablespace temp;
grant CONNECT to ssi;
grant RESOURCE to ssi;
grant dba to ssi;
alter profile DEFAULT limit failed_login_attempts unlimited password_life_time unlimited

 

----使用ssi用户登入-----

@database.sql

----完成-----

 

也可以写出批处理

创建文件createtablespaceanduser.sh

#!/usr/bin/ksh

 
net_svr="bss"
export ORACLE_SID=$net_svr
link_str="/as sysdba"

echo "create tablespaces start ......"
sqlplus "$link_str" <<EOF1

CREATE TABLESPACE ssitablespace
 DATAFILE
     '/opt/oracle/db/oradata/iptvrpt/lv_ssitablespace1tbs' SIZE 20M AUTOEXTEND ON NEXT 10M MAXSIZE 100M
   EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

 

create user ssi identified by ssi default tablespace ssitablespace temporary tablespace temp;
grant CONNECT to ssi;
grant RESOURCE to ssi;
grant dba to ssi;
alter profile DEFAULT limit failed_login_attempts unlimited password_life_time unlimited

 

exit  

 

link_str="ssi/ssi"

echo  "load data start ....... "

sqlplus "$link_str"

 

@./sql/data.sql

echo  "load data finish ....... "
EOF1
echo "create tablespaces end ......"

----完成-----