Oracle-第二篇：创建用户，赋予权限，并导入数据库脚本（一个操作小记录）

解决sqlplus: command not found

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1

su - root

ln -s $ORACLE_HOME/bin/sqlplus /usr/bin

su - oracle

sqlplus /nolog

启动监听

       lsnrctl start

停止监听

       lsnrctl start

重启监听

       lsnrctl reload

查看监听状态

       lsnrctl status

执行以下sql语句

--删除表空间

drop tablespace FDATATBS including contents and datafiles cascade constraint;

--创建表空间

create tablespace FDATATBS

datafile '/orcl/app/oracle/tableSpace/FDATATBS.dbf'  size 1024m  autoextend on next 100m;

--删除即创建用户

drop user FBUSI cascade;

create user FBUSI identified by FBUSI;

--授权

grant create view to FBUSI;

grant connect to FBUSI;

grant resource to FBUSI;

grant dba to FBUSI;

alter user FBUSI default tablespace FDATATBS

alter user FBUSI quota unlimited on FDATATBS

 

参考资料:

https://blog.csdn.net/pcmagic5328/article/details/80275625

通过命令创建oracle实例：https://blog.csdn.net/Trigl/article/details/53101888

数据库简单实例的创建过程：https://blog.csdn.net/lvshaorong/article/details/78048823