巴啦啦大魔王

2017年11月10日

摘要：用Informatica跑ETL时，出现ora-26002错误。使用BULK时会报这个错误，因为是大批量insert插入所以很多normal insert时该完成的任务没完成，例如表上有索引时。而且BULK不支持update。总结出现这个错误可以把load type改成normal 阅读全文

posted @ 2017-11-10 11:40 巴啦啦大魔王阅读(459) 评论(0) 推荐(0) 编辑

053-305

摘要： Which command do you use to create a recovery-catalog schema?A. create recovery catalogB. create catalogC. build catalogD. catalog createE. mount cata 阅读全文

posted @ 2017-11-10 10:16 巴啦啦大魔王阅读(92) 评论(0) 推荐(0) 编辑

2017年11月9日

053-304

摘要： What privileges must be granted to allow an account to create the recovery catalog? (Choose all thatapply.)A. RECOVERY_CATALOG_OWNERB. DBAC. RESOURCED 阅读全文

posted @ 2017-11-09 18:28 巴啦啦大魔王阅读(89) 评论(0) 推荐(0) 编辑

053-303

摘要： What is the purpose of the RMAN recovery catalog? (Choose all that apply.)A. It must be used because all RMAN-related backup and recovery metadata inf 阅读全文

posted @ 2017-11-09 18:24 巴啦啦大魔王阅读(79) 评论(0) 推荐(0) 编辑

053-302

摘要： You issue the following command:RMAN>CONFIGURE BACKUP OPTIMIZATION ON;What is the result of this command on your backups?A. An incremental backup stra 阅读全文

posted @ 2017-11-09 18:16 巴啦啦大魔王阅读(97) 评论(0) 推荐(0) 编辑

053-301

摘要： Which command is used to configure RMAN to perform a compressed backup for every backupexecuted?A. BACKUP AS COMPRESSED BACKUPSET DATABASEB. BACKUP AS 阅读全文

posted @ 2017-11-09 18:12 巴啦啦大魔王阅读(89) 评论(0) 推荐(0) 编辑

053-600

摘要： Which of the following statements are true about the BACKUP command? (Choose all that apply.)A. The BACKUP command can not be used to make image copie 阅读全文

posted @ 2017-11-09 18:06 巴啦啦大魔王阅读(80) 评论(0) 推荐(0) 编辑

053-599

摘要： Given the following steps, which would be the correct order to create a backup of an Oracle database in ARCHIVELOG mode with control-file autobackups 阅读全文

posted @ 2017-11-09 18:04 巴啦啦大魔王阅读(85) 评论(0) 推荐(0) 编辑

053-598

摘要： The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter should be set to what value?(Choose all that apply.)A. The initialization parameter should 阅读全文

posted @ 2017-11-09 17:59 巴啦啦大魔王阅读(108) 评论(0) 推荐(0) 编辑

053-597

摘要： What command would you use to set a persistent setting in RMAN so that backups are all written to a tape device?A. CONFIGURE DEFAULT DEVICE TYPE TO TA 阅读全文

posted @ 2017-11-09 17:55 巴啦啦大魔王阅读(84) 评论(0) 推荐(0) 编辑

公告