(0/1/2):0input elog path:/tmp/elog only create huge table with delta? (0/1):1rlog generateforhuge? (0/1):0pseg_mgr_flag (0/1):0auto_overwrite mode? (0/1/2):0CHARACTER typefixedstorage ? ([Y]es/1, [N]o/0): n SQL log forbid? ([Y]es/1, [N]o/0): n Normal of ...
dexp USERID=<用户>/<密码>@<IP>:<port> FILE=<文件名> LOG=<执行日志文件名> TABLES=<table1,table2> DIRECTORY=<备份文件所在路径> #导入 dimp USERID=<用户>/<密码>@<IP>:<port> FILE=<备份文件绝对路径> LOG=<执行日志文件名> TABLES=<table1,table2> DIRECTORY=<执行日志存放的路径> IGNORE=...
REGION_MODE system tablespace datafile region policyinddfs(default0)0: MICRO1: GREAT HUGE_WITH_DELTA Only support to create with delta huge table(default1)1: YES0: NO RLOG_GEN_FOR_HUGE whether to generate redo logforwith delta huge table(default0)1: YES0: NO PSEG_MGR_FLAG Only use ma...
input elog path: //日志路径 only create huge table with delta? (0/1): 0 rlog generate for huge? (0/1): 0 pseg_mgr_flag (0/1): 0 auto_overwrite mode? (0/1/2): 0 ——— //等待提示成功 create dm database success. 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13....
<STORAGE 子句>中,WITH DELTA 表示创建事务型 HUGE 表;WITHOUT DELTA 表示创建非事务型 HUGE 表,缺省为 WITH DELTA。若创建数据库时使用参数HUGE_WITH_DELTA的缺省值1,则不支持创建非事务型 HUGE 表。 HUGE_WITH_DELTA这个参数应该只能建库时指定,可能无法修改。
CREATE HUGE TABLE [IF NOT EXISTS] <表名定义> <表结构定义>[<PARTITION子句>] [<表空间子句>] [<STORAGE子句1>][<压缩子句>] [<日志属性>][<DISTRIBUTE子句>]; <表名定义> ::= [<模式名>.] <表名> <表结构定义> ::=<表结构定义1> | <表结构定义2> <表结构定义1> ::= (<列定义> {...
only create huge table with delta? (0/1): 1 rlog generate for huge? (0/1): 0 auto_overwrite mode? (0/1/2): 0 ## 注册服务及启动 chmod -R 777 dmtest cd /home/dmdba/dmdbms/script/root ./dm_service_installer.sh -t dmserver -dm_ini /home/dmdba/dmdatas/dmtest/dm.ini -p...
HUGE table space name htsname=HMAIN # HUGE table space id htsid=128 #HUGE table space share flag htsflag=0 # HUGE table space copy num hts_copy_num=0 # HUGE table space region size flag hts_size_flag=0 # HUGE table space create time hts_create_time=DATETIME '2021-5-26 2:6:28...
(0/1/2): 0 input elog path: /home/dm/data/logs only create huge table with delta? (0/1): 1 rlog generate for huge? (0/1): 0 pseg_mgr_flag (0/1): 0 auto_overwrite mode? (0/1/2): 0 log file path: /home/dm/data/test/test01.log log file path: /home/dm/data/test...
only create huge table with delta? (0/1): 1 rlog generate for huge? (0/1): 0 pseg_mgr_flag (0/1): 0 auto_overwrite mode? (0/1/2): 0 CHARACTER type fixed storage ? ([Y]es/1, [N]o/0): 0 SQL log forbid ? ([Y]es/1, [N]o/0): 0 ...