Comments (3)
Hi Bruno,
Yes all objects name with non alphanumerics characters (and some other) need to be double-quoted by hand. But here I think thay in an index name you may rename the index instead and remove the ampersand.
from ora2pg.
I wish the manual would have warned me about that but it's no big deal.
For now, since I'm only testing and I have about 50 indexes with an ampersand, I'm using the following python script:
import re
with open('output.sql', 'r') as f_in:
with open('output2.sql', 'w') as f_out:
for line in f_in:
f_out.write(re.sub(r'(CREATE.*INDEX )(.*)( ON)', r'\1"\2"\3', line))
from ora2pg.
You can also use this single command line:
perl -p -i -e 's/(CREATE.INDEX )(.)( ON)/\1"\2"\3/' output.sql
from ora2pg.
Related Issues (20)
- Ora2pg Migration assessment using sql file HOT 2
- Enhance DATA_EXPORT_ORDER with custom order of Tables.
- Unwanted NOT NULL constraint
- Data validation through FDW
- Error in tempfile() using /tmp/tmp_ora2pgXXXXXX: Could not create temp file /tmp/tmp_ora2pg4CEPen: Too many open files at /usr/share/perl5/vendor_perl/Ora2Pg.pm line 8711
- Assessment report via ora2pg HOT 1
- Schema for Default partition is not dumped while using the RENAME_PARTITION
- Clarification HOT 4
- [BUG] Procedure not converting properly using Ora2pg 24.1 (MSSQL Server - Postgresql) HOT 1
- [NICE2HAVE] line-continuation character for config-file HOT 1
- CREATE TABLE DDL in schema dump of Oracle for List Partitions is not correct HOT 1
- not sure if this is an issue \N HOT 1
- psql:./schema/tables/table.sql:625: ERROR: syntax error at or near what -- missing comma HOT 2
- Ora2Pg migration Speed reducing after 20-30 mins of migration start time. HOT 1
- Error while running DBD::Oracle > make: *** [Makefile:524: blib/arch/auto/DBD/Oracle/Oracle.so] Error 1 HOT 1
- Ora2pg scanner HOT 1
- while doing INSERT, ST_GEOMETRY() is applied to non-spatial columns, resulting in syntax error, since SRID parameter is empty
- [Urgent Question] NON DBA Account to generate report and export HOT 1
- Option for ALTER TABLE ADD CONSTRAINT being in a separate file HOT 2
- ERROR: out of memory DETAIL: Cannot enlarge string buffer containing 1073741808 bytes by 8191 more bytes. CONTEXT: COPY TABL, line 95ERROR: out of memory DETAIL: Cannot enlarge string buffer containing 1073741808 bytes by 8191 more bytes. CONTEXT: HOT 10
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from ora2pg.