Use DBCAT to migrate schemas from OceanBase Database to an Oracle database

$sudo yum -y install java-1.8.0-openjdk.x86_64

$which java
/usr/local/java/jdk1.8.0_261/bin/java

echo 'export JAVA_HOME=/usr/local/java/jdk1.8.0_261/' >> ~/.bash_profile
. ~/.bash_profile

tar zxvf dbcat-1.8.0-SNAPSHOT.tar.gz
cd dbcat-1.8.0-SNAPSHOT/
chmod +x bin/dbcat

$tree -L 3 --filelimit 30
.
├── bin
│   ├── dbcat
│   ├── dbcat.bat
│   └── dbcat-debug
├── conf
│   ├── dbcat.properties
│   └── logback.xml
├── docs
│   ├── README.docx
│   ├── README.md
│   └── README.txt
├── LEGAL.md
├── lib [45 entries exceeds filelimit, not opening dir]
├── LICENSE
├── meta
│   └── README
└── NOTICE

5 directories, 12 files

bin/dbcat convert -H<host> -P<port> -u<user> -p<******>  -D <database> --from <from> --to <to> --table '*' 

bin/dbcat convert -H 172.30.xxx.xxx  -P 2883 -uroot -pxxxxx -D test --from oboracle40 --to oracle12c --table '*' 

$tree ~/output/dbcat-20xx-xx-xx-164533/
/home/qing.meiq/output/dbcat-20xx-xx-xx-164533/
├── tpccdb
│   └── TABLE-schema.sql
└── tpccdb-conversion.html

1 directory, 2 files

SQL> @TABLE-schema.sql
Query OK, 0 rows affected (0.044 sec)

obclient [SYS]> desc bmsql_customer;
+----------------+---------------+------+-----+---------+-------+
| FIELD          | TYPE          | NULL | KEY | DEFAULT | EXTRA |
+----------------+---------------+------+-----+---------+-------+
| C_W_ID         | NUMBER(38)    | NO   | PRI | NULL    | NULL  |
| C_D_ID         | NUMBER(38)    | NO   | PRI | NULL    | NULL  |
| C_ID           | NUMBER(38)    | NO   | PRI | NULL    | NULL  |
| C_DISCOUNT     | NUMBER(4,4)   | YES  | NULL | NULL    | NULL  |
| C_CREDIT       | CHAR(2)       | YES  | NULL | NULL    | NULL  |
| C_LAST         | VARCHAR2(16)  | YES  | NULL | NULL    | NULL  |
| C_FIRST        | VARCHAR2(16)  | YES  | NULL | NULL    | NULL  |
| C_CREDIT_LIM   | NUMBER(12,2)  | YES  | NULL | NULL    | NULL  |
| C_BALANCE      | NUMBER(12,2)  | YES  | NULL | NULL    | NULL  |
| C_YTD_PAYMENT  | NUMBER(12,2)  | YES  | NULL | NULL    | NULL  |
| C_PAYMENT_CNT  | NUMBER(38)    | YES  | NULL | NULL    | NULL  |
| C_DELIVERY_CNT | NUMBER(38)    | YES  | NULL | NULL    | NULL  |
| C_STREET_1     | VARCHAR2(20)  | YES  | NULL | NULL    | NULL  |
| C_STREET_2     | VARCHAR2(20)  | YES  | NULL | NULL    | NULL  |
| C_CITY         | VARCHAR2(20)  | YES  | NULL | NULL    | NULL  |
| C_STATE        | CHAR(2)       | YES  | NULL | NULL    | NULL  |
| C_ZIP          | CHAR(9)       | YES  | NULL | NULL    | NULL  |
| C_PHONE        | CHAR(16)      | YES  | NULL | NULL    | NULL  |
| C_SINCE        | TIMESTAMP(6)  | YES  | NULL | sysdate | NULL  |
| C_MIDDLE       | CHAR(2)       | YES  | NULL | NULL    | NULL  |
| C_DATA         | VARCHAR2(500) | YES  | NULL | NULL    | NULL  |
+----------------+---------------+------+-----+---------+-------+
21 rows in set (0.002 sec)

SQL> desc bmsql_customer;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 C_W_ID                                    NOT NULL NUMBER(38)
 C_D_ID                                    NOT NULL NUMBER(38)
 C_ID                                      NOT NULL NUMBER(38)
 C_DISCOUNT                                         NUMBER(4,4)
 C_CREDIT                                           CHAR(2)
 C_LAST                                             VARCHAR2(16)
 C_FIRST                                            VARCHAR2(16)
 C_CREDIT_LIM                                       NUMBER(12,2)
 C_BALANCE                                          NUMBER(12,2)
 C_YTD_PAYMENT                                      NUMBER(12,2)
 C_PAYMENT_CNT                                      NUMBER(38)
 C_DELIVERY_CNT                                     NUMBER(38)
 C_STREET_1                                         VARCHAR2(20)
 C_STREET_2                                         VARCHAR2(20)
 C_CITY                                             VARCHAR2(20)
 C_STATE                                            CHAR(2)
 C_ZIP                                              CHAR(9)
 C_PHONE                                            CHAR(16)
 C_SINCE                                            TIMESTAMP(6)
 C_MIDDLE                                           CHAR(2)
 C_DATA                                             VARCHAR2(500)