You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
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));
The text was updated successfully, but these errors were encountered:
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));
The text was updated successfully, but these errors were encountered: