配置连接远程数据库
ORCL125 =
? (DESCRIPTION =
??? (ADDRESS_LIST =
????? (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.125)(PORT = 1521))
??? )
??? (CONNECT_DATA =
????? (SERVICE_NAME = orcl)
??? )
? )

2查询序列
select seqname.currval from dual?? 查询序列当前值
select seqname.nextval from dual?? 查询序列下一值

3
ORA----00947-----没有足够的值
如果你插入语句，选择了四列，而你的值小于4列，就是......


4 关键字
select * from v$reserved_words;

5Oracle中 查询一个表有多少列
select count(column_name) from user_tab_columns where table_name=upper('表名');


5 Oracle 删除一个用户

drop user username cascade;



6 切换账户

su oracle : 只切换用户，而不切换环境；就是说切到oracle用户后，使用的依旧是root的环境。
su - oracle ：同时切换用户和环境



su?? oracle：不会执行oracle主目录中的profile脚本??
su?? -oracle：会执行oracle主目录中的profile脚本?



7? Oracle 查找有哪些用户表

select * from user_tables


8 Oracle 建用户操作

1 建立表空间
create tablespace test2
datafile 'c:\test2.dbf' size 50m
default storage(
? initial 500k
? next 500k
? minextents 1
? maxextents unlimited
? pctincrease 0
);

2 创建用户
create user pige identified by pige default tablespace test1;

create user cs identified by jabsco default tablespace test1;

create user upgrade identified by abc default tablespace test2;

3 授权
grant resource,connect,dba to pige;

grant resource,connect,dba to cs;

grant resource,connect,dba to upgrade;

4 导入文件
imp pige/pige@orcl full=y file=D:\File\Myeclipse\OperationPlatform\database\cs20120222.dmp
ignore=y

imp cs/jabsco@orcl126 full=y file=E:\文档\OperateForm.dmp
ignore=y

5?
exp pige/pige@orcl file=d:\pipi.dmp full=y

如何查看有哪些用户的命令? 授权命令

exp pige/pige@orcl file=d:\pipi1.dmp owner=(pige)

select grantee,privilege from dba_sys_privs where grantee='RESOURCE' OR GRANTEE