![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
PrivateWolf
这个作者很懒,什么都没留下…
展开
-
oracle 新建空间 和 用户
create tablespace bap171 datafile 'c:\app\Administrator\oradata\orcl\bap171.dbf' size 100m autoextend on maxsize unlimited segment space management auto; create user bap171identified by "supcon"default tablespace bap171temporary tablespace TEMPprofil原创 2020-09-10 21:11:15 · 102 阅读 · 0 评论 -
正则表达式匹配ORACLE时间
被匹配字符TIMESTAMP '2020-08-19 18:05:11.130000'正则表达式TIMESTAMP '[0-9- :.]+'原创 2020-08-21 15:47:21 · 712 阅读 · 0 评论 -
windows热备份 oracle 数据库
1)新建backup.bat文件如下@echo offexp LW10/supcon@orcl file=C:\BACKUP\LW10_%date:~0,4%%date:~5,2%%date:~8,2%.dmp log=C:\BACKUP\LW10_%date:~0,4%%date:~5,2%%date:~8,2%.log@exit2)C盘新建BACKUP文件夹3)创建定时任务4)执行bat文件进行备份...原创 2020-06-30 10:30:38 · 246 阅读 · 1 评论 -
Oracle死锁
https://www.cnblogs.com/tianwyam/p/oracle_lock.html原创 2020-01-05 11:56:49 · 80 阅读 · 1 评论 -
oracle11g安装教程
1.安装 oracle客户端2.instantclient323.配plsql环境 windows环境路径原创 2020-01-06 20:10:21 · 88 阅读 · 0 评论 -
oracle expdp impdp备份/还原数据库
https://www.cnblogs.com/grisa/p/10450923.htmlses24/supcon@10.30.21.150/orclselect * from dba_directories;create or replace directory backup as ‘C:\oraclebf\PDMIS’;quitexpdp SES24/supcon@orcl directory=backup schemas=SES24 dumpfile=pdmis_20190228.dmp l原创 2020-06-24 16:49:43 · 303 阅读 · 0 评论 -
导出导入oracle数据,用dmp格式
导出oracle数据https://bbs.csdn.net/topics/390869255https://blog.csdn.net/gray_key/article/details/81072345sql plus连接数据库https://blog.csdn.net/czh500/article/details/89633382ORACLE_HOME=D:\oracle\ludun...原创 2020-01-05 12:17:29 · 100 阅读 · 0 评论 -
查询oracle历史数据
select count(1) from PLBD_MODULEFUNCTION AS OF TIMESTAMP to_timestamp(‘20200622 10:00:00’,‘yyyymmdd hh24:mi:ss’);原创 2020-06-22 15:04:48 · 1033 阅读 · 0 评论