oracle常用命令

查看版本
（1）用客户端连接到数据库，执行select * from v$instance
（2）select * from product_component_version

添加用户和表空间
create tablespace jira datafile '/home/oracle/oracle/product/10.2.0/jiradata/jiradata.dbf' size 4G autoextend on next 8M maxsize unlimited;
create user jirauser identified by jirauser default tablespace jira;
grant connect,resource to jirauser;
commit;