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;
网友评论