启动数据库的步骤

2019独角兽企业重金招聘Python工程师标准>>>

1.登陆到 oracle

su - oracle

2.启动 监听

$ lsnrctl start

3. 启动数据库

$ sqlplus /nolog

sql>conn / as sysdba

sql>startup

4.解锁hr用户

sql> alter user hr identified by hr account unlock;

5.登陆到 hr用户

sql>conn hr/hr

6.查看有哪些表

sql>select table_name from user_tables;

7.查看表结构

sql> desc departments

8.看具体内容

sql>select * from departments;

转载于:https://my.oschina.net/u/3635497/blog/3038277