You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Jira Link: DB-13445
If there is a table having a name as a reserved keyword of datatype in Oracle. There is an issue in dumping the incorrect data dump for that table and importing that exported data in target might fail with syntax errors.
Workaround: Modify the data to correct syntax as per the datatype exported for that table.
Example
An example schema on the source database is as follows:
priyanshi-yb
changed the title
[Oracle] Issue in importing data of tables having reserved word names as datatypes in Oracle
[Oracle] Issue in importing data of tables having reserved keyword of datatype as table names in Oracle
May 10, 2024
Jira Link: DB-13445
If there is a table having a name as a reserved keyword of datatype in Oracle. There is an issue in dumping the incorrect data dump for that table and importing that exported data in target might fail with syntax errors.
Workaround: Modify the data to correct syntax as per the datatype exported for that table.
Example
An example schema on the source database is as follows:
The exported schema and data are as follows:
Error when import the data is as follows:
Workaround for the example is to modify the data to change the
f/t
to0/1
respectively:The text was updated successfully, but these errors were encountered: