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.
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)
(Applied Patch: FS07_339042a)
CautionThe patch is applied through technical support provided by TmaxTibero.