oracle安装选择高级安装,除需手动配置SID外其他均可选默认
sql developer 的启动错误可以通过更新Oracle11g_home1\db_1\jdbc\lib下的那四个文件的方式解决;
sql developer安装第三方数据库驱动时先把jar包放在extention下再entry
show user;
alter user scott account unlock; --给scott解锁
desc tablename; --显示表结构
--创建新用户
1-- backup scott
exp
2-- create user
create user shijin(username) identified by shijin(password) default tablespace users qutoa(配额) 10M on users
3-- grant
grant create session,create table,create view to shijin
4-- import the data
imp(先输shijin,再输scott)
--数据字典表 user_tables
desc user_tables;
select table_name from user_tables;
select view_name from user_views;
select constraint_name from user_constraints;
select index_name from user_indexes;
<