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));
rwjlewis
commented
6 years ago
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));