Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

conversion rule does not work #1847

Open
fchapuis0101 opened this issue Dec 12, 2024 · 0 comments
Open

conversion rule does not work #1847

fchapuis0101 opened this issue Dec 12, 2024 · 0 comments

Comments

@fchapuis0101
Copy link

fchapuis0101 commented Dec 12, 2024

I used ora2pg version 24.3
Here is my configuration file:
PG_VERSION 14
ORACLE_DSN dbi:Oracle:host=host;port=1521;service_name=server.com
ORACLE_USER SCHEMA
ORACLE_PWD xxxxxxx
USER_GRANTS 1
PG_SCHEMA schemaname
SCHEMA SCHEMA
TRANSACTION READONLY
EXCLUDE TGUTASKLOCK
DATA_TYPE NUMBER(38\,*):bigint
DATA_TYPE NUMBER(1,0):smallint
FILE_PER_CONSTRAINT 1
FILE_PER_INDEX 1
FILE_PER_FKEYS 1
DEBUG YES

the rule DATA_TYPE NUMBER(38,*):bigint does not work for converting NUMBER(38,0) to bigint, instead type are mapped with numeric(38)
Any help will be very appreciate
Fabrice

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant