按类别查询搜索结果
关于关键词 的检测结果,共 11225
xuekai20080901 | 2020-03-19 20:41:31 | 阅读(10250) | 评论(0)
一、更换环境操作系统:AIX数据库:10.2.0.4数据文件存储方式:ASM二、前期准备1、图形界面工具:Xmanager 42、确认新存储正常挂载映射,新存储lun划分规则需和当前使用存储一致(ocr、votingdisk所在盘,其他盘可以不一致),被his两台服务器识别。3、提前格式化一块大盘,做成文件系统,挂载到一个服务器节点,用...【阅读全文】
brjl | 2020-03-01 13:42:26 | 阅读(1880) | 评论(0)
oracle 创建数据库 多租户 脚本【阅读全文】
brjl | 2020-02-12 14:21:02 | 阅读(1750) | 评论(0)
oracle rac 集群名字【阅读全文】
新的旅程 | 2020-02-11 21:38:47 | 阅读(10870) | 评论(0)
一、更换环境操作系统:AIX数据库:10.2.0.4数据文件存储方式:ASM二、前期准备1、图形界面工具:Xmanager 42、确认新存储正常挂载映射,新存储lun划分规则需和当前使用存储一致(ocr、votingdisk所在盘,其他盘可以不一致),被his两台服务器识别。3、提前格式化一块大盘,做成文件系统,挂载到一个服务器节点,用...【阅读全文】
brjl | 2020-02-09 20:16:47 | 阅读(3490) | 评论(0)
ORACLE 19c ADG Switchover 切换【阅读全文】
brjl | 2020-01-24 08:48:00 | 阅读(7110) | 评论(0)
ASMCMD [+datadg/orcl/parameterfile] > pwd+datadg/orcl/parameterfileASMCMD [+datadg/orcl/parameterfile] > lsspfile.268.1030523449spfile_newASMCMD [+datadg/orcl/parameterfile] > lsspfile.268.1030523449spfile_newASMCMD [+datadg/orcl/parameterfile] > rm spfile.268.1030523449AS...【阅读全文】
brjl | 2020-01-22 14:11:31 | 阅读(1540) | 评论(0)
MOS oracle 补丁下载 地址 support【阅读全文】
hxl | 2019-12-06 17:53:17 | 阅读(6370) | 评论(0)
环境:OS: Centos 7DB:12.2.0.1 数据库必须在归档模式1.创建表空间12c pdb下创建表空间create tablespace tps_dataloggingdatafile '/u01/app/oracle/oradata/ora12c/ora12cpdb1/tps_data01.dbf'size 100mautoextend onnext 10m maxsize 24Gextent management local;表空间添加数据文...【阅读全文】
unix_5359 | 2019-11-14 13:26:48 | 阅读(1320) | 评论(0)
Which two statements are true about the DUAL table?B) It can be accessed only by the SYS user.D) It can display multiple rows but only a single column.F) It can be used to display only constants or pseudo columns.(解析:dual 这个虚拟的表可以显示多行多列;任何用户都可以访问它。这道题...【阅读全文】
unix_5359 | 2019-11-06 10:08:36 | 阅读(750) | 评论(0)
Which three statements are true about GLOBAL TEMPORARY TABLES?B) A GLOBAL TEMPORARY TABLE can have multiple indexesD) Data Manipulation Language (DML) on GLOBAL TEMPORARY TABLES generates no REDO.F) A tigger can be created on a GLOBAL TEMPORARY TABLE(解析:全局临时表跟普通表一样,...【阅读全文】
unix_5359 | 2019-11-04 10:49:06 | 阅读(680) | 评论(0)
Which two statements are true about transactions in the Oracle Database serve?B) Data Manipulation Language (DML) statements always start a new transaction.D) A Data Detiniton Language (DDL) statement does a commit automatially only for the data dictionary updates caused by the DDLF) I...【阅读全文】
unix_5359 | 2019-11-04 10:18:09 | 阅读(860) | 评论(0)
In the PROMOTIONS table, the PROMO_BEGTN_DATE columm is of datatype DATE and the default date format is DD-MON-RR.A) TO_NUMBER(PROMO_ BEGIN_DATE) - 5 will return numberC) PROMO_BEGIN_DATE - SYSDATE will return a number.E) PROMO_BEGIN_DATE - SYSDATE will return an error.(解析:这道...【阅读全文】
unix_5359 | 2019-10-25 14:59:53 | 阅读(900) | 评论(0)
Examine this partial command:cust_id NUMBER(2),)Which two clauses are required for this command to execute successfully?B) the REJECT LIMIT clauseD) the ACCESS PARAMETERS clauseAnswer:AD【阅读全文】
unix_5359 | 2019-10-25 14:13:42 | 阅读(770) | 评论(0)
Examine the description of the PRODUCTS table:-----------------------------------------------------------------PRODUCT_NANE                     VARCHAR2(10)PURCHARGE                  &nb...【阅读全文】
unix_5359 | 2019-10-21 11:39:52 | 阅读(850) | 评论(0)
Which three statements are true about dropping and unused columns in an Oracle database?B) A DROP COLUMN command can be rolled backD) An UNUSED column's space is redaimed automatially when the row containing that column is next queried.F) A column that is set to NNUSED still counts tow...【阅读全文】
unix_5359 | 2019-10-21 10:25:04 | 阅读(650) | 评论(0)
Which two statements are true about a self join?B) It can be a left outer join.D) It can be an inner join.Answer:BD不过在进行内连接时为了区别表的名字,需要加别名from emp2 won w.mgr=m.empno;)【阅读全文】
unix_5359 | 2019-10-18 14:51:08 | 阅读(1050) | 评论(0)
Which two statements are true about Oracle synonyms?B) All private synonym names must be unique in the database.D) A synonym can be created on an object in a package.(解析:同义词也是 Oracle 的一个对象;【阅读全文】
unix_5359 | 2019-10-18 09:36:29 | 阅读(660) | 评论(0)
Which three statements are true about views in an Orade batabase?B) Rows inserted into a table using a view are retained in the table if the view is doppedD) Views have no segment.F) A view can be created that refers to a non-existent table in its defining query.(解析:...【阅读全文】