oracle 常见操作

Oracle数据库登录

# 乱码的话设置
set nls_lang=AMERICAN_AMERICA.ZHS16GBK

sqlplus “/as sysdba”

# Oracle表空间创建
create tablespace lewen datafile ‘/data/oracle/oradata/orcl/‘ size 10m;

# Oracle用户创建
create user lewen identified by lewen default tablespace lewen;
grant dba to lewen;

#然后就可以吧用户名和密码给开发人员了

# Oracle表创建
conn lewen/lewen;
create table lewen1(id number(12) primary key, name varchar(20)) ;
# Oracle数据插入
insert into lewen1 values(1,‘lewen01‘);
insert into lewen1 values(2,‘lewen02‘);
commit;


# Oracle数据查询
select * from lewen1;


日志路径
select * from v$diag_info;

SQL> SELECT name from v$datafile;

NAME
--------------------------------------------------------------------------------
/data/oracle/oradata/orcl/system01.dbf
/data/oracle/oradata/orcl/sysaux01.dbf
/data/oracle/oradata/orcl/undotbs01.dbf
/data/oracle/oradata/orcl/users01.dbf