Skip to main content

Search

Welcome to Tibero GTS!

Column Comment Error When Using tbexport REMAP_TABLE Option

Document Type | Troubleshooting 

Category | Utility

Applicable Product Versions | 6FS07, 7FS02PS, 6FS07, 7FS02PS

Error Code | 7071

Document Number | TUTTS003

 

Issue

When performing tbexport using the REMAP_TABLE option, a column comment error occurs. 
Below is an example of remapping the TEST table to TEST_B.
 
Test Table

SQL> create table test(a number, b varchar(20));

SQL> comment on table test is 'Test';

SQL> comment on column test.a is 'Number';

$ tbexport username=sys password=xxxxx ip=localhost port=8629 sid=tibero table=tibero.test REMAP_TABLE=TEST:TEST_B file=TEST.dmp log=TEST.log script=y 

## Partial tbexport.log

 COMMENT ON TABLE "TEST_B" IS 'Test'
/
COMMENT ON COLUMN TEST."A" IS 'Number'

 

Cause

An error occurs because the table name in the "comment on column" statement is not changed.

 

Solutions

A patch has been applied that modifies the logic so that column comments also apply the remap table.
(Applied Patch: FS07_339042a)
Caution
The patch is applied through technical support provided by TmaxTibero.
 
 
 

Related to