Comments (9)
Thanks for the report, could you please execute ora2pg 12.1 again with the -d option and add the result to this issue?
Regards,
from ora2pg.
command:
ora2pg -d -c conf/ora2pg.conf -t SHOW_TABLE
output
Trying to connect to database: dbi:Oracle:host=;sid=
Isolation level: SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
Auto detecting Oracle character set and the corresponding PostgreSQL client encoding to use.
Using Oracle character set: AMERICAN_AMERICA.WE8ISO8859P1.
Using PostgreSQL client encoding: LATIN1.
Showing table information...
FATAL:
Aborting export...
Regards
from ora2pg.
Ok, thanks for the report. The error message is not really useful but maybe the error comes from the materialized view listing introduced before displaying table information. I have patched ora2pg to change level of the error message when querying materialized view to continue even if there's an error.
Could you test latest code from github and let us know if it solves the issue.
Regards,
from ora2pg.
Hi, I've pulled the latest code (with the changes in the .pm module). But result stays the same.
:-(
FATAL:
Aborting export...
Regards
from ora2pg.
Ok. Ive enumerated all the FATAL "echos" in the Ora2Pg.pm and btw there are a lot of them... ;-)
The FATAL which is triggered is in Line 4249
4243 my $ret = $self->{dbh}->err;
4244 if (!$recurs && ($ret == 942) && ($self->{prefix} eq 'DBA')) {
4245 $self->logit("HINT: Please activate USER_GRANTS or connect using a user with DBA privilege.\n");
4246 $self->{prefix} = 'ALL';
4247 return $self->_column_info($table, $owner, 1);
4248 }
4249 $self->logit("50FATAL: " . $self->{dbh}->errstr . "\n", 0, 1);
4250 }
Hope that helps. Regards
from ora2pg.
I'm trying to install a 8i on a VM with a help of colleague to be able to reproduce the issue. It takes time because it is a task that required some knowledge of palaeontology :-(
from ora2pg.
Ok. I think I found the solution. It was a missing if(!$sth)
I have commited it as a patch in my forked repository
c1acafc
hope thats right. I'm new to this github thing ;-)
from ora2pg.
.... aaaaaaaaand forgot to close the if statement
740d45f
Seems to work with '-t SHOW_TABLE' going for a test run tomorrow (the export takes a while) and report back
from ora2pg.
Good catch, commit 20b8327 applied your patch. At least now, thanks to you and Marco I have a running 8i for testing :-)
from ora2pg.
Related Issues (20)
- Migrating From SQL Server to Postgres with Ora2pg Is very Slow HOT 1
- Request for sha256sum on downloads HOT 1
- Config option to override the NLS_TIMESTAMP_FORMAT or such encoding parameters used by Ora2pg HOT 1
- Invalid check constraint conversion to PostgreSQL format while exporting schema from Oracle HOT 1
- OUT OF MEMORY EVEN THOUGH SERVER HAS OVER 16GB FREE RAM HOT 2
- [ORACLE]Slow export of BLOB and CLOB from HOT 7
- Reading the ora2pg assessment report HOT 6
- Mysql to postgresql migration HOT 9
- ERROR : DBI::db=HASH(0x29c1784f2e8)->disconnect invalidates 1 active statement handle HOT 3
- Wrong argument "extra_param OPAQUE" in function with OUT arguments (regression in release 24.3) HOT 1
- Wrong change in translation of "is not null" clause (regression in release 24.3) HOT 1
- Extract data query errorring out HOT 6
- Oracle column aliases (after TRIM function) are syntactically incorrect due to small bug introduced in commit 66f4fc37 HOT 1
- Issue in migrating from SQL Server to CloudSQL Postgres HOT 4
- Foreign server always generated with default port HOT 3
- Export data with CLOB is too slow HOT 7
- Generated export_schema.ps1 contains bash if else HOT 1
- Problems trying to use new parameter PARTITION_BY_REFERENCE=duplicate
- Oracle to Postgresql migration - issue with SECURITY DEFINER
- Filenames created incorrectly when exporting using the COPY option and parameter RENAME_PARTITION=1
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.