ODC version
ODC423
OB version
Oceanbase3248
OceanBase 3.2.4.8 (r1-5cffd929496eda6dde960d02ad21a56448395e23) (Built Jan 29 2024 20:15:38)
What happened?
Oracle creates an index without a library name. After exporting, it adds a library name.
What did you expect to happen?
After exporting, it adds without library name.
How can we reproduce it (as minimally and precisely as possible)?
create table TC_TCHECKIDRESULT ( VC_QUERY_NO VARCHAR2(200) not null, VC_TENANT_ID VARCHAR2(32) not null, VC_QUERY_DATE VARCHAR2(8) not null, VC_QUERY_TIME VARCHAR2(6) not null, C_CUST_TYPE CHAR(1) not null, VC_CUSTOM_NAME VARCHAR2(200) not null, C_IDENTITY_TYPE VARCHAR2(3) not null, VC_IDENTITY_NO VARCHAR2(255) not null, C_ID_MATCH_RESULT CHAR(1), C_SEX CHAR(1), VC_NATIONALITY VARCHAR2(3), VC_BIRTHDAY VARCHAR2(8), C_TRUST CHAR(1), C_ID_CHECK_TYPE CHAR(1) default 0, C_BANK_NO VARCHAR2(20), VC_BANK_ACCO VARCHAR2(40), VC_ID_CHECK_CHANNEL VARCHAR2(4), VC_OTHER_SERIAL_NO VARCHAR2(200), VC_ERR_CODE VARCHAR2(32), VC_ERR_MSG VARCHAR2(255), VC_BANK_ERR_MSG VARCHAR2(255), VC_FAIL_FALG CHAR(1) not null, VC_NATION VARCHAR2(255), VC_VALID_DATE VARCHAR2(8), VC_NET_NO VARCHAR2(22), VC_IDENTITY_VALID_BEGIN_DATE VARCHAR2(8), VC_IDENTITY_VALID_END_DATE VARCHAR2(8), L_FAIL_NUM NUMBER(2) default 0, VC_OLD_NAME VARCHAR2(200), VC_SERVCIE_SPACE VARCHAR2(200), VC_EDUCATION_LEVEL VARCHAR2(2), VC_MARRIAGE_STATUS VARCHAR2(8), VC_NATIVE_PLACE VARCHAR2(20), VC_BORN_ADDR VARCHAR2(200), VC_ADDRESS VARCHAR2(300), VC_REMARKS VARCHAR2(10), VC_DOUBT_FLAG VARCHAR2(2), VC_REG_ADDRESS VARCHAR2(256), VC_ORG_TYPE VARCHAR2(50), VC_BUSINESS_SCOPE VARCHAR2(256), VC_BUSIN_STATUS VARCHAR2(50), VC_CORPORATE_NAME VARCHAR2(100), VC_REGIST_CAPITAL_DESC VARCHAR2(20), VC_CHECK_REGULATION VARCHAR2(50), VC_SETUP_DATETIME VARCHAR2(20), VC_REGISTER_ORG VARCHAR2(256), VC_AREA_NAME VARCHAR2(50), VC_BUSINESS_BEGIN_DATETIME VARCHAR2(20), VC_BUSINESS_END_DATETIME VARCHAR2(20), VC_ECONOMIC_TYPE VARCHAR2(50), VC_LAST_UPDATE_DATETIME VARCHAR2(20), VC_BUSIN_LOCATION VARCHAR2(256), VC_INDUSTRY_DESC VARCHAR2(50), VC_SUPERIOR VARCHAR2(256), VC_BANK_PHONE VARCHAR2(50), VC_EMAIL VARCHAR2(50), VC_EMPLOYEES_NUM VARCHAR2(10), VC_URL VARCHAR2(50), VC_UNITE_CREDIT_CODE VARCHAR2(18), VC_PHOTO_PATH VARCHAR2(256), VC_CHECK_ID VARCHAR2(10), VC_RESPONSE_CONTENT CLOB, VC_BLACK_RANK_DESC VARCHAR2(100), C_ALLOW_OPEN_ACCO CHAR(1), constraint PK_TC_TCHECKIDRESULT primary key (VC_QUERY_NO) ); create index INDEX_TC_TCHECKIDRESULT on TC_TCHECKIDRESULT (VC_CUSTOM_NAME, VC_IDENTITY_NO, C_IDENTITY_TYPE, C_CUST_TYPE);
Anything else we need to know?
No response
Cloud
No response
ODC version
ODC423
OB version
Oceanbase3248
OceanBase 3.2.4.8 (r1-5cffd929496eda6dde960d02ad21a56448395e23) (Built Jan 29 2024 20:15:38)
What happened?
Oracle creates an index without a library name. After exporting, it adds a library name.
What did you expect to happen?
After exporting, it adds without library name.
How can we reproduce it (as minimally and precisely as possible)?
create table TC_TCHECKIDRESULT ( VC_QUERY_NO VARCHAR2(200) not null, VC_TENANT_ID VARCHAR2(32) not null, VC_QUERY_DATE VARCHAR2(8) not null, VC_QUERY_TIME VARCHAR2(6) not null, C_CUST_TYPE CHAR(1) not null, VC_CUSTOM_NAME VARCHAR2(200) not null, C_IDENTITY_TYPE VARCHAR2(3) not null, VC_IDENTITY_NO VARCHAR2(255) not null, C_ID_MATCH_RESULT CHAR(1), C_SEX CHAR(1), VC_NATIONALITY VARCHAR2(3), VC_BIRTHDAY VARCHAR2(8), C_TRUST CHAR(1), C_ID_CHECK_TYPE CHAR(1) default 0, C_BANK_NO VARCHAR2(20), VC_BANK_ACCO VARCHAR2(40), VC_ID_CHECK_CHANNEL VARCHAR2(4), VC_OTHER_SERIAL_NO VARCHAR2(200), VC_ERR_CODE VARCHAR2(32), VC_ERR_MSG VARCHAR2(255), VC_BANK_ERR_MSG VARCHAR2(255), VC_FAIL_FALG CHAR(1) not null, VC_NATION VARCHAR2(255), VC_VALID_DATE VARCHAR2(8), VC_NET_NO VARCHAR2(22), VC_IDENTITY_VALID_BEGIN_DATE VARCHAR2(8), VC_IDENTITY_VALID_END_DATE VARCHAR2(8), L_FAIL_NUM NUMBER(2) default 0, VC_OLD_NAME VARCHAR2(200), VC_SERVCIE_SPACE VARCHAR2(200), VC_EDUCATION_LEVEL VARCHAR2(2), VC_MARRIAGE_STATUS VARCHAR2(8), VC_NATIVE_PLACE VARCHAR2(20), VC_BORN_ADDR VARCHAR2(200), VC_ADDRESS VARCHAR2(300), VC_REMARKS VARCHAR2(10), VC_DOUBT_FLAG VARCHAR2(2), VC_REG_ADDRESS VARCHAR2(256), VC_ORG_TYPE VARCHAR2(50), VC_BUSINESS_SCOPE VARCHAR2(256), VC_BUSIN_STATUS VARCHAR2(50), VC_CORPORATE_NAME VARCHAR2(100), VC_REGIST_CAPITAL_DESC VARCHAR2(20), VC_CHECK_REGULATION VARCHAR2(50), VC_SETUP_DATETIME VARCHAR2(20), VC_REGISTER_ORG VARCHAR2(256), VC_AREA_NAME VARCHAR2(50), VC_BUSINESS_BEGIN_DATETIME VARCHAR2(20), VC_BUSINESS_END_DATETIME VARCHAR2(20), VC_ECONOMIC_TYPE VARCHAR2(50), VC_LAST_UPDATE_DATETIME VARCHAR2(20), VC_BUSIN_LOCATION VARCHAR2(256), VC_INDUSTRY_DESC VARCHAR2(50), VC_SUPERIOR VARCHAR2(256), VC_BANK_PHONE VARCHAR2(50), VC_EMAIL VARCHAR2(50), VC_EMPLOYEES_NUM VARCHAR2(10), VC_URL VARCHAR2(50), VC_UNITE_CREDIT_CODE VARCHAR2(18), VC_PHOTO_PATH VARCHAR2(256), VC_CHECK_ID VARCHAR2(10), VC_RESPONSE_CONTENT CLOB, VC_BLACK_RANK_DESC VARCHAR2(100), C_ALLOW_OPEN_ACCO CHAR(1), constraint PK_TC_TCHECKIDRESULT primary key (VC_QUERY_NO) ); create index INDEX_TC_TCHECKIDRESULT on TC_TCHECKIDRESULT (VC_CUSTOM_NAME, VC_IDENTITY_NO, C_IDENTITY_TYPE, C_CUST_TYPE);Anything else we need to know?
No response
Cloud
No response