Oracle
zhangningboo
这个作者很懒,什么都没留下…
展开
-
PL/SQL下载、安装、监听配置
1、官网下载PL/SQLhttps://www.allroundautomations.com/try-it-free/如何突破free,自己google/baidu,不做说明;汉化,推荐google/baidu,不做说明2、下载监听文件https://www.oracle.com/technetwork/topics/winsoft-085727.html下载最新的吧,注...原创 2019-11-21 16:30:53 · 1386 阅读 · 0 评论 -
oracle round、trunc、floor、ceil函数
复习下这几个函数吧select round(1.3456) from dual; -- 1select round(1.3456, 1) from dual; -- 1.3select round(1.3456, 2) from dual; -- 1.35select trunc(1.3456) from dual; -- 1.3select trunc(1.3456, 1) fro...原创 2019-11-06 08:37:58 · 120 阅读 · 0 评论 -
Oracle数据泵导入与导出
导出-- 1、创建需要备份到的路径并赋权 sqlplus命令行执行CREATE OR REPLACE DIRECTORY backup_path_name AS '/home/oracle/backup';GRANT READ,WRITE ON DIRECTORY backup_path_name TO yourUserName;-- 2、给用户赋导出的权限 sqlplus...原创 2019-03-23 19:06:32 · 769 阅读 · 0 评论 -
impdp失败:ORA-31694: master table "XXX"."XXXX" failed to load/unload
若impdp导入失败,报错如下:[oracle@linux ~]$ impdp userName/'password'@IP:PORT/Instance_ID directory=yourSetImportPathVariableName dumpfile=yourDmpFile.dmp logfile=yourLogName.log remap_schema=originalUserNam...原创 2019-06-12 18:38:43 · 6256 阅读 · 0 评论