-
编辑 删除
1.1 RMAN Recovery: RESTORE and RECOVER Commands
1.1 RMAN Recovery: RESTORE and RECOVER Commands在recovery操作 从备份中恢复全部或部分数据库的内容包含两个阶段：1. 从备份文件中查询数据文件的copy，从archivelog和onlineredolog中重新应用文件的改变，把数据库应用到指定SCN；2.  ...
-
编辑 删除
1 配置RMAN
1 配置RMANchecklistDescribe the RMAN repository and recovery catalog记录在控制文件中的备份信息，采用recovery catalog形式的实例，存放的也是备份信息Describe the...
-
编辑 删除
在雪豹10.6.6（Mac OS X）上安装Oracle10g
最近搞了个MACBOOK PRO的笔记本，准备做开发用，当然首要就是安装数据库啦，找了一下，ORACLE竟然也有FOR MAC的版本，因此就安装这个了，期间折腾了N遍，甚至连操作系统都重装了，最后终于搞定，写出来，大家分享一...
-
编辑 删除
删除重复数据
删除重复数据delete from mdsp_t_prodorderex where rowid not in (select min(rowid) from mdsp_t_prodorderex group by productorderkey);
-
编辑 删除
导入数据时遭遇ORA-39087错误
假设导入用户为sysdb数据文件存放目录为DATA_PUMP_DIR 查询：select * from dba_directories where DIRECTORY_NAME='DATA_PUMP_DIR';查看目录是否存在 select owner,table_name,grantor,privilege from d...
-
编辑 删除
Control the order of rows returned
01 SELECT 'Individual', 02 LAST_NAME || ', ' || FIRST_NAME 03 FROM CRUISE_CUSTOMERS 04 UNION 05&nb...
-
编辑 删除
12 Using the Set Operators
1. 4种操作符：union，union all，intersect，minus2. SELECT... UNION (SELECT... INTERSECT SELECT...) INTERSECT SELECT...Just be sure to use the parentheses so that:n The code enclosed is a standa...
-
编辑 删除
1212
Review the WORK_HISTORY table:Your task is to create a query that will list—for each ship—all of the EMPLOYEE_ID values for all the employees who have the shortest work history for their ship. In...
-
编辑 删除
1 Managing Schema Objects
1 Managing Schema Objects1.1 Add and Modify Columns1.11 &nb...
-
编辑 删除
solve Problems with Correlated subqueries
SELECT A.SHIP_CABIN_ID, A.ROOM_STYLE, A.ROOM_NUMBER, A.SQ_FT FROM SHIP_CABINS A WHERE A.SQ_FT > (SELECT AVG(SQ_FT) FROM SHIP_CABINS W...
