ora2pg

ora2pg copied to clipboard

With a ora2pg.conf with SCHEMA myself EXPORT_SCHEMA 1 PACKAGE_AS_SCHEMA 1 it seems to export fine, but I ran into an error, and I think it is because the return type...

unrandom123

the character E and multiLine insert

1

# ora2pg -version Ora2Pg v21.0 # ora2pg_table_data.conf ORACLE_HOME /u01/oracle/product/11.2.0 ORACLE_DSN dbi:Oracle:host=192.168.1.4;sid=orcl ORACLE_USER user1 ORACLE_PWD user1 SCHEMA user1 TYPE INSERT ALLOW system_params NLS_LANG AMERICAN_AMERICA.AL32UTF8 OUTPUT system_params_data.sql # ora2pg -c ora2pg_table_data.conf WARNING:...

tithonus163

When we have reserved keywords used and USE_RESERVED_WORDS enabled, it should apply to the CONSTRAINTS_output.sql as well

1

I have the reserved keyword "authorization" used in Oracle, so I enabled the USE_RESERVED_WORDS, I also have FILE_PER_CONSTRAINT enabled to have the constraints in a separate file, and some of...

marie-joechahine

I decided to change the type of one of the columns being imported, but ran into a problem since the field in Oracle had a default value and it is...

marie-joechahine

WHERE DIRECTIVE

6

Hi,darold Dose the 'WHERE' directive support Chinese characters。I've tried it and found it doesn't support。 ora2pg.conf like this: [ora2pg.txt](https://github.com/darold/ora2pg/files/5813339/ora2pg.txt)

xinjirufen

Ora2pg did not convert Constraints and Indexes

2

Good afternoon Darold, I hereby contact you because I read from the ora2pg documentation that if the software had configured for the type of table export, it would convert indexes...

RuiFilipeGoncalvesPereira

Installing ora2pg in windows 10

10

I am trying to install Ora2Pg version 20 (lattest release) on windows 10. Installed StrawberryPerl as well as ActivePerl. 1) Run perl Makefile.PL. 2) Run gmake: Error: **to undefined at...

matul3jan

Export result to CSV format

3

Hi darold, Thank for your very useful tools, it's save so much time! I have some table need export to CSV file, I read in document and see a flag...

Ryo51289

Ora2pg error: FATAL: bad export type using input file option

7

Hi Darold, I am trying to export Materialized views using input file option and got the below error:  Below query I used: CREATE MATERIALIZED VIEW "MV_EMP" ("EMPNO", "ENAME",...

naveenjul29

PRESERVE_CASE doesn't preserve case in VIEWs and CHECK constraints

6

Setting PRESERVE_CASE to 1 and migrating an Oracle schema gives expected results on CREATE/ALTER TABLE statements, etc., i.e. table names in the resulting `table.sql` are double quoted upper case (e.g....

otterrisk