Category - 数据库

2016-05-10 01:45:24    275    0    0

1、首先打开dbca


================================================================================

=================================================================================
=====
2016-05-10 01:36:43    211    0    0
建立表: ``` SQL> l 1 create table range_list_part_tab (id number,deal_date date,area_code number,nbr number,contents varchar2(4000)) 2 partition by range (deal_date) 3 subpartition by list (a
2016-05-10 00:55:53    196    0    0
1、OS: ``` [root@anderson oracle]# lsb_release -a LSB Version: :base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4
2016-05-10 00:47:00    365    0    0
1、Execute shutdown immediate in Far sync: ``` [oracle@dg v01]$ sqlplus sys/oracle@fs3 as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Mon Aug 17 18:48:51 2015 Copyright (c) 1982, 2014, Oracle.
2016-05-10 00:45:30    271    0    0
1、Execute shutdown abort: ``` [oracle@dg v01]$ sqlplus sys/oracle@fs3 as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Mon Aug 17 18:37:59 2015 Copyright (c) 1982, 2014, Oracle. All rights res
2016-05-10 00:42:46    248    0    0
一、实验前: ``` DGMGRL> show configuration Configuration - dbconfig Protection Mode: MaxAvailability Members: v01p - Primary database fs3 - Far sync instance v01ls - (*) Physical st
2016-05-10 00:39:57    208    0    0
是否回表的性能对比: 配置实验参数: ``` SQL> drop table t purge; Table dropped. SQL> create table t as select * from dba_objects; Table created. SQL> create index idx1_object_id on t(object_id); Index created. SQL> s
2016-05-10 00:38:46    208    0    0
colocated表根据x列有一定的物理顺序 ``` SQL> create table colocated ( x int, y varchar2(80) ); Table created. SQL> begin for i in 1 .. 100000 loop insert into colocated(x,y) values (i, rpa
2016-05-10 00:37:22    188    0    0
--分区交换 --操作会导致全局索引失效(要考虑including indexes 或者重建索引),具体见索引章节 --分区表的exchange ``` SQL> l 1 create table part_tab_exch (id int,col2 int,col3 int,contents varchar2(4000)) 2 partition by range (id
2016-05-10 00:36:32    200    0    0
创建表: ``` SQL> l 1 create table part_tab_add (id int,col2 int,col3 int,contents varchar2(4000)) 2 partition by range (id) 3 ( 4 partition p1 values less than (10000), 5
1/2