![](https://img-blog.csdnimg.cn/20201014180756754.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
文章平均质量分 77
LiKarmenIcloud
这个作者很懒,什么都没留下…
展开
-
oracle导出导入dmp
1.切换到oracle用户,su - oracle 2.输入导出命令,接着是下面的操作(下面已导出民办教育数据库为例):exp mbedu/mbedu@orcl [oracle@qtone3 ~]$ exp mbedu/mbedu@orcl Export: Release 10.2.0.4.0 - Production on Mon Nov 18 08:33:19 2013Co原创 2013-12-03 15:08:22 · 873 阅读 · 0 评论 -
oracle 删除已存在进程
开一个sqlplus conn aa/aa在开一个sqlplus conn sys/liang as sysdbaSQL> drop user aa;drop user aa*ERROR at line 1:ORA-01940: cannot drop a user that is currently connectedSQL> select sid,ser转载 2013-12-20 10:44:57 · 980 阅读 · 0 评论 -
查询不小心被误修改的数据
select * from qt_msg_default as of scn TIMESTAMP_TO_SCN(TO_TIMESTAMP('2014-04-04 15:00:00', 'yyyy-mm-dd HH24:mi:ss')) where msg_id = 21611 ;原创 2014-04-04 18:59:55 · 835 阅读 · 0 评论