Skip to content

nuodb-migrator data export fail on Oracle DB EE (12.2) #42

Description

@rwjlewis

Create generic Oracle DB user/data:

conn / as sysdba
set echo on
alter session set container = orclpdb;
drop user foo cascade;
create user foo identified by foo;
grant create session,resource,unlimited tablespace to foo;
conn foo/foo@orclpdb
create table foo(ID INT);
INSERT INTO FOO(ID) VALUES(1);
commit;
exit

nuodb-migrator schema --source.driver=oracle.jdbc.driver.OracleDriver --source.url=jdbc:oracle:thin:@//localhost:1521/orclpdb --source.username=foo --source.password=foo --source.schema=FOO --output.path=/tmp/schema.sql

Output of schema.sql doesn't contain data:
USE "FOO";
DROP TABLE IF EXISTS "FOO" CASCADE;
CREATE TABLE "FOO" ("ID" NUMERIC(38,0));

I added --meta.data.=true to force it with no output change.
nuodb-migrator schema --source.driver=oracle.jdbc.driver.OracleDriver --source.url=jdbc:oracle:thin:@//localhost:1521/orclpdb --source.username=foo --source.password=foo --source.schema=FOO --output.path=/tmp/schema.sql --meta.data.
=true
Output of schema.sql still doesn't contain data:
USE "FOO";
DROP TABLE IF EXISTS "FOO" CASCADE;
CREATE TABLE "FOO" ("ID" NUMERIC(38,0));

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions