易截截图软件、单文件、免安装、纯绿色、仅160KB

ORACLE数据导入到指定的表空间

create user 用户名 identified by 密码 default tablespace 缺省表空间 Temporary tablespace 临时表空间;­
­
grant connect,resource,dba to 用户名;­
  ­
revoke unlimited tablespace from 用户名;­
  ­
alter user 用户名 quota 0 on Users;­
­
alter user 用户名 quota unlimited on 用户缺省表空间;­
­
--关键是后面3行命令,必须执行。­
­
--接着使用IMP工具导入数据即可导入到用户缺省表空间. ­
 
--EXAMPLE:    USER NAME: GROUPCMS;     tablespace:GROUPCMS
--DROP USER GROUPCMS CASCADE;
create user GROUPCMS identified by ABC123 default tablespace GROUPCMS  ;
grant connect,resource,dba to GROUPCMS;
revoke unlimited tablespace from GROUPCMS;
alter user GROUPCMS quota 0 on Users;
alter user GROUPCMS quota unlimited on GROUPCMS;


相关文档:

oracle发送邮件存储过程:

oracle发送邮件存储过程:
create or replace procedure bsd_sendemail(
p_receiver varchar2,
p_sub varchar2,
p_txt varchar2)
is
p_user varchar2(30):='';
p_pass varchar2(30):='';
p_sendor varchar2(20):='Gnie';
p_server varchar2(20):='Mail_Server_IP';
p_port number:=25;
p_need_smtp number:=0;
p ......

oracle插入时如何插入uuId

 是想生成GUID吗?
SQL> select   sys_guid() from dual ;
SYS_GUID()
--------------------------------
F18031C69D8345DEB305D4B2E796A282
你可以把表的主键字段的缺省值设为sys_guid()
insert into luxian_info (id) values(sys_guid()); ......

Oracle 常用sqlplus命令

 
一、ORACLE的启动和关闭
1、在单机环境下要想启动或关闭ORACLE系统必须首先切换到ORACLE用户,如下
su - oracle
a、启动ORACLE系统
oracle>svrmgrl
SVRMGR>connect internal
SVRMGR>startup
SVRMGR>quit
b、关闭ORACLE系统
oracle>svrmgrl
SVRMGR>connect internal
SVRMGR>shutdow ......

SQL Server和Oracle常用函数对比


数学函数
1.绝对值
S:select abs(-1) value
O:select abs(-1) value from dual
2.取整(大)
S:select ceiling(-1.001) value
O:select ceil(-1.001) value from dual
3.取整(小)
S:select floor(-1.001) value
O:select floor(-1.001) value from dual
4.取整(截取)
S:select cast(-1.002 as in ......

oracle RAC 底层进程介绍

 1.GSD global services daemon 
oracle官方文档的描述 
The Global Services Daemon (GSD) runs on each node with one GSD process per node. The GSD coordinates with the cluster manager to receive requests from clients such as the DBCA, EM, and the SRVCTL utility to execute administrative ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号