ct to gjds; Command> grant create table to gjds; Command> grant create view to gjds; Command> grant admin to gjds; #用户创建完之后使用connect切换用户 Command> connect "DSN=cachedb_gjds;uid=gjds;pwd=gjds" > ; Connection successful: DSN=cachedb_gjds;UID=gjds;DataStore=/opt/oracle/TimesTen/ttdattionCharacterSet=ZHS16GBK;DRIVER=/opt/oracle/TimesTen/tt1122/lib/libtten.so;PermSize= (Default setting AutoCommit=1) con1: Command>
3、创建表
Command> CREATE TABLE "TEST"."TIMESTEN_SYNC_TEST" ( > "ID" varchar2(10 byte) NOT NULL, > "NAME" varchar2(50 byte), > "AGE" number > ); #创建表的语法跟Oracle是一模一样的，Timesten的语法几乎与Oracle一致 Command> tables TEST.TIMESTEN_SYNC_TEST 1 table found. #使用tables可以查看数据库中所有的表信息 Command>INSERT INTO TIMESTEN_SYNC_TEST VALUES('1','1',20);
其他语法与Oracle一致，在此不再赘述。
配置Oracle客户端
Timesten已经安装Oracle客户端，可以不用重复安装，安装目录TIMESTEN_HOME/ttoracle_home/instantclient_11_2
默认的没有TNS_ADMIN环境变量，需要手动添加
[timesten@bogon support]$vi ~/.bash_profile #添加 export TNS_ADMIN=/opt/oracle/TimesTen/tt1122/ttoracle_home/instantclient_11_2/network/admin
将tnsnames.ora复制到TNS_ADMIN目录
添加如下内容
ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.57.62)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )
创建一个与Oracle关联的用户
语法同创建用户的语法，用户名要与Oracle数据库的用户名一致。
使用下面的方式登录用户
[timesten@bogon info]$ ttisql "DSN=cachedb_gjds;uid=test;pwd=test;OraclePwd=test" Copyright (c) 1996, 2015, Oracle and/or its affiliates. All rights reserved. Type ? or "help" for help, type "exit" to quit ttIsql. connect "DSN=cachedb_gjds;uid=test;pwd=********;OraclePwd=********"; Connection successful: DSN=cachedb_gjds;UID=test;DataStore=/opt/oracle/TimesTen/ttdata/gjds/cachedb_gjds;DatabaseCharacterSet=ZHS16GBK;ConnectionCharacterSet=ZHS16GBK;DRIVER=/opt/oracle/TimesTen/tt1122/lib/libtten.so;PermSize=40;TempSize=32;TypeMode=0;OracleNetServiceName=ORCL; (Default setting AutoCommit=1) Command>
这样登录就与Oracle用户建立了连接
使用工具创建表并导入Oracle数据
#ttTableSchemaFromOraQueryGet(['tblOwner'], 'tblName', 'Query') #只能生成建表语句，不能创建表，需要手动执行下建表语句 Command> call ttTableSchemaFromOraQueryGet('TEST','TIMESTEN_SYNC_TEST','SELECT * FROM TEST.TIMESTEN_SYNC_TEST'); < CREATE TABLE "TEST"."TIMESTEN_SYNC_TEST" ( "ID" varchar2(10 byte) NOT NULL, "NAME" varchar2(50 byte), "AGE" number ) > 1 row found. #ttLoadFromOracle(['tblOwner'], 'tblName', 'Query' [,numThreads]) #从Oracle数据库将表的数据导入 Command> CALL ttLoadFromOracle ('TEST','TIMESTEN_SYNC_TEST','SELECT * FROM TEST.TIMESTEN_SYNC_TEST'); < 1 > 1 row found. Command> select * from TIMESTEN_SYNC_TEST; < 1, 2, 18 > 1 row found. Command> tables TEST.TIMESTEN_SYNC_TEST 1 table found.